- 20 Marks
PM – May 2022 – L2 – SA – Q2 – Cash Budgeting and Working Capital
Preparation of a cash budget for Mega Laboratories PLC for the quarter ending June 30, 2021.
Question
Mega Laboratories plc is a successful manufacturing company in the pharmaceutical industry. The company manufactures a number of household drugs. Since the advent of the Covid-2019 pandemic, its products have been in high demand. One of its newest products is known as vacineDcovid. In order to manufacture the product, a single raw material, Zithromax, is used.
Budgets are to be prepared for the quarter ending 30 June 2021, and the following information is available for this purpose:
(i) At 31 March 2021 various balances were as follows:
- Receivables: N500,700
- Creditors (suppliers of Zithromax): N153,000
- Inventory of vacineDcovid: 20,300 units
- Inventory of Zithromax: 200,000 kg
(ii) Extracts from the ‘standard cost card’ – vacineDcovid are as follows:
- Direct material Zithromax, 10kg at N5.00 per kg: N50.00
- Direct labour, 2 hours at N6.00 per hour: N12.00
(iii) Suppliers of Zithromax give two months credit to the company, whereas customers take one month’s credit.
(iv) Sales expectations for the quarter ending 30 June 2021 are as follows:
- 25,000 units of vacineDcovid at a selling price of N95.00 per unit.
(v) Assume that sales of vacineDcovid and purchases of Zithromax will be evenly spread over the three months to 30 June 2021.
(vi) Depreciation relating to plant and machinery is N55,000 for the quarter ending 30 June 2021.
(vii) Other expenses are paid immediately in cash and are estimated to be N200,000 for the quarter ending 30 June 2021.
(viii) The anticipated inventory levels at 30 June 2021 are as follows: - Inventory of vacineDcovid: 15,000 units
- Inventory of Zithromax: 150,500 kgs
(ix) Assume there is no work-in-progress and that stocks of vacineDcovid and Zithromax are valued at standard direct cost – see (ii) above.
Required:
For the quarter ending 30 June 2021 prepare:
a. A cash budget (amounts for each separate month are not required). (8 Marks)
b. Income Statement budget (clearly state any assumptions you have made). (5 Marks)
c. Briefly state the benefits of a Cash Budget to Mega Laboratories plc. (3 Marks)
d. Sales are often considered to be a principal budget factor of an organisation. Explain the meaning of a ‘principal budget factor’ and assuming that it is sales, explain how sales may be forecast, making appropriate reference to the use of statistical techniques and the use of computers. (4 Marks)
Find Related Questions by Tags, levels, etc.
- Tags: Cash Budget, Inventory Management, Payables, Receivables
- Level: Level 2
- Topic: Cash Budgeting and Working Capital
- Series: MAY 2022