Question

you are the human resources manager for a business. you use the spreadsheet shown to manage the vacation days of the employees in your company. for 1 of the 5 employees listed, the number of remaining vacation days is incorrect. which one?
chart with columns: employee (sara, dan, carlos, mara, nathan), total number of vacation days available (21, 21, 21, 18, 18), full vacation days used (7, 11, 14, 0, 1), half vacation days used (2, 1, 0, 1, 2), total vacation days used (8, 11.5, 14, 0, 2), number of vacation days remaining (13, 9.5, 7, 18, 16)
multiple choice options: a. sara, b. dan, c. carlos, d. mara, e. nathan

Explanation:

Step1: Calculate Sara's remaining days

Total days: 21, Full vacation used: 7, Half vacation used: 2 (half - day counts as 0.5). Total used: \(7 + 2\times0.5=7 + 1 = 8\). Remaining: \(21-8 = 13\) (correct).

Step2: Calculate Dan's remaining days

Total days: 21, Full vacation used: 11, Half vacation used: 1 (0.5). Total used: \(11+0.5 = 11.5\). Remaining: \(21 - 11.5=9.5\) (correct).

Step3: Calculate Carlos's remaining days

Total days: 21, Full vacation used: 14, Half vacation used: 0. Total used: 14. Remaining: \(21 - 14 = 7\) (correct).

Step4: Calculate Mara's remaining days

Total days: 18, Full vacation used: 0, Half vacation used: 1 (0.5). Total used: 0.5. Remaining should be \(18-0.5 = 17.5\), but listed as 18 (incorrect).

Step5: Calculate Nathan's remaining days

Total days: 18, Full vacation used: 1, Half vacation used: 2 (1). Total used: \(1 + 1=2\). Remaining: \(18 - 2 = 16\) (correct).

Answer:

D. Mara