Using Excel to Prepare a Production Budget

PROBLEM

Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December $31,2022.$

Quarter $1$ sales $10,000$

Quarter $2$ sales $14,000$

Quarter $3$ sales $15,000$

Quarter $4$ sales $18,000$

Desired ending finished goods inventory

based on next quarter's expected unit sales $25\%$

Unit selling price $$70\mathrm{.}00$

Prepare a production budget by quarters for the first $6$ months of $2022.*$Please answer with excel formulas$*$