$($Questions on Page $2)$ Using AnyLogistix, solve the following problem using Network Optimization $($NO$).$ MooveOver Milk has retail customers in four different cities across the state of Kansas. They currently have a factory in Dodge City and a distribution center in Salina. They have the option of renting a factory in Hutchinson as well as a distribution center in Wichita. Help MooveOver Milk decide which supply chain design is more profitable. Consider the following information and costs in your NO model. For vehicle type, assume that each truckload fits $200$ units $($pcs$)$ and trucks travel at $65$ miles per hour. Units for products is pcs and distance is miles. It is suggested to group your customers, distribution centers, and factories. Table $1.$ Location, Roles, and X$/$Y Coordinates of Sites Site Role Inclusion Type Latitude Longitude Great Bend Customer Include $38\mathrm{.}355-98\mathrm{.}784$ Manhattan Customer Include $39\mathrm{.}194-96\mathrm{.}570$ Newton Customer Include $38\mathrm{.}048-97\mathrm{.}333$ Pratt Customer Include $37\mathrm{.}640-98\mathrm{.}740$ Salina Distribution Center Include $38\mathrm{.}848-97\mathrm{.}592$ Wichita Distribution Center Consider $37\mathrm{.}693-97\mathrm{.}328$ Dodge City Factory Include $37\mathrm{.}758-100\mathrm{.}009$ Hutchinson Factory Consider $38\mathrm{.}070-97\mathrm{.}921$ Table $2.$ Customer Demand per Week by Location and Product $($Revenue for each product is $$15)$ Location Product Demand Per Week Great Bend Chocolate Milk $100$ Great Bend Regular Milk $200$ Great Bend Strawberry Milk $100$ Manhattan Chocolate Milk $150$ Manhattan Regular Milk $300$ Manhattan Strawberry Milk $175$ Newton Chocolate Milk $175$ Newton Regular Milk $325$ Newton Strawberry Milk $175$ Pratt Chocolate Milk $175$ Pratt Regular Milk $250$ Pratt Strawberry Milk $175$ Table $3.$ MooveOver Milk Model Parameters Supply Chain Costs Value in U$.$S$.$ Dollars $($USD$)$ Facility Expenses Dodge City: other costs $($fixed$),$ per day $55\mathrm{.}00$ Hutchinson: other costs $($fixed$),$ per day $60\mathrm{.}00$ Salina: other costs $($fixed$),$ per day $50\mathrm{.}00$ Salina: carrying costs $($variable$),$ per pcs$,$ per day $2\mathrm{.}00$ Wichita: other costs $($fixed$),$ per day $60\mathrm{.}00$ Wichita: carrying costs $($variable$),$ per pcs$,$ per day $3\mathrm{.}00$ Processing Costs Salina $($inbound and outbound$),$ per pcs $0\mathrm{.}35$ Wichita $($inbound and outbound$),$ per pcs $0\mathrm{.}25$ AGEC $632|$ Agribusiness Logistics Homework $5|$ Page $2$ of $2$ Production Dodge City, per pcs $7\mathrm{.}00$ Hutchinson, per pcs $7\mathrm{.}00$ Paths Factories to DCs $($product&distance$-$based$)0\mathrm{.}01*$ product$($pcs$)*$ distance DCs to Customers $($product&distance$-$based$)0\mathrm{.}01*$ product$($pcs$)*$ distance Products Selling price $($all products$)15\mathrm{.}00$ Cost $($all products$)7\mathrm{.}00$ When going to solve your NO experiment, be sure to have the following: Demand variation type $(95-100\%)$; Finances statistics unit $($USD$)$; Product statistics unit $($pcs$)$; and Distance statistics unit $($mile$).1.(3$ points$)$ What is the most profitable supply chain design? Provide evidence $($either Excel export or screenshot$)$ from your results to enhance your answer. $2.(3$ points$)$ Why do you think this is the optimal design? Provide evidence $($either Excel export or screenshot$)$ from your results to enhance your answer. $3.(3$ points$)$ Is demand for all customers satisfied? Why or why not? Provide evidence $($either Excel export or screenshot$)$ from your results to enhance your answer. $4.(3$ points$)$ What is the total revenue of the most profitable supply chain? Provide evidence $($Excel export or screenshot$)$ from your results to enhance your answer. $5.(4$ points$)$ Compare the optimal supply chain design $($answer to Question $1)$ and the initial supply chain design $($Dodge City factory and Salina DC$)$ in terms of profit. What is causing inefficiencies in the initial supply chain design? $6.(9$ points$)$ Imagine that MooveOver Milk experiences a sudden $20\%$ increase in demand for all products across all customer locations due to a promotional event. Using your NO model in AnyLogistix, estimate the impact of this demand spike on costs and assess whether the current design would require adjustments to remain profitable. You will want to change the Demand Coefficient within the Periods menu item from $1\mathrm{.}0$ to $1\mathrm{.}2.$ Based on your analysis, suggest possible adjustments to the supply chain, such as temporarily renting additional warehouse space or increasing production capacity, and explain how these changes could help MooveOver Milk meet the increased demand while managing costs effectively. Provide evidence $($Excel export or screenshot$)$ from your results to enhance your answer and justify your recommendations