Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started