This is done using solver in Excel, so please show formulas used in excel, to help understand. Also please include screenshot of solver entries. Thank you so much!

21. Fitness Bracelet Distribution. Orion Fitness produces bracelets with an embedded chip that tracks its wearer's activities. Orion has plants in Denver and Jacksonville. Bracelets produced at either plant may be shipped to either of the firm's two regional warehouses, which are located in Davenport and Cincinnati. These regional ware- houses subsequently supply retail outlets in Chicago, Orlando, Houston, and Little Rock. The file Orion contains data on each plant's supply (number of bracelets), each retail outlet's demand (number of bracelets), and the shipping costs ($ per bracelet) for the shipping channels. All Rights Rome May not be copied kamel, crasplicated, is hulle is part. Due to its rights, come ind party chetont may be es from the contraplert pecued content does not matrully affect the overall caming experience Cengage Leaming on the right to remove tonal content any time i en rigtitions require it Problems 655 Shipping Costs ($ per bracelet) Supply (number of bracelets) Plant Denver Jacksonville Warehouse Davenport Cincinnati $2.00 $3.00 $3.00 $1.00 700 400 Warehouse Davenport Cincinnati Demand (number of bracelets) Chicago $3.00 $5.00 200 Shipping Costs ($ per bracelet) Retail Outlet Orlando Houston $7.00 $4.00 $5.00 $7.00 150 350 Little Rock $7.00 $6.00 300 a. Construct and solve a linear optimization model that defines the supply chain strat- egy that meets the demand of each retail outlet at minimum total shipping cost. b. In a separate worksheet, reformulate the problem to determine if there is an alterna- tive optimal solution. Clearly explain your result