You are the owner of the President Theater. It is also your full time job, for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are the owner of the President Theater. It is also your full time job, for which you draw a salary to live on. Two years ago, the President Theater had a small loss. Last year, facing a much larger loss, you went to the Bank and borrowed an additional $100,000. The Bank, however, has said that the current amount is the maximum that your business can borrow. The business now needs to put together a Business Plan or Budget 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 "Budget Questions and Answers" and on "Budget Financial Forecast" There are three parts to this assignment 1) Explain some of the Computations IN YOUR OWN WORDS. 2) First Cut Budget-Based 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 Budget 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 "Budget Questions and Answers" Only Only Only Enter in Yellow Colored Cells, Like B3 You may work together on this, however, every student should do their OWN file. President Theater 2 Enter Your Name Right Here, in Cell B3-NOW X 7 = Revenue Development # Number of Movies Shown X 9= 11 B4 Number of Tickets Sold 12 X Percent Tickets who Buy Junk Food 13= # of Ticket holders Buying Junk Food 14 X Average Price per Junk Food 15 = Junk Food Revenue - Total 17 Cost Development 18 B4 Number of Tickets Sold 19 X Avg. Cost /Ticket to Movie Producers 20 Total Cost for Movie Tickets 21 22 B4 # of Ticket holders Buying Junk Food 23 X Avg. Cost per Junk Food Sold 24 Total Cost for Junk Food 29 X 30 = Average Number of Tickets/Movie Number of Tickets Sold 25 26 B4 Number of Movies Shown 27 X Number of Employee Hours per Show 28 Total Number of Employee Hours 31 32 # Average Price per Ticket Movie Ticket Sales -Total 33 34 # 35 X# RE 45 46 47 36 = Total Interest Expense 37 Rate of Pay per Cost per Hour Total Cost of Employees Your Salary - You Live on This Balance of Loan Interest Rate Financial Summary Movie Ticket Sales -Total Junk Food Revenue - Total 43 Total Revenue Total Cost for Movie Tickets Total Cost for Junk Food Total Cost of Employees Your Salary - You Live on This Total Interest Expense 50 Total Expenses 51 52 Total Profit (Loss) Two Years Ago Actual $ $ $ $ $ 55 $ $ $ $ $ $ $ $ $ $ $ $ $ 500 98.0 49,000 $ 6.65 $ 325,622 $ 49,000 70.0% 34,300 3.70 $ 126,947 $ 49,000 4.35 $ 213,000 $ Two Years Ago Actual 34,300 1.46 $ 50,100 $ 500 24.0 12,000 8.00 $ 96,000 $ 45,000 $ 600,000 $ 9.0% 54,000 $ 53 54 Capital Investment Projects (Enter as Negative Numbers) 55 1) Fix Roof 56 2) New Ticket System to Cut Employees 57 Ending Cash Balance 58 325,622 $ 126,947 $ 452,569 $ 213,000 $ 50,100 $ 96,000 $ 45,000 $ 54,000 $ 458,100 $ (5,531) $ 5,123 S Last Year Actual 500 97.0 48,500 6.66 323,222 48,500 71.0% 34,435 3.80 130,876 48,500 4.76 231,000 34,435 1.75 60,300 500 24.0 12,000 8.75 105,000 45,000 700,000 9.0% 63,000 Last Year Actual 323,222 130,876 454,098 231,000 60,300 105,000 45,000 63,000 504,300 (50,202) 54,921 First Cut % Change - | | | F $ $ F First Cut % Change $ $ 0.0% $ $ 0.0% $ $ 0.0% S $ 0.0% $ $ $ 0.0% S 0.0% $ 0.0% $ 0.0% S 0.0% S 0.0% $ 0.0% $ 0.0% $ 0.0% $ $ $ First Cut Next Year Budget $ 500 97.0 48,500 6.66 323,222 48,500 71.0% 34,435 3.80 130,876 48,500 4.76 231,000 34,435 1.75 60,300 500 24.0 12,000 8.75 105,000 45,000 700,000 9.0% 63,000 First Cut Next Year Budget 323,222 130,876 454,098 231,000 60,300 105,000 45,000 63,000 504,300 (50,202) 4,719 Second Cut % Change 0.0% 0.0% 0.0% $ $ 0.0% F 0.0% $ $ - Second Cut Next Year Budget 0.0% - $ $ $ $ Second Cut% Change 0.0% $ $ 0.0% $ $ $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ $ 500 97.0 $ 48,500 6.66 323,222 48,500 71.0% 34,435 3.80 130,876 48,500 4.76 231,000 Second Cut Next Year Budget 34,435 1.75 60,300 500 24.0 12,000 8.75 105,000 45,000 700,000 9.0% 63,000 323,222 130,876 454,098 231,000 60,300 105,000 45,000 63,000 504,300 (50,202) 4,719 You are the owner of the President Theater. It is also your full time job, for which you draw a salary to live on. Two years ago, the President Theater had a small loss. Last year, facing a much larger loss, you went to the Bank and borrowed an additional $100,000. The Bank, however, has said that the current amount is the maximum that your business can borrow. The business now needs to put together a Business Plan or Budget 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 "Budget Questions and Answers" and on "Budget Financial Forecast" There are three parts to this assignment 1) Explain some of the Computations IN YOUR OWN WORDS. 2) First Cut Budget-Based 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 Budget 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 "Budget Questions and Answers" Only Only Only Enter in Yellow Colored Cells, Like B3 You may work together on this, however, every student should do their OWN file. President Theater 2 Enter Your Name Right Here, in Cell B3-NOW X 7 = Revenue Development # Number of Movies Shown X 9= 11 B4 Number of Tickets Sold 12 X Percent Tickets who Buy Junk Food 13= # of Ticket holders Buying Junk Food 14 X Average Price per Junk Food 15 = Junk Food Revenue - Total 17 Cost Development 18 B4 Number of Tickets Sold 19 X Avg. Cost /Ticket to Movie Producers 20 Total Cost for Movie Tickets 21 22 B4 # of Ticket holders Buying Junk Food 23 X Avg. Cost per Junk Food Sold 24 Total Cost for Junk Food 29 X 30 = Average Number of Tickets/Movie Number of Tickets Sold 25 26 B4 Number of Movies Shown 27 X Number of Employee Hours per Show 28 Total Number of Employee Hours 31 32 # Average Price per Ticket Movie Ticket Sales -Total 33 34 # 35 X# RE 45 46 47 36 = Total Interest Expense 37 Rate of Pay per Cost per Hour Total Cost of Employees Your Salary - You Live on This Balance of Loan Interest Rate Financial Summary Movie Ticket Sales -Total Junk Food Revenue - Total 43 Total Revenue Total Cost for Movie Tickets Total Cost for Junk Food Total Cost of Employees Your Salary - You Live on This Total Interest Expense 50 Total Expenses 51 52 Total Profit (Loss) Two Years Ago Actual $ $ $ $ $ 55 $ $ $ $ $ $ $ $ $ $ $ $ $ 500 98.0 49,000 $ 6.65 $ 325,622 $ 49,000 70.0% 34,300 3.70 $ 126,947 $ 49,000 4.35 $ 213,000 $ Two Years Ago Actual 34,300 1.46 $ 50,100 $ 500 24.0 12,000 8.00 $ 96,000 $ 45,000 $ 600,000 $ 9.0% 54,000 $ 53 54 Capital Investment Projects (Enter as Negative Numbers) 55 1) Fix Roof 56 2) New Ticket System to Cut Employees 57 Ending Cash Balance 58 325,622 $ 126,947 $ 452,569 $ 213,000 $ 50,100 $ 96,000 $ 45,000 $ 54,000 $ 458,100 $ (5,531) $ 5,123 S Last Year Actual 500 97.0 48,500 6.66 323,222 48,500 71.0% 34,435 3.80 130,876 48,500 4.76 231,000 34,435 1.75 60,300 500 24.0 12,000 8.75 105,000 45,000 700,000 9.0% 63,000 Last Year Actual 323,222 130,876 454,098 231,000 60,300 105,000 45,000 63,000 504,300 (50,202) 54,921 First Cut % Change - | | | F $ $ F First Cut % Change $ $ 0.0% $ $ 0.0% $ $ 0.0% S $ 0.0% $ $ $ 0.0% S 0.0% $ 0.0% $ 0.0% S 0.0% S 0.0% $ 0.0% $ 0.0% $ 0.0% $ $ $ First Cut Next Year Budget $ 500 97.0 48,500 6.66 323,222 48,500 71.0% 34,435 3.80 130,876 48,500 4.76 231,000 34,435 1.75 60,300 500 24.0 12,000 8.75 105,000 45,000 700,000 9.0% 63,000 First Cut Next Year Budget 323,222 130,876 454,098 231,000 60,300 105,000 45,000 63,000 504,300 (50,202) 4,719 Second Cut % Change 0.0% 0.0% 0.0% $ $ 0.0% F 0.0% $ $ - Second Cut Next Year Budget 0.0% - $ $ $ $ Second Cut% Change 0.0% $ $ 0.0% $ $ $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ 0.0% $ $ 500 97.0 $ 48,500 6.66 323,222 48,500 71.0% 34,435 3.80 130,876 48,500 4.76 231,000 Second Cut Next Year Budget 34,435 1.75 60,300 500 24.0 12,000 8.75 105,000 45,000 700,000 9.0% 63,000 323,222 130,876 454,098 231,000 60,300 105,000 45,000 63,000 504,300 (50,202) 4,719
Expert Answer:
Answer rating: 100% (QA)
Computations The First Cut Budget is based on the current situation and what is expected to happen i... View the full answer
Related Book For
Fraud examination
ISBN: 978-0538470841
4th edition
Authors: Steve Albrecht, Chad Albrecht, Conan Albrecht, Mark zimbelma
Posted Date:
Students also viewed these accounting questions
-
You are the owner of a privately owned, moderate sized company. The business was founded over 20 years ago and has experienced impressive growth and profitability. The only frustrating thing,...
-
You are the owner of a small hard ware store, and you are considering opening a gardening store in a vacant area in the back of your present store. You estimate that it will cost you $50,000 to set...
-
You are the owner of two furniture stores: one catering to upper-middle class consumers and the other to lower class consumers. How do social class differences influence each stores: (a) Product...
-
5.8 Calculate the U value for the following double- glazed windows assuming the temperatures and the heat transfer coefficients as given in Example 5.1: (a) Ordinary glass with vacuum between the...
-
Why do interest rates on consumer loans typically average higher than on most other kinds of loans?
-
(Single-step Income, Retained Earnings, Periodic Inventory) Presented below is the trial balance of Mary J. Blige Corporation at December 31, 2004. A physical count of inventory on December 31...
-
Identify and describe the key attributes that might mitigate a red flag, suggesting that no bad act or compliance issues exist.
-
The trial balance of Avtar Sandhu Co. shown below does not balance. Each of the listed accounts has a normal balance per the general ledger. An examination of the ledger and journal reveals the...
-
3. The length of the biceps muscle increases 1.7cm over the course of an overhead softball throw. The stiffness constant for the biceps is 225,000 N/cm. Calculate the strain potential energy (in Nm)...
-
The following account balances are for Lisa Assaad, Certified Public Accountant, as of April 30, 20X1. INSTRUCTIONS Using the accounting equation form, determine the balance for Lisa Assaad, Capital,...
-
Find the worst case run time function f(n) of the following algorithm. int sum = 0; for (int i; i
-
Discuss which of the theories from HRTM 7708 you think is most consistent with your philosophy on managing people in the hospitality & tourism industry. Why? Would your response have been different...
-
A car dealership claims to give customers a median trade-in offer of at least $6000. A random sample of 103 transactions revealed that the trade-in offer for 60 automobiles was less than $6000 and...
-
1. why are digital payments disruptive to traditional banking? 2.Will we value an ICO and an STO differently? Why? 3. Do you think the abnormal price pattern is sustainable in the long run? Why or...
-
Calculate RT for the circuit below. R1 = 18 kQQ, R2 = 11 kQQ, and R3 = 19 kQ R2 Vs Answer:
-
write a class that satisfies the PersonDriver: The class will contain the following: An abstract Person class that contains one abstract method "public abstract String doesForALiving()" An interface...
-
A portfolio comprises of two bonds. Bond X, worth 10 million, has a daily volatility of 0.5%. Bond Y, worth 30 million, has a daily volatility of 1%. The correlation coefficient between the two bonds...
-
Complete the equations for the following equilibria and calculate Keq where the Keq expression includes [HO]. Be sure to enter Keq in proper scientific notation. (a) ammonia (acting as a base) reacts...
-
The following actual fraud occurred in a communications company. What Ruth Mishkin did in her spare time didnt concern the Boca Raton, Florida, public relations firm where she worked very much. We...
-
How can tips and complaints help in detecting fraud?
-
How does the Internet assist in determining the net worth of suspected perpetrators?
-
A surface with \(N_{0}\) adsorption centers has \(N\left(\leq N_{0}ight)\) gas molecules adsorbed on it. Show that the chemical potential of the adsorbed molecules is given by \[ \mu=k T \ln...
-
Assuming that the latent heat of vaporization of water \(L_{\mathrm{V}}=2260 \mathrm{~kJ} / \mathrm{kg}\) is independent of temperature and the specific volume of the liquid phase is negligible...
-
Define a quantity \(J\) as \[ J=E-N \mu=T S-P V \] Show that for a system in the grand canonical ensemble \[ \overline{(\Delta J)^{2}}=k T^{2} C_{V}+\left\{\left(\frac{\partial U}{\partial...
Study smarter with the SolutionInn App