please urgent.

Three grams of poppy oil are required for each bottle of Afghan Caress, a very popular perfume made

by a small company in Kabul. The cost of the poppy oil is $1.50 per gram. Budgeted

production of Afghan Caress is given below by quarters for Year 2 and for the first quarter of Year 3:

Year 2 Year 3

First Second Third Fourth First

Budgeted production, in bottles . . . . . 60,000 90,000 150,000 100,000 70,000

Poppy oil has become so popular as a perfume ingredient that it has become necessary to carry

large inventories as a precaution against stock-outs. For this reason, the poppy oil at the

end of a quarter must be equal to 20% of the following quarters production needs. Some 36,000

grams of musk oil will be on hand to start the first quarter of Year 2.

Required:

Prepare a poppy materials budget for musk oil, by quarter and in total, for Year 2. At the bottom of

your budget show the amount of purchases for each quarter and for the year in total.