Master budget: cash budget - Practice 3 The following information is available for ABC Co. Budgeted sales Gross profit as a percentage of sales BUD May $ Closing trade payables as a percentage of cost of sales Opening inventory Nil Closing inventory Nil How much money should be budgeted for supplier payments in June? A $10,500 B $14,000 $24,500 $30,000 C 30,000 30% 50 Jun $ Nil Nil 40,000 30% 50%
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.
Please don't provide answer in image format thank you
![Master budget: cash budget - Practice 3
The following information is available for ABC Co.
Budgeted sales
Gross profit as a percentage of sales
Closing trade payables as a percentage of cost of sales
Opening inventory
Closing inventory
ABCD
May
$
$10,500
$14,000
$24,500
$30,000
Nil
Nil
How much money should be budgeted for supplier payments in June?
30,000
30%
50
Jun
$
Nil
Nil
40,000
30%
50%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9ec61dd6-e17c-497e-a0e0-89dafabd6584%2F56300b3a-6846-4b3c-8dc1-84d80c3b3361%2Fgg1at4_processed.jpeg&w=3840&q=75)
![XYZ company produces three products: X, Y and Z. For the coming accounting period, budgets are to be prepared
based on the following information.
Budgeted sales: Product X 2,000 at $100 each
Product Y
4,000 at $130 each
Product Z
3,000 at $150 each
Budgeted usage of raw material
Product X
Product Y
Product Z
Cost per unit of material
Finished inventories budget
Opening
Closing
Raw materials inventory budget
Opening
Closing
Expected hours per unit
Expected hourly rate (labour)
RM11
5
3
2
$5
Product X
500
600
RM11
21,000
18,000
Product X
4
$9
RM22
2
2
1
$3
Product Y
800
1,000
RM22
10,000
9,000
Product Y
6
$9
RM33
1234
$4
Product Z
700
800
RM33
16,000
12,000
Product Z
8
$9
Required:
Prepare for product X, Y & Z
a. sales budget: quantity and value.
b. production budget.
c. material: usage & purchase budget.
d. labour budget.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9ec61dd6-e17c-497e-a0e0-89dafabd6584%2F56300b3a-6846-4b3c-8dc1-84d80c3b3361%2Fmacexh_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![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)