2. A least square regression analysis is required. Determine the: a. Manufacturing assembly variable cost per unit. 1. Use the Variable Cost Formula shown in classroom HEX?) (EXXEY) HGXZ} (BBQ?) 2. Confirm with ljnest {EXCEL} b. Manufacturing assembly fixed cost 3. Use the Fixed Cost Total shown in the classroom. (21") (EX 2} (EXMZXY) HEW} - (ZXJ'CEX) 4. Confirm with Intercept c. The resulting cost function :1. |f195 machine hours are expected forlanuarv, which is the total cost using the cost function of requirement c. 3. Determine the goodness of t a. Square R using the formula shown in classroom (Yyiz 2 _ R _ 1 (YW b. Interpret the least square result, indicating its limitations 4. Present the corresponding table with the required columns and the Excel Summary Output of the Regression. 5. Shows the formulas uses in Excel