Preparing a sales budget

Sales Forecast for Q$1$ in $20$XX: Selling price $=$$$8$ per unit

January $10,000$ units

February $12,000$ units

March $15,000$ units

April $11,000$ units

Preparing a production budget

Miles will begin the year with $14,000$ units in FG

Miles wants to end each month with $140\%$ of the next month's

projected sales in inventory

$$ Formulas:

Expected sales $+$ Desired EI $=$ Units Needed

Units Needed $-$ Est. BI $=$ Units to produce

${?}^{**}EI($Ending Inventory$),*$BI$($Beginning Inventory$)$