only question B i need

QUESTION 3 Bader Ltd is considering investing in a new machine in November which costs 37,500 and has a five year useful economic life. In order to support the request for funding Bader Ltd has produced a Profit and Loss(P&L) forecast for the new project covering the first six months of its life which he has presented to the Bank (this is presented below). However, the bank has claimed that this P&L is insufficient for the bank to make a lending decision and has requested a month-by-month cash flow forecast. (All figures in ) Now Dec Jan Feb March April Sales 96,000 120,000 132,000 156,000 216,000 259,200 Less: Variable Costs Material Costs 48,000 72,000 96,000 108,000 132,000 158.400 Labour Costs 12,000 14,400 19,200 24,000 28,800 34,560 Contribution 36,000 33,600 16,800 24,000 55,200 66.240 Less: Fixed Costs Depreciation 625 625 625 625 625 625 Overheads 9,000 9,000 9,000 12,500 12,500 12,500 Operating Profit 26,375 23,975 7,175 10,875 42,075 53.115 The following additional information is available: 1) Sales are 25% cash and 75% credit. Credit Sales are paid two months after the month of sale. 2) Purchases are paid in the month following the purchase. 3) 80% of wages are paid in the current month and 20% the following month. 4) Overheads are paid in the month after they are incurred. 5) There will be a dividend payment of 5,000 in March. 6) Capital Expenditure is paid three months after it is incurred. 7) The management of Bader will contribute 40,000 in cash into the project to start with Required: (a) Prepare a month-by-month cash flow forecast, including a total column, for the first six months of the project's life. Include cash brought forward and cash carried forward amounts each month starting with the initial cash amount above made available to the project. (12 marks) (b) Discuss the cash position of the business as shown by your cash flow forecast in part (a) and how the business could improve its cash position. (8 marks) WORD COUNT GUIDANCE: 300 WORDS+/-10% Total 20 Marks