Question

Varmit-B-Gone is a pest control service that operates in a suburban neighborhood. The company attempts to make service calls at least once a month to all homes that subscribe to its service. It makes more frequent calls during the summer. The number of subscribers also varies with the season. The number of subscribers and the average number of calls to each subscriber for the months of interest follow: Service calls (per subscriber) 0.6 0.9 1.6 Subscribers 450 700 1,450 1,450 1,650 1,300 March April May June July August nimic mat The average price charged for a service call is $50. Of the service calls, 30 percent are paid in the month the service is rendered, 60 percent in the month after the service is rendered, and 8 percent in the second month after. The remaining 2 percent is uncollectible. Required: What are Varmit-B-Gone's expected cash receipts for May, June, July, and August? Cash Receipts May June July August

Answer 1

Answer

May	$   54,780.00
June	$ 122,145.00
July	$ 188,530.00
August	$ 218,540.00

Calculations:

Particulars	March	April	May	June	July	August
Subscribers (A)	450.00	700.00	1,450.00	1,450.00	1,650.00	1,300.00
Service calls per subscriber (B)	0.6	0.9	1.6	2.3	3.2	2.4
Average price C)	$         50.00	$         50.00	$           50.00	$           50.00	$           50.00	$           50.00
Total sales (A*B*C)	$ 13,500.00	$ 31,500.00	$ 116,000.00	$ 166,750.00	$ 264,000.00	$ 156,000.00
30% collection	$   4,050.00	$   9,450.00	$   34,800.00	$   50,025.00	$   79,200.00	$   46,800.00
60% collection		$   8,100.00	$   18,900.00	$   69,600.00	$ 100,050.00	$ 158,400.00
8% collection			$     1,080.00	$     2,520.00	$     9,280.00	$   13,340.00
Total collection	$   4,050.00	$ 17,550.00	$   54,780.00	$ 122,145.00	$ 188,530.00	$ 218,540.00

In case of any doubt, please comment.