Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Shipped 65 Total Shipping Cost $4,050 3,600 3,800 Month January February March April May June July 1,600 3,900 2,600 1,950 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 5500 5000 4500 4000 3500 Total Cost 3000 2500 2000 1500 1000 500 - 0 10 20 30 40 50 60 70 80 90 100 Number of Units 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 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 X Variable 5. Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's shipping costs. Total Shipping Cost = Number of Units Shipped Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Shipped 65 Total Shipping Cost $4,050 3,600 3,800 Month January February March April May June July 1,600 3,900 2,600 1,950 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 5500 5000 4500 4000 3500 Total Cost 3000 2500 2000 1500 1000 500 - 0 10 20 30 40 50 60 70 80 90 100 Number of Units 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 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 X Variable 5. Using the regression output, create a linear equation (y = a + bx) for estimating Odessa's shipping costs. Total Shipping Cost = Number of Units Shipped
