Assignment 3 Budgeting (40 Marks) Overview In this assignment, learners are required to create staffing and operating budgets for Play-Outside. To create the staffing and operating budgets learners will need to identify cost, understand how changes in costs affects decisions, and explain the budget decisions they make. Learning Outcomes Identify the role of budgets in planning and decision-making and apply the budgeting process. Prepare labor and selling and administrative expense operating) budgets. Background Information Play-Outside is a not-for-profit organization that develops and maintain playgrounds and sport fields in neighbourhoods with no or disused playgrounds or fields. Play-Outside has been operating since 1987. Play-Outside's mission is to help put smiles on the faces of children and build a better future, one playground at a time. During the 30 years of operation, Play-Outside has developed 43 playing fields and 22 playgrounds Play-Outside maintains playing fields for 10 years and afterwards a local community organization takes over maintenances. Every year new projects are submitted, but with limited resources only 2 new playgrounds and 2 sports fields can be developed. Volunteers carry out the majority of the work. The paid staff oversee the administration of external grants, project applications, maintenance schedules and volunteers. With the growing number of projects and volunteers, Play- Outside is looking to hire a new Volunteer Assistant Play-Outside's revenue is from projects grants from the different levels of government and corporate donations. The operating expenses and some project costs are from an anonymous donor and fundraising donations. Not all project costs are covered by the project grants. The task is to create the 2020 budget for Play-Outside from the guidelines provided by the Chief Financial Officer. Along with the 2020 budget, you are asked to include the justifications for your budget decisions Play-Outside's fiscal year is January to December. ACCT2001 Managerial Accounting Assignment 3 1 Page Project length and format: Your answer should be no more than 4 pages and include answers to the 4 questions, calculations, completed Exhibit C and Exhibit D. Round to the nearest whole number. Questions: 1. Introduce Play-Outside's current situation and identify their challenges. Use the background information, Exhibit A: Memorandum and Exhibit B: 2019 and 2020 Budget. 2. Create the 2021 staffing budget that does not total more than $248,500 and includes the 2.5 current positions, the new position, annual increase and benefits. Use the template in Exhibit C. (Total of 3.5 positions in the 2021 budget) 3. Create 2021 Operating budget using the template in Exhibit D, and must include all the changes from Exhibit A Part B. Operating Expenses. 4. Identify budget items that can be reduced or increased. 5. Evaluate of each budget item using quantitative and qualitative factors. 6. Rank recommendation budget item changed based on your evaluation. 7. Provide a recommendation on a. The annual salary for the Volunteer Coordinator b. Changes in the operating budget. Items you would decrease or increase. c. Explain how your recommendation is feasible, practical, result orientated, and resolves major challenge. ACCT2001 Managerial Accounting Assignment 3 2 Page EXHIBIT A Memorandum From Chief Financial Officer Project Group Manager 2021 Budget Preparation Guidelines Re The 2021 budget for the Play-Outside's Project Group needs to be prepared using the following guidelines. A. Staffing Budget There up has 2.5 staff position, the Manager position is shared with another department. Your request for a Volunteer Assistant position has been approved for 2021. The annual salary can be between $42,000 and $47,000 per year plus benefits. The position will start on January 15 2020 Salaries for current position Manager (50%) - $32,500 plus benefits Coordinator -- $55,000 plus benefits Administrative Assistant -- 545,000 plus benefits Addition Information: The benefit rate is 39% In 2020 all current employees will receive a 3% increase, as of January 1, 2021 The total staffing budget cannot be more than $248,000 for all 3.5 position for 12 months (1 year) B. Operating Budget The Project Group's Actual results for 2019 and 2020: Description 2019 Actuals Total Revenue $ 46,013 Total Expenses $ 45,813 Budget Surplus (Deficit) $ 2020 Actuals $ 48,672 $ 46,573 $ 2,100 200 Exhibit B shows the full Operating Budget results. ACCT2001 Managerial Accounting Assignment 3 3 Page The 2021 budget cannot be in deficit (a negative amount) or in a surplus of more than $2,500. Revenue comes from rentals of the 3 sports fields. Rented for $10/hour Available 8 hours every day 5 days/week. Current rental rate is at 65% of the available time. Changes to Project Groups Expenses: The new Development Project for 2021 will cost between $20,000 and $25,000 New marketing and outreach is approved to increase by $2,500 Inflation in 2021 will increase expenses by 4%, expect for the lease annual fees. The computer for the new position will be $225/year. The following expenses cannot be reduced: Field and playground maintenance fees Field and playground development fees Annual fees Exhibit B - Project Group Actual Expenses for 2019 and 2020 2019 2020 Project Group Actual Expenses Sales Rental Revenue Total Revenue $46,013 $46,013 $48,672 $48,672 Expenses Maintenance projects Development projects Office Supplies Printing Marketing presentations and outreach Miscellaneous expenses Lease for printers and copiers (annual fee) Lease for computers ($225 annual fee) Total Expenses Budget Surplus (Deficit) $10,500 16400 3,200 350 4,800 2,000 8,000 563 $45,813 $200 10,750 16,650 2,800 750 5.200 1,860 8,000 563 $46,573 $2,100 ACCT2001 Managerial Accounting Assignment 3 4 Page 2 3 Recommended Marking Criteria Questions Criteria Marks The information describing Play-Outside, Exhibit A: 5 marks Memorandum and Exhibit B:2019 Budget Describe current situation of Play-Outside, identify all principal issues and strategic challenges Create the 2021 Labor Annual Budget that does not total more 10 marks than $248,000 and includes new position, annual increase and benefits using the correct salaries. Use the attached template in Exhibit C Create the 2021 Operating Annual Budget using the attached 10 marks template in Exhibit D. Full marks must meet all the criteria. The Budget can not be in a deficit and the surplus can not total more than $2,500 Describe alternatives and evaluate of each alternative using 5 marks quantitative and qualitative factors. Rank recommendation based on this analysis Provide a recommendation to Play-Outside on staffing and 5 marks operating budgets. Explain how your recommendation is feasible, practical, result orientated, and resolves major challenge Total 40 marks 3 ACCT2001 Managerial Accounting Assignment 3 51 Page Exhibit C - Annual Labor Budget Annual Labor Budget with 2020 Actuals 2021 Budget Employee Expenses 2020 Actuals Manager (50%) 32,500 Coordinator 55,000 Administrative Assistant 41,000 Volunteer Assistant -- New 2021 Budget 128,500 Salary Totals Benefits Manager (50%) Coordinator Administrative Assistant Volunteer Assistant -- New 12,675 21.450 15,990 50.115 Benefits Totals Labor Budget Total 178,615 ACCT2001 Managerial Accounting Assignment 3 6 Page Exhibit D- Operating Budget 2021 Annual Operating Budget Description 2020 Actuals 2021 Budget Sales Rental Revenue Total Revenue 48,672 48,672 Expenses Maintenance project Development projects Office supplies Printing Marketing presentations and outreach Miscellaneous expenses Lease for printers and copiers (annual fee) Lease for computers ($225 annual fee) Total Expenses Budget Surplus (Deficit) 10,750 16,650 2,800 750 5,200 1,860 8,000 563 46,573 2.100 ACCT2001 Managerial Accounting Assignment 3 71 Page Assignment 3 Budgeting (40 Marks) Overview In this assignment, learners are required to create staffing and operating budgets for Play-Outside. To create the staffing and operating budgets learners will need to identify cost, understand how changes in costs affects decisions, and explain the budget decisions they make. Learning Outcomes Identify the role of budgets in planning and decision-making and apply the budgeting process. Prepare labor and selling and administrative expense operating) budgets. Background Information Play-Outside is a not-for-profit organization that develops and maintain playgrounds and sport fields in neighbourhoods with no or disused playgrounds or fields. Play-Outside has been operating since 1987. Play-Outside's mission is to help put smiles on the faces of children and build a better future, one playground at a time. During the 30 years of operation, Play-Outside has developed 43 playing fields and 22 playgrounds Play-Outside maintains playing fields for 10 years and afterwards a local community organization takes over maintenances. Every year new projects are submitted, but with limited resources only 2 new playgrounds and 2 sports fields can be developed. Volunteers carry out the majority of the work. The paid staff oversee the administration of external grants, project applications, maintenance schedules and volunteers. With the growing number of projects and volunteers, Play- Outside is looking to hire a new Volunteer Assistant Play-Outside's revenue is from projects grants from the different levels of government and corporate donations. The operating expenses and some project costs are from an anonymous donor and fundraising donations. Not all project costs are covered by the project grants. The task is to create the 2020 budget for Play-Outside from the guidelines provided by the Chief Financial Officer. Along with the 2020 budget, you are asked to include the justifications for your budget decisions Play-Outside's fiscal year is January to December. ACCT2001 Managerial Accounting Assignment 3 1 Page Project length and format: Your answer should be no more than 4 pages and include answers to the 4 questions, calculations, completed Exhibit C and Exhibit D. Round to the nearest whole number. Questions: 1. Introduce Play-Outside's current situation and identify their challenges. Use the background information, Exhibit A: Memorandum and Exhibit B: 2019 and 2020 Budget. 2. Create the 2021 staffing budget that does not total more than $248,500 and includes the 2.5 current positions, the new position, annual increase and benefits. Use the template in Exhibit C. (Total of 3.5 positions in the 2021 budget) 3. Create 2021 Operating budget using the template in Exhibit D, and must include all the changes from Exhibit A Part B. Operating Expenses. 4. Identify budget items that can be reduced or increased. 5. Evaluate of each budget item using quantitative and qualitative factors. 6. Rank recommendation budget item changed based on your evaluation. 7. Provide a recommendation on a. The annual salary for the Volunteer Coordinator b. Changes in the operating budget. Items you would decrease or increase. c. Explain how your recommendation is feasible, practical, result orientated, and resolves major challenge. ACCT2001 Managerial Accounting Assignment 3 2 Page EXHIBIT A Memorandum From Chief Financial Officer Project Group Manager 2021 Budget Preparation Guidelines Re The 2021 budget for the Play-Outside's Project Group needs to be prepared using the following guidelines. A. Staffing Budget There up has 2.5 staff position, the Manager position is shared with another department. Your request for a Volunteer Assistant position has been approved for 2021. The annual salary can be between $42,000 and $47,000 per year plus benefits. The position will start on January 15 2020 Salaries for current position Manager (50%) - $32,500 plus benefits Coordinator -- $55,000 plus benefits Administrative Assistant -- 545,000 plus benefits Addition Information: The benefit rate is 39% In 2020 all current employees will receive a 3% increase, as of January 1, 2021 The total staffing budget cannot be more than $248,000 for all 3.5 position for 12 months (1 year) B. Operating Budget The Project Group's Actual results for 2019 and 2020: Description 2019 Actuals Total Revenue $ 46,013 Total Expenses $ 45,813 Budget Surplus (Deficit) $ 2020 Actuals $ 48,672 $ 46,573 $ 2,100 200 Exhibit B shows the full Operating Budget results. ACCT2001 Managerial Accounting Assignment 3 3 Page The 2021 budget cannot be in deficit (a negative amount) or in a surplus of more than $2,500. Revenue comes from rentals of the 3 sports fields. Rented for $10/hour Available 8 hours every day 5 days/week. Current rental rate is at 65% of the available time. Changes to Project Groups Expenses: The new Development Project for 2021 will cost between $20,000 and $25,000 New marketing and outreach is approved to increase by $2,500 Inflation in 2021 will increase expenses by 4%, expect for the lease annual fees. The computer for the new position will be $225/year. The following expenses cannot be reduced: Field and playground maintenance fees Field and playground development fees Annual fees Exhibit B - Project Group Actual Expenses for 2019 and 2020 2019 2020 Project Group Actual Expenses Sales Rental Revenue Total Revenue $46,013 $46,013 $48,672 $48,672 Expenses Maintenance projects Development projects Office Supplies Printing Marketing presentations and outreach Miscellaneous expenses Lease for printers and copiers (annual fee) Lease for computers ($225 annual fee) Total Expenses Budget Surplus (Deficit) $10,500 16400 3,200 350 4,800 2,000 8,000 563 $45,813 $200 10,750 16,650 2,800 750 5.200 1,860 8,000 563 $46,573 $2,100 ACCT2001 Managerial Accounting Assignment 3 4 Page 2 3 Recommended Marking Criteria Questions Criteria Marks The information describing Play-Outside, Exhibit A: 5 marks Memorandum and Exhibit B:2019 Budget Describe current situation of Play-Outside, identify all principal issues and strategic challenges Create the 2021 Labor Annual Budget that does not total more 10 marks than $248,000 and includes new position, annual increase and benefits using the correct salaries. Use the attached template in Exhibit C Create the 2021 Operating Annual Budget using the attached 10 marks template in Exhibit D. Full marks must meet all the criteria. The Budget can not be in a deficit and the surplus can not total more than $2,500 Describe alternatives and evaluate of each alternative using 5 marks quantitative and qualitative factors. Rank recommendation based on this analysis Provide a recommendation to Play-Outside on staffing and 5 marks operating budgets. Explain how your recommendation is feasible, practical, result orientated, and resolves major challenge Total 40 marks 3 ACCT2001 Managerial Accounting Assignment 3 51 Page Exhibit C - Annual Labor Budget Annual Labor Budget with 2020 Actuals 2021 Budget Employee Expenses 2020 Actuals Manager (50%) 32,500 Coordinator 55,000 Administrative Assistant 41,000 Volunteer Assistant -- New 2021 Budget 128,500 Salary Totals Benefits Manager (50%) Coordinator Administrative Assistant Volunteer Assistant -- New 12,675 21.450 15,990 50.115 Benefits Totals Labor Budget Total 178,615 ACCT2001 Managerial Accounting Assignment 3 6 Page Exhibit D- Operating Budget 2021 Annual Operating Budget Description 2020 Actuals 2021 Budget Sales Rental Revenue Total Revenue 48,672 48,672 Expenses Maintenance project Development projects Office supplies Printing Marketing presentations and outreach Miscellaneous expenses Lease for printers and copiers (annual fee) Lease for computers ($225 annual fee) Total Expenses Budget Surplus (Deficit) 10,750 16,650 2,800 750 5,200 1,860 8,000 563 46,573 2.100 ACCT2001 Managerial Accounting Assignment 3 71 Page