Question: 4. Using the data collected by Sam, create a spreadsheet that calculates the costs of handling paper at SSC based on hourly rates per employee
4. Using the data collected by Sam, create a spreadsheet that calculates the costs of handling paper at SSC based on hourly rates per employee of $16, $22, and $28. Add the cost of lost documents to this. Then, add the costs of warehousing the paper, which increases by 10% every month due to increases in volume. Present the results, showing both monthly totals and a yearly total. Prepare graphs as visualization tools so that Sam can easily perceive the projected growth in warehousing costs over the next three years. Download the spreadsheet to help you get started from the textbook’s Web site. Spring Street Company (SSC, a fictitious company) faced rising costs not only from sky-high energy prices, but also from what it considered “hidden costs” associated with its paperintensive processes. The employees jokingly predicted that if the windows in the offices blew open on a very windy day, there would be total chaos as the papers started flying. The financial implications were that, if such a disaster occurred, the business would grind to a halt.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
