shipped and total shipping costs: Number of Units Shipped 75 Month January February March April May June July 60 40 20 70 80 50 Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. sing the regression output, create a linear equation (y=a+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. Fixed cost Variable cost per unit Total Shipping Cost $3,250 2,300 1,700 1,200 2,300 2,700 2,000 Required 5 Complete this question by entering your answers in the tabs below. Required 3 Required 4 Intercept X Variable Perform a least-squares regression analysis on Odessa's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using to 2 decimal places. Required 5 Required 3 Required 4 Coefficients Complete this question by entering your answers in the tabs below. < Required 3 Required 5 Required 5 Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's ship Note: Round your answers to 2 decimal places. Total shipping cost= Number of units shipped
shipped and total shipping costs: Number of Units Shipped 75 Month January February March April May June July 60 40 20 70 80 50 Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. sing the regression output, create a linear equation (y=a+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. Fixed cost Variable cost per unit Total Shipping Cost $3,250 2,300 1,700 1,200 2,300 2,700 2,000 Required 5 Complete this question by entering your answers in the tabs below. Required 3 Required 4 Intercept X Variable Perform a least-squares regression analysis on Odessa's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using to 2 decimal places. Required 5 Required 3 Required 4 Coefficients Complete this question by entering your answers in the tabs below. < Required 3 Required 5 Required 5 Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's ship Note: Round your answers to 2 decimal places. Total shipping cost= Number of units shipped
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
Related questions
Question
![shipped and total shipping costs:
Number of
Units
Shipped
75
60
40
20
70
80
50
Month
January
February
March
April
May
June
July
Required:
3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit.
4. Perform a least-squares regression analysis on Odessa's data.
5. sing the regression output, create a linear equation (y= a + bx) for estimating Odessa's shipping costs.
Complete this question by entering your answers in the tabs below.
Required 3 Required 4
Total
Shipping
Cost
$3,250
2,300
1,700
1,200
2,300
2,700
2,000
Required 5
Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit.
Fixed cost
Variable cost per unit
Complete this question by entering your answers in the tabs below.
Required 3 Required 4 Required 5
Intercept
X Variable
Perform a least-squares regression analysis on Odessa's data.
Note: Use Microsoft Excel or a statistical package to find the coefficients using
to 2 decimal places.
Required 3 Required 4
Coefficients
Complete this question by entering your answers in the tabs below.
< Required 3
Required 5
Required 5
Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's ship
Note: Round your answers to 2 decimal places.
Total shipping cost =
Number of units shipped](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F86bb5a26-1c17-43b4-b357-4e877aaa3121%2F655f68a8-0b40-4612-bff0-2753ff9786ff%2F2gjf5d_processed.jpeg&w=3840&q=75)
Transcribed Image Text:shipped and total shipping costs:
Number of
Units
Shipped
75
60
40
20
70
80
50
Month
January
February
March
April
May
June
July
Required:
3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit.
4. Perform a least-squares regression analysis on Odessa's data.
5. sing the regression output, create a linear equation (y= a + bx) for estimating Odessa's shipping costs.
Complete this question by entering your answers in the tabs below.
Required 3 Required 4
Total
Shipping
Cost
$3,250
2,300
1,700
1,200
2,300
2,700
2,000
Required 5
Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit.
Fixed cost
Variable cost per unit
Complete this question by entering your answers in the tabs below.
Required 3 Required 4 Required 5
Intercept
X Variable
Perform a least-squares regression analysis on Odessa's data.
Note: Use Microsoft Excel or a statistical package to find the coefficients using
to 2 decimal places.
Required 3 Required 4
Coefficients
Complete this question by entering your answers in the tabs below.
< Required 3
Required 5
Required 5
Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's ship
Note: Round your answers to 2 decimal places.
Total shipping cost =
Number of units shipped
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing