Super Clean produces and sells stain remover. Information about the budget for the year 2018 is as follows:
1. The company expects to sell 57,000 bottles of stain remover in the first quarter, 65,000 in the second quarter, 105,000 in the third quarter, and 42,000 in the fourth quarter.
2. A bottle of stain remover requires 6 ounces of Chemical A and 11 ounces of Chemical B.
3. For 2018, the desired ending inventory of finished goods is equal to 12 percent of next quarter's sales, whereas the desired ending inventory for material is 15 percent of next quarter's production requirements.
4. There are 7,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 85,000 ounces of Chemical B to meet its needs in the first quarter of 2018.
6. The cost of Chemical A is $0.13 per ounce, the cost of Chemical B is $0.08 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 $65,000 per quarter.
8. Variable selling and administrative expense is 5 percent of sales, and fixed selling and Administrative expenses is $42,000 per quarter.
Required
a. Prepare a production budget for each quarter of 2018.
b. Prepare a material purchases budget for each quarter of 2018.
c. Prepare a budgeted income statement for each quarter of 2018 (ignore taxes).