Please upload a excel

file, I do not want images

WAKE l A G U A R Was recently formed as an event management company. The following information has been drawn from the budgets prepared in the planning exercise so far. Sales value November nil December 65,000 January 80,000 February 92,000 March 98,000 Direct wages 8,500 per month Direct materials purchases (e.g. food and drink) December 12,000 January 13,000 February 15,000 March 20,000 (0 (ii) (iii) (M (V) M) The industry has a poor credit collection reputation and therefore JAGUAR heavily encourage early payment and thus are predicting very few credit customers not to pay. The company sells 20% of its goods for cash at a discount of 20%. The remainder of customers receive two months' credit. JAGUAR allows credit customers a 10% discount if they pay within 1 month. This policy means that on average 50% of credit customers pay within 30 days. The management believe that the threat of non-payment cannot be ruled out altogether and a provision for doubtful debts should be set up on 31!\" March for 2,500. Payments to suppliers are made at the time of purchase and a discount of 5% is allowed. Wages are paid as they are incurred. Administrative overheads are 11,500 per month and selling and distribution overheads amount to 14,000 per month. Included in the amounts for administrative overheads and seiling and distribution overheads are depreciation charges of 1,500 and 500 respectivety. JAGUAR expects to purchase an integrated IT system in February for a cash payment of 10,500. The balance sheet as at 3151 December 2009 showed an overdraft balance of (10,000); inventories of 10,000; and a liability for a staff bonus of 5,000. The bonus will be paid in January and closing inventories are expected to be 12,000 as at 31 5' March 2021. Required: Use Excel Sheet (8) (b) Prepare a cash budget for each of the months January to March. [10 marks] Prepare an income statement for the three month period ending 31 5' March 2021. [8 marks]