X Calibri (Body) 12 A A % Conditional Formatting O Format as Table Paste B I UV MVA v Number Cells Editing Analyze Sensitivity i Cell Styles v Data J26 X V fx A B C D E G H K L Function: SUM; Formulas: Subtract, Multiply; Cell Referencing N P BE6.3 - Using Excel to Create a Production Budget Student Work Area A W PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the required UT Filling in for his supervisor, who suddenly left the company, Harvey quickly mathematical formulas or functions with cell references to the Problem area or work area as evaluated the situation to wrap up his department's production budget. The indicated. department currently holds enough inventory to be in compliance with its 8 standard which is based on the following month's budgeted sales. From the 9 sales and previous budgets, he learned the budgeted unit sales for the next 4 Show the production budget that Harvey would assemble for the next quarter. 10 months and the standard for holding inventory at month end which are both 11 presented here. Month 1 Month 2 Month 3 Quarter 12 Budgeted sales volume 5,000 4,500 6,000 13 Unit sales per month Target ending FG Inventory 14 Month 1 5,000 Total units needed 15 Month 2 4,500 Beginning FG Inventory 16 Month 3 6,000 Budgeted units to be produced 17 Month 4 6,500 18 Ending inventory standard 19 Materials held at month end 10% 20 21 22 23 24 25 26