The managers of UD Flyer Pizza ask you to do a 3-year financial analysis of total...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The managers of UD Flyer Pizza ask you to do a 3-year financial analysis of total profit -- based on the following data and information the managers have gathered. Sales volume in the first year is estimated to be 100,000 units and is projected to grow each year at a rate that is normally distributed with a mean of 7% and a stdev of 4%. The selling price in year 1 will be $10 (average over the total units sold) and the price increase in each of the following years is estimated to be normally distributed with a mean of $0.50 and a stdev of $0.05. Per-unit variable cost is $3 and annual fixed costs are $200,000 for year 1. Per-unit variable costs are expected to change by an amount normally distribued with a mean of 5% per year and stdev of 2%. Fixed costs are expected to increase each year estimated as normally distributed with a mean of 10% per year and stdev of 3%. In addition to estimated 3-yr profit, suppose the UD Flyer Pizza general manager also wants you to estimate (1) the likelihood that the 3-year profit will be over $1,800,000, (2) over $2,000,000, and (3) risk that the profit will not show an increase over the three years, i.e. the 2nd and 3rd year profits will, on average, be no more than the 1st year. Since the 1st year profit is estimated at 5500,00, this is the same as the probability that 3-yr profit is <= $1,500,000. Perform analysis work (complete BFDA) for these two cases in one excel file. For each case, use 1000 trials & after obtaining the results you will use, be sure to freeze the 1000 values of the objective measures. The manager asks one more question: If we spend $50,000 each of the 3 years on advertising & it is estimated to result in sales growth that yields 108,000 units the first year and growth averaging 10% for years 2 and 3 (same stdev of growth), what are the answers to the same business questions? Assume marketing costs will not change for years 2 and 3. Note, for the third question, since with advertising the first year profit is $506,000, this is the same as the probability that 3-yr profit is <= $1,518,000. UD Pizza -- 3-Year Financial Analysis. The managers of UD Flyer Pizza ask you to do a 3-year financial analysis of total profit -- based on the following data and information the managers have gathered. Sales volume in the first year is estimated to be 100,000 units and is projected to grow each year at a rate that is normally distributed with a mean of 7% and a stdev of 4%. The selling price in year 1 will be $10 (average over the total units sold) and the price increase in each of the following years is estimated to be normally distributed with a mean of $0.50 and a stdev of $0.05. Per-unit variable cost is $3 and annual fixed costs are $200,000 for year 1. Per-unit variable costs are expected to change by an amount normally distribued with a mean of 5% per year and stdev of 2%. Fixed costs are expected to increase each year estimated as normally distributed with a mean of 10% per year and stdev of 3%. In addition to estimated 3-yr profit, suppose the UD Flyer Pizza general manager also wants you to estimate (1) the likelihood that the 3-year profit will be over $1,800,000, (2) over $2,000,000, and (3) risk that the profit will not show an increase over the three years, i.e. the 2nd and 3rd year profits will, on average, be no more than the 1st year. Since the 1st year profit is estimated at 5500,00, this is the same as the probability that 3-yr profit is <= $1,500,000. Perform analysis work (complete BFDA) for these two cases in one excel file. For each case, use 1000 trials & after obtaining the results you will use, be sure to freeze the 1000 values of the objective measures. The manager asks one more question: If we spend $50,000 each of the 3 years on advertising & it is estimated to result in sales growth that yields 108,000 units the first year and growth averaging 10% for years 2 and 3 (same stdev of growth), what are the answers to the same business questions? Assume marketing costs will not change for years 2 and 3. Note, for the third question, since with advertising the first year profit is $506,000, this is the same as the probability that 3-yr profit is <= $1,518,000. UD Pizza -- 3-Year Financial Analysis.
Expert Answer:
Answer rating: 100% (QA)
WITHOUT ADVERTISEMENT Particulars Year 1 Year 2 Year 3 No of Units 100000 102720 105514 Mean 7 Standard Deviation 4 Average Selling Price per Unit 100... View the full answer
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these mathematics questions
-
For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $ 12 and will increase by $ 0.50 each year....
-
For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $ 12 and will increase by $ 0.50 each year....
-
For a new product, sales volume in the first year is estimated to be 80,000 units and is projected to grow at a rate of 4% per year. The selling price is $ 12 and will increase by $ 0.50 each year....
-
In April 2016, Vanessa bought 100 shares in Entagon plc at a cost of 5 per share. The company went into liquidation and Vanessa received a first distribution of 40p per share in July 2020. The shares...
-
The Consumer Product Testing Laboratory selects a dozen batteries (labeled 9 volts) from each company that makes them. Each battery is tested for its actual voltage level. a. Are the values obtained...
-
John and Marylynne agree to form a partnership on 16 September 2017 to supply first-aid kits to motor vehicle dealers. They agree on the following market values given to them by an independent...
-
The data below pertains to the number of hours a laptop has been charged for and the number of hours of backup provided by the battery. (a) Use the first set of expressions on page 330, involving...
-
(Multiple Choice) 1. All America Bank, the nationwide banking company, owns many types of investments. Assume that All America Bank paid $650,000 for trading securities on December 5. Two weeks...
-
Let sequence (an) be -8, -3, 2, 7, ... (a = -8) a. Find recursive formula for an. b. Find explicit (iterative) formula for an
-
In this mini-case, you will complete the test of details on accounts receivable for the 2019 audit of EarthWear Clothiers, Inc. The principal test of detail involves sending "confirmations" or...
-
On January 1, 2017, McIlroy, Inc., acquired a 60 percent interest in the common stock of Stinson, Inc., for $312,000. Stinson's book value on that date consisted of common stock of $100,000 and...
-
a. How can a repurchase agreement be used by a dealer firm to finance a long position in a Treasury security? b. One party in a repo transaction is said to "buy collateral," the other party to "sell...
-
What is the drawback of using currency forward contracts for hedging long-dated positions?
-
a. What is the difference between a STRIP, a trademark Treasury zero-coupon security, and a Treasiry receipt? b. What is the most common type of Treasury zero-coupon security?
-
Explain three factors that could cause an increase in the level of consumption in an economy.
-
Explain the difference between the components of aggregate demand and the determinants of aggregate demand.
-
Suppose a company has 50 million shares outstanding at a price of $52.14 per share. The market value of its debt is $17 billion. What is the market value of its assets in billions of dollars
-
What is beacon marketing? What are digital wallets?
-
Identify each of the variables in the Excel file Credit Approval Decisions as categorical, ordinal, interval, or ratio and explain why.
-
PLE has developed a prototype for a new snow blower for the consumer market. This can exploit the companys expertise in small gasoline engine technology and also balance seasonal demand cycles in the...
-
River, NJ: Prentice Hall, 2011).The Excel file Science and Engineering Jobs shows the number of jobs in thousands in the year 2000 and projections for 2010 from a government study. Use the Excel file...
-
Nestls financial statements are presented in Appendix B. Financial statements of Delfi Limited are presented in Appendix C. Instructions Refer to the financial statements and answer the following...
-
Writing Financial statement information about four different companies is as follows. Instructions a. Determine the missing amounts. (Hint: For example, to solve for (a), Assets Liabilities = Equity...
-
The financial statements of TSMC are presented in Appendix A. The complete annual report, including the notes to the financial statements, is available at the companys website. Instructions Refer to...
Study smarter with the SolutionInn App