Reference no: EM132979270
ZETA manufactures two products, A and B, which use the same raw materials, Y and Z. One unit of A uses 3 liters of Y and 4 kilograms of Z. One unit of B uses 5 liters of Y and 2 kilograms of Z. A liter of Y costs €3 and a kilogram of Z €7.
Budgeted sales for 2018 are 8,000 of A and 6,000 of B. Finished goods at the beginning of 2018 were 1,300 units of A and 400 units of B and the company plans to hold inventories of 600 units of each product at the end of 2018.
Inventories of raw materials are 6,000 liters of Y and 2,800 kilograms of Z at the beginning of the year and the company plans to hold 5,000 liters of Y and 3,500 kilograms of Z at the end of the year.
The warehouse and store managers have suggested that a provision should be made for damages and deterioration of items held in store as follows:
Product A: loss 70 units material Y: loss 500 liters
Product B: loss 400 units material Z: loss 200 kilogram
Required
Problem 1: Prepare a materials budget for 2018.