Exercise $13-43($Algo$)$ Prepare Budgeted Financial Statements $($LO $13-6)$

Cornwall Mobile Detailing $($CMD$)$ is a service that washes and details a customer's vehicle at their home or office. It operates on a membership basis. Members pay $$400$ dues per month, which entitle them to a complete wash and detail service monthly. Members may also order additional car washes during the month at a fee of $$85.$ Additional washes are common in both summer and winter months. The number of members also varies with the season. The number of members and the average number of additional washes by members for the months of interest follow:

$\backslash$table$[[,$Members,Additional Washes $($Average per Member$)],[$January$,380,1\mathrm{.}0],[$February$,440,1\mathrm{.}3],[$March$,1,000,0\mathrm{.}9],[$April$,1,140,0\mathrm{.}8],[$May$,1,170,1\mathrm{.}1],[$June$,1,320,1\mathrm{.}6]]$

References

Cornwall allows members to pay for dues on credit. Cornwall's experience is that $40$ percent of its members pay cash for the dues, $50$ percent of the members pay the dues for a month in the next month, $5$ percent in the second month after. The remainder is uncollectible. Additional washes are payable in cash.

Cornwall estimates that the number of members in July should increase $20$ percent above June levels, and the number of additional washes per member should increase by an estimated $12\mathrm{.}5$ percent. The following information is available for costs incurred in June. All costs except depreciation are paid in cash.

$\backslash$table$[[$Service costs,$],[$Variable costs,$$45,000$