Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello please provide answers for a & b with the work! I dont know where to start and need help with them. Thank you! This

Hello please provide answers for a & b with the work! I dont know where to start and need help with them. Thank you! image text in transcribed

image text in transcribed

This is the only information provided.

U UC III 2. Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. Month Sales June 2017 July August September October $279,500 230,750 196,625 151,125 123,500 131,625 Other Payments $130,000 121,875 113,750 81,250 73,000 November 13 CHAPTER 4: The Cash Budget same month as the purchase. A minimum cash balance of $25,000 must be maintained each month, and the firm pays 4% annually for short-term borrowing from its bank. a. Create a cash budget for June to October 2017. The cash budget should account for short-term borrowing and pay back of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance. b. Bob Loblaw, the president is considering stretching out its inventory payments. He believes that it may be less expensive to borrow from suppliers than from the bank. He has asked you to use the Scenario Manager to see what the total interest cost for this time period would be if the company paid for 0%, 10%, 30%, or 40% of its inventory purchases in the same month. The remainder would be paid in the following month. Create a scenario summary and describe whether the results support Bob's beliefs. 3. Camp and Feyurly Fina April and May sales were $186,875 and $219.375, respectively. The firm collects 15% of its sales during the month, 75% the following month, and 10% two months after the sale. Each month it purchases inventory equal to 55% of the next month's expected sales. The company pays for 40% of its inventory purchases in the same month and 60% in the following month However, the firm's suppliers give it a 2% discount if it pays during the U UC III 2. Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. Month Sales June 2017 July August September October $279,500 230,750 196,625 151,125 123,500 131,625 Other Payments $130,000 121,875 113,750 81,250 73,000 November 13 CHAPTER 4: The Cash Budget same month as the purchase. A minimum cash balance of $25,000 must be maintained each month, and the firm pays 4% annually for short-term borrowing from its bank. a. Create a cash budget for June to October 2017. The cash budget should account for short-term borrowing and pay back of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance. b. Bob Loblaw, the president is considering stretching out its inventory payments. He believes that it may be less expensive to borrow from suppliers than from the bank. He has asked you to use the Scenario Manager to see what the total interest cost for this time period would be if the company paid for 0%, 10%, 30%, or 40% of its inventory purchases in the same month. The remainder would be paid in the following month. Create a scenario summary and describe whether the results support Bob's beliefs. 3. Camp and Feyurly Fina April and May sales were $186,875 and $219.375, respectively. The firm collects 15% of its sales during the month, 75% the following month, and 10% two months after the sale. Each month it purchases inventory equal to 55% of the next month's expected sales. The company pays for 40% of its inventory purchases in the same month and 60% in the following month However, the firm's suppliers give it a 2% discount if it pays during the

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

Management Accounting

Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Phillip Beaulieu

6th Canadian edition

013257084X, 1846589207, 978-0132570848

Students also viewed these Finance questions

Question

What do you know of my (the interviewers) research program?

Answered: 1 week ago