Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
[The following information applies to the questions displayed below.] Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number of Units Month Shipped January 25 February 80 March 30 April 65 May 40 June 55 July 70 Total Shipping Cost $1,450 3,650 1,500 3,700 2,750 3,150 4,150 Part 2 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 (ya+bx) for estimating Odessa's shipping costs. Part 2 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. Required 3 Required 4 Required 5 cos Using the high-low method, calculate Odessa's total fixed shipping costs and variable shipping cost per unit. (Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar) Fixed Cost Variable Cost per Unit Required Required 4 > Part 2 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. Required 3 Required 4 Required 5 Perform a least squares regression analysis on Odessa'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 X Variable 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. Required 3 Required 4 Rekuired 5 Using the regression output, create a linear equation (y = a + bx ) for estimating Odessa's shipping costs. Total Shipping Cost Number of Units Shipped

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

Recommended Textbook for

College Accounting A Practical Approach Chapters 1-15

Authors: Jeffrey Slater

7th Edition

0130954888, 978-0130954886

More Books

Students also viewed these Accounting questions