Practice 2 (Lecture 2) 1 a Colculate the totol shipment load to be dropped off a

Question

Practice 2 (Lecture 2) 1 a Colculate the totol shipment load to be dropped off at each store. b Checkf the total dropo per store is less than the requested demand; i so, calculate the demand shortage and display e Count the number of times any truck driver is schedule to ship a load greater than its truck capacity. d Highlight table rows for given pickup store and route order e Colculate the totol shipment load to be picked up ot each store for each route order. message shorty otherwise leave blank. Drtver ID Route Order Pickup Store Dropor store Shipment load store Name Total DroportDe Demand Warring 1234 DoorMertShep DeorMart ABC1234 ABC1234 DEF5678 DEFS678 GreenFloor Bulseve GreenFloor Left-Aid GreenFloor DoorMart 103 600 13 GreenFloor Buillseye 2 Bulye K-Shop Left-Aid 420 15 5678 GHI9101 GH19101 GHI9101 Left Aid Left-Aid Bullseye Bulseye GreenFloor GreenFloor DoorMart Bulseye DoorMart 147 73 120 120 120 110 130 130 110 17 18 19 ABC1234 DEF5678 GHI9101 L1121 2DoorMertk-Shop MNO3141 PORS161 TU7181 118 KL1121 3 K-Shop Left-Aid oorMertBuliseye Left-Aid GreenFloor 23 JKL1121 MNO3141 MNO3141 MNO3141 ORS161 POR5161 VWAS202100 2 Bulseye Left-Aid ZA1222 10 100 Left-Aid Bulseye GreenFloo GreenFloor KShoo 26 DoorMart 105 Hishlight table rows for given Piekup Store and Route Order Pickup Store B Route Order Bullseve R5161 DoorMart 31 32 TU7181 STU7181 GreenFloor Left Aid 105 DoorMar 93 et each store for each VW9202 Wx9202 VW9202 YZA1222 ZA1222 YZA1222 34 GreenFloor Lelt-Aid 3 eft-Aid Bullseye GreenFloor Left-Aid 2 Left Aid Bullseye DoorMar Bulseye GreenFloor Left Aid

Explanation / Answer

a.

c.

e. Total Shipment to be picke dup from each store

Thank you

Store name Total drop off Demand Demand Warning Door Mart 585 580 K Shop 662 700 #Short Bullseye 609 600 Green floor 405 420 #Short Left Aid 403 420 #Short

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.