F G H 1 Collins Title Insurance Ltd. 2 Example 2 3 Assignment: Build formulas in the yellow cells. 4 5 Old System New System 6 Staff (# of people) 4 4 7 Hours worked per day per employee 8 8 8 Total Payroll Cost per Day: $ 640 $ 640 9 Output (# of titles processed per day) 8 14 10 Overhead Cost per Day $ 400 $ 800 11 12 Old System New System 13 Total Labor Hours per Day 14 Labor Productivity (Titles per Hour) 15 Multifactor Productivity (Titles per $) 16 17 18 19 20 21 22 % Incr/Decr.) B C D E F G Chapter 2 Example 1 Rating Potential Outsourcing Providers Page 47 Enter the ratings for each supplier in light yellow shaded cells. Then, build formulas in green cells to calculate Total Weighted Score for each supplier. Outsourcing Providers and Ratings! BIM SPC Telco Factor (Criterion) 1. Can reduce operating costs. 2. Can reduce capital investment. 3. Skilled personnel. 4. Can improve quality. 5. Can gain access to technology not in company. 6. Can create additional capacity. 7. Aligns with policy/philosophy/culture. Weight 0.20 0.20 0.20 0.10 0.10 0.10 0.10 1.00 Hint: You could use the SUMPRODUCT function or just build a longer formula. This example is also shown in the book, worked in Excel on page 51