Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) What is the variable rate (to the nearest cent) and the fixed cost that would be used in a cost formula for receiving based on these results? Variable Rate: _______________ Fixed Cost:_________________ Calculate the predicted receiving cost for a month with 1,450 receiving orders. In your calculations, round variable cost per unit to two decimal places. Round your final answer to the nearest dollar.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question

(Appendix 3A) Method of Least Squares

Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controller's department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:

  Month   Receiving Orders   Receiving Cost
1   1,000     $18,000
2   700     15,000
3   1,500     28,000
4   1,200     17,000
5   1,300     25,000
6   1,100     21,000
7   1,600     29,000
8   1,400     24,000
9   1,700     27,000
10   900     16,000

Suppose that Tracy has gathered two more months of data:

Month   Receiving Orders Receiving Cost
11   1,200     $28,000
12   950     17,500

Note:For the following requirements, round the intercept terms to the nearest dollar, round the variable rates to the nearest cent, and R2 to two decimal places.

 

Hi there,

 

I am just missing question#3

3.  Conceptual Connection: Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) What is the variable rate (to the nearest cent) and the fixed cost that would be used in a cost formula for receiving based on these results?

Variable Rate: _______________

Fixed Cost:_________________

Calculate the predicted receiving cost for a month with 1,450 receiving orders. In your calculations, round variable cost per unit to two decimal places. Round your final answer to the nearest dollar.

______________

 

 

1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of
data. Select the results for the intercept, slope, and R2 for each regression. Enter the R2 values as decimals to two decimal places rather than as percentages.
10 Months' Data
12 Months' Data
Intercept
3,212 V
3,820 V
Slope
15.15 V
15.10 V
R2
0.85 V
0.75 V
2. Conceptual Connection: On your own paper, prepare a scattergraph using all 12 months of data. Which month appears to be an outlier?
11 V
3. Conceptual Connection: Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) What is the variable rate (to the nearest cent) and the fixed cost
that would be used in a cost formula for receiving based on these results?
Variable rate
3,168.56 X per receiving order
Fixed cost
15.18 X
Calculate the predicted receiving cost for a month with 1,450 receiving orders. In your calculations, round variable cost per unit to two decimal places. Round your final answer to the nearest dollar.
Transcribed Image Text:1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Select the results for the intercept, slope, and R2 for each regression. Enter the R2 values as decimals to two decimal places rather than as percentages. 10 Months' Data 12 Months' Data Intercept 3,212 V 3,820 V Slope 15.15 V 15.10 V R2 0.85 V 0.75 V 2. Conceptual Connection: On your own paper, prepare a scattergraph using all 12 months of data. Which month appears to be an outlier? 11 V 3. Conceptual Connection: Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) What is the variable rate (to the nearest cent) and the fixed cost that would be used in a cost formula for receiving based on these results? Variable rate 3,168.56 X per receiving order Fixed cost 15.18 X Calculate the predicted receiving cost for a month with 1,450 receiving orders. In your calculations, round variable cost per unit to two decimal places. Round your final answer to the nearest dollar.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education