Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a similar exercise posted on in the previous question (given below as reference) with different numbers and a different collection schedule: Logan Township

This is a similar exercise posted on in the previous question (given below as reference) with different numbers and a different collection schedule: 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. 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 $4,000,000, and expected to increase 30% in July. August sales will be the same as July sales. Estimate the monthly cash collections for June, July, August, and September.

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 Junes 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?

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

P7 Advanced Audit And Assurance Q And A 2013

Authors: ACCA Simplified

1st Edition

1492716626, 978-1492716624

More Books

Students also viewed these Accounting questions