11. Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslies prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the companys biggest source of revenue. A portion of Leslies operating information for the companys last year follows:

Month	Number of Jerseys Printed	Operating Cost
January	210	$5,745
February	220	5,850
March	540	8,645
April	690	9,750
May	625	9,250
June	460	6,210
July	385	6,125
August	245	5,930
September	195	4,800
October	290	6,015
November	255	5,960
December	200	4,955

Required

a. Perform a least-squares regression analysis on Leslies data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places.)

Intercept

X Variable 1 b. Using the regression output, create a linear equation (y = a + bx) for estimating Leslies operating costs. (Round your answers to 2 decimal places.)

Total cost=_______+_______(number of jerseys)

c.Using the least-squares regression results, calculate the stores expected operating cost if it prints 605 jerseys. (Round your intermediate calculations to 2 decimal places. Round your final answer to 2 decimal places.)

Total cost

4.

Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells in gallon-size bottles with a spray attachment. The majority of Garfields business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards. Garfields operating information for the first six months of the year follows:

Month	Number of Bottles Sold	Operating Cost
January	1,000	$	10,420
February	1,300		15,600
March	1,810		16,050
April	2,490		19,380
May	3,550		27,440
June	3,630		34,870

3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. (Do not round your intermediate calculations. Round your variable cost per unit answer to 2 decimal places and fixed cost answer to the nearest whole number.) X Answer is complete but not entirely correct. $ 9.30 Variable Cost per Unit Fixed Cost $ 1,111 5. Determine how well this regression analysis explains the data. (Round you regression statistics to three decimal places and your percentage answer to the nearest whole number.) X Answer is complete but not entirely correct. Regression Statistics Multiple R 0.950 0.902 0.878 3,122.867 R Square Adjusted R Square Standard Error Observations From the regression output, number of bottles explains about 6.000 95 X % of the variability in Garfield's total cost