Question 1 The following data has been extracted from the operating budgets of Gray Ltd for...
Fantastic news! We've Found the answer you've been seeking!
Question:
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: Month Income from sales to retailer £ Income from high street shop sales £ January 255,000 90,000 February 262,500 112,500 75,000 March 232,500 April 232,500 67,500 May 150,000 71,250 Raw material Labour Overheads purchases £ 232,500 225,000 232,500 236,250 225,000 £ £ 97,500 5,500 90,000 5,500 97,500 8,200 108,750 8,400 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 1s¹ 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. 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: Month Income from sales to retailer £ Income from high street shop sales £ January 255,000 90,000 February 262,500 112,500 75,000 March 232,500 April 232,500 67,500 May 150,000 71,250 Raw material Labour Overheads purchases £ 232,500 225,000 232,500 236,250 225,000 £ £ 97,500 5,500 90,000 5,500 97,500 8,200 108,750 8,400 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 1s¹ 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 Answer:
Answer rating: 100% (QA)
Gray Sales budget January February March April May Note Income from high street sales 11250000 7500000 6750000 A Income from sales to retailer 2550000... View the full answer
Related Book For
Accounting Business Reporting For Decision Making
ISBN: 9780730302414
4th Edition
Authors: Jacqueline Birt, Keryn Chalmers, Albie Brooks, Suzanne Byrne, Judy Oliver
Posted Date:
Students also viewed these accounting questions
-
The following data has been extracted from last quarter's budget of Elise Ltd, which manufactures and sells a single product. January February March Production units 6200 6200 5800 Sales units 5900...
-
The following information has been extracted from the draft financial statements of TEX, a manufacturing entity: TEX - Income statement for the year ended 30 September 2003 September 2003...
-
The following information has been extracted from the accounting records of the Atwood Corporation: 1. Cash on hand (undeposited sales receipts) ............ $ 1,020 2. Certificates of deposit...
-
A client of Park Street's expected a delivery of samples for an event on Friday evening. The order was setup correctly by Park Street, however the vendor that was hired to pick up and deliver the...
-
Determine the population variance and standard deviation for the following data by using the original formula. Class f 20under 30 ........ 7 30under 40 ........11 40under 50 ........18 50under 60...
-
A company deposits $12,000 at the beginning of each quarter into an account that earns 7.2% compounded quarterly. How much will be in this account after 5 years? (a) State whether the problem relates...
-
Under what circumstances is a moving party entitled to summary judgment?
-
The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester....
-
At BCD car wash, when a customer arrives, he or she first checks in with a receptionist and then leaves the car to one of several car washers. While the customer is waiting for the car to be washed,...
-
Compare the forward quotes, money market hedges and options with each other to determine the best exchange rate hedge for France (Complete Table 5 on the separate answer sheet) Calculate the exchange...
-
(a) Prove that for any p = [0, 1] and any integers k and n such that 1 k n, n -p)--(-)- (-1)p(1 - p). n (m) p (1 - p)" m=k = m=k For this you may consider a binomial process with parameter p and its...
-
Now choose one of your firms and look up the other firms in the same industry. Perform a Valuation by Comparables analysis by looking at the price/earnings, price/book value, price/sales, and...
-
Subway uses approximately 60 acres of lettuce a daythe equivalent of more than 17 football fields of lettuce. If you take all the cheese that is produced for Subway restaurants in a year and place...
-
Check out the online education services. Which look best to you?
-
What is the professionals consensus forecast for inflation for the next two years?
-
How do recent U.S. inflation and long-term interest rates compare with those of the other countries listed?
-
Three wooden beams and two steel plates are securely bolted together to form the composite member shown. Using the data given in the table, determine the largest permissible bending moment when the...
-
What is the amount of total interest dollars earned on a $5,000 deposit earning 6% for 20 years?
-
What is the balanced scorecard framework?
-
You have a friend who is considering purchasing some shares in LookFool Ltd. The shares are currently trading on the stock exchange at $3.58 each. The entity's financial statements suggest that the...
-
a) In relation to short-term liquidity explain: i) What the operating cycle is. ii) Why it is important. b) How does the quick asset ratio differ from the current ratio? Explain.
-
For the European Union and the European Central Bank, an expansionary monetary policy was the only way to beat recession and increase the economic growth of the member states from 2015 to 2017....
-
What are the determinants that influence the open economy IS curve? Which factors shift the open economy IS curve in which direction? What was the advantage for China to open its economy?
-
Grekos Olia produces organic extra virgin olive oil that is sold for 20 per bottle ( 1 liter). Turkish Oliva makes standard olive oil that is sold for 40 Turkish lira per bottle (1 liter). The real...
Study smarter with the SolutionInn App