I’m a teacher in training, and want to see how challenging this question is and who can answer it. Thanks!
Calculate the value of data in the following circumstance:
b.Fred works for a Grocery store.
c.The company keeps all its inventory data on an excel spreadsheet.
d.It is updated daily
e.The store orders at the end of each day and food arrives within a week.
f.As the food arrives, the Inventory file is updated
g.The company throws all orders and receipts in a drawer
h.If the Inventory file were lost
i.It would take 2 weeks (80 hours @ $20/ hour) to reconstruct the status of orders
ii.It would take 20 hours @ $10 / hour to redo the inventory the entire store
iii.The store would lose $10,000 in business because of lack of inventory
i.Backups for the Inventory file
i.The office manager will do backups
ii.The office manager makes $20 an hour
iii.Backups take 1 hour per day, if done.
What is the value of the Inventory data?
What is the yearly cost of doing the backup
If you want to be a teacher, you need to get your alphabet in order. You missed letter A. then you went to I then a 2, 3 and then back to I (twice) and 2, 3 again.
Perhaps you missed so items in your list, but no matter your attention to detail is key as a teacher.
As for an answer, the yearly cost of the manager doing a daily backup is $7,280 (given 7 days in a week, 52 weeks a year and 1 hour at $20)
The value of the inventory data is “invaluable” as the cost of it being lost far outweighs the cost to do the backup.