Acct301, week 7 corse project
-
peratlng Budget Cash Budget Variances Decisions Capital are a Master Operating Budget for the First Quarter Buzz Pizza I Target Market: adult learners. limcstarvcd. poor lirnc management in Ed: aunt Wit : Average Salei li'l'ice:f {B} 0 (: Pricefurlit [I nu Sales Price {all 2 topping): M Sales Revenue [I I] I) [I Large 10.5 Medium 8.5 ale Costs (stated as per unit) lotion 2.55 2.55 2.55 Direct Labor: 3 [I [I I) (C) efficiency rate as minutes per pizza Variable Costs per unit 2.55 hourly labor cost plus fringe benets 12 ibutiun Margin [I [I D Total direct labor per pizza 0 CM per unit 4.55 -2.55 -2.55 CM Ratio Direct Materials: Costs Dough 0.25 .3 (E) I] I] [I cheese I15 nistration (I?) I I III 0| 0| toppings I175 Fixed. Costs [I D D caff'lnatecl tomato sauce 1 Boxes 0.05 warm [I H mm Total direct material per pizza 155' :even Point in sales units units for a Target Prot of $100,000 I ItH} Sales comissiom (D) Total Variable Selling Expenses per pizza Ll] CCT301CourseProjectSpreadsheet (8) - Protected View . Search (Alt+() Irany Rj E Formulas Data Review View Add-ins Help Team Share Com 000 net income target, F Prepare a Master Operating Budget for the First Quarter Buzz Pizza Target Market: adult learners, timestarved, poor time management Jan Feb April Total Orr [A] Input the planned product mis Sales Average Sales Pricelunit (B] Input the forecast sale volume Units (B) [A] wgtd (C] Input the number of pizza made per hou Price/unit $ Sales Price (all 2 topping) Zasales average (0] Input the sales commission as a % of res Total Sales Revenue Large $ 10.50 $ - (E] Input the sales manager's salary Medium $ 8.50 (F] Input the office manager's salary Variable Costs (stated as per unit] 0% $ (G] Calculate the breakeven point in sales u Production 2.55 $ 2.55 $ 2.55 Direct Labor. (H] Calculate the sales units needed to read Selling (C] efficiency rate as minutes per pizza $200,00 net income target Total Variable Costs per unit 2.55 $ 2.55 $ 2.55 hourly labor cost plus fringe benefits| $ 12:00 Contribution Margin $ - Total direct labor per pizza $ CM per unit $ (2.55) $ (2.55) CM Ratio #DIV/O! #DIV/0! #DIV/0! Direct Materials. Fixed Costs Dough 0.25 Selling (E] sheese 0.50 Administration [F) toppings 0.75 20 Total Fixed Costs caffinated tomato sauce 100 Boxes 0.05 Net Income Total direct material per pizza $ 2 55 24 Breakeven Point in sales units (G] Sales comissions (D] Total Variable Selling Expenses per pizza $ 26 Sales units for a Target Profit of $200,000 27 29 31 32 33 Operating Budget Cash Budget Variances Decisions Capital 709% 12:45 PM 9 T X 8/22/2021 2000 f10 112 insert ort sc delete 144 % backspace home 4 5 O pg R T Y U O P L enter F G H K
