Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started