Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
DeeSplay Ltd ( DeeSplay ) makes and sells frames for displaying vinyl LPs . In September the company approached its bank for a loan to
DeeSplay Ltd DeeSplay makes and sells frames for displaying vinyl LPs In September the company approached its bank for a loan to help meet short term cash requirements. In order to assess the scale of the loan required, the loan manager at the bank has asked the company to prepare a cash budget for the three months of October to December. DeeSplay's management accountant has gathered the following information. The budgeted data per frame is as follows: Selling price Variable materials cost Variable labour cost Variable production overheads Variable selling expenses Additional information: Unit sales of frames are budgeted to be: November October December September January Credit sales account for of total sales. Credit customers are expected to pay in the month following sale for which there will be a discount of given. One credit customer who bought frames on September was declared bankrupt on September, with no prospect of being able to pay their creditors. DeeSplay also wishes to make a general provision for bad debts of in October. Inventory levels will be such that production takes place the month before sale. Materials are purchased one month before production takes place. Suppliers of materials are paid two months after purchase. DeeSplay has some obsolete materials in inventory which cost These will be sold on one month's credit in October for Labour costs are paid in the month in which they are incurred. All other expenses are paid in the month following that in which they are incurred. Fixed expenses incurred are per month for the months of September and October and per month for the months of November, December and January. All fixed expenses are paid in the month following that in which they are incurred. The fixed expenses include for depreciation of buildings per month. The buildings were revalued by a surveyor in September and are worth more than the net book value shown in September's accounts. This additional value is to be recorded in October's accounts The company is also planning to purchase a new delivery vehicle costing which will be paid in full in October. The estimated scrap value is in years' time. On November, additional machinery will be purchased at a cost of payable in three equal installments in November, December and January. The estimated scrap value is in four years' time. Depreciation is calculated straight line per month and a full month's depreciation is charged in the month of purchase. The bank balance on October is in credit. Overdraft interest payments are estimated at for November and for December. Taxable profits for last year amounted to and the tax on these at a rate of is due to be paid on October. Prepare the cash budget for each of the three months ending December. You should make an entry in every box in the cash budget. Enter a zero or dash where applicable. Do not leave any boxes blank.
DeeSplay Ltd
DeeSplay makes and sells frames for displaying vinyl LPs In September the company approached its bank for a loan to help meet short term cash requirements. In order to assess the scale of the loan required, the loan manager at the bank has asked the company to prepare a cash budget for the three months of October to December.
DeeSplay's management accountant has gathered the following information.
The budgeted data per frame is as follows:
Selling price
Variable materials cost Variable labour cost
Variable production overheads Variable selling expenses
Additional information:
Unit sales of frames are budgeted to be:
November
October
December
September
January
Credit sales account for of total sales. Credit customers are expected to pay in the
month following sale for which there will be a discount of given. One credit customer who bought frames on September was declared bankrupt on September, with no
prospect of being able to pay their creditors. DeeSplay also wishes to make a general provision for bad debts of in October.
Inventory levels will be such that production takes place the month before sale. Materials are purchased one month before production takes place.
Suppliers of materials are paid two months after purchase.
DeeSplay has some obsolete materials in inventory which cost These will be sold on one month's credit in October for
Labour costs are paid in the month in which they are incurred. All other expenses are paid in the month following that in which they are incurred.
Fixed expenses incurred are per month for the months of September and October and per month for the months of November, December and January. All fixed expenses are paid in the month following that in which they are incurred. The fixed
expenses include for depreciation of buildings per month. The buildings were revalued by a surveyor in September and are worth more than the net book value shown in September's accounts. This additional value is to be recorded in October's accounts
The company is also planning to purchase a new delivery vehicle costing which will be paid in full in October. The estimated scrap value is in years' time. On November, additional machinery will be purchased at a cost of payable in three equal installments in November, December and January. The estimated scrap value is
in four years' time.
Depreciation is calculated straight line per month and a full month's depreciation is charged in the month of purchase.
The bank balance on October is in credit. Overdraft interest payments are
estimated at for November and for December. Taxable profits for last year amounted to and the tax on these at a rate of is due to be paid on October.
Prepare the cash budget for each of the three months ending December. You should make an entry in every box in the cash budget. Enter a zero or dash where applicable. Do not leave any boxes blank.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started