Question
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Month Number of Units Shipped
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Month Number of Units Shipped Total Shipping Cost January 25 $1,450 February 80 3,650 March 30 1,500 April 65 3,700 May 40 2,750 June 55 3,150 July 70 4,150 Required: 3. Using the high-low method, calculate Odessas total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessas data. 5. Using the regression output, create a linear equation (y = a + bx ) for estimating Odessas shipping costs
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Shipped 25 80 Month January February March April May June July Shipping Cost $1,450 3,650 1,500 3,700 2,750 3,150 4,150 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. Using 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 Required 5 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 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. Using 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 Required 5 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 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. Using 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 Required 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 Required 4 Required 5 >
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