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 Scenario, Excellent Fair Poor (Price - Variable cost) $ 30 20 12 Number of Service Calls 10,350 7,300 5,600 In addition to the variable costs of service, the owner estimates that other costs 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. 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 Number of Service Calls Service Call. Total Contribution Margin Other Costs Marketing and Administrative Operating Profit (Loss) Excellent $ 30 10,350 $ 0 Fair $ 20 10,350 $ 0 Poor $ 12 10,350 $ 0 Excellent $ 30 7,300 S 0 Fair $ 20 7,300 0 Poor $ 12 7.300 $ 0 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 Scenario Excellent Fair Poor (Price- Variable cost) $ 30 Number of Service Calls 10,350 7,300 5,600 20 12 In addition to the variable costs of service, the owner estimates that other costs 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. 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 Number of Service Galls Service Call Total Contribution Margin Other Costs Marketing and Administrative Operating Profit (Loss) Excellent $ 30 10,350 $ Fair $ 20 10,350 $ 0 Poor $ 12 10,350 $ 0 Excellent $ 30 7,300 $ 0 Fairi $ 20 7,300 $ 0 Poor $ 12 7,300 $ 0 Excellent $ 30 5,600 $ 0 Fair $ 20 5,600 $ Poor $ 12 5,600 $ 0