please make sure the answer fits the page.
PA5-2 (Algo) Estimating Cost Behavior Using Scatterg Methods [LO 5-2,5-3,5-4] Leslie Sporting Goods is a locally owned store that specializes in print for various local teams and organizations. While Leslie's prints everyth special event shirts, summer league baseball and softball team jerseys A portion of Leslie's operating information for the company's last year 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 Required: 3. Using the high-low method, calculate the store's total fixed operating 4. Using the high-low method results, calculate the store's expected ope 5. Perform a least-squares regression analysis on Leslie's data. A 11 specializes in printing team jerseys. The majority of its business comes from orders slie's prints everything from bowling team jerseys to fraternity/sorority apparel to oftball team jerseys are the company's biggest source of revenue. mpany's last year follows: s total fixed operating costs and variable operating cost per jersey. e store's expected operating cost if it printed 420 jerseys. Leslie's data. uation (y= a + bx) for estimating Leslie's operating costs. culate the store's expected operating cost if it prints 610 jerseys. Hequired 1 Required 2 Complete the contribution margin income statement for the business last month, this falls within the relevant range of operations). (Round your intermediate calcul to the nearest whole number.) BETHANY LINK Contribution Margin Income Statement For the Last Month Contribution Margin + Net Operating Income 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 results, calculate the store's expected operating cost if it printed 420 jerseys intermediate calculations. Round your answer to the nearest whole number.) Total Cost Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Required 7 Perform a least-squares regression aralysis on Leslie's data. (Use Microsoft Excel or a sta coefficients using least-squares regression. Round your answers to 2 decimal places.) Coefficients Intercept X Variable 1 Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Required 7 Using the regression output, create a linear equation (y = a + bx) for estimating Leslie's operating cos answers to 2 decimal places.) Total Cost = (Number of Jerseys) Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Required 7 Using the least-squares regression results, calculate the store's expected operating cost if it prints 610 intermediate calculations and final answer to 2 decimal places.) Total Cost
