Willow Products expects the following sales of its single product:

Units
March 5,800
April 6,400
May 7,800
June 8,150
July 8,800

Willow Products desires an ending finished goods inventory to be equal to 10% of the next month’s sales needs. Actual March 1 inventory is projected to be 580 units.

Required:

Prepare a production budget for Willow Products for as many months as is possible.

March April May June July
Sales
Ending Inv
Beginning Inv

Production