Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[The following information applies to the questions displayed below.] Odessa, Incorporated, manufactures one model of computer desk. The following data are available regarding units shipped

[The following information applies to the questions displayed below.] Odessa, Incorporated, manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Month January February March April May June July Number of Units Shipped 30 80 55 40 45 25 70 Total Shipping Cost $1,550 4,150 3,450 2,650 2,800 1,950 4,250 Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. 4. Perform a least-squares regression analysis on Odessa's data. 5. Using the regression output; create a linear equation (y= a + bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Fixed Cost Variable Cost per Unit Required 3 Required 4 Required 5 Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. Note: Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar.
image text in transcribed
image text in transcribed
image text in transcribed
[The following information applies to the questions displayed below] Odessa, Incorporated, manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Required: 3. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit 4. Perform a least-squares regression analysis on Odessa's data. 5. Using the regression output; create a linear equation (y=a+bx) for estimating Odessa's shipping costs. Complete this question by entering your answers in the tabs below. Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. Note: Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar. Perform a least-squares regression analysis on Odessa's data. Note: Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places. Using the regression output, create a linear equation (y=a+bx) for estimating Odessa's shipping costs. Note: Round your answers to 2 decimal places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions