Posted: March 29th, 2023

MAN400 – INTRODUCTION TO PROJECT MANAGEMENT

MAN400 – INTRODUCTION TO PROJECT MANAGEMENT
Other Version MAIN VERSION-A

Allowable Examination Aids: (check applicable boxes)

☐ Calculators (non-programmable only) ☐ Math Tables (normal distribution table) ☐ Periodic Tables
☐ Formula Sheets (attached) ☒ Textbooks ☐ Probability Tables
☐ Dictionary ☐ Notes ☒ Other

Answers to be completed on:

☐ Exam Booklet ☐ GradeMaster Card ☐ Exam Paper

TOTAL MARKS: 20 WEIGHTED VALUE: 20

INSTRUCTIONS:

Academic Integrity Policy. Seneca upholds a learning community that values academic integrity, honesty, fairness, trust, respect, responsibility and courage. These values enhance Seneca’s commitment to students by delivering high-quality education and teaching excellence, while supporting a positive learning environment. The AI policy is always in effect. Note Sections 2.3 and 2.4:
“…2.3 Should there be a suspected violation of this policy (e.g.…cheating, falsification, impersonation or plagiarism), the academic integrity sanctions will be applied according to the severity of the offence committed. Refer to Appendix B for the academic integrity sanctions. 2.4 Should a suspected violation of this policy be a result of, or in combination with, a suspected violation of Seneca’s Student Code of Conduct and/or another non-academic-related Seneca policy, the matter will be investigated and adjudicated through the process found in the Student Code of Conduct.”

TO BE COMPLETED BY STUDENT
SUBJECT SECTION NUMBER (e.g. QNM223 AA):
STUDENT NAME:
STUDENT NUMBER:
STUDENT SIGNATURE:

APPROVED BY: ________________________________________________________
Shahrzad Farzinpak, Chair
School of Human Resources and Global Business

DATE: ________________________________________________________

Double click on the word ‘Version’ at the end of the page and change the Version letter to the right. Double click here when done.

MAN 400 – Introduction to Project Management.
GROUP ASSIGNMENT – II
Winter 2023
Project Budget
Costing the Oscars

The Assignment is due EOD Sunday, 9th April 2023

Group Assignment 2 – Project Budget
—————————————————————————————————————————
Instructions
Academic Integrity Declaration:
By beginning this Assignment, the Group affirms that they will not give or receive any unauthorized help on this case and that all work provided will be the Groups own work. The Group agrees to abide by Seneca’s Academic Integrity Policy, and we understand that any violation of academic integrity will be subject to the penalties outlined in the policy.
This is a Group Assignment and representation of anyone else’s work as your own is an Academic Integrity violation. All answers will be checked with SafeAssign to prevent this.
All questions refer to the “Case Study” which is posted in the Assignments Section in Blackboard. Read the case and answer all the questions.
Use the information provided in the case as a basis for the Groups response. The Group may include other information or knowledge, but make sure the Groups response is based first on the information in the case. Make sure to reference concepts discussed in class or the textbook in your answers. Remember, the Group must cite anything that is not your own thoughts or words. The Assignment will be checked with SafeAssign for potential Academic Integrity issues.
YOU MUST USE APA Guidelines.
This is a Group Assignment.
Please ensure you upload and submit the assignment before the due date and time indicated on Blackboard.
Late assignments have 10% deducted from the final mark each day for the first two days, at the beginning of the third day late you get a mark of zero. Each Group will submit only one peer review form. The faculty has the prerogative to adjust individual marks that may be different than the group mark based on the peer Assessments. You must fill out and complete the peer Assessment and upload it to blackboard along with the assignment.
WISH YOU ALL THE VERY BEST, DO WELL AND HAVE FUN!
This assessment accounts for 20% of your final course grade.

“All the Worlds a Stage”
“I work all night; I work all day to pay the bills I have to pay
ABBA
The Academy Awards offer a chance for Hollywood to show off its glitz, glam and gold. From courting voters to hiring red carpet, the Academy Awards are big business. To even get to the Oscars, it costs a lot: Hollywood spends $100 million on awards-season lobbying each year.
Although the pandemic hit Hollywood hard, with revenue down nearly 60% compared to pre-COVID pandemic levels, according to WalletHub, people can still look forward to certain things to stay the same: the red carpet, the awards and of course, the films.
To attend the Oscar party can cost around $80,000 per couple, and A-list actors can expect to pay an average of $10 million on their outfits: although this number varies from $1.5 million for the average attendee’s ensemble to $266,000 for a first timer. For Los Angeles, the Oscars are an economic boon: $130 million is the annual revenue the city gets from the awards ceremony. ABC gets $120 million in ad revenue from the awards show and $21 million is generated from the Red-Carpet show. It’s not just the city or television network that benefits from the awards: the best actor/actress winner can expect a 60% boost in pay.
Seneca college has been invited to prepare an initial budget for the Oscar Grand Gala and your Group has been designated to undertake this.
You can refer to the links given here for preparing the WBS and you can also refer to other documents in the public domain.
https://www.theguardian.com/film/2017/feb/25/oscars-2017-how-much-does-hollywood-biggest-party-cost-earn

