Pam's Perfume Inc. (PPI) is a company that manufactures and sells flashy womens shoes. The companys budget committee has been working feverishly to complete its master budget for the fiscal quarter (three months) ending September 30, 2021. The vice-president of sales has established the following estimates for sales (in units) for July to October:

Jul Aug Sep Oct

3,000 3,500 4,000 4,500

Management desires to have an ending inventory on hand at the end of each month equal to 20% of the next months budgeted sales. The inventory estimate for June 30, 2021 is 600 units.

Required:

Prepare a production budget for the quarter ending September 30, 2021. Use the template thats already been completed below to record your answer.

	July	August	September	Total
Expected sales
Add: desired ending inventory
Total units required
Less: beginning inventory
Required units to produce