1. Najjar Co. manufactures office desks at three locations: Ajman, Fujairah and Khor Fakkan. Each plant is able to supply the following number of units, Ajman 100 units, Fujairah 300 units and Khor Fakkan 300 units. Najjar distributes the desks through regional warehouses located in Dubai, Sharjah and Ras El Khaimah. The distribution requires the following units; Dubai 300 units, Sharjah 200 units, and Ras El Khaimah 200 units.

Production costs are the same at the three factories so the only relevant costs are shipping from each source to each destination. Costs are constant no matter the quantity shipped

Restrictions regarding factory capacities and warehouse requirements must be observed. Using Excel to demonstrate the understanding of the application of Solver in Network Models, select the optimal shipping routes to be used and the number of desks to be shipped on each route to minimize total transportation cost Rubrics: a) Present a table that shows the decision variables, and the constraints (4 points) b) Present the Decision function (2 points) c) Present the optimal solution identifying the routes, shipments and total cost (4 points)