How much is the Academy Awards ceremony costing this year?

https://fox4kc.com/news/how-much-is-the-oscars-costing-this-year/

Assignment Notes
Your team put together the Work Breakdown Structure (WBS) for this project and get the same approved by the Business Sponsor. This signals the approval of your project’s scope. Now it’s time to determine how much it will cost to deliver this project’s scope. In other words, we are building the project’s budget.
1. Your first step is to create the structure of your budget. Please use Microsoft Excel and the WBS provided in the Table 1 below
2. Your second step is to estimate the labour and non-labour costs.
Estimating labour costs requires you to estimate how long the work will take (durations) and how much you will pay the people performing the work. Use the duration estimates provided in Table 1 below.
As a group, determine the hourly rates for the human resources required.
With respect to the non-labour costs of this project, consider the equipment and materials required to complete the project. Ensure you document your assumptions clearly. This includes a description of what the cost represents and how you determine the dollar amounts.
3. Your third step is to create the total budget
This requires you to sum up the costs of each major deliverable. Create subtotals at the major deliverable level. Create subtotals for the labour and non-labour costs as well. Use formulas whenever possible so you fully harness the power of Microsoft Excel.
Establish a reasonable contingency for this project. You are free to make any assumptions you like; simply ensure they are well documented.
4. Your final step is to create the time-phased budget.
As discussed in class, the objective of the time-phased budget is to determine the cash flow needs of the project. To create a time-phased budget, you need to consider when the work will be done. Refer to Table 1 below for guidance.
With respect to contingencies, it is acceptable to include them at the beginning of the project, end of the project or spread them out over the project’s duration. As a team, decide which approach you feel is most appropriate. Lastly, ensure your time-phased budget has the same total cost as your aggregate budget.

Deliverables for this Assignment:
As part of this Assignment, you will submit four deliverables:
1. Developed WBS
2. Assumptions Document – The documents should clearly list out the assumptions you have made for:
a. Total Budget
b. Time Phased Budget
c. Level of Contingency considered.
3. Total Budget: This is aggregated costs of components/sub-components. Your total budget is the aggregate of all your WBS categories.
4. Time-phased budget: Create your time-phased budget on a monthly, quarterly, or half years basis
Additional Assignment Notes:
1. Please submit your Microsoft Excel file (not a PDF version) as I will be reviewing the calculations made. One member of your team will submit your completed assignment on blackboard.
2. You must use MS Teams as your online collaboration tool.
3. Confidential Peer Assessments are also required. Please note to submit the Peer Assessment.
TABLE 1
Costing the Oscars
WBS # Deliverable /Work Package Duration (Days)
1 The Campaign
1.1 PR Consulting 5
1.2 Advertising 12
1.3 TV Commercials 21
1.4 Talent Costs 11
1.5 Film Screenings 3
1.6 Digital Screenings 1
2 The Show
2.1 Producers Briefing 14
2.2 Hosts Briefing 2
2.3 Dolby Theatre Booking 7
2.4 Oscar statuettes 2
2.5 Security 5
2.6 Red Carpet 1
3 Black-Tie Dinner
3.1 Main Course 5
3.2 Dessert 2
3.3 Drinks 2

RUBRICS

Criterion Levels Achieved
Grading 1-3
1 point 2 points 3 points TOTAL
1. Structural consistency with the Work Breakdown Structure (WBS) Budget is not consistent with the structure provided. Budget is somewhat consistent with the structure provided. Budget is completely consistent with the structure provided.
3

2. Work packages estimates.

None/few of the work package duration estimates were used.
Some of the work package duration estimates were used.

Majority/all of the work package duration estimates were used.

3

3. Aggregate budget completed Aggregate budget provided but most deliverables do not have subtotals. Contingencies were not included. Aggregate budget provided and some deliverables have subtotals. Contingencies were included. Aggregate budget provided and all deliverables have totals. Contingencies were included.

3
4. Time-phased budget completed Time-phased budget was not provided. Time-phased budget was provided but it does not have the same total as the aggregate budget. Time-phased budget was provided and it has the same total as the aggregate budget.

3
5. Assumptions are well documented Few assumptions provided Some assumptions provided Most/all assumptions provided
3

6. Accuracy of calculations Many mathematical mistakes made (3 or more) Some mathematical mistakes made (1 -2) All calculations are correct.

3

The Assignment is due EOD Sunday, 9th April 2023
By submitting this assignment, we affirm that we have not given or received any unauthorized help and that all work submitted is our own. We have abided by Seneca’s Academic Integrity Policy, and we understand that any violation of academic integrity will be subject to the penalties outlined in the policy.

SAMPLE WBS

Source: – PMI PMBOK 6 page 158

(Once the group has submitted the assignment, for all the hard work and effort you have put into the assignment, you can claim your non-monetary reward below.

This is an instruction document for a group assignment in MAN 400 – Introduction to Project Management. The assignment is related to preparing a budget for the Oscars Grand Gala. The document includes instructions for academic integrity declaration, guidelines for completing the assignment, and submission requirements. The document also mentions the penalties for violating academic integrity and the weightage of the assignment. The assignment is due on Sunday, 9th April 2023.

Order | Check Discount