Answered You can hire a professional tutor to get the answer.

QUESTION

I NEED THE EXCEL SHEET SOLVER FOR THE TWO EXERCISE 4 (a) Starting from the basic models in (a), we will build more advanced models in the subsequent...

I NEED THE EXCEL SHEET SOLVER FOR THE TWO EXERCISE4(a)Starting from the basic models in (a), we will build more advanced models in the subsequent parts of this question. Prior to merger, Sleekfon and Sturdyfon operate independently, and so we need to build separate models for each of them.Optimization model for Sleekfon:= 3: Sleekfon production facilities.= 7: number of regional markets.Dj = Annual market size of regional market jKi = maximum possible capacity of production facility i= Variable cost of producing, transporting and duty from facility i to market j= Annual fixed cost of facility ixij = Number of units from facility i to regional market j.It should be integral and non-negative.Please note that we need to calculate the variable cost cij before we plug it into the optimization model. Variable cost cij is calculated as follows:cij = production cost per unit at facility i + transportation cost per unit from facility i to market j + duty*( production cost per unit at facility i + transportation cost per unit from facility i to market j + fixed cost per unit of capacity)SYMBOL

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question