Day 3 Hoop Hayden Case Roles
Essay Preview: Day 3 Hoop Hayden Case Roles
Report this essay
Kristen Jin Seog (2015-27121)Jose Luis Tobias (2015-27147)Aljoscha David Ziller (2015-27150)Zhang Yong (2015-27152)Dell vs. HPCompare 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 StatisticsMultiple R0.998184496R Square0.996372289Adjusted R Square0.996042497Standard Error709.3679481Observations13The 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.  CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept-1420.807284909.3096169-1.5625121050.146460021-3422.184257580.5696887X Variable 10.9639578570.01753748254.965578988.91322E-150.9253581191.002557595We 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 StatisticsMultiple R0.979400203R Square0.959224758Adjusted R Square0.956312241Standard Error5373.352105Observations16The 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.  CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept2307.4472045013.0909080.4602843330.6523799-8444.56343913059.45785X Variable 10.9226610680.05084125518.147881523.99757E-110.8136174211.031704714We 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.