Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could you check my answer for part C and double check if my numbers are right please? QUESTION 4 Indigo Ltd is a manufacturer of

could you check my answer for part C and double check if my numbers are right please? image text in transcribed
image text in transcribed
QUESTION 4 Indigo Ltd is a manufacturer of electric vehicle parts. Although Indigo Ltd is making a profit, the Finance Director is concerned that the business continues to use an overdraft to fund the business on a day to day basis and may not be managing working capital effectively. The following information is available in relation to Indigo Lid: Indigo Ltd Average trade receivables settlement period 57 days Average inventory holding period 50 days Average trade payables payment period 45 days In addition: 1) Demand for electric vehicle parts has been 600,000 units for a number of months. Demand is expected to increase by 10% in February and an additional 10% in March 2020 before remaining static at March 2020 levels for the remainder of the year. Each unit sells for 4 ) 10% of sales are on one months credit terms with the remaining 90% of sales being on two months credit terms. ) It is company policy to make bulk purchases of raw materials to take advantage of bulk buying discounts. Each unit requires six component parts at a cost of 0.30 per part. In January 2020, purchases of parts are equal to the parts required to meet sales demand in February and March 2020. In March 2020, purchases of parts are equal to the parts required to meet sales demand in April and May 2020. Raw materials are paid on a cash basis in the month in which the purchases are made. 1) Rent of 300,000 per quarter is paid quarterly in advance. The first quarterly payment is due on 1 January 2020 v) Other expenses are 960,000 per month, increasing to 1,010,000 per month from March 2020 onwards. These costs are payable in the month in which they are incurred REQUIRED Please note: a maximum word count applies to parts (d) and (e) of this question ONLY. There are no maximum word counts for parts (a), (b) and (c). (a) Explain what is meant by the cash operating cycle. (2 marks) (b) Calculate the cash operating cycle for Indigo Ltd and explain what this figure means. (4 marks) (c) Prepare a cash budget for the months of January, February and March. Analyse the impact on cash of Indigo Ltd's sales and purchases policies as noted in il) and ) above, making specific reference to your cash budget. (22 marks) Cash Budget Incomes Jan Feb March Sales 240,000 972.000 972.000 264,000 1,069,200 290,400 Expenses Purchases 180,000 - 198,000 239,580 Rent 300,000 Other Expenses 960.000 - 960,000 1.010.000 Cash defecit/surplus 1,200.000 78,000 1,082,020 Working Units for Jan 600000* $4 per unit= 2400000 Units for Feb 600000*10% increase =660000*4=2640000 Units For March 660000*10% increase= 726000*4= 2904000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions