Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three

Question

Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three variablesunits shipped, weight shipped, or sales value of units shippedhas the closest relationship with shipping expenses.

Run 3 separate regressions. In each regression use the Shipping Expenses as the dependent variable (Y).

In regression 1, use the Units Shipped as the independent variable (X).

In regression 2, use the Weight Shipped as the independent variable (X).

In regression 3, use the Sales Value of Units Shipped as the independent variable (X).

Emeril Company Data

Month

Units Shipped

Weight Shipped (lbs.)

Sales Value of Units Shipped

Shipping Expenses (Y)

May

6,000

$6,200

$100,000

$5,600

June

10,000

8,000

110,000

7,700

July

8,000

8,100

80,000

6,500

August

14,000

10,000

114,000

10,400

September

12,000

7,000

140,000

8,600

October

9,000

8,000

160,000

8,200

Access the Spreadsheet for Quiz 7 (Excel) to manipulate the data.

Based on the data provided, the R-squared ofunits shippedwould be___________. Round your answers to 2 decimal places. (Example: 0.885 enter as 0.89)

2--

Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three variablesunits shipped, weight shipped, or sales value of units shippedhas the closest relationship with shipping expenses.

Run 3 separate regressions. In each regression use the Shipping Expenses as the dependent variable (Y).

In regression 1, use the Units Shipped as the independent variable (X).

In regression 2, use the Weight Shipped as the independent variable (X).

In regression 3, use the Sales Value of Units Shipped as the independent variable (X).

Emeril Company Data

Month

Units Shipped

Weight Shipped (lbs.)

Sales Value of Units Shipped

Shipping Expenses (Y)

May

6,000

$6,200

$100,000

$5,600

June

10,000

8,000

110,000

7,700

July

8,000

8,100

80,000

6,500

August

14,000

10,000

114,000

10,400

September

12,000

7,000

140,000

8,600

October

9,000

8,000

160,000

8,200

Access the Spreadsheet for Quiz 7 (Excel) to manipulate the data.

Based on the data provided, the R-squared ofweight shippedwould be___________pounds. Round your answers to 2 decimal places. (Example: 0.885 enter as 0.89)

3--

Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three variablesunits shipped, weight shipped, or sales value of units shippedhas the closest relationship with shipping expenses.

Run 3 separate regressions. In each regression use the Shipping Expenses as the dependent variable (Y).

In regression 1, use the Units Shipped as the independent variable (X).

In regression 2, use the Weight Shipped as the independent variable (X).

In regression 3, use the Sales Value of Units Shipped as the independent variable (X).

Emeril Company Data

Month

Units Shipped

Weight Shipped (lbs.)

Sales Value of Units Shipped

Shipping Expenses (Y)

May

6,000

$6,200

$100,000

$5,600

June

10,000

8,000

110,000

7,700

July

8,000

8,100

80,000

6,500

August

14,000

10,000

114,000

10,400

September

12,000

7,000

140,000

8,600

October

9,000

8,000

160,000

8,200

Access the Spreadsheet for Quiz 7 (Excel) to manipulate the data.

Based on the data provided, the R-squared ofsales value of units shippedwould be $___________. Round your answers to 2 decimal places. (Example: 0.885 enter as 0.89)

4--

Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three variablesunits shipped, weight shipped, or sales value of units shippedhas the closest relationship with shipping expenses.

Run 3 separate regressions. In each regression use the Shipping Expenses as the dependent variable (Y).

In regression 1, use the Units Shipped as the independent variable (X).

In regression 2, use the Weight Shipped as the independent variable (X).

In regression 3, use the Sales Value of Units Shipped as the independent variable (X).

Emeril Company Data

Month

Units Shipped

Weight Shipped (lbs.)

Sales Value of Units Shipped

Shipping Expenses (Y)

May

6,000

$6,200

$100,000

$5,600

June

10,000

8,000

110,000

7,700

July

8,000

8,100

80,000

6,500

August

14,000

10,000

114,000

10,400

September

12,000

7,000

140,000

8,600

October

9,000

8,000

160,000

8,200

Access the Spreadsheet for Quiz 7 (Excel) to manipulate the data.

Using the regression output of the independent variable that appears to have the closest relationship to shipping expenses, the fixed cost per month would be $___________.Round your answers to 2 decimal places. (Example: $2,800.44)

5--

Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three variablesunits shipped, weight shipped, or sales value of units shippedhas the closest relationship with shipping expenses.

Run 3 separate regressions. In each regression use the Shipping Expenses as the dependent variable (Y).

In regression 1, use the Units Shipped as the independent variable (X).

In regression 2, use the Weight Shipped as the independent variable (X).

In regression 3, use the Sales Value of Units Shipped as the independent variable (X).

Emeril Company Data

Month

Units Shipped

Weight Shipped (lbs.)

Sales Value of Units Shipped

Shipping Expenses (Y)

May

6,000

$6,200

$100,000

$5,600

June

10,000

8,000

110,000

7,700

July

8,000

8,100

80,000

6,500

August

14,000

10,000

114,000

10,400

September

12,000

7,000

140,000

8,600

October

9,000

8,000

160,000

8,200

Access the Spreadsheet for Quiz 7 (Excel) to manipulate the data.

Using the independent variable that has the closest relationship to shipping expenses, the variable cost would be $___________. Round your answers to 2 decimal places. (Example: 0.48)

6--

Emeril Company manufactures and sells toaster ovens. To improve the planning and control of shipping expenses, management is trying to determine which of three variablesunits shipped, weight shipped, or sales value of units shippedhas the closest relationship with shipping expenses.

Run 3 separate regressions. In each regression use the Shipping Expenses as the dependent variable (Y).

In regression 1, use the Units Shipped as the independent variable (X).

In regression 2, use the Weight Shipped as the independent variable (X).

In regression 3, use the Sales Value of Units Shipped as the independent variable (X).

Emeril Company Data

Month

Units Shipped

Weight Shipped (lbs.)

Sales Value of Units Shipped

Shipping Expenses (Y)

May

6,000

$6,200

$100,000

$5,600

June

10,000

8,000

110,000

7,700

July

8,000

8,100

80,000

6,500

August

14,000

10,000

114,000

10,400

September

12,000

7,000

140,000

8,600

October

9,000

8,000

160,000

8,200

Access the Spreadsheet for Quiz 7 (Excel) to manipulate the data.

Using theroundeddata from the requirements determined in questions 4 and 5, the predicted total shipping expensesin a month when 10,000 units, weighing 14,000 lbs., with a total sales value of $228,000 are shippedwould be $___________. Round your answer to 2 decimal places. (Example: 9,400.04)

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

Advanced Accounting

Authors: Paul Marcus Fischer, Rita H Cheng, William James Taylor, Roger Taylor

10th Edition

0324379056, 9780324379051

More Books

Students also viewed these Accounting questions

Question

Discuss three trends in communications and networking.

Answered: 1 week ago

Question

Annoyance about a statement that has been made by somebody

Answered: 1 week ago