Solver for excel 2011 how to#

Total Profit is equal to Total Revenue – Total Cost. The total revenue TotalRevenue should be equal to the multiple of number of products sold SalesForecastUnits and price demandForecastPrice The total cost TotalCost should be equal to the manufacture cost ShippingPlan * unitManufactureCost and shipping cost ShippingPlan * transport. ShippingPlan * (unitManufactureCost + transport) The planned number of products produced Plan should be equal to the number of product sold, SalesForecastUnits. The planned number of products produced, Plan, should be equal to the number of products shipped, ShippingPlan. The total capacity required must be smaller or equal to factory capacity factor圜apacity. Plan * manufactureLoadsĪnd iter2, iter3 and iter4 represent loops that would sum up the total capacity required per factory ( ). The capacity required to produce the planned number of products is: DemandConstraint – The units of products with promotions that will be sold in areas will be produced should be less than the units forecasted.Constraint6 – Total profit is the summation of each product’s revenue minus its cost.Constraint5 – Total revenue is the forecasted price times the units sold.Constraint4 – total cost for each product involves manufacture cost and shipping cost.Constraint3 – The product units sold should match the sales forecasted units.Constraint2 – Summation of units from all promotions should equal to the units shipped for each product produced in factories that will be sold in areas.

Capacit圜onstraint – Each factory has a capacity limit on how many products it can produce within a fixed period of time that we are planning on.

There are 7 constraints in this supply chain model and we are going to look at each one of them. In this blog, I am going to continue the demonstration and discuss the last component, Constraints.

Solver for excel 2011 how to#

In my last blog, I demonstrated how to create Sets, Parameters, Decisions and Goals in Solver Foundation Excel Add In.