Please help me i will give good rating

Use Excel

Question 1 Ultra-Sani produces and sells sanitizers that is made out of a type of natural aloe vera. Due to its unexpected demands, ULTRA-SANI decided to prepare a budget to plan its production activity early. The following details were obtained from the factory: ULTRA-SANI currently (November 2021) manufactures 10,000 bottles of sanitizers monthly. Due to the increasing demand, the production is expected to increase by 1,000 in December 2021, increase by 1,200 in January 2022 and increase by 1500 in February 2022. All increase are based on previous month demand. The factory is estimated to use 3 kilograms of aloe vera for every bottle it produces. Due to the increasing production, the factory is estimated to have ending inventory of material (aloe vera) equivalent to 20% of the followings month's material (aloe vera) usage requirement. All materials (aloe vera) will be purchased on credit at RM10 per kilogram of aloe vera. The suppliers are estimated to be paid in the month after purchase. The factory is also estimated to use 3 hours of direct labour to produce 1 bottle of sanitizers. Direct labours are expected to be paid at the rate of RM20 per hour. Direct labours are usually paid on 7th of the following month. You are required to prepare: a. Direct material usage and purchase budget (including payment to suppliers) for the months of December, January and February 2021. b. Direct labour budget (including payment to direct labour) for the months of December and January 2021. C. Briefly discuss two (2) advantages of budgeting with relevant example. Question 1 Ultra-Sani produces and sells sanitizers that is made out of a type of natural aloe vera. Due to its unexpected demands, ULTRA-SANI decided to prepare a budget to plan its production activity early. The following details were obtained from the factory: ULTRA-SANI currently (November 2021) manufactures 10,000 bottles of sanitizers monthly. Due to the increasing demand, the production is expected to increase by 1,000 in December 2021, increase by 1,200 in January 2022 and increase by 1500 in February 2022. All increase are based on previous month demand. The factory is estimated to use 3 kilograms of aloe vera for every bottle it produces. Due to the increasing production, the factory is estimated to have ending inventory of material (aloe vera) equivalent to 20% of the followings month's material (aloe vera) usage requirement. All materials (aloe vera) will be purchased on credit at RM10 per kilogram of aloe vera. The suppliers are estimated to be paid in the month after purchase. The factory is also estimated to use 3 hours of direct labour to produce 1 bottle of sanitizers. Direct labours are expected to be paid at the rate of RM20 per hour. Direct labours are usually paid on 7th of the following month. You are required to prepare: a. Direct material usage and purchase budget (including payment to suppliers) for the months of December, January and February 2021. b. Direct labour budget (including payment to direct labour) for the months of December and January 2021. C. Briefly discuss two (2) advantages of budgeting with relevant example