XYZ Berhad produces three different types of health drinks Spriluna, Aloe Vera and Mint. Forecast information...

 

Transcribed Image Text:

XYZ Berhad produces three different types of health drinks Spriluna, Aloe Vera and Mint. Forecast information of sales, production and material requirements for next year are given below: (1) Sales PRODUCT Spriluna Aloe Vera Mint QUANTITY (UNITS) 500 1000 400 (2) Material usage Raw material Wland Y2 is required in the production of the health products. Quantity of chemical per unit of SELLING PRICE PER UNIT ($) 4.00 2.00 3.00 W1 Y2 (KG) (KG) 2 2 2 1 1 1 The purchase price of raw material W1 and Y2 per kilogram is expected Spriluna Aloe Vera Mint (3) Forecasted stock levels Finished goods Spriluna Aloe Vera Mint Raw material W1 Y2 1st Jan (units) 100 200 150 (ii) (iii) (iv) KG 500 400 REQUIRED: Prepare the following budgets for the next year. 31st Dec (units) 80 140 130 KG 400 600 Sales budget in quantities and value including total value. Production budget in quantities. Material usage budget in quantities. Material purchases budget in quantities and value including the total value. XYZ Berhad produces three different types of health drinks Spriluna, Aloe Vera and Mint. Forecast information of sales, production and material requirements for next year are given below: (1) Sales PRODUCT Spriluna Aloe Vera Mint QUANTITY (UNITS) 500 1000 400 (2) Material usage Raw material Wland Y2 is required in the production of the health products. Quantity of chemical per unit of SELLING PRICE PER UNIT ($) 4.00 2.00 3.00 W1 Y2 (KG) (KG) 2 2 2 1 1 1 The purchase price of raw material W1 and Y2 per kilogram is expected Spriluna Aloe Vera Mint (3) Forecasted stock levels Finished goods Spriluna Aloe Vera Mint Raw material W1 Y2 1st Jan (units) 100 200 150 (ii) (iii) (iv) KG 500 400 REQUIRED: Prepare the following budgets for the next year. 31st Dec (units) 80 140 130 KG 400 600 Sales budget in quantities and value including total value. Production budget in quantities. Material usage budget in quantities. Material purchases budget in quantities and value including the total value.

Answer rating: 100% (QA)

To prepare the budgets well follow these steps i Sales Budget The sales budget estimates the quantity of each product to be sold and their corresponding total sales value Product sales quantity Foreca... View the full answer