Accounting 301
AutoSave . OH ACCT301CourseProjectSpreadsheet (6) - Protected View . Search (An-CO Irany Rj R X File Home Insert Page Layout Formulas Data Review View Add-ins Help Team & Share Comments D PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X PRODUCT DEACTIVATED To keep using Excel without interruption, please reactivate now. Reactivate X M12 X $200,000 net income target, B D E G H KLM N O 2 Target Market adult learners, timestarved, poor time management 4 Jan Feb April Total Qtr (A) Input the planned product mix Sales Average Sales Price/unit (B) Input the forecast sale volume 6 Units (B) (A) wetd (C) Input the number of pizza made per 7 Price/unit $ $ $ Sales Price (all 2 topping). % Sales average (D) Input the sales commission as a % 8 Total Sales Revenue S S S Large $ 10.50 S (E) Input the sales manager's salary 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 sa 11 Production $ 2.55 $ 2.55 $ 255 Direct Labor: (H) Calculate the sales units needed to 12 Selling [C) efficiency rate as minutes per pizza $200,000 het 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 S 15 CM per unit S (2 55) $ (2 55) $ (2.55) 16 CM Ratio #DIV/O #DIV/O #DIV/O Direct Materials. 17 Fixed Costs Dough $ 0.25 18 Selling (E) S S S cheese 0.50 19 Administration (F) toppings 0.75 20 Total Fixed Costs S $ caffinated tomato sauce 1.00 21 Boxes 0.05 22 Net Income 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 $ 26 Sales units for a Target Profit of $200,000 (H) 27 Operating Budget Cash Budget Variances Decisions Capital 91%