E1:
Intercept | 438.0 |
Revenue | -0.09 |
Employees | 100.3 |
E2: Revenue = $2.40 million or $2,400 thousand.
No. of employees = 55
Thus cost = 438 + (-0.09*2400) + (100.3*55)
= $5,738.5 thousand or $5.7385 million
It can be rounded off to $5.74 million (2 decimal place) or $5.7 million (1 decimal place)
If the excel output are not rounded off then the answer will be $5,740.3 thousand or $5.74 million (2 decimal place) or $5.7 million (1 decimal place)
Calculations and explanations:
In this case cost is the “y” variable, no. of employees is the “x1” variable, and revenue is the “x2” variable.
In excel go to ‘data’, then ‘data analysis’ and then select ‘regression’. The output will be:
Coefficients | Standard Error | |
Intercept | 438.0 | 1232.393962 |
x1 (employees) | 100.3 | 22.08056382 |
x2 (revenues) | -0.09 | 0.183643513 |
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at...
Required information [The following information applies to the questions displayed below. Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected the following...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are .considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year's operations (revenues and costs in thousands of dollars). Store 101 102 103 104 105 106 107 188 Revenues $4,180 2,307 5,858 4,142 3,034...
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars).StoreRevenuesCosts101$4,180$4,3341022,3073,0541035,8585,3011044,1424,1981053,0343,9161064,1833,5991076,9745,1491081,8992,7741095,8165,0081103,4683,1991114,0464,3791124,8903,3601133,6322,7961145,1374,8151152,5243,106Requireda. Use the high-low method to estimate the fixed and variable portions of store costs based...
please help
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store revenues. As a result of that suggestion, managers collected...
Davis Stores sells clothing in 15 stores located around the
southwestern United States. The managers at Davis are considering
expanding by opening new stores and are interested in estimating
costs in potential new locations. They believe that costs are
driven in large part by store volume measured by revenue. The
following data were collected from last year’s operations (revenues
and costs in thousands of dollars).StoreRevenuesCosts101$4,200$4,3641022,3273,0941035,8885,3311044,1824,2481053,0643,9761064,2233,6691076,9945,1791081,9292,8741095,9165,0881103,5283,2591114,0864,4291124,9403,4001133,6522,8561145,2174,8551152,6243,136Required AUse the high-low method to estimate the fixed and variable
portions of store costs based...
Required information [The following information applies to the questions displayed below.] Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. During a discussion, one of the managers suggests that number of employees might be better at explaining cost than store...