Managerial Accounting

QUESTION 4: 20 marks SHOW ALL SUPPORTING CALCULATIONS FOR THIS PROBLEM. NO MARKS WILL BE AWARDED FOR ANSWERS TO THE PROBLEMS UNSUPPORTED BY CLEARLY SHOWN CALCULATIONS. In early July 2020, Leonora Kevill-Davies, the Chief Executive Officer (CEO) of Nutravalu Foods, a Toronto-based company dedicated to ensuring the purity and quality of its diverse range of health food products, was considering the future of her family-owned business. The company had experienced great success since its inception in 2011, but Nutravalu was now planning to expand its operations into other parts of the country. Leonora knew expansion would be successful only if the company had a good cash management policy, and has asked Otto Semmler, the company's Chief Accountant (CA) for a cash budget for the current month (July 2020). Otto has collected the following pieces of information in order to prepare the cash budget: a. The cash balance on July 1 is $50,000. b. Actual sales for May and June and expected sales for July are shown below. Sales on account are collected over a three-month period as follows: 25% collected in the month of sale, 60% collected in the month following sale, and 10% collected in the second month following sale. The remaining 5% is uncollectible. May June July Cash sales $46,000 $70,000 $83,000 Sales on account $490,000 $501,000 $700,000 c. The company maintains a minimum cash balance of $13,000. An open line of credit is available from Ontario and Saskatchewan Banking Corporation (OSBC), the company's bank, to borrow from if needed, in order to maintain this minimum cash balance. d. A new high-tech food commercial food processor costing $66,000 will be bought for cash during July, and employee bonuses totalling $9,000 will be paid during the month. e. Purchase of inventory will total $280,000 for July. 55% of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $169,000, all of which will be paid in July. f. Selling and administrative expenses are budgeted at $405,000 for July. Of this amount $31,000 is for depreciation. Required: 1. Prepare a schedule of expected cash collections in July. 6.5 marks 2. Prepare a schedule of expected cash disbursements during July for merchandise purchases. 4 marks 3. Prepare a cash budget for July. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month (August). 9.5 marks