Cash Conscious Inc. is a merchandising company that buys goods for resale Cash Conscious Inc is preparing a cash budget for the month of March 2021 and has collected the following estimated NOTE: If some of the boxes below have HVALVE in them it means you haven't entered your student number on the Cover tab. 1 Estimated monthly sales in units January 1.250 February 1,350 March 1.450 April 1.300 May 1,500 2 Average selling price is estimated 14.60 per unit. All sales are credit sales Estimated collection pattern for credit sales is 30% in the month of sale, sos in the month after 3 sale and 20% two months after the sale 4 The company would like to have ending inventory each month equal to 20% of next months soles. 5 Cost of purchases are estimated 8.00 per unit and prepaid in the month of purchase Depreciation is calculated using the straight line method. Assume all other annat fixed 6 operating expenses are incurred evenly throughout the year and are paid in the month incurred Annual Fixed Operating Expenses Advertising 5 12,288.00 Depreciation 5 13.72800 insurance 5 1420000 Property Tores 5 12,950.00 Sales and Admin Salaries S 14,400.00 Required: Prepare Cash Conscious Inc's cash budget for March 2021. Assume a Maren opening 19.500.00 To help you organize this, you will need to a) Determine the sales budgeted for the first quarter and the amount of cash collected in March (4 marks) b) Determine the merchandise purchase requirements for March (3 marks) c) Determine the total cash disbursements for March (purchases and feed operating expenses) (2 marks) d) Prepare the cash budget in good form (only 4 lines are required opening cash balance plus receipts minus disbursements equals ending cash balance) (4 marks