Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Call (Price - Variable cost) $ 30 20 12 Scenario Excellent Fair Poor In addition to the variable costs of service, the owner estimates that other posts are $47,000 plus $8 for each service call in excess of 3,400 calls. Annual administrative and marketing costs are estimated to be $29,000 plus 10 percent of the contribution margin. Excellent Fair Poor Excellent Fair Poor Required: Use a spreadsheet to prepare an analysis of the possible operating income for Lamphere Lawn Care similar to that in Exhibit 13.16. What is the range of possible operating incomes? Contribution Margin Per Service Call $ $ $ $ $ $ 30 882882 20 12 30 Number of Service Calls. 20 10,350 7,300 5,600 12 Number of Service Calls 10,350 10,350 10,350 7,300 7,300 7,300 Total Contribution Margin Other Costs Marketing and Administrative Operating Profit (Loss) $ $ $ $ $ oooo00

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter7: Linear Regression
Section: Chapter Questions
Problem 3P: Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel...
icon
Related questions
Question
Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most
costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two
factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who
will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable
cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly
true, the owner assumes that the cost of fuel and the number of customers are independent.
Contribution Margin per Service Call
(Price -
Variable
cost)
$ 30
20
12
Scenario
Excellent
Fair
Poor
In addition to the variable costs of service, the owner estimates that other posts are $47,000 plus $8 for each service call in excess of
3,400 calls. Annual administrative and marketing costs are estimated to be $29,000 plus 10 percent of the contribution margin.
Excellent
Fair
Poor
Excellent
Required:
Use a spreadsheet to prepare an analysis of the possible operating income for Lamphere Lawn Care similar to that in Exhibit 13.16.
What is the range of possible operating incomes?
Fair
Poor
Contribution
Margin Per
Service Call
$
$
$
$
$
$
Number of
Service Calls
30
20
10,350
7,300
5,600
12
30
20
12
Number of
Service Calls
10,350
10,350
10,350
7,300
7,300
7,300
Total
Contribution
Margin
Other Costs
Marketing and
Administrative
Operating
Profit (Loss)
$
$
$
$
·ss
$
$
0
0
0
OOOO
0
0
Transcribed Image Text:Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Call (Price - Variable cost) $ 30 20 12 Scenario Excellent Fair Poor In addition to the variable costs of service, the owner estimates that other posts are $47,000 plus $8 for each service call in excess of 3,400 calls. Annual administrative and marketing costs are estimated to be $29,000 plus 10 percent of the contribution margin. Excellent Fair Poor Excellent Required: Use a spreadsheet to prepare an analysis of the possible operating income for Lamphere Lawn Care similar to that in Exhibit 13.16. What is the range of possible operating incomes? Fair Poor Contribution Margin Per Service Call $ $ $ $ $ $ Number of Service Calls 30 20 10,350 7,300 5,600 12 30 20 12 Number of Service Calls 10,350 10,350 10,350 7,300 7,300 7,300 Total Contribution Margin Other Costs Marketing and Administrative Operating Profit (Loss) $ $ $ $ ·ss $ $ 0 0 0 OOOO 0 0
Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most
costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two
factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who
will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable
cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly
true, the owner assumes that the cost of fuel and the number of customers are independent.
Contribution Margin per Service Call
(Price -
Variable
cost)
$ 30
20
12
Scenario
Excellent
Fair
Poor
In addition to the variable costs of service, the owner estimates that other posts are $47,000 plus $8 for each service call in excess of
3,400 calls. Annual administrative and marketing costs are estimated to be $29,000 plus 10 percent of the contribution margin.
Excellent
Fair
Poor
Excellent
Required:
Use a spreadsheet to prepare an analysis of the possible operating income for Lamphere Lawn Care similar to that in Exhibit 13.16.
What is the range of possible operating incomes?
Fair
Poor
Contribution
Margin Per
Service Call
$
$
$
$
$
$
Number of
Service Calls
30
20
10,350
7,300
5,600
12
30
20
12
Number of
Service Calls
10,350
10,350
10,350
7,300
7,300
7,300
Total
Contribution
Margin
Other Costs
Marketing and
Administrative
Operating
Profit (Loss)
$
$
$
$
·ss
$
$
0
0
0
OOOO
0
0
Transcribed Image Text:Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Call (Price - Variable cost) $ 30 20 12 Scenario Excellent Fair Poor In addition to the variable costs of service, the owner estimates that other posts are $47,000 plus $8 for each service call in excess of 3,400 calls. Annual administrative and marketing costs are estimated to be $29,000 plus 10 percent of the contribution margin. Excellent Fair Poor Excellent Required: Use a spreadsheet to prepare an analysis of the possible operating income for Lamphere Lawn Care similar to that in Exhibit 13.16. What is the range of possible operating incomes? Fair Poor Contribution Margin Per Service Call $ $ $ $ $ $ Number of Service Calls 30 20 10,350 7,300 5,600 12 30 20 12 Number of Service Calls 10,350 10,350 10,350 7,300 7,300 7,300 Total Contribution Margin Other Costs Marketing and Administrative Operating Profit (Loss) $ $ $ $ ·ss $ $ 0 0 0 OOOO 0 0
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Enterprise resource planning (ERP)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning