I would appreciate if there is an excel cell referencing please ! Thank you !

Sales Projections in Units January February March April May 35,574 58.090 26,418 42,264 48,597 Projected Sales Price (per unit) $ 371.00 Monthly Projected Selling & Administrative Expenses Variable Cost (per unit) $5.00 Fixed Costs $21,768 Production: Desired Ending Inventory (% Next Month) Beginning Inventory (new business) 31.0% 0 Materials Desired Ending Inventory (% Next Month) Amount of Materials per Unit Projected Cost per Material (Yard) Beginning Inventory (new business) 43.0% - 9. 0 $26.00 0 yds Direct Labor Time per Unit (in hours) Cost per Hour 1.60 hrs $10.40 Manufacturing Overhead Variable Cost (per Unit) Fixed Costs rate $3.60 $9,190 Type your name here (Last, First) Sales Projections in Units January February Apr 10 Projected Sales Price/Unit 12 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit Fixed Costs 16 Production: Desired Ending Inventory Beginning Inventory (new business) Materials Desired Ending Inventory Number of Materials per Unit Projected Cost Material Unit Beginning Inventory (new business) Direct Labor Time per Unit (in hours) Cost per Hour Manufacturing Overhead Variable Cost/Unit Fixed Costs SALES BUDGET January February March April May Projected Sales in Units Selling Price per Unit Total Sales First Quarter - Man - March) Anticipated Sales Dollars SELLING & ADMINISTRATIVE EXPENSE BUDGET January February March Sales in Units Variable S&A Rate/Unit Anticipated Variable Costs Fixed S&A Costs Total Anticipated Selling & 15 Administrative Costs PRODUCTION BUDGET January February March April May Sales in Units Desired Ending Inventory Total Units Needed Beginning Inventory Total Production in Units MATERIALS REQUIREMENTS BUDGET January February March April Units to be Produced Material Unit Total Production Need Desired Ending Inventory Direct Materials Costs Material/unit Total Materials Needed Beginning Inventory Cost per Unit of Material Total Materials Needed to be Purchased Cost of Material per Product Cost per Unit of Material Total Material Cost DIRECT LABOR BUDGET January February March Number of Units Produced Direct Labor Hours/Unit Total Direct Labor Hours Needed Cost/Direct Labor Hour Total Direct Labor Cost Direct Labor Costs Direct Labor Hours/Unit Cost/Direct Labor Hour Cost of Direct Labor per Product Predetermined OH Rate March Total Estimated OH Costs (for the quarter) Total Estimated DLHs (for the quarter) MANUFACTURING OVERHEAD BUDGET January February Production in Units Variable OH Rate/Unit Anticipated VOH Costs 1 Fixed OH Costs Total Anticipated OH Costs Manufacturing Overhead Predetermined MOH rate Total MOH Q1 DLHs per Unit MOH per Unit of Product PRODUCT COST PER UNIT Item Amount -57 Direct Materials Direct Labor Manufacturing Overhead Total Unit Cost See Direct Materials, Direct Labor, and Manufacturing Overhead calculations to the right (Columns F-L) March PROJECTED INCOME STATEMENT January February Sales in Units Sales Revenue Cost of Goods Sold: Gross Profit (Margin) Selling and Administrative (Operatinal Expenses Net Operating Income 5 Situation #1: What would the effect be on the Projected Operating Income if you decreased your selling price by 10% to match a price change by one of your competitors? 7 9 January 10 February 11 March 13 Would you recommend this action? Reasoning/Rationale: Situation #2 What would the effect be on the Projected Operating Income if you decided to improve your product's quality by buying a 19 raw material that cost 15% more than your current material? 21 January 22 February 23 March 25 Would you recommend this action? No Reasoning/Rationale: Situation #3 What would the effect be on the Projected Operating Income if you decided to remove executive bonus' and decrease your Selling and Administrative costs by 5%. 32 34 January 35 February 36 March 38 Would you recommend this action? No