*******************************PLEASE SHOW FORMULAS*******************************

Insert formulas and cell references into the gold cells below. March April May June July Quarter Total (April, Moy, June) Sales Projections: [1] Quantities Revenues 320,000 268.200 boxes of muesli 360,000 3,060,000 288.000 2,448,000 267.000 2,269,500 Production Plan: [2] Required for Sales + Desired Ending Finished Goods Inventory - Beginning Finished Goods Inventory Required Production boxes of muesli Raw Materials Purchases: [3] Required Production Kilograms of Raw Materials for Production +Desired Ending Raw Materials Inventory -Beginning Raw Materials Inventory Required Purchases of Raw Materials (Kg) Cost of Raw Materials Purchases 13,962 Kg Fixed Manufactu Other Purchases: [4] Manufacturing Overhead Less Depreciation (not a cash expense) Manufacturing Overhead Cash Purchases Fixed Direct Labor Fixed Selling & Admin Variable Selling & Admin (. 20 per unit sold) Total Other Purchases