Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Earth and Artistry, Inc. provides commercial landscaping services. Sasha Cairns, the firms owner, wants to develop cost estimates that she can use to prepare bids

Earth and Artistry, Inc. provides commercial landscaping services. Sasha Cairns, the firms owner, wants to develop cost estimates that she can use to prepare bids on jobs. After analyzing the firms costs, Cairns has developed the following preliminary cost estimates for each 1,000 square feet of landscaping.

Direct material $ 380
Direct labor (5 direct-labor hours at $10 per hour) 50
Overhead (at $16 per direct-labor hour) 80
Total cost per 1,000 square feet $ 510

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 $16 per direct-labor hour was determined by dividing the total overhead costs for the 12-month period ($616,000) by the total direct-labor hours (38,500).

Regular Direct- Overtime Direct- Total Direct-
Total Overhead Labor Hours Labor Hours* Labor Hours
January $ 50,000 2,980 190 3,170
February 51,000 3,270 40 3,310
March 53,000 3,030 70 3,100
April 53,000 3,470 200 3,670
May 48,000 3,400 490 3,890
June 53,000 2,740 730 3,470
July 53,000 2,760 620 3,380
August 49,000 2,440 320 2,760
September 60,000 3,060 70 3,130
October 50,000 2,500 30 2,530
November 49,000 3,400 20 3,420
December 47,000 2,450 220 2,670
Total $ 616,000 35,500 3,000 38,500

*The overtime premium is 50 percent of the direct-labor wage rate.

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 = $47,474 + $1.20 DLH

Required:

  1. 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.

  2. Cairns has been asked to submit a bid on a landscaping project for the city government consisting of 58,000 square feet. Cairns estimates that 50 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.

  1. After attending a seminar on activity-based costing, Cairns decided to further analyze the companys activities and costs. She discovered that a more accurate portrayal of the firms 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 = $10,200 + $3.70 DLH, where DLH denotes direct-labor hours OH2= $9,200 + $13.30 SFS, where SFS denotes the number of square feet of turf seeded (in thousands) OH3 = $8,100 + $6.20 PL, where PL denotes the number of individual plantings (e.g., trees and shrubs) Assume that 5 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 58,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 citys landscaping project assuming half of the 58,000-square-foot landscaping area will be seeded and there will be 290 individual plantings. The plantings will cover the entire 58,000-square-foot area.

PLEASE ANSWER ALL PARTS

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

More Books

Students also viewed these Accounting questions

Question

State three essential attributes of a lab notebook.

Answered: 1 week ago