Based on the information is given, show the calculation step by step; a) PREPARE the following budgets: i. Sales Budget,  ii. Production Budget,  iii. Direct Material Usage Budget,  iv. Direct Material Purchase Budget and  v. Direct Labour Budge

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter12: Capital Investment Decisions
Section: Chapter Questions
Problem 2MTC: NoFat manufactures one product, olestra, and sells it to large potato chip manufacturers as the key...
icon
Related questions
icon
Concept explainers
Question

Based on the information is given, show the calculation step by step;
a) PREPARE the following budgets:
i. Sales Budget, 
ii. Production Budget, 
iii. Direct Material Usage Budget, 
iv. Direct Material Purchase Budget and 
v. Direct Labour Budge

Foodsburry is a business that specializes in selling and supplying chocolate cakes. This
Business is well known by all residents of Shah Alam. In 2020, Foodsburry decided to
Introduce their two latest products, namely, Chocolate Milk and Choco Bites in mid-2020.
The following is a sales analysis of the two products;,
Unit sold
Chocolate Milk
Choco Hites
June
400
500
July
30% less than the previous
450
month
August
20% more than the previous
50% more than June
month
September
20% less than the previous
25% more than the previous
month
month
October
20% less than the previous
420
month
November
50% more than the previous
25% more than June
month
December
20% less than the previous
550
month
Additional information:
• Selling price for Chocolate Milk is RM 8.50
• Selling price for Choco Bites is RM 5.20
• Closing inventory for Chocolate Milk is 400 units and Choco Bites is 325 units.
• Opening inventory for Chocolate Milk and Choco Bites is 40% of units sold.
• Closing inventory for Material A and Material B is 20% of the units required
Opening inventory for Material A and Material B are 50% more than the closing
• Inventory.
Estimated materials required for production:
Product
Material A
Material B
(RM 0.8 per kg)
(RM 0.5 per kg)
Chocolate Mil
Choco Bites
2 kg
Half of material A
1.5 kg
Estimated labour hours:
Product
Chocolate Mil
Hour per unit
Rate per hour
4
RM 1.50
Choco Bites
2
RM 0.80
Transcribed Image Text:Foodsburry is a business that specializes in selling and supplying chocolate cakes. This Business is well known by all residents of Shah Alam. In 2020, Foodsburry decided to Introduce their two latest products, namely, Chocolate Milk and Choco Bites in mid-2020. The following is a sales analysis of the two products;, Unit sold Chocolate Milk Choco Hites June 400 500 July 30% less than the previous 450 month August 20% more than the previous 50% more than June month September 20% less than the previous 25% more than the previous month month October 20% less than the previous 420 month November 50% more than the previous 25% more than June month December 20% less than the previous 550 month Additional information: • Selling price for Chocolate Milk is RM 8.50 • Selling price for Choco Bites is RM 5.20 • Closing inventory for Chocolate Milk is 400 units and Choco Bites is 325 units. • Opening inventory for Chocolate Milk and Choco Bites is 40% of units sold. • Closing inventory for Material A and Material B is 20% of the units required Opening inventory for Material A and Material B are 50% more than the closing • Inventory. Estimated materials required for production: Product Material A Material B (RM 0.8 per kg) (RM 0.5 per kg) Chocolate Mil Choco Bites 2 kg Half of material A 1.5 kg Estimated labour hours: Product Chocolate Mil Hour per unit Rate per hour 4 RM 1.50 Choco Bites 2 RM 0.80
Expert Solution
steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning