Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are Assistant to Susan Ali, controller for POW PRODUCTS Ltd. (PP), a food distributor. It is late afternoon May 31. Susan has called you

You are Assistant to Susan Ali, controller for POW PRODUCTS Ltd. (PP), a food distributor. It is late afternoon May 31. Susan has called you to her office to tell you that she is leaving this evening on a well-deserved vacation and that you are to complete and circulate the cash budget for June. To help , she has assembled the following budget data.

sales inventory purchase
April 1,200,000
May 1,300,000 940,000
June 1,100,000 1,040,000

Sales. Each month 40% of sales are in cash and 60% are on credit. The collection of credit sales is 20% in the month of sale, 50% in the following month, and 30% in the next month. Inventory purchases. Inventory purchases are paid 30% in the month of purchase, and 70% the following month. Additional information: At the end of the day on May 31st the company has a cash balance of $460,000.

Early in May a dealer offered to sell PP a fleet of 12 new high capacity delivery vans at $900,000 for all 12 vans. PP intends to make the purchase in cash on June 15. In addition, the dealer has agreed to accept the old fleet as a trade-in for $140,000. PP will recognize a gain on disposal sale of $55,000 in this transaction.

Other monthly cash expenses are expected to total $250,000.

Monthly depreciation of plant and equipment is $180,000.

Quarterly income tax instalments of $150,000 is to be paid in June.

A dividend payment of $230,000 was declared in May for payment in June.

All PP employees share a monthly cash bonus of 2% of the preceding month's sales.

The company has a policy of maintaining a minimum cash balance of $10o,000 and has a line of credit with the bank to enable it to borrow when necessary. All borrowing is done at the beginning of the month, and borrowings are made to the nearest $1,000. Monthly interest is calculated at 2% per annum and must be paid at the end of each month. There is no outstanding borrowing currently. Susan is rushing to catch her flight as she hands you the budget data, and says, "We may be a bit cash short for June. If so, prepare the budget on the assumption that the cash shortfall will be made up with borrowing. You then go to Stella Ruel, the CEO, to get permission to borrow. However, she will first want to know what are the best alternatives so you should also prepare two reasonable alternatives for your meeting with her. She will also want to know which of these three courses of action you recommend and why. You know our operations, priorities and constraints well enough to do thisjust be prepared.

Required A. Prepare a cash budget for June 200x using a clear and logical format.

B. Assume that Susan is correct about June being cash short. Prepare notes to present to the CEO, outlining the three best alternative courses of action to choose from, i.e., borrowing and two others. Then make a case for the one you judge to be best.

C. Some managers who do not have any accounting training dont understand the difference between a statement of cash flows (SCF) and a cash budget. The CEO of POW PRODUCTS , Stella Ruel, is one of these non-accountant managers and she asks you to explain, briefly, in what way are these two statements are similar and in what way to they differ. In particular, what are the key differences between them.

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

Auditing Transformation Regulation Digitalisation And Sustainability

Authors: Jan Marton, Fredrik Nilsson, Peter Öhman

1st Edition

103253303X, 978-1032533032

More Books

Students also viewed these Accounting questions