Olympic Company needs a cash budget for the month of April, 2020. The companys controller has provided you with the following information and assumptions: 1. The April 1, 2020 cash balance is expected to be $11,000. 2. All sales are on account. Credit sales are collected over a three-month period50 percent in the month of sale, 35 percent in the month following sale, and 15 percent in the second month following sale. Actual sales for February and March were $100,000 and $90,000, respectively. Aprils sales are budgeted at $110,000. 3. Marketable securities are expected to be sold for $25,000 during the month of April. 4. The controller estimates that direct materials totalling $44,000 will be purchased during April. Sixty percent of a months raw materials purchases are paid in the month of purchase with the remaining 40 percent paid in the following month. Accounts payable for March purchases total $9,000, which will be paid in April. 5. During April, direct labour costs are estimated to be $19,000. 6. Manufacturing overhead is estimated to be 40 percent of direct labour costs. Further, the controller estimates that approximately 10 percent of the manufacturing overhead is depreciation on the factory building and equipment. 7. Selling and administrative expenses are budgeted at $22,000 for April. Of this amount, $7,000 is for depreciation. 8. During April, Olympic Company plans to buy a new delivery van costing $25,000. The company will pay cash for the van. 9. Olympic Company owes $35,000 in income tax, which must be paid in April. 10. Olympic Company must maintain a minimum cash balance of $10,000. To bolster the cash position as needed, an open line of credit is available from the bank. Instructions Prepare the following: a) A schedule of cash collections for April (2 marks). b) A schedule of cash payments for raw materials for April (2 marks). c) Fill out the following cash budget for the month of April (16 marks). OLYMPIC COMPANY Cash Budget For the Month Ending April 30, 2020 Beginning cash balance $11,000 Add: Receipts _________________________________ _________________________________ _________________________________ _________________________________ _________________________________ Total receipts ________ Total available cash ________ Less: Disbursements _________________________________ _________________________________ _________________________________ _________________________________ _________________________________ _________________________________ _________________________________ _________________________________ Total disbursements ________ Excess (deficiency) of available cash over disbursements ________ Financing Borrowings ________ Ending cash balance $_________