Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 $47,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, 40% collected in the month following sale, and 20% collected in the second month following sale. The remaining 15% is uncollectible. May June July Cash sales $59,000 $80,000 $88,000 Sales on account $420,000 $530,000 $640,000 c. The company maintains a minimum cash balance of $17,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 $73,000 will be bought for cash during July, and employee bonuses totalling $7,900 will be paid during the month. e. Purchase of inventory will total $260,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 $129,000, all of which will be paid in July. t. Selling and administrative expenses are budgeted at $387,000 for July. Of this amount $38,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 Form YY1H6577

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Birth Of American Accountancy

Authors: Peter L. McMickle, Paul H. Jensen

1st Edition

0367534681, 9780367534684

More Books

Students also viewed these Accounting questions