Exercise $8-3($Static$)$ Direct Materials Budget $[$LO$8-4]$

Three grams of musk oil are required for each bottle of Mink Caress, a popular perfume made by a company in western Siberia. The cost of the musk oil is $$1\mathrm{.}50$ per gram. Budgeted quarterly production of Mink Caress is given below for Year $2$ and the first quarter of Year $3$:

$\backslash$table$[[,$Year $2,$Year $3],[,$First,Second,Third,Fourth,First$],[$Budgeted production, in bottles,$60,000,90,000,150,000,100,000,70,000]]$

The inventory of musk oil at the end of a quarter must equal $20\%$ of the following quarter's production needs. A total of $36,000$ grams of musk oil will be on hand to start the first quarter of Year $2.$

Required:

Prepare a direct materials budget for musk oil, by quarter and in total, for Year $2.$

$\backslash$table$[[$Mink Caress$],[$Direct Materials Budget $-$ Year $2],[(2),$Quarter,Year$],[,$First,Second,Third,Fourth$],[,60,000,90,000,150,000,100,000,400,000],[$Units of raw materials needed per unit of finished goods,$2,2,2,2,2],[$Units of raw materials needed to meet production,$120,000,180,000,300,000,200,000,800,000],[$Add: Units of beginning raw materials inventory,Y$,,,,5],[$Total units of raw materials needed$],[,,,,,],[$Units of raw materials to be purchased$],[$Unit cost of raw materials$],[$Cost of raw materials to purchased,,,,,$]]$