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
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc3dcb9b5-96bb-48c0-8100-79406803cce0%2Ffc364792-ce92-47c6-b57e-4c02150c40d3%2Ft92k02j_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 4 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)