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

Solution Posted by

## yousafbhutta

Rating : (28)C
Solution Detail
Price: \$3.00
• 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

Attachments