Question
Data for Sunland Corporations maintenance costs is shown below. Units Produced Total Cost July 20,880 $37,120 August 37,120 55,680 September 41,760 63,800 October 25,520 44,080
Data for Sunland Corporations maintenance costs is shown below.
Units Produced | Total Cost | |||||||
---|---|---|---|---|---|---|---|---|
July | 20,880 | $37,120 | ||||||
August | 37,120 | 55,680 | ||||||
September | 41,760 | 63,800 | ||||||
October | 25,520 | 44,080 | ||||||
November | 46,400 | 76,676 | ||||||
December | 44,080 | 71,920 |
Compute the variable- and fixed-cost elements using the regression analysis. Present your solution in the form of a cost equation. (We recommend that you use the Intercept and Slope functions in Excel.) (Round intercept to 2 decimal places e.g. 1.25 and slope to 5 decimal places e.g. 1.25125.)
Intercept | $enter a dollar amount rounded to 2 decimal places | |
---|---|---|
Slope | $enter a dollar amount rounded to 5 decimal places |
The cost equation is: $enter a dollar amount rounded to 2 decimal places + $enter a dollar amount rounded to 5 decimal places per unit produced = Total cost |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started