Microsoft Excel 16.41 Answer Report Worksheet: [Unit 50_Part_Three_Reporting.xlsx]Distribution Report Created: 10/4/20 10:22:54 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 274882481.012 Seconds. Iterations: 11 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 18-06, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume Non Objective Cell (Min) Cell Name Original Value Final Value $J$10 Total Total Costs $ 12,000.00 $ 23,587.65 Variable Cells Cell Name Original Value Final Value Integer $F$4 Food Buzz Distribution Ctr. 1 60 60 Integer $G$4 Food Buzz Distribution Ctr. 2 0 O Integer $H$4 Food Buzz Distribution Ctr. 3 0 O Integer $F$5 Healthy Stuff Distribution Ctr. 1 O O Integer $G$5 Healthy Stuff Distribution Ctr. 2 0 0 Integer $H$5 Healthy Stuff Distribution Ctr. 3 78 78 Integer $F$6 Smoothie City Distribution Ctr. 1 0 O Integer $G$6 Smoothie City Distribution Ctr. 2 0 125 Integer $H56 Smoothie City Distribution Ctr. 3 O Integer SF$7 Burger Barn Distribution Ctr. 1 O 0 Integer $G$7 Burger Barn Distribution Ctr. 2 0 O Integer SH$7 Burger Barn Distribution Ctr. 3 183 187 Integer $F$8 Cafe Organic Distribution Ctr. 1 0 0 Integer $G$8 Cafe Organic Distribution Ctr. 2 0 313 Integer SH$8 Cafe Organic Distribution Ctr. 3 O 0 Integer