Answer and Explanation:
The preparation of an inventory purchases budget for April, May, and June is shown below:-
April May June July Quarter End
Budgeted cost of
goods sold $37,500 34,000 $30,000 $45,000
Add: Ending balance
of inventory
(10% of Next month's
COGS) $3,400 $3,000 $4,500
Total needs $40,900 $37,000 $34,500
Less: Beginning balance of
inventory $1,800 $3,400 $3,000
Required inventory
purchases $39,100 $33,600 $31,500 $104,200