Question

B ANTH-2351-91L-Sp... Saved ng Goods is a locally owned store that specializes in printing team jerseys. The majority of its

Saved Help SE 5. Perform a least-squares regression analysis on Leslies data. (Use Microsoft Excel or a statistical package

g the regression output, create a linear equation (y = a + bx) for estimating Leslies operating costs. (Round al places.) st

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Month Jerseys Printed(X) Total Cost(Y)(in $) Square of X X*Y(in $)
Jan                                       215                        5,835                      46,225                  12,54,525
Feb                                       195                        5,685                      38,025                  11,08,575
Mar                                       230                        5,930                      52,900                  13,63,900
Apr                                       550                        8,575                   3,02,500                  47,16,250
May                                       675                        9,770                   4,55,625                  65,94,750
Jun                                       655                        9,260                   4,29,025                  60,65,300
Jul                                       455                        6,230                   2,07,025                  28,34,650
Aug                                       375                        6,175                   1,40,625                  23,15,625
Sep                                       310                        6,005                      96,100                  18,61,550
Oct                                       230                        5,960                      52,900                  13,70,800
Nov                                       185                        4,960                      34,225                    9,17,600
Dec                                       175                        4,800                      30,625                    8,40,000
Total                                    4,250                      79,185                 18,85,800               3,12,43,525
Unit Variable Cost (b) = nΣxy − (Σx)(Σy) /nΣx^2 − (Σx)^2
Total Fixed Cost (a) = Σy − bΣx / n
So here n =12 ,Σx =4,250, Σy =79,185, Σx^2=18,85,800 ,Σxy =33,12,43,525
Variable cost per unit(b) =12*3,12,43,525 - (4,250*79,185) / 12*18,85,800 - 4,250^2
Variable cost per unit(b) =37,49,22,300 - 33,65,36,250 / 2,26,29,600 - 1,80,62,500
Variable cost per unit(b) =3,83,86,050 / 45,67,100 =$8.40
Total Fixed cost =79,185 - ($8.40*4,250) / 12
Total Fixed cost =(79,185 - 35,700) / 12
Total Fixed cost =$43,485 / 12 =$3,623.75
Y =$3,263.75 + $8.40X
At 640 jerseys, Total Costs =$3,263.75+$8.40*640 =$8,639.75 or $8,640
Add a comment
Know the answer?
Add Answer to:
B ANTH-2351-91L-Sp... Saved ng Goods is a locally owned store that specializes in printing team jerseys....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...

    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 Leslie's prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest source of revenue. A portion of Leslie's operating information for the company's last year follows: Month January February March Number of Jerseys Printed 170 215 195...

  • Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...

    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 Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Month Number of Jerseys Printed Operating Cost January 200 $5,785 February...

  • Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...

    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 Leslie's prints everything from bowling team jerseys to fraternitylsorority apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest source of revenue A portion of Leslie's operating information for the company's last year follows: Number of Jerseys Printed 210 Month January February March April 22e...

  • Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...

    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 Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Number of Operating Month Jerseys Printed Cost January 215 $5,500 February...

  • Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority...

    Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its busine orders for various local teams and organizations. While Leslie's prints everything from bowling team jerseys to fra apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest sou A portion of Leslie's operating information for the company's last year follows: Number of Jerseys Printed 215 195 230 550 675 Month January February March April May...

  • ork 5 Help Save & Exit Sube Check my world Leslie Sporting Goods is a locally...

    ork 5 Help Save & Exit Sube Check my world 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 Leslie's prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest source of revenue. A portion of Leslie's operating information for the company's last year follows: Number...

  • Please show how you got the answer: 5) Leslie Sporting Goods is a locally owned store...

    Please show how you got the answer: 5) 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 Leslie’s prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company’s biggest source of revenue. A portion of Leslie’s operating information for the company’s last year follows: Number of Operating...

  • find the intercep Check my work Leslie Sporting Goods is a locally owned store that specializes...

    find the intercep Check my work 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 Leslie's prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest source of revenue. A portion of Leslie's operating information for the company's last year follows: Number of Jerseys Printed 215...

  • Return to questio Answer is complete but not entirely correct. Intercept X Variable 1 Coefficients 3,449.37...

    Return to questio Answer is complete but not entirely correct. Intercept X Variable 1 Coefficients 3,449.37 8.77 6. Using the regression output, create a linear equation (y = a + bx) for estimating Leslie's operating costs. (Round your answers to 2 decimal places.) Answer is complete but not entirely correct. (Number of $ 3,449.37 - 8.77 $ Jerseys) Total Cost 7. Using the least squares regression results, calculate the store's expected operating cost if it prints 605 jerseys, (Round your...

  • O il Required information Camp Rainbow offers overnight summer camp programs for children ages 10-14 every...

    O il Required information Camp Rainbow offers overnight summer camp programs for children ages 10-14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT