SCHOOL OF BUSINESS ACC 2302: INTRODUCTION TO MANAGEMENT ACCOUNTING ASSIGNMENT-3 (WEEKEND +DISTANCE LEARNING) Instructions: Time Allowed: 1 Week HH Company is in the process of preparing the cash budget for the last four months of 2021 that is September to December. The following information has been made available. Sept Oct Nov Dec Projected sales quantity (units) 60,000 65,000 65,000 70,000 Additional information: 1. Selling price is ksh 110 per unit but expected to drop by 5% from 1st November. 2. Payment for goods sold is as follows; 20% in the month of sales, 70% the following month after sales and The balance in the second month after sales. 3. Bad debt is estimated at 2% of sales value. 4. Purchases of goods at ksh 60 per unit are as follows: September 84,000 units, October 80,000units, November 92,000 units and December 78,000 units. 5. Goods purchased are paid one month in arrears. 6. Monthly expenses estimated at 10% on sales revenue are paid in the month of incurrence. 7. The company plans to buy a delivery van at ksh 2,700,000, 40% of the cost to be paid in October and the balance in January 2021. 8. The Director withdraws ksh 300,000 monthly for personal expenses. 9. Extracts from August figures are as follows: Debtors ksh 5,600,000 out of which ksh 1,400,000 is part of July sales before bad debt Creditors for goods ksh 3,200,000 Cash ksh 850,000 Required: Prepare Monthly cash budget for the four months ending December 2021 (10 Marks)