Question: formulate the LP Model Table 5 - Plant's Annual Capacities Table 6 shows the unit production cost of each plant and the required amount of




formulate the LP Model
Table 5 - Plant's Annual Capacities 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 9 -Customers' Demand \begin{tabular}{|c|c|c|c|c|} \hline \multirow{2}{*}{ Customer } & \multicolumn{2}{|c|}{ Product A } & \multicolumn{2}{|c|}{ Product B } \\ \cline { 2 - 5 } & Year 1 & Year 2 & Year 1 & Year 2 \\ \hline A & 300 & 700 & 400 & 1000 \\ \hline B & 400 & 800 & 500 & 1400 \\ \hline C & 300 & 1100 & 300 & 1300 \\ \hline \end{tabular} Table 10 - Unit Transportation Cost (Php/unit) \begin{tabular}{|c|c|c|c|} \hline Supplier\Plant & A & B & C \\ \hline 1 & 7 & 4 & 5 \\ \hline 2 & 6 & 10 & 8 \\ \hline 3 & 13 & 9 & 11 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Plant \ Warehouse & 1 & 2 & 3 \\ \hline A & 8 & 10 & 5 \\ \hline B & 12 & 7 & 9 \\ \hline C & 11 & 9 & 15 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Warehouse Customers & A & B & C \\ \hline 1 & 9 & 10 & 6 \\ \hline 2 & 8 & 4 & 7 \\ \hline 3 & 2 & 5 & 3 \\ \hline \end{tabular} able 7 shows the annual capacities of the three warehouses, the holding cost and the beginning iventory of each warehouse. Table 7 - Warehouse Annual Capacities, Holding Cost (Same for Products A and B, Php/unit-year), and Beginning Inventory (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. 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 1 - Sunnliers' Annual Canarities Table 2 shows the unit purchase cost of the two materials. Table 2 - Raw Material Unit Purchase Cost Table 3 shows the fixed ordering costs of the three suppliers. Table 3 - Supplier'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. Table 4- Plant's Raw Material Requirements
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
