amswers all question

answer this quation and it is excel filles

thasirtating \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} President Theater \\ Enter Your Name Right Here, in Cell B3- \end{tabular}}} & \multirow{3}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} Two Years \\ Ago Actual \end{tabular}}} & \multirow{2}{*}{\multicolumn{2}{|c|}{ Last Year }} & \multirow{3}{*}{\begin{tabular}{l} First Cut \\ % \\ Change \end{tabular}} & \multicolumn{2}{|r|}{ First Cut } & \multirow{3}{*}{\begin{tabular}{l} Second \\ Cut \% \\ Change \end{tabular}} & \multicolumn{2}{|c|}{ Second Cut } \\ \hline & & & & & & & & Next Year & & & Next Year \\ \hline & & & & & Actual & & & Budge: & & & Budget \\ \hline \multicolumn{12}{|c|}{ Revenue Development } \\ \hline & Number of Movies Shown & & 500 & & 500 & - & & 500 & 0.0% & & 500 \\ \hlinex & Average Number of Tickets & & 980 & & 970 & - & & 970 & 0.0% & & 97.0 \\ \hline & Number of Tickets Sold & & 49,000 & & 48,500 & & & 48,500 & & & 48,500 \\ \hlinex & Average Price per Ticket & $ & 6.65 & $ & 6.66 & - & $ & 6.66 & 0.0% & $ & 6.66 \\ \hline * & Movie Ticket Sales -Total & s & 325,622 & \$ & 323.222 & & s & 323,222 & & $ & 323.222 \\ \hline 84 & Num & & 49. & & 48,500 & & & 48,500 & & & 48,500 \\ \hline & Perce & & 70.0% & & 71.0% & & & 71.0% & 0.0% & & 71.0% \\ \hline & Buying Junk Food & & 34,300 & & 34,435 & & & 34,435 & & & 34,435 \\ \hlinex & Average Pric & $ & 3.70 & s & 3.80 & & $ & 3.80 & 0.0% & $ & 380 \\ \hline= & Junk Food Revenue - Total & s & 126,947 & \$ & 130,876 & & \$ & 130,876 & & $ & 130,876 \\ \hline \multicolumn{12}{|c|}{ Cost De } \\ \hline & Number of Tickets Sold & & 49,000 & & 8,500 & & & 48,500 & & & 48,500 \\ \hlinex & Avg Cost /Ticket to Movie Producers & $ & 435 & $ & 4.76 & 0.0% & s & 4.76 & & $ & 4.76 \\ \hline & Total Cost for Movie Tickets. & $ & 213,000 & $ & 231,000 & & $ & 231,000 & & & \\ \hline \end{tabular} 3.11 Raise Ticket Prices by 5.0%. This will cause a 5.0% change in 3.12 Offer 10% more movies shown at 20% lower prices with a resulting increase in 15% more tickets 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 Ticket holders Buying Junk Food OR Do Nothing - Pick the best, then 3.31 Purchase a New Ticket System for $15,000 (negative), which wil a low you to decrease the Number of Employee Hours per Show by - 10.0% OR 3.32 Do Not Purchase the New System and keep the same number of hours employees work per show. - Pick the best, then 3.41 Continue to Pay Employees the Same Hourty Rate as Last Year by Entering 4.0% in the Second Cut Chanpe - or not 3.51 Continue to Pay Yourserif the Same Salary as Last Year by Entering 5.0% in the Second Cut Change - of not \begin{tabular}{ll} 3.7A \\ \hline 3.7A \end{tabular} 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. but things you might try to plan into your budget to improve the next year. Be briel but as complete as you can -Only One Plan Change per Line 4.1A 4.2A Total President Theater Enter Your Name Right Here, in Cell B3 - NOW 1.1A1.1A 1.2A1.2A 2.0 The following Cost Changes are forecast for Next Year. Enter them in the Yellow Cells on First Cut \% Change and First Cut Budget 21 The cost paid to movie makers to show their movies is expected to increase by 7.0% per Theket Sold next year. 2.2 The Average Cost paid to the makers of the Junk Food you sell is expected to increase by 6.0% next year. 2.3 You would like to give your hourty employees a raise of 4.0% next year 2.4 You would like to give yourself a raise of 6.0% next year. You have been living on the same salary for two years, and it is tight. 2.5 You need to make a capltal investment to Fix the Leaky roof. This will cost $10.000 (enter as a Negative Number) 2.6 \$ 4.719 Not OK Check if Red OK in Cell C16: You have successfully completed step 2.5. Save and Print Budpet Financial Forecast 27 Look carefuly at the model. Explain what the number in 2.6 on the financial forecast MEANS for Presidents Theater. Answer Below on one line. 27A 3.0 Second Cut Chanpes and Budget for Next Year - Your Plan - Pick the Best Options to Survive - Your Options Are: 3.11 Raise Ticket Prices by 5.0%. This will cause a 5.0% change in the number of tickets sold per movie, as some people will go elsewhere OR. 3.12 Offer 10% more movies shown at 2.0% lower prices with a resulting increase in 15% more tickets per movie sold 0R 3.13 Do Not Change Ticket Prices - Pick and Enter The Best Option for Second Cut Ending Cash Balance - Then Your Next Options are: \begin{tabular}{|c|c|c|c|c|c|c|} \hline President Theater & & & First Cut & First Cut & Second & Second Cut \\ \hline Enter Your Name Right Here, in Cell B3 - & Two Years & Last Year & % & Next Year & Cut % & Next Year \\ \hline Your Salary - You Live on This & Ago Actual & 45.000Actual & Change & $45,000Budget & 0.0%Change & $45.000Budget \\ \hline \begin{tabular}{l} Your Salary - You Live on This \\ Total Interest Expense \end{tabular} & & 63,000 & 0.0% & 63,000 & 0.0% & \begin{tabular}{ll} $ & 45,000 \\ $ & 63,000 \\ \end{tabular} \\ \hline Total Expenses & $458,100 & $504,300 & 0.0% & $504,300 & 0.0% & $504,300 \\ \hline Total Profit (Loss) & (5,531) & $(50,202) & & $(50.202) & & (50,202) \\ \hline Capital Investment Projects (Enteriss Nega & & & & & & (50,202) \\ \hline 1) Fix Roof & ative Numbers) & & & s & & \\ \hline \begin{tabular}{l} 2) New Ticket System to Cut Employees \\ Ending Cash Balance \end{tabular} & & & & & & \begin{tabular}{l} s \\ s \end{tabular} \\ \hline Ending Cash Balance & 5,123 & 54,921 & & 4,719 & & 4,719 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{2}{|r|}{ President Theater } & & & \multirow{2}{*}{\begin{tabular}{c} First Cut \\ % \end{tabular}} & First Cut & \multirow{2}{*}{\begin{tabular}{l} Second \\ Cut % \end{tabular}} & \multicolumn{2}{|c|}{ Second Cut } \\ \hline & ter Your Name Right Here, in Cell B3.- & & wo Years & & ast Year & & Next Year & & \multicolumn{2}{|c|}{ Next Year } \\ \hline & & & go Actual & & Actual & Change & Budget. & Change: & & Budget \\ \hlinex & Avg. Cost / Ticket to Movie Producers & $ & 4.35 & s & 4.76 & 0.0% & 4.76 & & s & 4.76 \\ \hline= & Total Cost for Movie Tickets & s & 213,000 & s & 231,000 & & $231,000 & & s & 231,000 \\ \hline B4 & \# of Ticket holders Buying Junk Food & & 34,300 & & 34,435 & & 34,435 & & & 34,435 \\ \hlinex & Avg. Cost per Junk Food Sold & s & 1.46 & $ & 1.75 & 0.0% & 1.75 & & $ & 1.75 \\ \hline= & Total Cost for Junk Food & \$ & 50,100 & s & 60,300 & & 60,300 & & $ & 60,300 \\ \hline 84 & Number of Movies Shown & & 500 & & 500 & & 500 & + & & 500 \\ \hlinex & Number of Employee Hours per Show & & 240 & & 24.0 & - & 24.0 & 0.0% & & 24.0 \\ \hline= & Total Number of Employee Hours & & 12,000 & & 12,000 & & 12,000 & & & 12,000 \\ \hlinex & Rate of Pay per Cost per Hour & s & 8.00 & $ & 8.75 & 0.0% & 8.75 & 0.0% & $ & 8.75 \\ \hline= & Total Cost of Employees & s & 96,000 & $ & 105,000 & & $105,000 & & $ & 105,000 \\ \hline# & Your Salary - You Live on This & s & 45,000 & $ & 45,000 & 0.0% & 45,000 & 0.0% & $ & 45,000 \\ \hlinen & Balance of Loan & $ & 600,000 & $ & 700,000 & & $700,000 & & & 700,000 \\ \hline & Interest Rate & & \begin{tabular}{l} 90% \\ Budoet Pinan \end{tabular} & & 90% & & 90% & & & 90% \\ \hline \end{tabular} nstructions - President Theater All Mode Questions will be taken in the Student Lounge Discussion Gioup 1 Enter Your Name Right Here, in C.ell B3. NOW This will put your name on all the pages Save the Flle as Yourfirstrame YourLastName All Mode_Presidents_Theater_Budget Save the File Ofien. It is also a good idea to make a backup copy under another name occevionally, then save it back under the oniginal. There are three Sheets in this Excel Workbook. Move between them by clicking on the Tabs at the Blotiom Only Only Only Enter in Yellow Colored Cells, Like B3 If you accitentally erase a cell with a formula, it is gone. Try to Undo with the Left Arow. If that does not work, close the file without savisg and reopen it to the last time that you saved. Only Only Only Enter in Yellow Colored Cells, Like B3 Case. Descriptien Your are the Owner of the President Theater, It is also your fult time job, for which you draw a salary to Ifve on. Iwo years ago, the President Theater had a snall low. Lau year, tacing a much targer loss, you weat to the Bank asd borrowed an additional 5100,000 . The Bank, howner, has said that the current amount is the maximum that your business can borrow. The buniness now needs to put logether o Business Plan or thudget for the coming year. If you run out of cash, you will go out of business, lose the theater, and your job. Good Luck. Prepare a completing the Yellow Areas on "Fudget Questions and Answen" and on "Budget Financial Forecasf There are three parts to this assignment 1) Explain some of the Computations IN YOUR OWN WOADS. 2) First Cut Budget. Bated on what you think will happen to your costs and 3) The Second Cut Budget are changes that you can make to stay in business and keep the Theater open for another year. 4) What You might Change in a Third Cut Budgot Success will be a Positive Cash Balance at the End of the Final Budget. If you have Cash Left (and Explained Why), you win. 2 Follow the instructions iN ORDER on "Gudget Ouestions and Anuntis" Only Only Only Enter in Yellow Colored Cells, Like B3 Yeua man work innether en this. however, everv student should do their OWN file. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} President Theater \\ Enter Your Name Right Here, in Cell B3 - \end{tabular}} & \multirow{3}{*}{\begin{tabular}{l} Two Years \\ Ago Actual \end{tabular}} & \multirow{3}{*}{\begin{tabular}{l} Last Year \\ Actual \end{tabular}} & \multirow{3}{*}{\begin{tabular}{c} First Cut \\ % \\ Change \end{tabular}} & \multirow{3}{*}{\begin{tabular}{l} First Cut \\ Next Year \\ Budget \end{tabular}} & \multirow{3}{*}{\begin{tabular}{c} Second \\ Cut % \\ Change \end{tabular}} & \multirow{3}{*}{\begin{tabular}{c} Second Cut \\ Next Year \\ Budget \end{tabular}} \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \# Balanc & $600.000 & \$ 700,000 & - & \$ 700,000 & - & $700,000 \\ \hline X\# Interest Rate & 9.0% & & & & - & 9.0% \\ \hline= Total Interest Expense & 54,000 & 63,000 & & 63,000 & & 63,000 \\ \hline & & & First Cut & & Second & \multirow{2}{*}{\begin{tabular}{l} Second Cut \\ Next Year \end{tabular}} \\ \hline & Two Years & Last Year & & Next Year & Cut & \\ \hline Financial summary & Ago Actual & Actual & Change & \multirow{2}{*}{$323,222Budget} & Change & Budget \\ \hline Movie Ticket Sales - To & $325,622 & \$ 323,222 & & & 0.0% & 222 \\ \hline Junk Food Revenue - & $126,947 & $130 & 0.0% & $130,876 & 0.0% & $13 \\ \hline Total Revenue & $462,569 & $454,098 & 0.0% & $454,098 & 0.0% & $454,098 \\ \hline & $213 & $23 & & s & & $23 \\ \hline & 50 & s & & s & & $ \\ \hline & 96,0 & \$ 105 & & $105 & & \$ 105,000 \\ \hline Your Salary - You Live o & 45.000 & \$ 45,000 & 0.0% & $45 & 0.0% & 45,000 \\ \hline Total Interest Expense & 54,000 & 63.000 & 0.0% & 63,000 & 0.0% & 63,000 \\ \hline & & in & & & n & \\ \hline \end{tabular}