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...
-
Explain the benefits principle and the ability-to-pay principle. What are vertical equity and horizontal equity? Why is studying tax incidence important for determining the equity of a tax system?
-
A tall, narrow pyramidal organizational shape would tell us which of the following about the organization? A. Has functional departmentalization B. Has small span of management C. Violates the scalar...
-
Mega Millions is a multistate lottery in which players try to guess the numbers that will turn up in a drawing of numbered balls. One of the balls drawn is the Mega Ball. Matching the number drawn on...
-
Refer to the scenario described in Problem 10 and the file BlueOrRed. Partition the data into training (50 percent), validation (30 percent), and test (20 percent) sets. Fit a classification tree...
-
Question 6 [6] The three-year zero rate is 8% and the four-year zero rate is 8.8% (both continuously compounded). 6.1 6.2 Determine the forward rate for the fourth year. Explain how a forward rate...
-
1. Liam Richardson is the business manager for the Smith & Lyngate Insurance agencies in the state of Maryland. Liam is interested in increasing the number of agents in Baltimore and plans to buy...
-
. Which of the following will not be disclosed in retained earnings? 1. Declaration of a stock dividend 2. Adjustment for an error of the current period 3. Adjustment for an error of a prior period...
-
Solve the equation below: 4 x ^ 2 = 9
-
Two sides of a triangle have lengths 8 m and 14 m. The angle between them is increasing at a rate of 0.03radians/min. How fast is the length of the third side increasing when the angle between the...
-
A particle is moving along the curve y = 32x+5. As the particle passes through the point (2,9), its x-coordinate increases at a rate of 5 units per second. Find the rate of change of the distance...
-
17. Mass of Jupiter Io is one of the moons of Jupiter. It has a semi- major axis of 0.042 100 m and an orbital period of 1.769 days. Use these data to estimate the mass of Jupiter.
-
A movie theater needs to know how many adult tickets and children tickets were sold out of the 830 total tickets. If children's tickets are $7.20, adult tickets are $16, and the total amount of...
-
It is required to maintain an air-conditioned hall at 280C DBT and 200C WBT. It has a sensible heat load of 45.4KW and a latent heat load of 16.5 KW. The air supplied from the outside atmosphere at...
-
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 simplified vibration analysis of an airplane considers bounce and pitch motions (Fig. 6.24(a)). For this, a model consisting of a rigid bar (corresponding to the body of the airplane) supported on...
-
Derive the equations of motion, using Newton's second law of motion, for each of the systems shown in Figs. 6.21. Pulley, mass M, mass moment of inertia Jo 3r 3m T x(1) F(t) 2k 000 T x2(1) m T X3(1)...
-
Derive the equations of motion, using Newton's second law of motion, for each of the systems shown in Figs. 6.22. M, cos wt G 15 G3 13 ka 03 4 kn 12 G k3 16 G6 G Number of teeth on gear G, n, (i = 1...
Study smarter with the SolutionInn App