2. Using the data collected by Sam, create a spreadsheet that calculates the costs of handling paper at SSC based on average hourly rates per employee of $28. Add the cost of lost documents to this.Then, add the costs of warehousing the paper, which increases by 10 percent every month due to increases in volume. Present the results showing both monthly totals and a yearly total.

Prepare graphs so that Sam can easily identify the projected growth in warehousing costs over the next three years. Download the spreadsheet to help you get started from the textbook’s website.