Answer should be on excel sheet format please
Sunol is a manufacturer of petrochemical products with worldwide sales in ive regions: North South America, furope, Africa and Asia. The available data are shown in the table below Lew Fixed 5 3 America 90 100 4,500 95 19 111 6500 6750 9,710 10 6 150 4,000 Note that all the variable costs are in thousands of dollars. Sunoil is considering two plant sizes in each ocation Low-capacity plants can produce 10 million units a year while high capacity plants can produce 20 miion units a year. The table above gives the annualized foxed cost of plants The VP of SunOil wants to know what is the lowest-cost network. 1) Formulate the problem and determine the lowest-cost network (Using Excel Solver and the 2) What if a plant must be built in Europe? Specify the constraintis) that should be added to the 3) What if plants must be built in every market? Specify the constraints) that should be added to provided Excel file) model and use the solver to answer the question the model and use the solver to answer the question Sunol is a manufacturer of petrochemical products with worldwide sales in ive regions: North South America, furope, Africa and Asia. The available data are shown in the table below Lew Fixed 5 3 America 90 100 4,500 95 19 111 6500 6750 9,710 10 6 150 4,000 Note that all the variable costs are in thousands of dollars. Sunoil is considering two plant sizes in each ocation Low-capacity plants can produce 10 million units a year while high capacity plants can produce 20 miion units a year. The table above gives the annualized foxed cost of plants The VP of SunOil wants to know what is the lowest-cost network. 1) Formulate the problem and determine the lowest-cost network (Using Excel Solver and the 2) What if a plant must be built in Europe? Specify the constraintis) that should be added to the 3) What if plants must be built in every market? Specify the constraints) that should be added to provided Excel file) model and use the solver to answer the question the model and use the solver to answer the