Batista Company _Production Budget

On January 1, 2013 the Batista Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2013.
Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000 Ending raw materials inventory: 50% of the next quarter’s production requirements Ending finished goods inventory: 30% of the next quarter’s expected sales units Third-quarter production: 7,250 units The ending raw materials and finished goods inventories at December 31, 2012, follow the same percentage relationships to production and sales that occur in 2013. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Complete the production budget by quarters for the 6-month period ended June 30, 2013.
BATISTA COMPANY
Production Budget
For the Six
Months Ending June 30, 2013
                                                Quarter
                Six                                                 1
       2                 Months Add: 
Total required units
Less: 
Required production units