Acct301

Calibri LB Paste BI U - F - CA- Merge & Center ~ $ ~ % 9 $28 98 Conditional Format as Cell Insert Delete Format Sort & Find & Analy Formatting ~ Table ~ Styles ~ Filter ~ Select Dat Clipboard Font Alignment Number Styles Cells Editing Anal M12 X V $200,000 net income target, B C D E F G H KLM N O P Q 1 Prepare a Master Operating Budget for the First Quarter Buzz Pizza 2 Target Market: adult learners, timestarved, poor time management 3 4 Jan Feb April Total Qu (A) Input the planned product mix 5 Sales Average Sales Price/unit (B) Input the forecast sale volume 6 Units (B) (A) wgtd. (C) Input the number of pizza made per hour 7 Price/unit S - S - Sales Price (all 2 topping): % Sales average (D) Input the sales commission as a % of revenue 8 Total Sales Revenue S S S S Large S 10.50 S (E) Input the sales manager's salary 9 Medium $ 8.50 S (F) Input the office manager's salary 10 Variable Costs (stated as per unit) 0% S (G) Calculate the breakeven point in sales units 11 Production S 255 S 2.55 S 255 Direct Labor. (H) Calculate the sales units needed to reach a 12 Selling C) efficiency rate as minutes per pizza $200,000 het income target, 13 Total Variable Costs per unit S 255 $ 2 55 $ 2.55 hourly labor cost plus fringe benefits | $ 12 00 14 Contribution Margin S S - S Total direct labor per pizza S 15 CM per unit S (2 55) S (2.55) $ (2.55) 16 CM Ratio #DIV/01 #DIV/0! #DIV/O! Direct Materials: 17 Fixed Costs Dough S 0.25 18 Selling (E) S S S cheese 0.50 19 Administration (F) toppings 0.75 20 Total Fixed Costs S S S caffinated tomato sauce 1.00 21 Boxes 0.05 22 Net Income S S - S Total direct material per pizza S 2.55 23 24 Breakeven Point in sales units (G) Sales comissions (D) 25 Total Variable Selling Expenses per pizza S 26 Sales units for a Target Profit of $200,000 (H) 27 Operating Budget Cash Budget Variances Decisions Capital +