Question
Question 2 (Total: 25 marks) The following is the forecast from April to August 2019 for Almari Magick Company: April RM000 May RM000 June RM000
Question 2 (Total: 25 marks)
The following is the forecast from April to August 2019 for Almari Magick Company:
| April RM000 | May RM000 | June RM000 | July RM000 | August RM000 |
Cash sales | 50 | 60 | 55 | 65 | 40 |
Credit sales | 800 | 750 | 675 | 600 | 550 |
Materials purchased | 400 | 440 | 460 | 400 | 420 |
Wages and salaries | 80 | 100 | 120 | 100 | 112 |
Factory overhead expenses | 135 | 145 | 160 | 155 | 145 |
Other overhead expenses | 90 | 85 | 92 | 112 | 102 |
Additional details are:
(1) One half of the remaining trade receivables will pay in the month after sales; the other one half will take an additional months to make payment.
(2) One half of the amount owing to trade payables for materials is paid in the month of purchase. The other half is paid in the month following purchase.
(3) 75% of wages and salaries are paid in the month in which they are incurred; the remainder will be paid in the following month.
(4) Depreciation of plant and machinery is included in the above factory overhead expenses, which is RM45,000 per month.
(5) Depreciation of office equipment is included in the above other overhead expenses, which is RM12,000 per month.
(6) All overhead expenses are paid in the month following the month in which they are incurred.
(7) Plant will be sold in July for RM5,000 in cash, incurring a loss on disposal of RM22,500.
(8) RM102,900 is to be paid in July for purchase of an additional freehold building.
(9) A dividend of RM50,300 is to be paid in August.
Required:
a) Assuming a bank overdraft of RM70,000 on 31 May, prepare a tabular Cash Budget for each of the three months of June, July and August. (19 marks)
b) Discuss three (3) key benefits companies get from preparing the budget.
(6 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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