ANALYZING LOGISTICS PERFORMANCE CASE This bonus activity is intended to give you practice with logistics key performance indicators and analyzing outcomes in transportation and warehousing operations. You are working as a logistics analyst for Mobile Accessories (MoAcc), a large manufacturer phone cases, chargers, and cords. MoAcc serves large and mid-sized retailers via its centralized fulfillment operation. These retailers are pushing MoAcc to improve service quality while MoAcc senior management is prioritizing efforts to control costs. Your task is to determine how well the company is performing from these external and internal perspectives. Show the work that you did to determine the answers. Use the following fulfillment data for the assignment: Month of December 202x: Total deliveries made 375 Total late deliveries 18 Total units ordered 1,150,000 Total units shipped 980,000 Total units damaged 17,511 Transit time for 12 sample deliveries 3, 5, 2, 5, 4, 3, 3, 2, 4, 5, 4,5 December 31 value of goods on hand $550,750 March monthly sales $2,975,000 Relevant Formulae Fill Rate = Total units shipped / Total units ordered Damage Rate = Total units damaged / Total units shipped On-Time Delivery = Number of on-time deliveries / Total number of deliveries Average Transit Time = Total transit time / Total number of deliveries Average Inventory Value - On-hand inventory value / 2 Inventory Turns - Cost of goods sold / Average inventory value Selling Days of Inventory on Hand = 385 / Inventory turns Show your work and final answer for each metric. Transportation Performance Analysis What percentage of shipments were delivered on time in December 202x? What was the average transit time across the sample of 12 deliveries? Fulfillment Performance Analysis What was the unit fill rate percentage for December 202X? What was the unit damage rate percentage for December 202x? Inventory Performance Analysis What was the average inventory value for December 202X? What was the inventory turns for December 202x? How many selling days of inventory are on hand at the end of December 202x? Week 3 Assignment Complete the scorecard using your results from above: Key Performance Indicator Performance Goal & Evaluation Actual Performance Evaluation Weight Factor Score (Evaluation x Weight Factor) On-time Delivery 5 4 3 2 1 20 Average Transit Time 5 4 3 2 1 20 Unit Fill Rate > 95% = 5 90.1 to 95% = 4 801 to 90% = 3 70 to 80% = 2 >7 days = 1 >95% = 5 90.01 to 95% = 4 80.01 to 90% = 3 70.01 to 80% - 2 3.0% = 1 > 10 = 5 7.5 to 10 = 4 5 to 7.49 = 3 2.5 to 4 99 = 2 >2.5 = 1 5 4 3 2 1 25 Damage Rate 5 4 3 2 1 20 Inventory Turns 5 4 3 2 1 15 Total Out of 500 possible Week 3 Assignment Analysis: Based on your scorecard results... What total score do you calculate for MoAcc's performance (out of a possible 500 points)? What area does MoAcc most need to improve upon? What is MoAcc's strongest area of performance? What is your overall assessment of MoAcd's December performance