Question

Problem 6-42 Continuation of Preceding Problem; Computing Least-Squares Regression Estimates; Comparing Multiple Methods (Appendix) (LO 6-1,...

Problem 6-42 Continuation of Preceding Problem; Computing Least-Squares Regression Estimates; Comparing Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-6, 6-8)

[The following information applies to the questions displayed below.]

Martha’s Vineyard Marine Supply is a wholesaler for a large variety of boating and fishing equipment. The company’s controller, Mathew Knight, has recently completed a cost study of the firm’s material-handling department in which he used work measurement to quantify the department’s activity. The control factor unit used in the work-measurement study was hundreds of pounds of equipment unloaded or loaded at the company’s loading dock. Knight compiled the following data.

Units of Activity
Month (hundreds of pounds of
equipment loaded or unloaded)
Material-Handling
Department Costs
January 1,900 $ 11,800
February 1,700 11,400
March 1,400 11,300
April 1,100 10,300
May 2,300 11,200
June 2,500 12,700
July 2,100 12,100
August 1,900 11,500
September 2,700 12,240
October 1,200 11,100
November 1,300 11,450
December 1,500 11,450

Problem 6-42 Part 1

Required:

  1. Compute the least-squares regression estimate of the variable- and fixed-cost components in the company’s material-handling department costs. (Do not round intermediate calculations. Round "Variable-cost component" to 2 decimal places and other answer to the nearest whole dollar amount.)

  1. Complete the least-squares regression equation for the department’s costs. (Do not round intermediate calculations. Round variable cost per unit to 2 decimal places and other answer to the nearest whole dollar amount.)

  1. Predict the firm’s material-handling department’s costs for a month when 2,300 units of activity are recorded. (Do not round intermediate calculations. Round variable cost per unit to 2 decimal places and final answer to the nearest whole dollar amount.)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) Gator Beach...
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months.    Month Total Hours of Operation Total Utility Cost January 550 $ 1,620 February 600 1,700 March 700...
Exercise 5A-5 (Algo) Least-Squares Regression [LO5-11] George Caloz & Frères, located in Grenchen, Switzerland, makes luxury...
Exercise 5A-5 (Algo) Least-Squares Regression [LO5-11] George Caloz & Frères, located in Grenchen, Switzerland, makes luxury custom watches in small lots. One of the company’s products, a platinum diving watch, goes through an etching process. The company has recorded etching costs as follows over the last six weeks: Week Units Total Etching Cost 1 5 $ 22 2 7 21 3 10 25 4 5 20 5 16 28 6 17 32 60 $ 148 For planning purposes, management would...
PA4-1 Assigning Costs Using Traditional System, ABC System [LO 4-1, 4-3, 4-4, 4-6] Hazelnut Corp. manufactures...
PA4-1 Assigning Costs Using Traditional System, ABC System [LO 4-1, 4-3, 4-4, 4-6] Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $160,188 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 4,108 18...
1. Mauro Products distributes a single product, a woven basket whose selling price is $22 per...
1. Mauro Products distributes a single product, a woven basket whose selling price is $22 per unit and whose variable expense is $19 per unit. The company’s monthly fixed expense is $8,100. Required: 1. Calculate the company’s break-even point in unit sales. 2. Calculate the company’s break-even point in dollar sales. (Do not round intermediate calculations.) 3. If the company's fixed expenses increase by $600, what would become the new break-even point in unit sales? In dollar sales? (Do not...