President Theater Enter Your Name Right Here, in Cell B3 - NOW Step Amoun ontatyies - 1.1 \$ (50,202) Describe in Your Own Wonds Why the Prosident had a GREATER Not Loss last year than the previous yeer. 3. 1.1A - 1.1A Hlimadri Shama 7. 1,2 4,710 Use WOROS to describe the COMPUTATION of Budget Financial Forecast Finel Budget Endllng Cash Balance by looking in coll H57. - 1.241.24 10 20 The following Cost Changes are forecast for Noxt Year. Enter them in the Yollow Colls on Firat Cut % Change and Firat Cut Budeot 1121 The cost pald to movie makers to show their movies is expected to increase by 7 .O\% per Tlicket Sold next year. 11 2.2. The Average Cont paid to the makers of the Junk Food you sell is expected to Increase by 6.98 next yoar. 14 2.3 You would like to glve your hourty omplovens a mige of 4 . Wh nant year 14. 2.4 You would like to give yournelf a raise of 5.0% noxt yoar. You have been ilving on the same salary for two years, and it is thath. 13 2.5 You need to make a copital livestiment to Fix the Leaky roof. This will cost $10,000 (onter as a Nogntive Number) it 27 Look carefully at the model. Explain what the number in 26 on the financial forecast MEANS for Prealdents Theater. Answor Below on ono line. 18 27A ii 3.0 Second Cut Changes and Budget for Next Year - Your Plan - Pick the Best Options to Sunive - Your Options Are: 3.11. Raise Ticket Prices by 5.0%. Thle will cause a 5.0% change in the number of tickets sold per move, as some people will po elsewhere OR 1 3.12 Offer 10% more movies shown at 20. Os lower prices with a resulting increese in 15% more tickets per movie sold o8: 3.13. Do Not Change Tickat Pricos - Plick and Enter The Bent Option for Second Cut Ending Cash Batance - Then Your Next Options are: 3.0 Second Cut Changes and Budget for Next Year - Your Plan - Plek the Best Options to Survive - Your Options Are: 3.11 Ralse Ticket Prices by 5.0%. Thls will cause a 5.0% change in the number of tickets sold per movie, as some people will go elsewhere Of 3.12 Offer 10% more movles shown at 2.0% lower prices with a resulting increase in 15% more ticicets per movie sold OR. 3.13 Do Not Change Ticket Prices - Pick and Enter The Best Option for Second Cut Ending Cash Balance - Then Your Next Options are: 3.21 Raise Junk Food Prices by 10.0%, which will result in 2.0% of the \# of Ticket holders Buying Junk Food OR 3.22. Lower Junk Food Prices by 10.0%, which will result in +2.0% of the \# of Tlcket holders Buylng Junk Food OR Do Nothing - Plck the best, then 3.31. Purchase a New Ticket System for $15,000 (negatlve), which will allow you to decrease the Number of Employee Hours per Show by - 10.0\% OR 3.32. Do Not Purchase the Now System and keop the same qumber of hours employees work per show. - Pick the best, then 3.41 Continue to Pay Employees the Same Hourly Rate as Last Year by Entering 4.0% in the Second Cut Change - or not 3.51 Continue to Pay Yourself the Same Salary as Last Year by Entering 5.0% in the Second Cut Change - or not 3.65 4.719 OK Check if Red OK in Cell C29: You positlve cash left at the end of next year's plan - Save and Print Budget Financial Forecast 3.7 Revlew the Printed Second Cut Budget. In your own words, briefly explain your plan to your Banker in your own words .7A 4.0 List three Changes that you might Explore in your "Third Cut Budget" below. These are your ideas that were not included in the previous lines, ut thiugs you might try to plan into your budget to improye the noxt year. Be brief but as complete as you can - Only One Pian Change per Line. 1.3A1.1A President Theater Enter Your Name Right Here, in Cell B3 - NOW Step Amoun ontatyies - 1.1 \$ (50,202) Describe in Your Own Wonds Why the Prosident had a GREATER Not Loss last year than the previous yeer. 3. 1.1A - 1.1A Hlimadri Shama 7. 1,2 4,710 Use WOROS to describe the COMPUTATION of Budget Financial Forecast Finel Budget Endllng Cash Balance by looking in coll H57. - 1.241.24 10 20 The following Cost Changes are forecast for Noxt Year. Enter them in the Yollow Colls on Firat Cut % Change and Firat Cut Budeot 1121 The cost pald to movie makers to show their movies is expected to increase by 7 .O\% per Tlicket Sold next year. 11 2.2. The Average Cont paid to the makers of the Junk Food you sell is expected to Increase by 6.98 next yoar. 14 2.3 You would like to glve your hourty omplovens a mige of 4 . Wh nant year 14. 2.4 You would like to give yournelf a raise of 5.0% noxt yoar. You have been ilving on the same salary for two years, and it is thath. 13 2.5 You need to make a copital livestiment to Fix the Leaky roof. This will cost $10,000 (onter as a Nogntive Number) it 27 Look carefully at the model. Explain what the number in 26 on the financial forecast MEANS for Prealdents Theater. Answor Below on ono line. 18 27A ii 3.0 Second Cut Changes and Budget for Next Year - Your Plan - Pick the Best Options to Sunive - Your Options Are: 3.11. Raise Ticket Prices by 5.0%. Thle will cause a 5.0% change in the number of tickets sold per move, as some people will po elsewhere OR 1 3.12 Offer 10% more movies shown at 20. Os lower prices with a resulting increese in 15% more tickets per movie sold o8: 3.13. Do Not Change Tickat Pricos - Plick and Enter The Bent Option for Second Cut Ending Cash Batance - Then Your Next Options are: 3.0 Second Cut Changes and Budget for Next Year - Your Plan - Plek the Best Options to Survive - Your Options Are: 3.11 Ralse Ticket Prices by 5.0%. Thls will cause a 5.0% change in the number of tickets sold per movie, as some people will go elsewhere Of 3.12 Offer 10% more movles shown at 2.0% lower prices with a resulting increase in 15% more ticicets per movie sold OR. 3.13 Do Not Change Ticket Prices - Pick and Enter The Best Option for Second Cut Ending Cash Balance - Then Your Next Options are: 3.21 Raise Junk Food Prices by 10.0%, which will result in 2.0% of the \# of Ticket holders Buying Junk Food OR 3.22. Lower Junk Food Prices by 10.0%, which will result in +2.0% of the \# of Tlcket holders Buylng Junk Food OR Do Nothing - Plck the best, then 3.31. Purchase a New Ticket System for $15,000 (negatlve), which will allow you to decrease the Number of Employee Hours per Show by - 10.0\% OR 3.32. Do Not Purchase the Now System and keop the same qumber of hours employees work per show. - Pick the best, then 3.41 Continue to Pay Employees the Same Hourly Rate as Last Year by Entering 4.0% in the Second Cut Change - or not 3.51 Continue to Pay Yourself the Same Salary as Last Year by Entering 5.0% in the Second Cut Change - or not 3.65 4.719 OK Check if Red OK in Cell C29: You positlve cash left at the end of next year's plan - Save and Print Budget Financial Forecast 3.7 Revlew the Printed Second Cut Budget. In your own words, briefly explain your plan to your Banker in your own words .7A 4.0 List three Changes that you might Explore in your "Third Cut Budget" below. These are your ideas that were not included in the previous lines, ut thiugs you might try to plan into your budget to improye the noxt year. Be brief but as complete as you can - Only One Pian Change per Line. 1.3A1.1A