Question

I need help with calculating the numbers in this problem. I have been stuck on it for days. I apologize if my formatting isn't the best, this is the first time I've posted a question.

Case 1 A Saved Help Save & Exit Submit You received partial credit in the previous attempt. Check my work View previous attempt Miller Cereals is a small milling company that makes a single brand of cereal. Recently, a business school intern recommended that the company introduce a second cereal in order to "diversify the product portfolio." Currently, the company shows an operating profit that is 20 percent of sales. With the single product, other costs were twice the cost of rent. 10 points The intern estimated that the incremental profit of the new cereal would only be 4.5 percent of the incremental revenue, but it would still add to total profit. On his last day, the intern told Miller's marketing manager that his analysis was on the company laptop in a spreadsheet with a file name, New Product.xlsx. The intern then left for a 12-month walkabout in the outback of Australia and cannot be reached eBook Print References When the marketing manager opened the file, it was corrupted and could not be opened. She then found an early incomplete) copy on the company's backup server. The incomplete spreadsheet is shown as follows. The marketing manager then called a cost management accountant in the controller's office and asked for help in reconstructing the analysis. Required: As the management accountant, fill in the blank cells. (Do not round intermediate calculations. Round your final answers to the nearest whole number. Enter all amounts as positive values.) Miller Cereals Projected Income Statement For One Year Statue Oue: Increaca Alternative

Answer 1

For one status year Quo : % single product Increase/ (Decrease) Alternative a product Sales Revenue 155ooo 217000 62000 Costs Material 61000 19000 habour 4-2 000 42000 45%. $19000x100 155455 101. {working Note 14 47 48 I 85% 61000 5545 Rent | 6410 J 1662 (4748X1357 Depreciation 8200 utilities 4100 1 27% $1100 X 100 7 4 100 5200 1100 other 9496 (4748 X 2) [364 % I 144100 Working Notea) [34604 Total costs 124000 18321059210 operating profit 9% 31000 (155000 X 20%). 38790 $ 31000 2790 6 R000 X 4.5% 2020-2-5 11:35

LOATE Working Note 1 het the cost of labou be se se + 10 xde = 61000 re . te Glooo Tog te = G 1000 = 61000 x 10 10x tre Il be SI 9000 - 55.455 horking Nore a = 183 210 w Total costs costs Material habour Rent 1000 6 1000 6416 Deon 8206 5200 utilities other 41400 2020-2-5 11:35
Hey.. Let me know if you have understood the solution and whether it is right. Also, please upvote and comment if you have liked the solution and the presentation. Any suggestions are always welcome. Thanks