Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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.

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 $1,700 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 $150. 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:

Members Additional Washes (Average per Member)
January 510 2.3
February 570 2.6
March 1,130 2.2
April 1,270 2.1
May 1,300 2.4
June 1,450 2.9

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.5 percent. The following information is available for costs incurred in June. All costs except depreciation are paid in cash.

Service costs
Variable costs $ 51,500
Equipment maintenance 47,500
Depreciation (fixed) 90,000
Total $ 189,000
Marketing and administrative costs
Marketing (variable) $ 39,500
Administrative (fixed) 112,500
Total $ 152,000
Total costs $ 341,000

Variable service and marketing costs change with volume, measured by number of members. Fixed depreciation will remain the same, but fixed administrative costs will increase by 10 percent beginning July 1. Equipment maintenance is outsourced and the contract calls for a 5 percent increase beginning July 1.

Required:

Prepare a budgeted income statement for July.

Note: Do not round intermediate calculations. Enter your answers rounded to the nearest whole dollars.image text in transcribed

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 $1,700 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 $150. 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: 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.5 percent. The following information is available for costs incurred in June. All costs except depreciation are paid in cash. Variable service and marketing costs change with volume, measured by number of members. Fixed depreciation will remain the same, but fixed administrative costs will increase by 10 percent beginning July 1 . Equipment maintenance is outsourced and the contract calls for a 5 percent increase beginning July 1 . Required: Prepare a budgeted income statement for July. Note: Do not round intermediate calculations. Enter your answers rounded to the nearest whole dollars

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Intermediate Accounting

Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones

10th Edition

978-0324300987

Students also viewed these Accounting questions