Create an “evaluative model” for the Bloomex case.
Build a spreadsheet evaluative model that you can use to determine if a given shipping plan satisfies Bloomex’s business requirements. Outputs from you model should include: Total boxes shipped from each Supply Point
Total boxes shipped to each Transshipment Center
Total boxes shipped from each Transshipment Center
Total boxes shipped to each Demand Point
Total cost
Set all Decision Variables (shipment quantities) to 1. (Setting all DVs to 1 is a smart way to check model calculations; it is called “The Ones Test”.)
Case study and required data attached. Please provide solution in the attached excel file on sheet named “2A) Bloomex Evaluative Model”