BE$6\mathrm{.}3-$ Using Excel to Create a Production Budget

PROBLEM

Filling in for his supervisor, who suddenly left the company, Harvey quickly

evaluated the situation to wrap up his department's production budget. The

department currently holds enough inventory to be in compliance with its

standard which is based on the following month's budgeted sales. From the

sales and previous budgets, he learned the budgeted unit sales for the next $4$

months and the standard for holding inventory at month end which are both

presented here.

Unit sales per month

Month $1$

Month $2$

Month $3$

Month $4$

Ending inventory standard

Materials held at month end

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Input the required

mathematical formulas or functions with cell references to the Problem area or work area as

indicated.

Show the production budget that Harvey would assemble for the next quarter.