Answered step by step
Verified Expert Solution
Question
1 Approved Answer
XYZ Berhad produces three different types of health drinks Spriluna, Aloe Vera and Mint. Forecast information of sales, production and material requirements for next
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.
Step by Step Solution
★★★★★
3.50 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started