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

I'm a teacher in training, and want to see how challenging this question is and who can answer it. Thanks!
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.