Acct301

Editin Number Styles Cells Clipboard Font Alignment PRODUCT DEACTIVATED To keep using Excel without interruption, please reactivate now. Reactivate M12 X V fx $200,000 net income target, 0 P Q R S B C E G H J K L M N D F Prepare a Master Operating Budget for the First Quarter Buzz Pizza 2 Target Market aduk learners, timestarved, poor time management 3 Jan Feb April Total Du (A] Input the planned product mix Sales Average Sales Pricelunit (B] Input the forecast sale volume 6 Units (B] (A] word (C] Input the number of pizza made per hour Pricelunit $ - - $ Sales Price (all 2 topping): Sales average (D) Input the sales commission as a % of revenue Total Sales Revenue $ - - $ Large $ 10.50 (E) Input the sales manager's salary Medium $ 8.50 (F) Inpur the office manager's salary 10 Variable Costs (stated as per unit) 0% $ (G] Calculate the breakeven point in sales units 11 Production 255 $ 255 $ 255 Direct Labor: (H) Calculate the sales units needed to reach a 12 Selling (C) efficiency rate as minutes per pizza $200,00 net income target, 13 Total Variable Costs per unit 2.55 $ 2.55 $ 2.55 hourly labor cost plus fringe benefits $ 12.00 14 Contribution Margin Total direct labor per pizza $ 15 CM per unit $ (255) $ (2.55) $ (2 55) 16 CM Ratio #DIVIO #DIV/O #DIV/O Direct Materials: 17 Fixed Costs Selling (E) Dough $ 18 0.25 $ $ 19 Administration (F) cheese 0.50 20 Total Fixed Costs toppings 0.75 $ 21 caffinated tomato sauce 1.00 22 Boxes Net Income 0.05 $ 23 Total direct material per pizza $ 255 24 Breakeven Point in sales units (G) 25 Sales comissions (D) 26 Sales units for a Target Profit of $200,000 (H) Total Variable Selling Expenses per pizza $ 27 28 29 Operating Budget Cash Budget Variances Decisions Capital (+ Ready