This is the trickiest break-even case to solve because there are two levels of fixed costs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This is the trickiest break-even case to solve because there are two levels of fixed costs depending on whether 20,000 spectators is surpassed or not. It is necessary for this worksheet to have an IF function in cell C32. The important data you need is: Fixed Costs will be $200,000 if total spectators is 20,000 or less; but Fixed Costs will be $300,000 if spectators go over 20,000 Variable Cost per Participant: $3.00 Ticket Price per Participant: $15 As with other cases formulae have been inserted into a number cells to make your task easier. Enter above data into the appropriate YELLOW cells. Then by trial an error find out what number goes into the BLUE CELL to make the profit closest to zero. This case actually has TWO answers depending on whether 20,000 spectators is exceeded. This is the trickiest break-even case to solve because there are two levels of fixed costs depending on whether 20,000 spectators is surpassed or not. It is necessary for this worksheet to have an IF function in cell C32. The important data you need is: Fixed Costs will be $200,000 if total spectators is 20,000 or less; but Fixed Costs will be $300,000 if spectators go over 20,000 Variable Cost per Participant: $3.00 Ticket Price per Participant: $15 As with other cases formulae have been inserted into a number cells to make your task easier. Enter above data into the appropriate YELLOW cells. Then by trial an error find out what number goes into the BLUE CELL to make the profit closest to zero. This case actually has TWO answers depending on whether 20,000 spectators is exceeded.
Expert Answer:
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
In a plant producing multiple products, would absorption costing overcost or undercost the more complex products? Why?
-
The balance sheet of Walton Wallcoverings Company reported the following: Redeemable preferred stock, 6%, $90 par value, redemption value $25,000; outstanding 200...
-
For F(x) = 1 / x - 3 Find each value (a) f(0.25) (b) f() (c) f(3 + 2)
-
Refer to the stockholders' equity of Sterling Trust in Short Exercise 13-9. Sterling has not declared preferred dividends for 5 years (including the current year). Compute the book value per share of...
-
Calculating Annuity Values you are serving on a jury. A plaintiff is suing the city for injuries sustained after a freak street sweeper accident. In the trial, doctors testified that it will be five...
-
The Difference Quotient of a Function Consider f(x) = 3x + 10. Practice a. Compute: f(a) - b. Compute and simplify: f(a + h) = - c. Compute and simplify: f(a + h) f(a) = d. Compute and simplify: -...
-
Files and More, Inc. (F&M), a manufacturer of office equipment, uses MRP to schedule its production. Because of the current recession and the need to cut costs, F&M has targeted inventory as a prime...
-
The Annapolis Corporation's stockholders' equity accounts have the following balances as of January 1, 2018: 12% preferred stock, cumulative, $50 par (10,000 shares issued and outstanding) $500,000...
-
A store is having a sale and items are either 30,50 , or \(70 \%\) off. Assuming all the items priced between \(\$ 5.00\) and \(\$ 50.00\) are on sale, output the following table using nested loops....
-
Rewrite the following for loop as a A. while loop *B. do-while loop int total, count; total = 0; for (count = 1; count
-
A part of the LineSI class from Section 5.6.1 is shown below. Identify necessary and unnecessary use of the keyword this. public class LineSI { // data members private static final double...
-
The Supreme Canning Company (the true name of the company is disguised) is an independent US packer of tomato paste and other tomato products (whole peeled tomatoes, chopped tomatoes, tomatoes and...
-
Repeat Exercise 12 to allow the user to repeat finding the Fibonacci number for an integer. Use input, message, and confirmation dialog boxes. Confirmation dialog boxes are discussed in Appendix A.6....
-
2. Find the roots of the following: (10 pts. each) z6 = 2 4i b. z - 2iz - 3i 5 = 0 .
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19 year-old nanny $125 per week for 48 weeks during the current year. a. What is the employers portion of...
-
In Gamble 1 you have a 99% chance of winning a trip to Venice and a 1% chance of winning tickets to a movie about Venice; and in Gamble 2, you have a 99% of winning the same trip to Venice and a 1%...
-
Business Taxes (contd): In exercise 13.11, we introduced a number of possible business taxes and asked what a firms response would be assuming that prices w, r and p remained unchanged. Now that we...
-
Suppose you are asked to model the savings decisions of a household that has an income of $100,000 this year but expects to have no income a period into the future. A. Suppose the interest rate is...
-
A W14 \(\times 30\) structural A992 steel column is pin connected at is ends and has a length \(L=12 \mathrm{ft}\). Determine the maximum eccentric load \(P\) that can be applied so the column does...
-
A W16 \(\times 45\) structural A992 steel column is fixed at the base and free at the top and has a length \(L=8 \mathrm{ft}\). Determine the maximum eccentric load \(P\) that can be applied so the...
-
Determine the \(\operatorname{load} P\) required to cause the steel \(\mathrm{W} 12 \times 50\) structural A-36 steel column to fail either by buckling or by yielding. The column is fixed at its...
Study smarter with the SolutionInn App