Marketing: You have a segmentation analysis of the lifestyle variables for the adult learners market. The results support the need to invigorate and refuel with comfort food that is also nourishing. What better choice for adults than pizza? What will fill this need and differentiate Buzz-Time Pizza is the caffeinated tomato sauce.

• Operations: You and a couple of friends will make, bake, and deliver made-to-order pizzas in two sizes. There is room in a garage for refrigeration, preparation tables, and a wood-fired oven. The sales manager will make all deliveries in his or her vehicle.
• 
  
• Financing: Clearly, this is a long-term investment. The three founders, who will each contribute an equal amount, have agreed not to draw a salary for 3 years. You have hired a sales manager and a part-time office manager.

Remember This

In Week 3, the first two deliverables involve preparing the necessary financial budgets in order to satisfy creditors and control business operations.

The Operating Budget

Input the sales volume, as projected by your Field Sales managers. The sales manager has provided the following sales estimates and price points for the first quarter of 2020. Input these values in the worksheet labelled Operating Budget.

Sales Estimates and Price Points for the First Quarter of 2020

	January	February	March
Number of pizzas sold	40,000	42,500	45,000
Sales Price for Large: $10.50
Sales Price for Medium: $8.50

1. Input your forecast product mix, as provided by the Marketing Department. There is much debate as to the probable sales mix between the two sizes. Input a product mix of your choice (make sure these two add up to 100%).
2. Input the efficiency rate for your direct labor, as projected by the VP of Manufacturing. Direct labor consists of your chef, Pepe, who has agreed to a low wage as long as cigarette and bathroom breaks are included. DO NOT CHANGE THIS LABOR RATE. However, you must calculate the chef's efficiency rate. Input your standard rate of how many minutes it will take to make one pizza from order to box.
3. Input the sales commission, as provided by the VP of Sales and the department's fixed costs. Ingredient and material costs, based on quotes after an extensive request for proposal (RFP), are good for two years. DO NOT CHANGE THE DIRECT MATERIAL RATES. The only variable selling cost is a sales commission based on a percent of sales revenue. Input the percent you wish to pay your sales manager.
4. Input the administrative fixed costs as provided by the CFO. Selling expenses include a fixed component for the sales manager's salary and car allowance for any company business use of their personal auto. Input the monthly salary you wish to pay for compensation.
5. Calculate the break-even sales.
6. Calculate sales volume needed to make $200,000 in net income.

   Remember This

   You are to look over this financial plan and make adjustments in the data you have input in order to obtain the most reasonable and not excessively optimistic results.

The Cash Budget

1. If needed, copy the sales from the first quarter operating budget. Ensure that the sales revenues for January through March is the same as that on the operating budget.
2. Using an aging of the collection period, as provided by the credit manager, forecast cash receipts by month. Calculate total cash receipts for January through March. For each month's cash disbursements, you are to assume that half of the direct material payments are from the current month's purchases and half are from the prior month's purchases. All selling and administrative expenses are paid in the month incurred.
3. Calculate the forecast direct material cash payments by month.
4. Determine the timing of a capital expenditure. You are to decide in which month to invest a significant amount of cash in a facility expansion.
5. Determine the timing and amount of financing. You are also to decide on the timing and amount of financing that will cover any month in which you do not meet the compensating cash balance requirement.

 
 

.

ACCT3CICourseProjeci5preassheetalsa - Excel Danny Moua 3 - O X 2 Share File Home asert Page Lavout Formulas Deta Rav Vie Fale Team Tell me what you want to do * cut E Autosum Caliori A A ah Wiae Text Ceneral Normal ad P Copy- + Fill- Curditional Forrne. as Good Formatting labie Pa:le BIUT - Marge k Cetar 5. % > Neutral Inseri Deleie Funat Sort & Firut o * Format Painter Cleer Filtar - Salact- Cliahcard Fert Aligrment Numher Stylas Colls Editing N17 fr KL P 3 (A) Inaut the plarned pracuct mix (B) Inaut thc feretast sale volume (C) Inaut the nummbar of pizza mada per hour Jan Feh April Tatal Ctr 5 Soles 5 Units (B| Average Sales Price/Lnit (A) wgtd. Sales Price (all 2 topping: * Soles (DJ Inaut the sales commission as a % of revenue (E) Inaut the soles manager's salary (F) Inaut the office manager a salary 7. Price/unit $ average Total Sales Reverue Large $ 10.50 Medium $ 450 A 50 10 Voriable Costs (sated as per unit 0% S (G) Calculate the breakeven point in sales units (HI Calculate the sales units reeded to reecti a 11 Production 2.55 $ 2.55 5 2.55 Direct Lebor: 12 Selling (C) erficiency rate as minutes per olzza $200.000 nel ircome largel. 13 Tolal Variatle Cosis per urit 2.55 5 2.55 $ 2.55 hourly labor cos. plus fringe teriefits $ 12.00 14 Contribution Margin Total direct laoor per aizza CM per unit_5 CM Ratio 15 (2.551 S 12.551_5 12.55) 15 #DV/O Direct Materials: 17 xed Costs Dongh .25 14 Selling (E) chease 14 adrministration (F) toap ngs caffinated tormata sauce 20 Total Fixed Cost: in 1.00 21 Buxes 0.05 22 Net Income Total irect nmaterial per alzza $ 2.55 23 21 Breakeveri Puint in seles urits IG) Sales comistiors (n) 25 Total Veriable Sellit: Epemes per vicce5 26 Seles units lor a Targel Prolit ul $200,000 (H) 27 28 24 31 32 33 34 Operating Budget Cash Budgot Variarees Drcisions Capital (4) Visplay Sztirs 314 O A: 10:17 PM P Type here to search 9. 1/26/2120