Tillman

Cycles manufactures chainless bicycles. On March 31,

Tillman

Cycles had

216

bikes in inventory. The company has a policy that the ending inventory in any month must be

20%

of the following month's expected sales.

Tillman

Cycles expects to sell the following number of bikes in each of next four months:

LOADING...

(Click the icon to view the data)

Prepare a production budget for the second quarter, with a column for each month and for the quarter.

Tillman Cycles
Production Budget
For the Months of April through June
	April	May	June	Quarter
Unit sales
Plus: Desired ending inventory
Total needed
Less: Beginning inventory
Units to produce

April. . . . . . . . . . . . . . . . .	1,080 bikes
May. . . . . . . . . . . . . . . . . .	1,190 bikes
June. . . . . . . . . . . . . . . . .	1,300 bikes
July. . . . . . . . . . . . . . . . . .	1,250 bikes