Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Formulate a MILP Model, solve with excel solver if possible Case 5 A company has three plants (A, B, and C) producing two products (A
Formulate a MILP Model, solve with excel solver if possible
Case 5 A company has three plants (A, B, and C) producing two products (A and B). Two types of raw materials ( 1 and 2 ) are needed to produce these two products. The company can source these materials from three suppliers (1,2, and 3 ). Table 1 shows the monthly capacity of each supplier. Table 2 shows the unit purchase cost of the two materials. Tahle 7 - Raw Material IInit Purchace Coct Table 3 shows the fixed ordering costs of the three suppliers. Table 3 - Supolier's Fixed Ordering Cost The yearly requirements for these raw materials and yearly production capacities of each plant can be seen in Table 4 and Table 5, respectively. Tahle 4- Dlant'c Raw Material Recuiremente Table 6 shows the unit production cost of each plant and the required amount of raw materials needed to produce one unit of each product. Table 6 - Unit Production Cost (Php/unit) and Raw Material Requirements per unit of the Product Table 7 shows the annual capacities of the three warehouses, the holding cost and the beginning inventory of each warehouse. Table 7 - Warehouse Annual Capacities, Holding Cost (Same for Products A and B, Php/unit-year), and Beginning Inventorv (Same for Products A and B) The production of each plant will be delivered to three warehouses (1,2, and 3). Each warehouse may serve three major customers (A, B, and C). Table 8 shows the annual requirements of each warehouse and Table 9 shows the annual demand of the three major suppliers. Table 10 shows the transportation costs in transporting a unit of raw material to plants, costs in transporting a unit of finished goods to the warehouses, and costs in transporting finished goods to the three major customers. Table 10-Unit Transbortation Cost (Pho/unit)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started