Day 3 Hoop Hayden Case Roles
Essay by Kristen Seog • April 21, 2016 • Research Paper • 851 Words (4 Pages) • 1,711 Views
Kristen Jin Seog (2015-27121)
Jose Luis Tobias (2015-27147)
Aljoscha David Ziller (2015-27150)
Zhang Yong (2015-27152)
Dell vs. HP
- Compare the cost estimation results.
We performed a regression analysis. As the variables we used Net Sales (independent variable) and COGS + Operating Expenses (dependent variable). We want to investigate how the latter depend on the former. COGS + Operating Expenses represent the output or outcome whose variation we want to study. Net Sales work as the inputs and represent causes. We then try to explain the effects that the independent variable has on the dependent variable.
Let’s start with the case of Dell.
Regression Statistics | |
Multiple R | 0.998184496 |
R Square | 0.996372289 |
Adjusted R Square | 0.996042497 |
Standard Error | 709.3679481 |
Observations | 13 |
The observations lead to an R² of 99.6%. This means that 99.6% of the COGS + Operating Expenses can be explained by the Net Sales. This is a very high number and indicates that Net Sales are very significant when determining COGS + Operating Expenses. The causality can be questioned however as we only have a very limited number of observations.
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% |
Intercept | -1420.807284 | 909.3096169 | -1.562512105 | 0.146460021 | -3422.184257 | 580.5696887 |
X Variable 1 | 0.963957857 | 0.017537482 | 54.96557898 | 8.91322E-15 | 0.925358119 | 1.002557595 |
We can determine the regression equation. In theory, the intercept can serve as the fixed cost and the slope can serve as the variable cost. However, the negative coefficient may seem striking as a negative fixed cost basis does not make sense. It has to be noted here that the intercept is not statistically relevant. Our sample observations range in the high ten-thousands. We cannot draw conclusions for out of the sample observations. It could be the case that out of the sample events do not follow a linear trend. The slope however, is statistically significant and we will compare it with HP.[pic 1]
Therefore, let’s move on to the case of HP.
Regression Statistics | |
Multiple R | 0.979400203 |
R Square | 0.959224758 |
Adjusted R Square | 0.956312241 |
Standard Error | 5373.352105 |
Observations | 16 |
The observations lead to an R² of 95.9%. This means that 95.9% of the COGS + Operating Expenses can be explained by the Net Sales. This is still a very high number and indicates that Net Sales are very significant when determining COGS + Operating Expenses. However, they seem to be less significant for HP than in the case of Dell. This means that there must be another factor that explains the COGS + Operating Expenses apart from the Sales. Again, the causality can be questioned here, as we only have 16 observations.
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% |
Intercept | 2307.447204 | 5013.090908 | 0.460284333 | 0.6523799 | -8444.563439 | 13059.45785 |
X Variable 1 | 0.922661068 | 0.050841255 | 18.14788152 | 3.99757E-11 | 0.813617421 | 1.031704714 |
We can determine the regression equation. In theory, the intercept can serve as the fixed cost and the slope can serve as the variable cost. Here, HP would have fixed costs of 2307. However, we can see from the t test that this figure is statistically not significant. The slope, in our case the variable costs, is significant however. Here, HP has variable costs of 0.9227 (variable cost in terms of sales). This is lower than the 0.964 variable costs (variable costs in terms of sales) of Dell.
...
...