Player Ltd specializes in the importation and sale of equipment for children's indoor play centers. The company was set up two years ago by its joint shareholders, Mr and Mrs Smith. The business has been very successful, expanding rapidly over the last year, and the cash balance in the company's current account has exceeded £1 million on several occasions recently. Mr and Mrs Smith,have asked you, an accounting technician for Player Ltd, to assist them in managing their cash balances over the next six months. You have been provided with the following information. (1) The bank balance on 1 July 2019 is forecast at £1-2 million in credit. (ii) Sales for May and June 2019 are £1-3 million per month. They are expected to rise to £1.5 million in July 2019, £1-7 million in August and £1.9 million inSeptember. They will then fall to £1-4 million for each of the following six months. This is due to a downturn in demand as the weather improves. (III) All sales are made on credit. 2% of debtors do not pay at all, 70% pay one monthafter sale and the remaining 28% pay two months after sale. (iv) Purchases are made one month prior to sales, and two months' credit is taken from suppliers. (V) The company's gross profit margin is 50%. (vi) The cost of employing Player Ltd's permanent staff is £150,000 per month. PlayerLtd also employs temporary staff during July, August and September at anadditional cost equating to 3% of sales for each month. (vii) Player Ltd uses a courier to dispatch the equipment to its customers. The cost of this service is 2% of sales value in July to September, falling to 1% thereafter. (viii) Administration costs are forecast at £30,000 for July. These costs are directly proportional to sales each month. (ix) Mr and Mrs Smith, will be attending a conference abroad in July 2019 at atotal cost of £5,000. They must complete the booking form and send it off, along with a deposit of £2,000, by the end of July 2019. The final balance is due in December. (X) The company charges depreciation of £45,000 each month. (xi) Player Ltd also owns two indoor play centres, that it rents out at the rate of £3,500each per month from July to October, falling to £3,000 per month thereafter. All rents are received one month in advance. (XII) The company will invest in a new computer system later in the year. This will be paid for by two equal installments of £200,000, one in December and one in March 2020. REQUIRED: (a) Prepare a monthly cash budget for EACH of the six months to 31 Dec 2019, showing.clearly any necessary workings. Note: All workings should be in £000. Unless told otherwise, assume that payments are made in the month in which the costs are incurred. (b) In a changing environment the incremental budgeting approach is often viewed tobe obsolete and instead firms should adopt the ZBB approach. Discuss?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
Player Ltd specializes in the importation and sale of equipment for children's indoor play centers. The company
was set up two years ago by its joint shareholders, Mr and Mrs Smith.
The business has been very successful, expanding rapidly over the last year, and the cash balance in the
company's current account has exceeded £1 million on several occasions recently. Mr and Mrs Smith,have asked
you, an accounting technician for Player Ltd, to assist them in managing their cash balances over the next six
months.
You have been provided with the following information.
(i) The bank balance on 1 July 2019 is forecast at £1-2 million in credit.
(ii) Sales for May and June 2019 are £1-3 million per month. They are expected to rise to £1.5 million in July
2019, £1-7 million in August and £1-9 million in September. They will then fall to £1-4 million for each of
the following six months. This is due to a downturn in demand as the weather improves.
(iii) All sales are made on credit. 2% of debtors do not pay at all, 70% pay one monthafter sale and the remaining
28% pay two months after sale.
(iv) Purchases are made one month prior to sales, and two months' credit is taken from suppliers.
(V) The company's gross profit margin is 50%.
(Vİ) The cost of employing Player Ltd's, permanent staff is £150,000 per month. PlayerLtd also employs temporary
staff during July, August and September at anadditional cost equating to 3% of sales for each month.
(vii) Player Ltd uses a courier to dispatch the equipment to its customers. The cost of this service is 2% of sales
value in July to September, falling to 1% thereafter.
(VIII) Administration costs are forecast at £30,000 for July. These costs are directly proportional to sales each
month.
(ix) Mr and Mrs Smith will be attending a conference abroad in July 2019 at atotal cost of £5,000. They must
complete the booking form and send it off, along with a deposit of £2,000, by the end of July 2019. The final
balance is due in December.
(X) The company charges depreciation of £45,000 each month.
(xi) Player Ltd also owns two indoor play centres that it rents out at the rate of £3,500each per month from July
to October, falling to £3,000 per month thereafter. All rents are received one month in advance.
(xii) The company will invest in a new computer system later in the year. This will be paid for by two equal
installments of £200,000, one in December and one in March 2020.
REQUIRED:
(a) Prepare a monthly cash budget for EACH of the six months to 31 Dec 2019, showing clearly any necessary
workings.
Note: All workings should be in £000.
Unless told otherwise, assume that payments are made in the month in which the costs are incurred.
(b) In a changing environment the incremental budgeting approach is often viewed tobe obsolete and instead
firms should adopt the ZBB approach. Discuss?
Transcribed Image Text:Player Ltd specializes in the importation and sale of equipment for children's indoor play centers. The company was set up two years ago by its joint shareholders, Mr and Mrs Smith. The business has been very successful, expanding rapidly over the last year, and the cash balance in the company's current account has exceeded £1 million on several occasions recently. Mr and Mrs Smith,have asked you, an accounting technician for Player Ltd, to assist them in managing their cash balances over the next six months. You have been provided with the following information. (i) The bank balance on 1 July 2019 is forecast at £1-2 million in credit. (ii) Sales for May and June 2019 are £1-3 million per month. They are expected to rise to £1.5 million in July 2019, £1-7 million in August and £1-9 million in September. They will then fall to £1-4 million for each of the following six months. This is due to a downturn in demand as the weather improves. (iii) All sales are made on credit. 2% of debtors do not pay at all, 70% pay one monthafter sale and the remaining 28% pay two months after sale. (iv) Purchases are made one month prior to sales, and two months' credit is taken from suppliers. (V) The company's gross profit margin is 50%. (Vİ) The cost of employing Player Ltd's, permanent staff is £150,000 per month. PlayerLtd also employs temporary staff during July, August and September at anadditional cost equating to 3% of sales for each month. (vii) Player Ltd uses a courier to dispatch the equipment to its customers. The cost of this service is 2% of sales value in July to September, falling to 1% thereafter. (VIII) Administration costs are forecast at £30,000 for July. These costs are directly proportional to sales each month. (ix) Mr and Mrs Smith will be attending a conference abroad in July 2019 at atotal cost of £5,000. They must complete the booking form and send it off, along with a deposit of £2,000, by the end of July 2019. The final balance is due in December. (X) The company charges depreciation of £45,000 each month. (xi) Player Ltd also owns two indoor play centres that it rents out at the rate of £3,500each per month from July to October, falling to £3,000 per month thereafter. All rents are received one month in advance. (xii) The company will invest in a new computer system later in the year. This will be paid for by two equal installments of £200,000, one in December and one in March 2020. REQUIRED: (a) Prepare a monthly cash budget for EACH of the six months to 31 Dec 2019, showing clearly any necessary workings. Note: All workings should be in £000. Unless told otherwise, assume that payments are made in the month in which the costs are incurred. (b) In a changing environment the incremental budgeting approach is often viewed tobe obsolete and instead firms should adopt the ZBB approach. Discuss?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Accounting Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education