Question: Can somebody please provide an answer along with steps to.....

A C D M N P About 32 47 9 Background Gordon's Distribution Company GDC) has been a family owned business for the last 80 years. It started as a 10 wholesale distributor to small grocery stores. It then esanded into delivering food to restaurants. When warehouse 11 stores developed. It adjusted its business model to create smaller box warehouse stores for retail customers, similar 12 to Sam's Cub and Costoo. While doing that it maintained its other two business lines of distribution 13 to grocery stores and delivering food to restaurants. It found synergies between these threw business lines, in that 14 as it developed a deli-service to attract retail astomers to its Gordon Warehouse stores some products from the 15 dell could be delivered through its food distribution to small grocery stores and to restaurants 16 Marysa Gordon is the current President of GC and is evaluating how GOC should evolve now In her view 17 GDC is threatened by competition from Amazon Ga Gracery Stares, Aldi grocery stores and Walmart Neighborhood Markets 18 At this point the competition is limited, but Maryse thinks it is growing rapidly and is starting to take market share 19 from the exsting three lines of GDC's business. But, before just opening a small store modeled on Aldor 20 Amazon Go, Marysa wants to ensure that there is enough fiability and capacity in the regional warehouses that 21 support the neisting lines of business to support a fourth line of business. She has asked you to remine 22 the flow of work in the regional warehouse 23 Your Investigation of the flow of work at the regional warehouse has shown the following 24 1 1 About 20% of the orders filled by the regional warehouse are for distribution to small grocery 25 Stors. These stores are dustered in the core ban areas or in the rural areas. Their 26 primary competitors are Dollar General Stores etc. Delivery lead times are important to them 27 because they sell at a higher markup than Dollar General and they try to attract customers by having 28 fresher perishables and small cell offerings. GDC has routes set up that deliver 2 times a week 29 2 About 40% of the orders filled by the regional warehouse are for distribution to small restaurants. 30 The characteristic that the restaurants prefer from GDC is that the lead time is 1 day 31 If the restaurant places an order by PM, it will receive delivery by 10:00 AM the next day, 32 The average daily order from these restaurants is $500 in frozen meats and $300 in prepared food 33 3 40% of the orders filled by the regional warehouse are for GDCs Gordon Warehouse' stores 34 for the retail customer. These are filled daily. About 20% of the orders are for partially 35 prepared foods from the GDC food prep center attached to the regional warehouse. This foods preparation 36 is finished once it arrives at the Gordon Warehouse store. Another 60% of the orders is for dry goods legereal, sugar, four, cooking oils etc. The remaining 20% of the orders is 38 for sessonal spedals to attract the retail customer. For example, a spedal on lawn stairs and ice chests and 39 pianic supplies was conducted during June of this year. 40 ICE After an initial evaluation of the existing lines of business supported by the GDC warehouse, you determined that the most 41 expensive partion of the storage capacity was the frozen foods. You gathered the following information 42 about the GDC fraren foods (referred to as ICE within cod. To simplify the analysis you decided to examine the processing a 43 'case' as the flow unit ICE has a daily volume of 1000 Gses. On average 30% of these are for 44 distribution to small grocery stores. To simplity filling these orders, ICE has a crate designated for each grocery store on its route 45 ICE begins picking the foods for these groceries at 2 AM so it can have trudki leaving the warehouse at 7AM. 16 To fill an order, a GOC team member goes to the Order aard and takes the next order. On average each order requires loading 20 cases into a store's crate. To do this the team member takes their pallet jack().e, a hard pulled 48 vehide designed to hold cases into each frezer. This ORDER START activity Lc., take order off of Order Scard, walk to pallet Jack 49 place empty pallet on pallet jack and walk to freezer door takes 3 minutes. . 50 The picker goes through the freezers in cerce. There are 5 freezer arranged in a row. The picker starts 51 at free and goes through them from front to back. On average it takes a picker 1 minute to walk through a freger and 52 another 1 minute to pick each case found in a freezer. On average the picker selects 3 cases from 53 freerers 182 4 ses from freezer and 5 cases from recrers 4 & 5. After leaving freezer 5, the picker 54 moves cases on the pallet jack to the crate, taking 1 minute. The picker takes 2 min to return to the Order Board 30 minute break Galuate the TAKT time required for ICE to meet 56 2 What is the average time to fill an average order for a grocery store from the ICE process? 57 minutes 58 AN/A 59 60 3 What is the capacity of each picker, measured as orders per shift? 61 Capacity of ore picker orders / shift 62 ANA 63 64 65 3 CE currently has 6. pickers working during the 2 AM a 7 AM shit. If they are only picking orders for the grocery 66 stores, what is their utilization, considering only time available and time per order? 67 utilization minutes 68 AN/A 69 20 71 ### 3 As a way of measuring the performance of eat picker, ICE keeps a separate order cure forest picker. The computer 72 at the order board gives each picker their next order. The computer places 1 new order into each picker's 73 cueve at the order board every 20 minutes. There is no variance in the order arrival rate. 74 There are differences though in the picker's ability to process arcers. The coefficient of variation of order processing 75 for each picke is given below. Calculate the number in their personal ander ee if all have the same wilization. . Costicient of vasol Number of Orders in 76 PROCHE Picker's Que 77 Picker 1 1 WNA 78 Picker 2 1.25 HNYA 79 Picker 3 0.75 ENJA an Picker 4 #N/A 81 Picker 5 0.85 #N/A 82 Picker 5 0.55 INA 83 84 5 You did a survey of small restaurant customers who are served by the ICE team. You have received the following negative 85 Comments about their service 26 Create a Pareto diagram below. State your conclusion Insert rows below as reeded! 87 Category Number 88 Supplies received do not match supplies ardered 13 89 Freean food received a critical temperature 45 on 90 Delivery was more than 1 hour after specified time 91 Minimum order size too large 11 92 Outside of can containers diamanaged 63 93 Invoices resived are often not care 6 94 Delivery drivers will not take cash for payment 4 95 Discount given only if bank transfer done within 24 hours 2 96 Higher volume foods were often stacked out or rationed 97 55 0.9 A C D M N P About 32 47 9 Background Gordon's Distribution Company GDC) has been a family owned business for the last 80 years. It started as a 10 wholesale distributor to small grocery stores. It then esanded into delivering food to restaurants. When warehouse 11 stores developed. It adjusted its business model to create smaller box warehouse stores for retail customers, similar 12 to Sam's Cub and Costoo. While doing that it maintained its other two business lines of distribution 13 to grocery stores and delivering food to restaurants. It found synergies between these threw business lines, in that 14 as it developed a deli-service to attract retail astomers to its Gordon Warehouse stores some products from the 15 dell could be delivered through its food distribution to small grocery stores and to restaurants 16 Marysa Gordon is the current President of GC and is evaluating how GOC should evolve now In her view 17 GDC is threatened by competition from Amazon Ga Gracery Stares, Aldi grocery stores and Walmart Neighborhood Markets 18 At this point the competition is limited, but Maryse thinks it is growing rapidly and is starting to take market share 19 from the exsting three lines of GDC's business. But, before just opening a small store modeled on Aldor 20 Amazon Go, Marysa wants to ensure that there is enough fiability and capacity in the regional warehouses that 21 support the neisting lines of business to support a fourth line of business. She has asked you to remine 22 the flow of work in the regional warehouse 23 Your Investigation of the flow of work at the regional warehouse has shown the following 24 1 1 About 20% of the orders filled by the regional warehouse are for distribution to small grocery 25 Stors. These stores are dustered in the core ban areas or in the rural areas. Their 26 primary competitors are Dollar General Stores etc. Delivery lead times are important to them 27 because they sell at a higher markup than Dollar General and they try to attract customers by having 28 fresher perishables and small cell offerings. GDC has routes set up that deliver 2 times a week 29 2 About 40% of the orders filled by the regional warehouse are for distribution to small restaurants. 30 The characteristic that the restaurants prefer from GDC is that the lead time is 1 day 31 If the restaurant places an order by PM, it will receive delivery by 10:00 AM the next day, 32 The average daily order from these restaurants is $500 in frozen meats and $300 in prepared food 33 3 40% of the orders filled by the regional warehouse are for GDCs Gordon Warehouse' stores 34 for the retail customer. These are filled daily. About 20% of the orders are for partially 35 prepared foods from the GDC food prep center attached to the regional warehouse. This foods preparation 36 is finished once it arrives at the Gordon Warehouse store. Another 60% of the orders is for dry goods legereal, sugar, four, cooking oils etc. The remaining 20% of the orders is 38 for sessonal spedals to attract the retail customer. For example, a spedal on lawn stairs and ice chests and 39 pianic supplies was conducted during June of this year. 40 ICE After an initial evaluation of the existing lines of business supported by the GDC warehouse, you determined that the most 41 expensive partion of the storage capacity was the frozen foods. You gathered the following information 42 about the GDC fraren foods (referred to as ICE within cod. To simplify the analysis you decided to examine the processing a 43 'case' as the flow unit ICE has a daily volume of 1000 Gses. On average 30% of these are for 44 distribution to small grocery stores. To simplity filling these orders, ICE has a crate designated for each grocery store on its route 45 ICE begins picking the foods for these groceries at 2 AM so it can have trudki leaving the warehouse at 7AM. 16 To fill an order, a GOC team member goes to the Order aard and takes the next order. On average each order requires loading 20 cases into a store's crate. To do this the team member takes their pallet jack().e, a hard pulled 48 vehide designed to hold cases into each frezer. This ORDER START activity Lc., take order off of Order Scard, walk to pallet Jack 49 place empty pallet on pallet jack and walk to freezer door takes 3 minutes. . 50 The picker goes through the freezers in cerce. There are 5 freezer arranged in a row. The picker starts 51 at free and goes through them from front to back. On average it takes a picker 1 minute to walk through a freger and 52 another 1 minute to pick each case found in a freezer. On average the picker selects 3 cases from 53 freerers 182 4 ses from freezer and 5 cases from recrers 4 & 5. After leaving freezer 5, the picker 54 moves cases on the pallet jack to the crate, taking 1 minute. The picker takes 2 min to return to the Order Board 30 minute break Galuate the TAKT time required for ICE to meet 56 2 What is the average time to fill an average order for a grocery store from the ICE process? 57 minutes 58 AN/A 59 60 3 What is the capacity of each picker, measured as orders per shift? 61 Capacity of ore picker orders / shift 62 ANA 63 64 65 3 CE currently has 6. pickers working during the 2 AM a 7 AM shit. If they are only picking orders for the grocery 66 stores, what is their utilization, considering only time available and time per order? 67 utilization minutes 68 AN/A 69 20 71 ### 3 As a way of measuring the performance of eat picker, ICE keeps a separate order cure forest picker. The computer 72 at the order board gives each picker their next order. The computer places 1 new order into each picker's 73 cueve at the order board every 20 minutes. There is no variance in the order arrival rate. 74 There are differences though in the picker's ability to process arcers. The coefficient of variation of order processing 75 for each picke is given below. Calculate the number in their personal ander ee if all have the same wilization. . Costicient of vasol Number of Orders in 76 PROCHE Picker's Que 77 Picker 1 1 WNA 78 Picker 2 1.25 HNYA 79 Picker 3 0.75 ENJA an Picker 4 #N/A 81 Picker 5 0.85 #N/A 82 Picker 5 0.55 INA 83 84 5 You did a survey of small restaurant customers who are served by the ICE team. You have received the following negative 85 Comments about their service 26 Create a Pareto diagram below. State your conclusion Insert rows below as reeded! 87 Category Number 88 Supplies received do not match supplies ardered 13 89 Freean food received a critical temperature 45 on 90 Delivery was more than 1 hour after specified time 91 Minimum order size too large 11 92 Outside of can containers diamanaged 63 93 Invoices resived are often not care 6 94 Delivery drivers will not take cash for payment 4 95 Discount given only if bank transfer done within 24 hours 2 96 Higher volume foods were often stacked out or rationed 97 55 0.9