Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. general management
  3. month machine hours (hrs.) maintenance costs (

Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine...

50.1K

Verified Solution

Question

General Management

Month

Machine Hours (hrs.)

Maintenance Costs ($)

1

1,330

102,694

2

1,400

103,694

3

1,500

108,694

4

1,470

108,694

5

1,620

116,694

6

1,690

115,694

7

1,490

107,694

8

1,310

102,694

9

1,450

106,694

10

1,580

113,694

11

1,300

100,694

12

1,600

113,694

13

1,650

114,694

14

1,440

109,694

15

1,340

102,694

16

1,670

114,694

17

1,480

106,694

18

1,360

103,694

19

1,340

103,694

20

1,540

112,694



Assume that the following relationship holds:

Maintenance Costs = (v * Machine Hours) + f

REQUIRED

Estimate the values of v and f and the cost equation, using,

1. The Linear Regression method.

Note, to use the linear regression method, you MUST use theMicrosoft Excel program.

Make sure to report

1. The values of v and f;

2. A scatter plot of the data points, and

3. The adjusted R-square; explain what the adjustedR-square means.

4. The cost equation in the form of Y = vx + f,substituting the values for v and f from the regressionoutput.

YOUR SUBMISSION MUST BE IN EXCEL.

Answer & Explanation Solved by verified expert
3.8 Ratings (405 Votes)
Adjusted Rsquare is a modified version of r2adjusted for the number of predictors    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Describe the structure and roles of enzymes in metabolic pathways. Include in your answer: a. the...

Biology
Q

Why are low back problems common in the manufacturing industry?

Psychology
Q

A dividend reinvestment plan DRIP investment portfolio B C risk tolerance D OTC market E...

Basic Math
Q

Multiply and simplify 2 2 7 7 2 5 7 2 2 7 7 2...

Algebra
Q

7 X 0 3 X y V 123 f E ABC a y 22 2...

Algebra
Q

Personalty Depreciation Exercises I - Company ABC purchased the following assets on October 21, 2022,...

Accounting
Q

One section of the production cost report describes the equivalent units of production for the...

Accounting
Q

Which of the following is the cost of quality classification for costs such as defects...

Accounting
Q

What is job order costing? Give a specific example of how you would use...

Accounting
Q

The standard variable overhead cost rate for the Gordon Company is $ 12.25 per unit....

Accounting
Q

Direct Materials and Direct Labor Variance Analysis Information about a production week is as follows:...

Accounting
Q

During the year, Park Corporation had 50,000 shares of $10 par value common stock and...

Accounting