Question
Lewisham Ltd manufactures one product line the Zenith. Plans over the next few months are as follows: Sales demand Units July 180,000 August 240,000 September
Lewisham Ltd manufactures one product line the Zenith. Plans over the next few months are as follows:
Sales demand
Units | |
---|---|
July | 180,000 |
August | 240,000 |
September | 200,000 |
October | 180,000 |
Each Zenith will sell for 3.
Receipts from sales.Credit customers are expected to pay as follows:
70 per cent during the month of sale
28 per cent during the following month.
The remaining trade receivables are expected to go bad (that is, to be uncollectable).
Credit customers who pay in the month of sale are entitled to deduct a 2 per cent discount from the invoice price.
Finished goods inventories. These are expected to be 40,000 units at 1 July. The businesss policy is that, in future, the inventories at the end of each month should equal 20 per cent of the following months planned sales requirements.
Raw materials inventories. These are expected to be 40,000 kg on 1 July. The businesss policy is that, in future, the inventories at the end of each month should equal 50 per cent of the following months planned production requirements. each Zenith requires 0.5 kg of the raw material, which costs 1.50/kg. Raw materials purchases are paid in the month after purchase.
Labour and overheads. The direct labour cost of each Zenith is 0.50. The variable overhead element of each Zenith is 0.30. Fixed overheads, including depreciation of 25,000, total 47,000 a month. All labour and overheads are paid during the month in which they arise.
Cash in hand. At 1 August the business plans to have a bank balance (in funds) of 20,000.
Required:
Prepare the following budgets:
Finished inventories budget (expressed in units of Zenith) for each of the three months July, August and September.
Raw materials inventories budget (expressed in kilograms of the raw material) for the two months July and August.
Cash budget for August and September.
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