prepare a direct materials budget for april may and june 648613

1. Rad Co. provides the following sales forecast for the next four months:

The company wants to end each month with ending finished goods inventory equal to 20% of next month’s sales. Finished goods inventory on April 1 is 174 units. Assume July’s budgeted production is 540 units.

Prepare a production budget for the months of April, May, and June.

2. In addition, assume each finished unit requires five pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month’s production needs. Beginning raw materials inventory for April was 663 pounds.

Prepare a direct materials budget for April, May, and June.