MBA620Module620HW.xlsx draw Home Layout Tables Charts | SmartArt Formulas Data Review Sort & Filter External Data Sources Group & Cutine .. . :Ti Taxt to Columns Show Detail Sort Filter PivotTable what-If Refresh Text Database TML FieMacer Duplicates GroupUngroupHide Detail A10 Show your work and write your answers below the questions in this spread sheet Incude Excel regression output of this problem in this worksheet using cell"12" as the anchor 5 Boom Company assembles and sells portable speaker systems throughout the midwest. In an effort to 6 improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipped, weight shipped, or sales value of units shipped-has the loslation- 8-1 ship with shipping expenses. The following information is available: Units Shipped Sales Value of Shippinngg 10 Month Shipped(Pounds) Units ShippedEpenses May 5,000 0,000 8,000 9,300 200,0008,960 12,000 $ 220,000 $ 12,320 12,150 $ 160,000$10,400 15,000 $ 2$16,640 12 13 14 15 16 17 18 Required 19 20 a. With the aid of a spreadsheet program, determine whether units shipped, weight shipped, or sales 21 value of units shipped has the closest relationship with shipping expenses. une 228,000 10,500 280,00013,760 12,000 320,000$13,120 August 12,000 9,000 October 23 b. Using the independent variable that appears to have the closest relationship to shipping expenses, 24 develop a cost-estimating equation for total monthly shipping expenses. 25 26 c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 27 5,000 units, weighing 7,000 lbs, with a total sales value of $114,000 are shipped 28 29 44FProblem 1 Nonal View Ready Sum- 1613150