excel assignment

Step

Instructions

Points Possible

1

Start Excel. Download and open the workbook named: Chapter_14_Theft_Problem_Start.

0

2

In cells E15-E17, by using cell references, enter the hourly employee wages, average hourly sales, and theft proportion using staffed registers. Refer to appropriate cells among E5-E7.

1

3

In cell E18, by using cell references, calculate the hourly cost per register using staffed registers. Use cells E15, E16, and E17.

1

4

In cell J15, by using cell references, calculate the hourly employee wages using self-checkout registers. Use cells E5 and H11.

1

5

In cell J16, by using cell references, calculate the average hourly sales at a self-checkout register as a proportion of hourly sales at a staffed registers. Use cells E6 and H13.

1

6

In cell J17, by using a cell reference, enter the theft proportion using self-checkout registers assuming there are no additional self-checkout registers. Refer to an appropriate cell among E5-E7.

1

7

In cell J18, by using cell references, calculate the hourly cost per register using self-checkout registers. Use cells J15, J16, and J17.

1

8

In cells E22-E24, by using absolute cell references, enter the hourly employee wages, average hourly sales, and theft proportion assuming the increase of staffed registers to the value indicated in cell E21. Refer to appropriate cells among E5-E7. Copy the formulas from cells E22-E24 across columns F-J.

1

9

In cell E25, by using cell references, calculate the hourly cost per register assuming the increase of staffed registers to the value indicated in cell E21. Use cells E22, E23, and E24. Copy the formula from cell E25 across columns F-J.

1

10

In cell E26, by using cell references, calculate the hourly cost for multiple registers assuming the increase of staffed registers to the value indicated in cell E21. Use cells E21 and E25. Copy the formula from cell E26 across columns F-J.

1

11

In cell E29, by using relative and absolute cell references, calculate the number of additional self-checkout registers assuming the increase of self-checkout registers to the value indicated in cell E28. Use cells H11 and E28. Copy the formula from cell E29 across columns F-J.

1

12

In cell E30, by using relative and absolute cell references, calculate the hourly employee wages assuming the increase of self-checkout registers to the value indicated in cell E28. Use cells E5 and E28. Copy the formula from cell E30 across columns F-J.

1

13

In cell E31, by using absolute cell references, calculate the average hourly sales assuming the increase of self-checkout registers to the value indicated in cell E28. Use cells E6 and H13. Copy the formula from cell E31 across columns F-J.

1

14

In cell E32, by using relative and absolute cell references, calculate the theft proportion assuming the increase of self-checkout registers to the value indicated in cell E28. Use cells E7, H12, and E29. Copy the formula from cell E32 across columns F-J.

1

15

In cell E33, by using cell references, calculate the hourly cost per register assuming the increase of self-checkout registers to the value indicated in cell E28. Use cells E30, E31, and E32. Copy the formula from cell E33 across columns F-J.

1

16

In cell E34, by using cell references, calculate the hourly cost for multiple registers assuming the increase of self-checkout registers to the value indicated in cell E28. Use cells E28 and E33. Copy the formula from cell E34 across columns F-J.

1

17

In cells C36 and E38, do the following: In cell C36, determine whether the retailer should use self-checkout registers. In case the answer in cell C36 is Yes, in cell E38, by using a cell reference, enter the number of registers that should be in a group monitored by 1 employee. Refer to an appropriate cell among E28-J28. In case the answer in cell C36 is No, in cell E38, enter zero value. Note: Do not use the equal sign when entering a numeric value.

1

18

In cells E43-E45, by using absolute cell references, enter the new hourly employee wages, average hourly sales, and theft proportion. Refer to appropriate cells among E5-E7 and E40. Copy the formulas from cells E43-E45 across columns F-J.

1

19

In cell E46, by using cell references, calculate the hourly cost per register assuming the new minimum wage and the increase of staffed registers to the value indicated in cell E42. Use cells E43, E44, and E45. Copy the formula from cell E46 across columns F-J.

1

20

In cell E47, by using cell references, calculate the hourly cost for multiple registers assuming the new minimum wage and the increase of staffed registers to the value indicated in cell E42. Use cells E42 and E46. Copy the formula from cell E47 across columns F-J.

1

21

In cell E50, by using relative and absolute cell references, calculate the number of additional self-checkout registers assuming the increase of self-checkout registers to the value indicated in cell E49. Use cells H11 and E49. Copy the formula from cell E50 across columns F-J.

1

22

In cell E51, by using relative and absolute cell references, calculate the hourly employee wages assuming the new minimum wage and the increase of self-checkout registers to the value indicated in cell E49. Use cells E40 and E49. Copy the formula from cell E51 across columns F-J.

1

23

In cell E52, by using absolute cell references, calculate the average hourly sales assuming the new minimum wage and the increase of self-checkout registers to the value indicated in cell E49. Use cells E6 and H13. Copy the formula from cell E52 across columns F-J.

1

24

In cell E53, by using relative and absolute cell references, calculate the theft proportion assuming the new minimum wage and the increase of self-checkout registers to the value indicated in cell E49. Use cells E7, H12, and E50. Copy the formula from cell E53 across columns F-J.

1

25

In cell E54, by using cell references, calculate the hourly cost per register assuming the new minimum wage and the increase of self-checkout registers to the value indicated in cell E49. Use cells E51, E52, and E53. Copy the formula from cell E54 across columns F-J.

1

26

In cell E55, by using cell references, calculate the hourly cost for multiple registers the new minimum wage and the increase of self-checkout registers to the value indicated in cell E49. Use cells E49 and E54. Copy the formula from cell E55 across columns F-J.

1

27

In cells C57 and E59, do the following: In cell C57 determine whether the retailer should use self-checkout registers if the minimum wage increases. In case the answer in cell C57 is Yes, in cell E59, by using cell reference, enter the number of registers that should be in a group monitored by 1 employee. Refer to an appropriate cell among E49-J49. In case the answer in cell C57 is No, in cell E59, enter zero value. Note: Do not use the equal sign when entering a numeric value.

1

28

Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

Total Points

26