School Spirit Company manufactures insignia items (sweatshirts, key chains, coffee mugs) for university bookstores. The table provides sales volume and total costs for each month of the past fiscal year. Month Total Costs Units Sold
School Spirit Company manufactures insignia items (sweatshirts, key chains, coffee mugs) for university bookstores.
The table provides sales volume and total costs for each month of the past fiscal year.
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Use above data to manipulate answer.
Using regression analysis, the R-squared (rounded to 3 decimal places) would be
question# 2
School Spirit Company manufactures insignia items (sweatshirts, key chains, coffee mugs) for university bookstores.
The table provides sales volume and total costs for each month of the past fiscal year.
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Using regression analysis, the estimated monthly fixed cost (rounded to 2 decimal places) would be $_
Question #3
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Using regression analysis, the estimated variable cost per unit (rounded to 2 decimal places) would be $
#4
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Using the rounded data from the requirements determined in questions 2 and 3, the total cost for the sales level of 8,000 units would be $________. (Round to 2 decimal places.)
#5
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Using the rounded data from the requirements determined in questions 2 and 3, the total cost for the sales level of 12,500 units would be $________. (Round to 2 decimal places.)
#6
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Using the rounded data from the requirements determined in questions 2 and 3, the total cost for the sales level of 20,000 units would be $________. (Round to 2 decimal places.)
#7
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
Using the rounded data from the requirements determined in questions 2 and 3, if the selling price of the firm’s products is $15.00, they need to sell _______ units to break even. (Round to nearest whole unit.)
#8
Month Total Costs Units Sold
January 98,000 11,200
February 121,000 12,000
March 151,000 17,500
April 131,000 17,000
May 125,000 16,000
June 100,000 12,000
July 154,000 17,000
August 175,000 18,000
September 82,000 9,000
October 108,000 13,000
November 114,000 13,500
December 119,000 15,000
If the selling price of the firm’s products is $15.00, they need to sell ______ units to generate a profit of $10,000. (Round to the nearest whole unit.
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
