a) Prepare a cash budget for the 3 months period February to April. b) Discuss the cash budget in (a) stating any concerns you would have about the figures and any steps the management of Gray Ltd could take to improve the company's cash flow position. (200 words) c) Explain why a business should prepare a cash budget.

Principles of Cost Accounting
17th Edition
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Edward J. Vanderbeck, Maria R. Mitchell
Chapter7: The Master Budget And Flexible Budgeting
Section: Chapter Questions
Problem 5P: Selling and administrative expense budget and budgeted income statement Budgeted selling and...
icon
Related questions
Question
Can you help me with that question?
Question 1
The following data has been extracted from the operating budgets of
Gray Ltd for 2023. The company manufactures shoes for sale to
large retailers shop and in its own high street shops:
Income from
high street shop
sales
Month
Income
Raw material
Labour
Overheads
from sales
purchases
to retailer
£
January
£
£
255,000
90,000
232,500
97.500
5,500
February 262,500
232,500
112,500
225,000
90,000
5,500
March
75,000
232,500
97,500
8,200
67,500
April
May
232,500
236,250
108,750 8,400
150,000
71,250
225,000
105,000 9,500
1. It is estimated that approximately 75% of cash from sales to
retailers is received at the time of sale and 25% is received one
month later. It is also agreed with the retailer that 5% of May
sales will be paid one month in advance.
2. Sales in the high street shops are all in cash and received at the
time of sale.
3. The company rents out one of its stores. It is going to receive
cash rent income of £6,000 in April 2023.
4. 60% of payments for raw materials are made in the month of
purchase, 40% one month later.
5. Labour costs are paid in full at the end of each month.
6. A new machine costing £120,000 is to be acquired on 28th
February. The new machine will be paid for in 3 equal monthly
instalments beginning in March.
7. Monthly overheads are paid one month after they are
incurred and include £3,700 of depreciation. The monthly
depreciation amount will increase by £4,000 in March 2023 due
to the purchase of the new machine.
8. The opening bank balance on 1st February 2023 is forecast to be
£130,000. The company is also forecast to have £20,000 in cash
on 1st February 2023.
Required
a) Prepare a cash budget for the 3 months period February to April.
b) Discuss the cash budget in (a) stating any concerns you would
have about the figures and any steps the management of Gray
Ltd could take to improve the company's cash flow position.
(200 words)
c) Explain why a business should prepare a cash budget.
Transcribed Image Text:Question 1 The following data has been extracted from the operating budgets of Gray Ltd for 2023. The company manufactures shoes for sale to large retailers shop and in its own high street shops: Income from high street shop sales Month Income Raw material Labour Overheads from sales purchases to retailer £ January £ £ 255,000 90,000 232,500 97.500 5,500 February 262,500 232,500 112,500 225,000 90,000 5,500 March 75,000 232,500 97,500 8,200 67,500 April May 232,500 236,250 108,750 8,400 150,000 71,250 225,000 105,000 9,500 1. It is estimated that approximately 75% of cash from sales to retailers is received at the time of sale and 25% is received one month later. It is also agreed with the retailer that 5% of May sales will be paid one month in advance. 2. Sales in the high street shops are all in cash and received at the time of sale. 3. The company rents out one of its stores. It is going to receive cash rent income of £6,000 in April 2023. 4. 60% of payments for raw materials are made in the month of purchase, 40% one month later. 5. Labour costs are paid in full at the end of each month. 6. A new machine costing £120,000 is to be acquired on 28th February. The new machine will be paid for in 3 equal monthly instalments beginning in March. 7. Monthly overheads are paid one month after they are incurred and include £3,700 of depreciation. The monthly depreciation amount will increase by £4,000 in March 2023 due to the purchase of the new machine. 8. The opening bank balance on 1st February 2023 is forecast to be £130,000. The company is also forecast to have £20,000 in cash on 1st February 2023. Required a) Prepare a cash budget for the 3 months period February to April. b) Discuss the cash budget in (a) stating any concerns you would have about the figures and any steps the management of Gray Ltd could take to improve the company's cash flow position. (200 words) c) Explain why a business should prepare a cash budget.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Morals and Ethics
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
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage