JAGUAR Was recently formed as an event management company. The following information has been drawn from the budgets prepared in the planning exercise so far. November December Sales value Enil 65,000 January February March 80,000 92,000 98,000 Direct wages 8,500 per month Direct materials purchases (e.g. food and drink) December January February March 12,000 13,000 15,000 20,000 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. (i) Payments to suppliers are made at the time of purchase and a discount of 5% is allowed. (ii) Wages are paid as they are incurred. (iv) 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 selling and distribution overheads are depreciation charges of 1,500 and 500 respectively. (v) JAGUAR expects to purchase an integrated IT system in February for a cash payment of 10,500. (vi) The balance sheet as at 31" 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" March 2021. Required: Use Excel Sheet (a) Prepare a cash budget for each of the months January to March. Prepare an income statement for the three month period ending 31" March JAGUAR Was recently formed as an event management company. The following information has been drawn from the budgets prepared in the planning exercise so far. November December Sales value Enil 65,000 January February March 80,000 92,000 98,000 Direct wages 8,500 per month Direct materials purchases (e.g. food and drink) December January February March 12,000 13,000 15,000 20,000 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. (i) Payments to suppliers are made at the time of purchase and a discount of 5% is allowed. (ii) Wages are paid as they are incurred. (iv) 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 selling and distribution overheads are depreciation charges of 1,500 and 500 respectively. (v) JAGUAR expects to purchase an integrated IT system in February for a cash payment of 10,500. (vi) The balance sheet as at 31" 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" March 2021.

Required:

Prepare a cash budget for each of the months January to March.

Prepare an income statement for the three month period ending 31" March 2021.