Stella Watson, financial controller for Woodland Company, has decided to estimate the fixed and variable components associated with the company's logistics activity. She has
Stella Watson, financial controller for Woodland Company, has decided to estimate the fixed and variable components associated with the company's logistics activity. She has collected the following data for the past 6 months: Packages delivered Total logistics costs 20 $2,400 40 3,300 30 2,700 24 2,700 36 3,150 50 3,750 Furthermore, she has estimated the fixed and variable components using the method of least squares. The output of a spreadsheet regression routine is as follows: Constant (intercept) R Squared 1,202.6376 0.6372 Number of observations 6. X Coefficient (s) 125.4783 Required: a. Estimate the fixed and variable components for the logistics costs using the high-low method. Using the cost formula, predict the total cost of delivery if 30 packages are delivered. b. Using the cost formula, predict the total cost of delivery if 30 packages are delivered. For the method of least squares, explain what the coefficient of determination tells us.
Step by Step Solution
3.49 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
a Packages delivered Total logistics costs High 50 3750 Low 20 2400 Differ...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