Question 1: "Logan Township acquired its water system from a private company on June 1. No receivables were acquired with the purchase. Therefore, total accounts receivable on June 1 had a zero balance.
Logan plans to bill customers in the month following the month of sale, and 70% of the resulting billings will be collected during the billing month. In the next following month, 90% of the remaining balance should be collectable. The remaining uncollectible amounts will relate to citizens who have moved away. Such amounts are never expected to be collected and will be written off.
Water sales during June are estimated at $3,000,000, and expected to increase 30% in July. August sales will be 10% less than July sales. "
(a) For each dollar of sales, how much is expected to be collected?
(b) Estimate the monthly cash collections for June, July, August, and September.
(c) As of the end of August, how much will be the estimated amount of receivables from which future cash flows are anticipated?
Question 2: "Nolan Johnson is CFO for a newly formed furniture manufacturing company. Below is the anticipated monthly production for the first year of operation, and beyond. Nolan is interested in learning which of the first twelve months will require cash outlays of more than $100,000 toward the purchase of lumber. Each unit requires 20 board feet of lumber at $5.80 per board foot. All lumber is purchased in the month prior to its expected use. Lumber purchases are paid for 10% in the month of purchase, 40% in the month following the month of purchase, and 50% in the second month following the month of purchase."
| Month |
|
Units |
| January |
|
0 |
| February |
|
800 |
| March |
|
500 |
| April |
|
1,200 |
| May |
|
700 |
| June |
|
900 |
| July |
|
300 |
| August |
|
600 |
| September |
|
800 |
| October |
|
1,300 |
| November |
|
400 |
| December |
|
400 |
| January |
|
600 |
| |
|
|
Which months will require cash outlays in excess of the $100,000 amount? Does the production in any given month necessarily correspond to the cash flow for that same month? What are the business implications of your observation?
Question 3: The chief financial officer for Cast In Stone concrete products had previously established a line of credit with a local bank that enables Cast In Stone to borrow 80% of the company's inventory balance. The company currently has 1,000 units in stock, and is performing "on budget." The budget anticipated that direct labor cost would be $15 per hour, and factory overhead is applied to production based on $7.50 per direct labor hour. Each unit requires 2.5 labor hours and 800 pounds of direct material. The direct material costs $0.10 per pound.
Determine the amount of credit available under the borrowing agreement.
Attachment:- acc.zip