Do this questions in a single Excel file. Pg 56-60 Case Film Prioritization Set

Question

Do this questions in a single Excel file.

Pg 56-60 Case Film Prioritization

Set up the Project Priority Evaluation Form (adapt Fig 2.5 & 2.6) in Excel and make Excel do all of the calculations to determine total weighted scores.  (see below for example)

Based on the descriptions given, you will have to evaluate each of the seven film projects to determine whether or not they meet the “must” objectives and then score them individually as 0,1,2 on the “want” objectives in order to calculate the total weighted scores.   Weights are given as Relative importance.  

Provide a brief overview of the case and report the project rankings based on total weighted scores.

film case:

Project Evaluation Form Must objectives Must meets Rate projects as Yes-meets objective, No- Does notmeetobjective, NVA no impact on objective Project 1 Project 2 Project 3 Objective MA Yes No Yes objective M-B NVA. No Yes Relative importance (criteria weight) Project impact definitions Project 1 Project 2 Project 3 Want objectives 0 Does not address, 1 opportunity to fix, 2-Urgent objective w A problem 50 o 1000, 1 100 500,2 >5000 2 2-2 objective w B o minor, 1 Significant, 2 objective WLC Major Project total weighted score 130

Explanation / Answer

okay so i am assuming that the question is asking for and expected ROI value which we will come back to later for now read the question again carefully it is asking for subjective evaluation of the objective so there is no real statistics involved but the only thing that involves statistics is the ROI which i am guessing to be equivalent to expected profit in percentage from different proposals.

If these values are greater than 18% then the want objectives will be fulfilled.

E(ROI) PROJECT NO. .8*8+ .5*18+ .2*24 1 .8*2+ .5*20+ .2*30 2 .8*12+.5*14+.2*18 3 .8*15+ .5*20+.2*24 4 .8*8+ .5*15+.2*20 5 .8*6+ .5*18+.2*25 6 .8*9+ .5*15+.2*20 7

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.