ect Assignment: Budgeting and Project Analysis

Soved

$\backslash$table$[[,$Year $2,$Year $3],[,$Finst,Second,Third,Fourth,First$],[$Budgeted production, in bottles,$96,000,126,000,186,000,136,000,106,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 $76,800$ 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],[,$Quarter,Year$],[,$First,Second,Third,Fourth$],[,,,,,],[$Units of raw matenals needed per unit of finished goods$],[$Units of raw materials needed to meet production$],[,,,,,],[$Total units of raw materials needed$],[,,,,,],[$Units of raw materials to be purchased$],[$Unit cost of raw materials$],[$Cost of raw materials to purchased,,,,,$]]$