Aspen, Inc., manufactures one model of computer desk. The following data are available - 9963

Solution Posted by
yousafbhutta

yousafbhutta

Rating : (28)C
Solution Detail
Price: $3.00
  • From: Business,
  • Posted on: Sat 19 May, 2012
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

 

Aspen, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs.

 

 

 

  Month

Number of Units Shipped

Total
Shipping Cost

  January

30       

 $

3,600    

  February

60       

 

2,300    

  March

40       

 

1,700    

  April

20       

 

1,200    

  May

70       

 

2,300    

  June

80       

 

2,700    

  July

50       

 

2,000    


 

 

 

Requirement 3:

Using the high-low method, calculate Aspen’s total fixed shipping costs and variable shipping cost per unit. (Omit the "$" sign in your response.)

 

 

 

  Fixed cost

$

  Variable cost per unit

$

 

 

 

Requirement 4:

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

 

 

 

 

Coefficients

  Intercept

 

  Units Shipped

 

 

 

 

Requirement 5:

Using the regression output, create a linear equation (Y = A + BX) for estimating Aspen’s shipping costs. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places. Omit the "$" sign in your response.)

 

 

 

  Total Shipping Cost = +  (Number of Units Shipped)

 

 

 

Solution Description

 

Please give me your A+++

Attachments
Question2 solution tutoring.docx
Question2 solut...