Elation 2: Cash Conscious Inc. (13 marks) Please leave Column A blank 50 1 can use it for marking. 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 data: NOTE: If some ofthe boxes below have WALUE in them it means you haven't entered your student number on the Covertab. 1 Estimated monthly salesin units: January February March April May 2 Average selling price is estimated to be 5 14.70 per unit. All sales are credit sales. Estimated collection pattern for credit sales is 30% in the month of sale, 50% in the month after sale and 20% two months after the sale. 4 The company would like to have ending inventory each month equal to 20% ofnext months sales. 5 Cost of purchases are estimated to be S 7.30 per unit and are paid in the month of purchase. Depreciation is calculated using the straightiline method. Assume all other annual fixed operating expenses are incurred evenly throughout the year and are paid in the month incurred. Annual Fixed Operating Expenses Advertising Depreciation Insurance Property Taxes Sales and Admin Salaries Required: Prepare Cash Conscious |nc.'s cash budget for March 2021. Assume a March opening cash balance of: S 16,500.00 To help you organize this, you will need to: :5) Determine the sales budgeted for therst 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 xed operating expenses). (2 marks) d) Prepare the cash budget in good form [only4 lines are required - opening cash balance plus receipts minus disbursements equals ending cash balance). (4 marks) Do your work below