Quantitative analysis:Linear regression.
Not what you're looking for?
5-26: Method of estimating costs: high-low
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last yearâ??s operations:
Month labor-hours Machine-hours Overhead costs
1 3,625.00 3,775.00 513,435.00
2 3,575.00 7,035.00 518,960.00
3 3,400.00 7,600.00 549,575.00
4 3,700.00 7,265.00 541,400.00
5 3,900.00 7,955.00 581,145.00
6 3,775.00 7,895.00 572,320.00
7 3,700.00 6,950.00 535,110.00
8 3,625.00 6,530.00 510,470.00
9 3,550.00 7,270.00 532,195.00
10 3,975.00 7,725.00 565,335.00
11 3,375.00 6,490.00 503,775.00
12 3,550.00 8,020.00 564,210.00
5-30:
Methods of estimating costs: Simple Regression
Simple regression results from the data of Adriana Corporation (exercise 26) are as follow:
Equation:
Overhead = $217,610 + (88.61 * labor-hours)
Statistical Data
Correlation Coefficient .610
R^2 .925
Required:
Estimate overhead if the company expects the plant to operate at a monthly average of 3,000 labor-hours next year.
Only need help with question 5-30 but I've provided 5-26 because its need to answer any questions.
Purchase this Solution
Solution Summary
The problem deals with estimating overhead costs with a linear equation.
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.