Question

Full Book Q Search this course х TOC Go to pg 64 A-Z TONOLOGY nž AA Use Technology 11. How much does it cost? You may think that taking a few Post-It Notes for personal use or arriving to work a few minutes late doesn't matter. Create a spreadsheet in Microsoft Excel. Complete the following calculations to see how much employee theft costs a fictitious company of 30 employees over the course of one weck. Over the course of a year? Does this change your opinion?* (Learning Objective 4 ) • Three workers cach take home two packs of Post-It Notes, at a cost of $.67 per pack. • Three workers arrive at work 15 minutes late, at a cost of $11/hour • Four workers take an extra half-hour for lunch, at a cost of $14/hour. • Three emplýyees play computer games for a total of 4 hours cach, at a cost of $10/hour. • One employee sends three personal packages at the company's expense, at a cost of S7, 4.50, and $12. • One worker makes 300 personal copies on the company photocopier, at a cost of S.05/copy • Three workers call in sick for one 8-hour day when they are healthy, at a cost of S10/hour < > • Ten workers send three personal emails each, which take a total of 7 hours, at a cost of $10/hour.

Answer 1

Computation of total cost

Three workers took 2 packs at cost of each$0.67 = $0.67*2packs * 3 workers = $4.02

Three workers arrive 15 minutes late at cost of 11 per hour = 3*15*11/60 =$8.25

Four workers took extra half hour for lunch cost of 14 per hour = 4*0.5*14 = $28

Three employees play computer games for 4 hours each at cost of $10 per hour=3*4hours*$10 = $120

One employee send 3 packages = $7 + $4.50 + $12 = $23.5

One worker makes 300 copies at a cost of $0.5/copy = 300 * $0.5 = $150

Three workers call-in-sick for one 8 hour day @cost of $10/hour = 3 * 8 * 10 =$240

Ten workers send 3 mails each, for 7 hours @10/hour = 10 * 7 * 10 = $700

Therefore Total Cost = $1273.77