i need just LP Model

this is case study in operation research

i need just linear programming model (LP)

Al-Batal: A Facility-Location Problem Al-Batal (AB) is a well-known Saudi snacks company that produces high quality chips. Basically, AB processes raw materials like potatoes.com, and nice to make ketchup flavored and salt & vinegar flavored chips. AB is expanding into the western and southern regions of Saudi Arabia and has to study several locations to build their production facilities. AB currently are considering five different sites. In Table 1, the second column shows the land rent prices and the last three columns show the purchase and delivery cost per ton of each material to cach of the locations under consideration. Each production facility can produce as much as 12.000 tons of all products per year. The largest four companies conducting business with AB, their distribution center location, and their yearly demand quantities are listed in Table 2. The demand is shipped by trucks from cach production facility to cach customer's distribution center. The shipping cost from each production facility to each distribution center is SRO.10 per ton per km. Demand for cach distribution center has to be fulfilled completely. The amount of each raw material that goes into the making of each flavored chips is given in Table 3. Your task is to determine how AB should expand. In addition, you are expected to answer the following questions: Which locations should be selected? How should the distribution centers receive AB service? If fuel cost increases and our shipping costs between production facilities and customer's distribution center are affected, will your recommendation change? Explain. (Hint: Sensitivity analysis is not required) If shipping costs for raw material increase, will your recommendation change? Explain using sensitivity analysis. Are their any other sensitivity analysis issues that you feel might be important to address? Conduct your experiments if so. Table / Site Information and Material Supping Cart Rauch Makkah 20 24 Yan Madinah Dahan. Makkah Al Al 250.000 240.000 270.000 320.000 30 e 22 3 Table 2 Demand Information 1.600 Company Aseer CO Taibah CO Al Rahma CO Red Sea CO La Abha, Aseer Al Madinah, Madinah Makkah, Makkah Jeddah. Makkah 2200 2.600 2.300 3.600 2.400 Tahle 3 Product Ingredient Mix Ketchup flavored chips Salt & vinegar flavored chips 65 30 25 1 5 10 5 5 Final Report Requirements: Cover page: It includes course name, project title, students' names and ID numbers. Table of contents: The contents and their page numbers. Introduction for the project: Introduce the project's main problem and its surrounding environment. Overview the remaining topics of the report. Project Management: Organize the tasks of the project in a timeline scale using Gantt chart. Distribute the tasks among the group members and show that in the chart. Problem Formulation (Modeling): O Define the decision variables. o Write and explain the objective function. Identify and explain all objective function coefficients (c). o identify and explain all constraints, which includes: . Identify and explain all constraints attributes (au). . Identify and explain all right-hand side values (b). . Identify and explain any other supporting data, if available. Problem Solution: Generate an optimal solution for the problem using a software package. Attach the software input and output in the appendix of the report. Al-Batal: A Facility-Location Problem Al-Batal (AB) is a well-known Saudi snacks company that produces high quality chips. Basically, AB processes raw materials like potatoes, com, and rice to make ketchup flavor ed and salt & vinegar flavored chips. AB is expanding into the western and southern regions of Saudi Arabia and has to study several locations to build their production facilities. AB currently are considering five different sites. In Table 1, the second column shows the land rent prices and the last three columns show the purchase and delivery cost per ton of each material to cach of the locations under consideration. Each production facility can produce as much as 12,000 tons of all products per year. The largest four companies conducting business with AB, their distribution center location, and their yearly demand quantities are listed in Table 2. The demand is shipped by trucks from cach production facility to each customer's distribution center. The shipping cost from each production facility to each distribution center is SRO 10 per ton per km. Demand for each distribution center has to be fulfilled completely The amount of each raw material that goes into the making of each flavored chips is given in Table 3. Your task is to determine how AB should expand. In addition, you are expected to answer the following questions: Which locations should be selected? How should the distribution centers receive AB service? If fuel cost increases and our shipping costs between production facilities and customer's distribution center are affected, will your recommendation change? Explain. (Hint: Sensitivity analysis is not required) If shipping costs for raw material increase, will your recommendation change? Explain using sensitivity analysis. Are their any other sensitivity analysis issues that you feel might be important to address? Conduct your experiments if so. Table / Site Information and Material Shipping Cost Materiali st SRT Site Location Land Resting Cost SRY 250.000 240.000 Rabigh, Makkah Ta'if, Makkah Yanhu, Madinah Dahban, Makkah Al Bahah, Al Bahah 270.00 230.000 Table 2 Demand Information Demand (Toms) Ketchup Salt & Vinegar Company Aseer CO 2.000 1.600 Location Abha, Aseer Al Madinah, Madinah Makkah, Makkah Jeddah, Makkah Al Rahma CO Red Sea CO 2,600 2,300 3,600 2,200 1,800 2.400 Table 3 Product-Ingredient Mix Product Ingredient("%) Rice flour 25 15 Corn 65 30 Ketchup flavored chips Salt & vinegar flavored chips Al-Batal: A Facility-Location Problem Al-Batal (AB) is a well-known Saudi snacks company that produces high quality chips. Basically, AB processes raw materials like potatoes.com, and nice to make ketchup flavored and salt & vinegar flavored chips. AB is expanding into the western and southern regions of Saudi Arabia and has to study several locations to build their production facilities. AB currently are considering five different sites. In Table 1, the second column shows the land rent prices and the last three columns show the purchase and delivery cost per ton of each material to cach of the locations under consideration. Each production facility can produce as much as 12.000 tons of all products per year. The largest four companies conducting business with AB, their distribution center location, and their yearly demand quantities are listed in Table 2. The demand is shipped by trucks from cach production facility to cach customer's distribution center. The shipping cost from each production facility to each distribution center is SRO.10 per ton per km. Demand for cach distribution center has to be fulfilled completely. The amount of each raw material that goes into the making of each flavored chips is given in Table 3. Your task is to determine how AB should expand. In addition, you are expected to answer the following questions: Which locations should be selected? How should the distribution centers receive AB service? If fuel cost increases and our shipping costs between production facilities and customer's distribution center are affected, will your recommendation change? Explain. (Hint: Sensitivity analysis is not required) If shipping costs for raw material increase, will your recommendation change? Explain using sensitivity analysis. Are their any other sensitivity analysis issues that you feel might be important to address? Conduct your experiments if so. Table / Site Information and Material Supping Cart Rauch Makkah 20 24 Yan Madinah Dahan. Makkah Al Al 250.000 240.000 270.000 320.000 30 e 22 3 Table 2 Demand Information 1.600 Company Aseer CO Taibah CO Al Rahma CO Red Sea CO La Abha, Aseer Al Madinah, Madinah Makkah, Makkah Jeddah. Makkah 2200 2.600 2.300 3.600 2.400 Tahle 3 Product Ingredient Mix Ketchup flavored chips Salt & vinegar flavored chips 65 30 25 1 5 10 5 5 Final Report Requirements: Cover page: It includes course name, project title, students' names and ID numbers. Table of contents: The contents and their page numbers. Introduction for the project: Introduce the project's main problem and its surrounding environment. Overview the remaining topics of the report. Project Management: Organize the tasks of the project in a timeline scale using Gantt chart. Distribute the tasks among the group members and show that in the chart. Problem Formulation (Modeling): O Define the decision variables. o Write and explain the objective function. Identify and explain all objective function coefficients (c). o identify and explain all constraints, which includes: . Identify and explain all constraints attributes (au). . Identify and explain all right-hand side values (b). . Identify and explain any other supporting data, if available. Problem Solution: Generate an optimal solution for the problem using a software package. Attach the software input and output in the appendix of the report. Al-Batal: A Facility-Location Problem Al-Batal (AB) is a well-known Saudi snacks company that produces high quality chips. Basically, AB processes raw materials like potatoes, com, and rice to make ketchup flavor ed and salt & vinegar flavored chips. AB is expanding into the western and southern regions of Saudi Arabia and has to study several locations to build their production facilities. AB currently are considering five different sites. In Table 1, the second column shows the land rent prices and the last three columns show the purchase and delivery cost per ton of each material to cach of the locations under consideration. Each production facility can produce as much as 12,000 tons of all products per year. The largest four companies conducting business with AB, their distribution center location, and their yearly demand quantities are listed in Table 2. The demand is shipped by trucks from cach production facility to each customer's distribution center. The shipping cost from each production facility to each distribution center is SRO 10 per ton per km. Demand for each distribution center has to be fulfilled completely The amount of each raw material that goes into the making of each flavored chips is given in Table 3. Your task is to determine how AB should expand. In addition, you are expected to answer the following questions: Which locations should be selected? How should the distribution centers receive AB service? If fuel cost increases and our shipping costs between production facilities and customer's distribution center are affected, will your recommendation change? Explain. (Hint: Sensitivity analysis is not required) If shipping costs for raw material increase, will your recommendation change? Explain using sensitivity analysis. Are their any other sensitivity analysis issues that you feel might be important to address? Conduct your experiments if so. Table / Site Information and Material Shipping Cost Materiali st SRT Site Location Land Resting Cost SRY 250.000 240.000 Rabigh, Makkah Ta'if, Makkah Yanhu, Madinah Dahban, Makkah Al Bahah, Al Bahah 270.00 230.000 Table 2 Demand Information Demand (Toms) Ketchup Salt & Vinegar Company Aseer CO 2.000 1.600 Location Abha, Aseer Al Madinah, Madinah Makkah, Makkah Jeddah, Makkah Al Rahma CO Red Sea CO 2,600 2,300 3,600 2,200 1,800 2.400 Table 3 Product-Ingredient Mix Product Ingredient("%) Rice flour 25 15 Corn 65 30 Ketchup flavored chips Salt & vinegar flavored chips