Please solve using screenshots from excel for a thumbs up!

car programmet shipping plan 13. Sports of All Sorts produces, distributes, and sells high-quality skateboards. Its supply chain consists of three factories located in Detroit, Los Angeles, and Austin) that produce skate- boards. The Detroit and Los Angeles facilities can produce 350 skateboards per week, but the Austin plant is larger and can produce up to 700 skateboards per week. Skateboards must be shipped from the factories to one of four distribution centers, or DCs (located in Iowa. Maryland, Idaho, and Arkansas). Each distribution center can process (repackage. mark for sale, and ship) at most 500 skateboards per week. Skateboards are then shipped from the distribution centers to retailers. Sports of All Sorts supplies three major US retailers Just Sports Sports 'N Stuff, and The Sports Dude. The weekly demands are 200 skateboards at Just Sports, 500 skateboards at Sports N Stuff, and 650 skateboards at The Sports Dade. The following tables display the per-unit costs for shipping skateboards between the factories and DCs and for shipping between the DCs and the retailers Arkansas Factory/DC Detroit Los Angeles Austin Towa 25.00 35.00 40.00 Shipping Costs ($ per skateboard) Maryland Idaho 25.00 35.00 45.00 35.00 40.00 42.50 40.00 42.50 32.50 Retailers/DC Just Sports Sports 'N Stuff The Sports Dude lowa 30.00 27.50 30.00 Maryland 20.00 32.50 40,00 Idaho 35.00 40.00 32.50 Arkansas 27.50 25.00 42 50 # Draw the network representation for this problem. b. Build a model to minimize the transportation cost of a logistics system that will deliver skateboards from the factories to the distribution centers and from the distribution cent- crs to the retailers. What is the optimal production strategy and shipping pattern for Sports of All Sorts? What is the minimum attainable transportation cost? c Sports of All Sorts is considering expansion of the lowa DC capacity to 800 units per week. The annual amortized cost of expansion is $40,000. Should the company expand the lowa DC capacity so that it can process 800 skateboards per weck? (Assume 50 operating weeks per year.)