Trellis Ltd is a small start-up business hoping to grow and diversify in future, currently engaged...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Trellis Ltd is a small start-up business hoping to grow and diversify in future, currently engaged in the bespoke manufacture of one product, a decorative garden fence. The company's overdraft limit is £15,000 and the directors wish to ensure that this is not exceeded between 1 October 2022 and 31 January 2023, as it wants to prove to its lenders that it can manage its cashflow. I 4 Each fence has the following selling price and direct costs per unit: £ - Selling price Direct material Direct labour Variable production expenses" Variable selling expenses Contribution Predicted sales quantities for the next 4 months are:< Sales Units P 4 October 2022 November 2022 December 2022- January 2023 200--> (120)** (20) (10) (20) 250 280 300- 340 £30 O fe 4² e P De om DE Extracts from the latest financial statements, as at 30 September 2022 included the following: ¹ 41 el Trade receivables + T Inventory Utilities bill (payable in October 2022) 4 4 Bank overdraft (trading bank account)" # Trade payables- + Variable selling expense accrual . ● The following information is also relevant:< 40% of sales each month are expected to be for cash (received immediately) and the remaining sales will be on 1 month's credit. ● 15,000- 17,000+¹ 400- 2,000+ 25,000+ 2,200 . de W de توله Purchases of direct material are made in the month of sale and Trellis Ltd takes, on average, one month's credit from its suppliers before payment.+¹ Direct labour cost and variable production expenses are paid for in the month in which they are incurred. The variable selling expenses are paid in the following month. Fixed expenses of £4,500 are paid each month as they are incurred.< Trellis I td has an £8.000 loan from a private source received on 1 January 2022.00. . . b) . ● they are Trellis Ltd has an £8,000 loan from a private source received on 1 January 2022 on which interest of 10% is payable after a year, on 31 December each year. The funds from the loan were deposited into its trading bank account on 1 January 2022. The company is planning to purchase additional machinery on 1 October 2022 at a cost of £9,000 payable in two equal instalments in October 2022 and December 2022. The company is planning to purchase space at a local Garden Centre to show off its garden fences and future products. A payment of £3,000 will be paid in full in November 2022 to secure the space for 2023, which is often in high demand. • Taxation owed from the previous period is £8,000 and will be paid in November 2022.< d An inventory of finished goods is kept for emergency orders. This is not expected to change throughout the period. Required: a) Prepare a month-by-month cash flow budget for Trellis Ltd using a tabular format, showing the closing balance expected each month, for the four months from 1 October 2022 to 31 January 2023.< (17 Marks)< Calculate the current ratio and 'acid test' quick ratio as at 31 January 2023. (5 Marks) Based on your answer to part a) and b), advise the directors on whether they need to take action and, if so, what action they might take to manage their cash position. (8 Marks)+ Trellis Ltd is a small start-up business hoping to grow and diversify in future, currently engaged in the bespoke manufacture of one product, a decorative garden fence. The company's overdraft limit is £15,000 and the directors wish to ensure that this is not exceeded between 1 October 2022 and 31 January 2023, as it wants to prove to its lenders that it can manage its cashflow. I 4 Each fence has the following selling price and direct costs per unit: £ - Selling price Direct material Direct labour Variable production expenses" Variable selling expenses Contribution Predicted sales quantities for the next 4 months are:< Sales Units P 4 October 2022 November 2022 December 2022- January 2023 200--> (120)** (20) (10) (20) 250 280 300- 340 £30 O fe 4² e P De om DE Extracts from the latest financial statements, as at 30 September 2022 included the following: ¹ 41 el Trade receivables + T Inventory Utilities bill (payable in October 2022) 4 4 Bank overdraft (trading bank account)" # Trade payables- + Variable selling expense accrual . ● The following information is also relevant:< 40% of sales each month are expected to be for cash (received immediately) and the remaining sales will be on 1 month's credit. ● 15,000- 17,000+¹ 400- 2,000+ 25,000+ 2,200 . de W de توله Purchases of direct material are made in the month of sale and Trellis Ltd takes, on average, one month's credit from its suppliers before payment.+¹ Direct labour cost and variable production expenses are paid for in the month in which they are incurred. The variable selling expenses are paid in the following month. Fixed expenses of £4,500 are paid each month as they are incurred.< Trellis I td has an £8.000 loan from a private source received on 1 January 2022.00. . . b) . ● they are Trellis Ltd has an £8,000 loan from a private source received on 1 January 2022 on which interest of 10% is payable after a year, on 31 December each year. The funds from the loan were deposited into its trading bank account on 1 January 2022. The company is planning to purchase additional machinery on 1 October 2022 at a cost of £9,000 payable in two equal instalments in October 2022 and December 2022. The company is planning to purchase space at a local Garden Centre to show off its garden fences and future products. A payment of £3,000 will be paid in full in November 2022 to secure the space for 2023, which is often in high demand. • Taxation owed from the previous period is £8,000 and will be paid in November 2022.< d An inventory of finished goods is kept for emergency orders. This is not expected to change throughout the period. Required: a) Prepare a month-by-month cash flow budget for Trellis Ltd using a tabular format, showing the closing balance expected each month, for the four months from 1 October 2022 to 31 January 2023.< (17 Marks)< Calculate the current ratio and 'acid test' quick ratio as at 31 January 2023. (5 Marks) Based on your answer to part a) and b), advise the directors on whether they need to take action and, if so, what action they might take to manage their cash position. (8 Marks)+
Expert Answer:
Answer rating: 100% (QA)
Here is my analysis of the cash flow budget and financial position for Trellis Ltd a Monthbymonth cash flow budget for Trellis Ltd Trellis Ltd Cash Fl... View the full answer
Related Book For
Corporate Finance and Investment decisions and strategies
ISBN: 978-1292064062
8th edition
Authors: Richard Pike, Bill Neale, Philip Linsley
Posted Date:
Students also viewed these accounting questions
-
The following facts pertain to a non-cancelable lease agreement between Marin Leasing Company and Cullumber Company, a lessee. Commencement date May 1. 2020 Annual lease payment due at the beginning...
-
Wildhorse Corporation purchased an asset at a cost of $60,000 on March 1, 2020. The asset has a useful life of 8 years and a salvage value of $4,800. For tax purposes, the MACRS class life is 5...
-
On January 1, 2020, Carla Vista Corp., which uses IFRS, signs a 10-year, non-cancellable lease agreement to lease a specialty lathe from Liu Inc. The following information concerns the lease...
-
A partially completed flowchart showing some of the major documents commonly used in the purchasing function of a merchandise business is presented below. Identify documents 1, 3, and4. Purchase Order
-
Jane Ives lived in Linwood, New Jersey, with her three school- age children. All three students went to Cosgrove High School, which covered grades 9 through 12. By law, the school district had to...
-
What recommendations would you have for Athletic Brewing to help it propel the non-alcoholic category to more than 50 percent of beer salesShufelts aspirational goal?
-
There are several ways of accounting for the sale of scrap material resulting from manufac- turing processes. One is to credit the proceeds to the Manufacturing Overhead account. Another is to reduce...
-
Indicate whether each of the following transactions would increase (+), decrease(??), or not affect (N/A) total assets, total liabilities, and total stockholders??equity. Stockholders' Transaction...
-
Harley-Davidson(B) 2010" Please respond to the following:From the case study, examine the significant differences between the Harley-Davidson 2008 securitization and the 2009 securitization and the...
-
One thousand kilomoles per hour of rich gas at 70F with 25% C1, 15% C2,25% C3, 20% nC4, and 15% nC5 by moles is to be absorbed by 500 kmol/h of nC10 at 90F in an absorber operating at 4 atm....
-
The American Indian is often portrayed as the "noble savage". One example is that of Chingachcook in Last of the Mohicans. However, life in early America was a brutal struggle for survival. Great...
-
what input can employees have with a companies ethical policies? How can employees play a role in corporate social responsibility? how can employee activism change a company policies and business...
-
The Quality Challenge Maria Walker has been working for the last several years in the research and developmentbdepartment of a semiconductor manufacturing company employing 120 staff. Because of her...
-
1. what ways did these political events or military conflicts affect the Olympic Games? What were the "issues" at play? (Did world events influence the location of the Games? Did any countries...
-
Explain the complexity of the health workforce as highly educated knowledge workers. Discuss how these characteristics might this dynamic lead to conflict and failures in communication and how...
-
What role does emotional contagion play in shaping team morale and energy levels, and how can team leaders use this knowledge to foster a positive and productive team climate ?
-
The following are selected transactions that may affect shareholders equity. Assuming the company follows IFRS ( including IAS 3 9 ) , indicate the effect that each of the 1 3 transactions has on the...
-
Quality Chicken grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2012 is: Joint cost of production in July 2012 was $50. A...
-
The directors of Mylo Ltd are currently considering two mutually exclusive investment projects. Both projects are concerned with the purchase of new plant. The following data are available for each...
-
Raiders Ltd is a private limited company financed entirely by ordinary shares. Its effective cost of capital, net of tax, is 10 per cent p.a. The directors are considering the company's capital...
-
The main principles of financial management may be applied to most organisations. However, the role of the financial manager may be affected by the type of organisation in which he or she works....
-
(Appendix) Journalize standard cost transactions (Learning Objective 6) Refer to the data in PI 1-44A. Journalize the usage of direct materials and the assign ment of direct labor, including the...
-
Compute variances and prepare standard cost income statement (Learning Objectives 4, 5, 6) Happ and Sons makes ground covers to prevent weed growth. During May, the company produced and sold 44,000...
-
Prepare a flexible budget for planning (Learning Objective 1) Digital Technologies manufactures capacitors for cellular base stations and other communications applications. The companys static budget...
Study smarter with the SolutionInn App