# Question: Outside Environment Inc provides commercial landscaping services in San Diego

Outside Environment, Inc. provides commercial landscaping services in San Diego. Sasha Cairns, the firm’s owner, wants to develop cost estimates that she can use to prepare bids on jobs. After analyzing the firm’s costs, Cairns has developed the following preliminary cost estimates for each 1,000 square feet of landscaping.

Direct material........................................................................$390

Direct labor (5 direct-labor hours at $11 per hour)................. 55

Overhead (at $18 per direct-labor hour)................................. 90

Total cost per 1,000 square feet..............................................$535

Cairns is quite certain about the estimates for direct material and direct labor. However, she is not as comfortable with the overhead estimate. The estimate for overhead is based on the overhead costs that were incurred during the past 12 months as presented in the following schedule. The estimate of $18 per direct-labor hour was determined by dividing the total overhead costs for the 12-month period ($1,296,000) by the total direct-labor hours (72,000).

Cairns believes that overhead is affected by total monthly direct-labor hours. Cairns decided to perform a least-squares regression of overhead (OH) on total direct-labor hours (DLH). The following regression formula was obtained.

OH = $52,400 + $9.25 DLH

Required:

1. The overhead rate developed from the least-squares regression is different from Cairns’ preliminary estimate of $18 per direct-labor hour. Explain the difference in the two overhead rates.

2. Using the overhead formula that was derived from the least-squares regression, determine a total variable-cost estimate for each 1,000 square feet of landscaping.

3. Cairns has been asked to submit a bid on a landscaping project for the city government consisting of 50,000 square feet. Cairns estimates that 30 percent of the direct-labor hours required for the project will be on overtime. Calculate the incremental costs that should be included in any bid that Cairns would submit on this project. Use the overhead formula derived from the least-squares regression.

4. Should management rely on the overhead formula derived from the least-squares regression as the basis for the variable overhead component of its cost estimate? Explain your answer.

5. After attending a seminar on activity-based costing, Cairns decided to further analyze the company’s activities and costs. She discovered that a more accurate portrayal of the firm’s cost behavior could be achieved by dividing overhead into three separate pools, each with its own cost driver. Separate regression equations were estimated for each of the cost pools, with the following results.

OH1 = $20,000 ÷ $4.15 DLH,

where DLH denotes direct-labor hours

OH2 = $18,200 ÷ $13.60 SFS,

where SFS denotes the number of square feet of turf seeded (in thousands)

OH3 = $16,000 ÷ $5.90 PL,

where PL denotes the number of individual plantings (e.g., trees and shrubs)

Assume that five direct-labor hours will be needed to landscape each 1,000 square feet, regardless of the specific planting material used.

a. Suppose the landscaping project for the city will involve seeding all 50,000 square feet of turf and planting 70 trees and shrubs. Calculate the incremental variable overhead cost that Cairns should include in the bid.

b. Recompute the incremental variable overhead cost for the city’s landscaping project assuming half of the 50,000 square-foot landscaping area will be seeded and there will be 230 individual plantings. The plantings will cover the entire 50,000 square-foot area.

c. Briefly explain, using concepts from activity-based costing, why the incremental costs differ in requirements (a) and (b).

(CMA,adapted)

Direct material........................................................................$390

Direct labor (5 direct-labor hours at $11 per hour)................. 55

Overhead (at $18 per direct-labor hour)................................. 90

Total cost per 1,000 square feet..............................................$535

Cairns is quite certain about the estimates for direct material and direct labor. However, she is not as comfortable with the overhead estimate. The estimate for overhead is based on the overhead costs that were incurred during the past 12 months as presented in the following schedule. The estimate of $18 per direct-labor hour was determined by dividing the total overhead costs for the 12-month period ($1,296,000) by the total direct-labor hours (72,000).

Cairns believes that overhead is affected by total monthly direct-labor hours. Cairns decided to perform a least-squares regression of overhead (OH) on total direct-labor hours (DLH). The following regression formula was obtained.

OH = $52,400 + $9.25 DLH

Required:

1. The overhead rate developed from the least-squares regression is different from Cairns’ preliminary estimate of $18 per direct-labor hour. Explain the difference in the two overhead rates.

2. Using the overhead formula that was derived from the least-squares regression, determine a total variable-cost estimate for each 1,000 square feet of landscaping.

3. Cairns has been asked to submit a bid on a landscaping project for the city government consisting of 50,000 square feet. Cairns estimates that 30 percent of the direct-labor hours required for the project will be on overtime. Calculate the incremental costs that should be included in any bid that Cairns would submit on this project. Use the overhead formula derived from the least-squares regression.

4. Should management rely on the overhead formula derived from the least-squares regression as the basis for the variable overhead component of its cost estimate? Explain your answer.

5. After attending a seminar on activity-based costing, Cairns decided to further analyze the company’s activities and costs. She discovered that a more accurate portrayal of the firm’s cost behavior could be achieved by dividing overhead into three separate pools, each with its own cost driver. Separate regression equations were estimated for each of the cost pools, with the following results.

OH1 = $20,000 ÷ $4.15 DLH,

where DLH denotes direct-labor hours

OH2 = $18,200 ÷ $13.60 SFS,

where SFS denotes the number of square feet of turf seeded (in thousands)

OH3 = $16,000 ÷ $5.90 PL,

where PL denotes the number of individual plantings (e.g., trees and shrubs)

Assume that five direct-labor hours will be needed to landscape each 1,000 square feet, regardless of the specific planting material used.

a. Suppose the landscaping project for the city will involve seeding all 50,000 square feet of turf and planting 70 trees and shrubs. Calculate the incremental variable overhead cost that Cairns should include in the bid.

b. Recompute the incremental variable overhead cost for the city’s landscaping project assuming half of the 50,000 square-foot landscaping area will be seeded and there will be 230 individual plantings. The plantings will cover the entire 50,000 square-foot area.

c. Briefly explain, using concepts from activity-based costing, why the incremental costs differ in requirements (a) and (b).

(CMA,adapted)

## Answer to relevant Questions

“I don’t understand this cost report at all,” exclaimed Jeff Mahoney, the newly appointed administrator of Valley General Hospital. “Our administrative costs in the new pediatrics clinic are all over the map. One ...Rosario Company, which is located in Buenos Aires, Argentina, manufactures a component used in farm machinery. The firm’s fixed costs are 2,000,000 p per year. The variable cost of each component is 1,000 p. and the ...Surreal Sound, Inc., manufactures and sells compact disks. Price and cost data are as follows: Selling price per unit (package of two CDs).................. $ 25.00Variable costs per unit: Direct ...Zodiac Company has decided to introduce a new product, which can be manufactured by either a computer-assisted manufacturing system or a labor-intensive production system. The manufacturing method will not affect the quality ...Columbus Canopy Company (CCC) manufactures and sells adjustable canopies that attach to motor homes and trailers. The market covers both new units as well as replacement canopies. CCC developed its 20x4 business plan based ...Post your question