Required Information {The following information applies to the questions displayed below.) Odessa, Inc., manufactures one model of computer desk. The following data are avallable regarding units shipped and total shipping costs: Number of Units Month January February March April May June July Shipped 30 80 55 40 45 25 70 Total Shipping cout $1,550 4.150 3,450 2,650 2,800 1,950 4,250 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 dota 5. Using the regression output, create a linear equation (Ya+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required 3 Required Required 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) Foxed Cost Variable Cost per Unit Required information (The following information applies to the questions displayed below.) Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Month Shipped Shipping Cont January $1,550 February 80 4,150 March 3,450 April 40 45 2,800 June July Total 30 55 2.650 MAY 25 70 1,950 4,250 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 Odesso's doto. 5. Using the regression output, create a linear equation (a+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Required Required Required 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 information [The following information applies to the questions displayed below.) Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Unito Total Month Shipped Shipping cost January 30 $1,550 February 4,150 March SS 3.450 April 2,650 2,800 25 1.950 July 4,250 BO May 40 45 June 70 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 + bx) for estimating Odessa's shipping costs. G Complete this question by entering your answers in the tabs below. Required 3 Required 4 Requlleds Using the regression output, create a linear equation (-abx) for estimating Odessa's shipping costs Total Shipping Cost Number of Units Shoped
