There are 40 customers in total. You group them into 2 (12 small, 6 medium and 2 large in each group). The groups are identical in terms of demand and other prevalent data. You made a contract with a local trucking company to supply each group simultaneously by using a single truck from your main distribution center.

With preparing an Excel template in which you laid-out all the 40 customer analysis one by one to be able to evaluate the bottom-line of the TOTAL replenishment strategy (i.e. total annual cost).

By visualizing the constraints section of Excel Solver as you answer this question. How many sets of constraints (lines of entries) do you need to place in Excel Solver? How many actual constraints in each group do we characterize and represent?

Label the groups of constraints with the relevant business meaning along with the sign for each set. LHS Sign RHS

State the business meaning of RHS (right-hand-side) along with LHS (left-hand-side) of each constraint set very clearly in the above table.