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 $200 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 $75. 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: January February March April May June Members 360 420 980 1,120 1,150 1,300 Additional Washes (Average per Member) 0.8 1.1 0.7 0.6 0.9 1.4 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.

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter12: Current Liabilities
Section: Chapter Questions
Problem 4PB: Review the following transactions and prepare any necessary journal entries for Woodworking...
icon
Related questions
Question

Please fast answering please and Do Not Give Solution In Image ? And please explain proper steps by Step ?

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 $200 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 $75. 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:
January
February
March
April
May
June
Members
360
420
980
1,120
1,150
1,300
Service costs
Additional
Washes (Average
per Member):
0.8
1.1
0.7
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 costs
Equipment maintenance
Depreciation (fixed)
Total
0.6
0.9
1.4
Marketing and administrative costs
Marketing (variable)
Administrative (fixed)
Total
Total costs
$ 44,000
40,000
75,000
$ 159,000
$ 32,000
105,000
$ 137,000
$ 296,000
Transcribed Image Text: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 $200 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 $75. 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: January February March April May June Members 360 420 980 1,120 1,150 1,300 Service costs Additional Washes (Average per Member): 0.8 1.1 0.7 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 costs Equipment maintenance Depreciation (fixed) Total 0.6 0.9 1.4 Marketing and administrative costs Marketing (variable) Administrative (fixed) Total Total costs $ 44,000 40,000 75,000 $ 159,000 $ 32,000 105,000 $ 137,000 $ 296,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.
Sales revenue
Service costs:
Answer is not complete.
Cornwall Mobile Detailing
Budgeted Income Statement
For the Month of July
Variable costs
Equipment maintenance
Depreciation (fixed)
Total service costs
Marketing and administrative:
Marketing (variable)
Administrative (fixed)
Overhead cost
Total marketing and administrative costs
Total costs
3
***
100
$
$ 52,800
42,000
75,000
496,275
$ 169,800
$
$
$
$
38,400
115,500
15,600
169,500
339,300
156,975
000
Transcribed Image Text: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. Sales revenue Service costs: Answer is not complete. Cornwall Mobile Detailing Budgeted Income Statement For the Month of July Variable costs Equipment maintenance Depreciation (fixed) Total service costs Marketing and administrative: Marketing (variable) Administrative (fixed) Overhead cost Total marketing and administrative costs Total costs 3 *** 100 $ $ 52,800 42,000 75,000 496,275 $ 169,800 $ $ $ $ 38,400 115,500 15,600 169,500 339,300 156,975 000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College