The company expects to sell 48,000 bottles of stain remover in the first quarter, 52,000 in the second quarter, 93,000 in the third quarter, and 36,000 in the fourth quarter.
A bottle of stain remover requires 8 ounces of chemical A (direct material).
The desired ending inventory of finished goods is equal to 20% of next quarter's sales, whereas the desired ending inventory for Chemical A is 15% of next quarter's production requirements of D.M.
There are 11,000 bottles of stain remover and 57,000 ounces of Chemical A on hand at the beginning of the first quarter (at the end of 2020).
At the end of the fourth quarter, the company must have 12,000 bottles of stain remover.
The cost of Chemical A is $0.05 per ounce and the selling price of the stain remover is $9.95 per bottle.
Each bottle requires half a labor hour (0.5 hrs) with a labor rate per hour of $20.
The cost of variable overhead is $0.90 per bottle. Fixed manufacturing overhead is $40,000 per quarter.
Variable selling and administrative expense is 4% of sales, and fixed selling and administrative expenses are $50,000 per quarter.
Required: Prepare a Direct material budget for the first quarter of 2021. (Fill the table and show your calculation)