1) I need help calculating B and C below. Please include step by step so I can follow where you got your numbers from so I can follow the process.

2) Also, when manually solving for fixed costs using a Total Cost equation, when there is a chart of costs like the one below that has multiple values for each independent variable and the problem does not indicate which value to use (such as calculate for May), how do you know, for example, which shipping expense number to use for the "Y" variable (a=y-bx)

Selecting a Basis for Predicting Shipping Expenses (Requires Computer Spreadsheet*) Cambridge SoundWorks sell portable speakers systems and bluetooth headphones. In an effort 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. The following information is available:

Month	Units Shipped	Weight Shipped (lbs.)	Sales Value of Units Shipped	Shipping Expenses
May	10,000	7,500	$350,000	$38,000
June	12,000	8,760	432,000	42,000
July	15,000	9,200	420,000	50,100
August	20,000	10,500	400,000	72,500
September	12,000	7,600	300,000	41,000
October	8,000	6,000	320,000	35,600

Required a. With the aid of a spreadsheet program, determine whether units shipped, weight shipped, or sales value of units shipped has the closest relationship with shipping expenses.

Complete the r-squared values between each possible independent variable and shipping expenses:

Round answers to two decimal places.

Units shipped	Answer 0.94
Weight shipped	Answer 0.78
Sale value	Answer 0.23

Based on the coefficient of determination, UNITS SHIPPED has the closest relationship with shipping expenses.

b. Using the independent variable that appears to have the closest relationship to shipping expenses, develop a cost-estimating equation for total monthly shipping expenses.

Round answers to two decimal places.

Shipping expenses

=

Answer ????

+

Answer ????

X

c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 14,000 units, weighing 9,380 lbs., with a total sales value of $420,000 are shipped.

??????