Super Clean, Inc. produces and sells stain remover. Information about the budget for the year 2012 is as follows:
1. The company expects to sell 50,000 bottles of stain remover in the first quarter, 60,000 in the second quarter, 105,000 in the third quarter, and 46,000 in the fourth quarter.
2. A bottle of stain remover requires 5 ounces of Chemical A and 12 ounces of Chemical B.
3. The desired ending inventory of finished goods is equal to 15 percent of next quarter’s sales, whereas the desired ending inventory for material is 10 percent of next quarter’s production requirements.
4. There are 8,000 bottles of stain remover, 25,000 ounces of Chemical A, and 60,000 ounces of Chemical B on hand at the beginning of the first quarter.
5. At the end of the fourth quarter, the company must have 10,000 bottles of stain remover, 35,000 ounces of Chemical A, and 90,000 ounces of Chemical B to meet its needs in the first quarter of 2012.
6. The cost of Chemical A is $0.15 per ounce, the cost of Chemical B is $0.10 per ounce, and the selling price of the stain remover is $10.50 per bottle.
7. The cost of direct labor is $0.80 per bottle, and the cost of variable overhead is $1.20 per bottle. Fixed manufacturing overhead is $50,000 per quarter.
8. Variable selling and administrative expense is 5 percent of sales, and fixed selling and administrative expenses is $60,000 per quarter.
a. Prepare a production budget for each quarter of 2012.
b. Prepare a material purchases budget for each quarter of 2012.
c. Prepare a budgeted income statement for each quarter of 2012 (ignore taxes).