Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number Total of Units Shipping
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number Total of Units Shipping Cost Month Shipped 3500 2.500 February 75 March 45 June July 80 4.000 50 3,450 Required: 1. Prepare a scattergraph of Odessa's shipping cost and draw the line you believe best fits the data. Instructions: 1. Use the point tool (7 points) to plot each Units Shipped / Total cost combination. 2. To enter exact coordinates, double click on the point and enter the values for each Units Shipped and Total Cost Scattergraph-Cost of Shipping Jan Feb 456 Ma 35ce April May June 10 10e July Number fUnits Shipped reset 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. (Round your intermediate calculations 2 decimal places and final answers to the nearest dollar) Fixed Cost Cost ner Unit 4. Perform a least-squares regression analysis on Odessa's data. (Use Microsoft Excel ra statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places.) Coefficients Intercept Variable 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. (Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar) Fixed Cost Variable Cost per Unit 4. Perform a least-squares regression analysis on Odessa's data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places.) Coefficients Intercept Variable bx) for estimating Odessa's shipping costs. 5. Using the regression output, create a linear equation (y a Total Shipping Co Number Shipped Units +
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