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.

Project Evaluation Form Must objectives Rate projects as Yes - meets objective, No- Does not meet objective, N/A - no impact on objective Must meets Project 1 Project 2 Project 3 Objective M-A Yes No Yes Objective M-B N/A No Yes Relative importance Want objectives (aiteria weight) Project impact definitions Project 1 Project 2 Project 3 0=Does not address, 1= Opportunity to fix, 2=Urgent problem Objective W-A 20 1 Objective W-B 50 0 5000 2 1 0=minor, 1=Significant, 2= Major Objective W-C 30 2 Project total weighted score 150 130