Explain Operations Research: Linear Optimization
Problem- Applichem wants to allocate the capacity of its worldwide manufacturing plants to fulfill its customer demand. Applichem makes a product, R, which is used by plastic molding companies around the world. R sells for $1/lb. Its plants are located in Gary, Indiana, Windsor, Ontario, Frankfurt, Germany, Mexico City, Caracus, Venezula, and Osaka, Japan. Its current strategy is to make and ship R as shown in the table below (x 100,000 lbs)
I need help to explore how to solve LPP problems using excel.