Question

In: Accounting

Logan Township acquired its water system from a private company on June 1. No receivables were...

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 during the month of sale, and 70% of the resulting billings will be collected during the same month. 90% of the remaining balance should be collectable in the next following month. 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 remain the same in July and August.

Estimate the monthly cash collections for August. An example for June and July follows:

June July August
$3,000,000 X .7 = $2,100,000 (June receivables collected in June). This leaves $900,000 yet to be collected. $3,000,000 X .7 = $2,100,000 (July billings collected in July). In addition, 90% of June’s uncollected receivables will be collected: $900,000 X .9 = $810,000. $2,100,000 + $810,000 = $2,910,000 will be collected in July. ($90,000 will never be collected)


Without performing calculations, how would the answer change if Logan bills customers in the month following the month of sale?

Solutions

Expert Solution

Estimate cash collection for the month of August

Schedule for Cash collection
Particulars August
(A) Sales (in $) (see sales given in problem) $3,000,000
Expected collection
a) 70% in the month of Sale (70% X A) $2,100,000
b) 90% in the month of following sale (refer note 1) $   810,000
b) 3% (i.e. 10% X 30%) uncollectible $             -  
Total monthly disbursements $2,910,000
Total collection for the month of August $2,910,000
Note 1 August
Previous months sales $3,000,000
27% (i.e. 90% X 30%) collection in subsequent month $   810,000

b) If the Company bills in the following month then 70% of the amount collected in the month of billing will be foregone. This will opportunity cost and increase liquidity crisis in the company. In other words, One month working of the company will be forever blocked.


Related Solutions

Logan Company manufactures several toy products. Logan presently manufactures and assembles all the parts for its...
Logan Company manufactures several toy products. Logan presently manufactures and assembles all the parts for its toy truck product. Another toy company has offered to sell the parts to Logan for $2.00 per truck. Logan is considering this offer. If Logan buys the truck parts instead of making them, the space used in producing the parts could be used for a new toy monster, which is scheduled to begin production next year. If Logan continues to produce the parts for...
Dell had its management buyout in 2013. Dell, as a private company, acquired EMC, a publicly...
Dell had its management buyout in 2013. Dell, as a private company, acquired EMC, a publicly listed company, for $67 billion; the deal closed in September 2017. What are the synergy benefits and challenges for Dell and EMC since this acquisition? (List all 5 benefits and challenges)
1.Water samples were taken from water used for cooling as it was being discharged from a...
1.Water samples were taken from water used for cooling as it was being discharged from a power plant into a river. It has been determined that as long as the mean temperature of the discharged water is at most 150 F, there will be no negative impact on the river's ecosystem. To investigate whether a plant is in compliance with regulations that prohibit a mean discharge water temperature above 150 F, researchers took 50 water samples at randomly selected times...
he Kali Company uses the periodic inventory system for its merchandise inventory. The June 1 inventory...
he Kali Company uses the periodic inventory system for its merchandise inventory. The June 1 inventory for one of the items in the merchandise inventory consisted of 60 units with a unit cost of $45. Transactions for this item during June were as follows: June 5 Purchased 40 units @ $50 per unit 13 Sold 50 units @ $95 per unit 25 Purchased 40 units @ $53 per unit 29 Sold 20 units@ $110 per unit Required a. Compute the...
Deliberate Speed Corporation (DSC) was incorporated as a private company on June 1, 2017. The company’s...
Deliberate Speed Corporation (DSC) was incorporated as a private company on June 1, 2017. The company’s accounts included the following at June 30, 2017:   Accounts Payable $ 29,000     Land $ 219,000     Factory Building 105,700     Notes Payable, due 2019 5,800     Cash 31,700     Retained Earnings 268,500     Contributed Capital 199,000     Supplies 8,900     Equipment 137,000   During the month of July, the company had the following activities: Issued 3,620 shares for $362,000 cash. Borrowed $128,000 cash from a local bank, payable June 30, 2020. Bought...
XXX Corporation acquired 80% of the outstanding shares of United Company on June 1, 2020 for...
XXX Corporation acquired 80% of the outstanding shares of United Company on June 1, 2020 for P3,517,500. United Company’s stockholders equity components at the end of this year as follows: Ordinary shares, P100 par, P1,500,000, Share premium P675,000 and Retained earnings P1,335,000. Non-controlling interest is measured at fair value and the fair value is P705,000. The assets of united were fairly valued, except for inventories, which are overstated by P66,000 and equipment which was understated by P90,000. Remaining useful life...
X Company started business on June 1 and prepares monthly financial statements. The following were June...
X Company started business on June 1 and prepares monthly financial statements. The following were June transactions: received $45,000 from a group of investors bought $8,413 of merchandise, $3,920 for cash and $4,493 on account sales were $42,400, of which $38,115 were for cash and $4,285 were on account; Cost of Goods Sold was $23,744 paid $3,785 to suppliers for merchandise previously bought on account collected $2,571 from customers on account paid expenses totalling $8,222 4. What were total assets...
On June 30, Year 7, Apple Company, which prepares monthly financial statements, acquired from Bee Company...
On June 30, Year 7, Apple Company, which prepares monthly financial statements, acquired from Bee Company for 500,000 yen a machine with life of 5 yrs and no residual value. To pay Bee Company, Apple Company borrowed 500,000 yen from Soy Bank (in China) on a 12%, 60 day note. Apple Company acquired a 510,000 yen draft to York Bank (in the U.S.) on August 29, Year 7 to pay the maturity value of the note to Soy Bank. Relevant...
Thirty-two 1-Liter specimens of water were drawn from the water supply for a city and the...
Thirty-two 1-Liter specimens of water were drawn from the water supply for a city and the concentration of lead in the specimen was measured. The average level of lead was 7.3 µg/Liter, and the standard deviation for the sample was 3.1 µg/Liter. Using a significance level of 0.05, do we have evidence the mean concentration of lead in the city’s water supply is less than 10 µg/Liter? Find: The t critical value ? If the true mean equals the null...
1. Concerning the water supply system and structure from the two different water companies, explain the...
1. Concerning the water supply system and structure from the two different water companies, explain the soundness of the research approach. Is this descriptive or analytic epidemiologic research design?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT