PA5-2 (Algo) Estimating Cost Behavior Using Scatte Methods [LO 5-2,5-3,5-4] Lesile Sporting Goods is a locally owned store that specializes in pr for various local teams and organizations. While Leslie's prints every special event shirts, summer league baseball and softball team jers A portion of Leslie's operating information for the company's last ye Number of Month Jerseys Printed January 215 February 210 March 230 April 515 May 680 June 650 July 455 August 370 September 290 October 235 November 205 December 180 Operating Cost $5,875 5,745 5,930 8,630 9,700 9, 255 6,225 6,165 6,035 5,980 4,975 4,845 Derived ng Scattergraph, High-Low, and Least-Squares Regression cializes in printing team jerseys. The majority of its business comes from orders s prints everything from bowling team jerseys to fraternity/sorority apparel to wall team jerseys are the company's biggest source of revenue. pany's last year follows: Required: 3. Using the high-low method, calculate the store's total fixed operating costs ar 4. Using the high-low method results, calculate the store's expected operating 5. Perform a least-squares regression analysis on Leslie's data. 6. Using the regression output, create a linear equation (y = a + bx) for estimating 7. Using the least-squares regression results, calculate the store's expected ope 1. Using least squares regression results, Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Required 7 Using the high-low method, calculate the store's total fixed operating costs and variable operatin round your intermediate calculations. Round your "Variable Cost" answer to 2 decimal places and nearest whole number.) Variable Cost per Jersey Fixed Cost Required 3 Required 4 > 7. Using the least-squares regression results, calculate the store's expe Complete this question by entering your answers in the tabs below. Required 3 Required 7 Required 4 Required 5 Required 6 Using the high-low method results, calculate the store's expected operating cost if itp intermediate calculations. Round your answer to the nearest whole number.) Total Cost Completes question by entering your ans Required 3 Required 4 Required 5 Required 7 Required 6 Perform a least-squares regression analysis on Leslie's data. (Use Microsoft Exc coefficients using least-squares rgression. Round your answers to 2 decimal p Coefficients Intercept X Variable 1 Complete this question by entering your answers in the tabs below Required 3 Required 4 Required 5 Required 6 Rfiquired 7 Using the least-squares regression results, calculate the store's expected op intermediate calculations and final answer to 2 decimal places.) Total Cost 7. Using the least-squares regression results, calculate the store's expe Complete this question by entering your answers in the tabs below. Required 3 Required 7 Required 4 Required 5 Required 6 Using the high-low method results, calculate the store's expected operating cost if itp intermediate calculations. Round your answer to the nearest whole number.) Total Cost Completes question by entering your ans Required 3 Required 4 Required 5 Required 7 Required 6 Perform a least-squares regression analysis on Leslie's data. (Use Microsoft Exc coefficients using least-squares rgression. Round your answers to 2 decimal p Coefficients Intercept X Variable 1 Complete this question by entering your answers in the tabs below Required 3 Required 4 Required 5 Required 6 Rfiquired 7 Using the least-squares regression results, calculate the store's expected op intermediate calculations and final answer to 2 decimal places.) Total Cost
