Chapter 01 - Exercise 16 Hillbilly Bob's Ozark Gift Shoppe Jefferson Hollar, Arkansas Piecework Payroll Sheet Items Completed Week 1 Week 2 Week 3 Belton, Lucille Embroidered pillow cases Pair 2 3 1 1 Cross-stitched table scarves 2 4 Jones, Betty Sue Strawberry Jam Muscadine Jelly Chow Chow Relish Corn Chow Relish Hot Pepper Jelly Blueber Jam Name Item Total Gross Pa Hill, Bill Joe Animal wood carvinos Wooden bookends Wooden stools Animal wall hangings Wooden key hanging Total Gross Pay Directions: a. Enter a formula in Cell H9 to calculate Lucille Belton's Gross Pay for the pillow cases that she completed overthe 4-week period. (Gross Pay is the total of Items Completed multiplied by the Rate.) b. Repeat this for each item under each employee's name. c. Format each of the Gross Pay cells for Number. Set Decimal places to 2. Set Use 1000 Separator (,) to off. d. Enter a formula in Cells H12, H19, and H24 to calculate each person's Total Gross Pay. Format for Currency. Set Decimal places to 2. Set Currency symbol to $