It is an essay. Read carefully before writing and look at the questions at the end. Can u give me the solution with excel?

Specialty Number Fees Maximum Salary 1 12 150 $ 20 days 200/day 2 8 200 $ 25 days 210/day a) Formulate a linear model to determine how many employees in each specialty CIGER will need to hire to minimize its production costs and how it will need to allocate them (30 points) b) Solve the model using the SEP method and give the enumeration tree. (20 points) Question 2 (50 points) A small municipality is divided into four sectors where household waste is collected five days a week, Monday through Friday. These frequent collections are costly to the city, but the pressure from environmentalists is strong and residents are proud to say they live in the most environmentally friendly city in the world. Once collected, the waste is taken to two transfer stations where it is transferred to heavier trucks and finally taken to three landfills. The following table summarizes the data relevant to waste transportation. S1 52 53 $4 D1 D2 D3 Min Max Cost T1 15 12 18 11 3 7 5 30 70 8 T2 9 7 8 6 2 8 7 30 60 12 Min 10 20 22 30 20 20 20 Max 10 20 22 30 50 60 40 Cost 3 5Here is how to interpret the entries in this table. The first seven columns, S1 through D3, are associated with areas of the city and landfills; the T1 and T2 lines are associated with transfer centers. Consider the row Ti(i=1,2). In the column Sj (j=1, 2, 3, 4) we find the transport cost (in euros per ton) of the waste from the sector Sj to the center Ti, and in the column Dj (j=1, 2, 3) the transport cost (in euros per ton) from Ti to Dj The Min and Max lines indicate the minimum and maximum quantities (in tons per day) of waste that can be collected in the different sectors, or that can be received by the landfills, while the Cost line gives the processing cost (in euros per ton) of the waste at each of the sites. Similarly, the values in the Min and Max columns correspond to the minimum and maximum capacities (in tons per day) of the T1 and T2 centers; those in the last column correspond to the transshipment cost (in euros per ton) of waste at the T1 and T2 centers. Note that the minimums and maximums in columns $1 to $4 coincide: that is, city officials found that the actual amount of waste collected in each sector varies little from day to day and decided, for the purposes of analysis, to take the minimum and maximum for a sector to be the average observed in that sector in the last year. City officials were asked to develop an optimal waste hauling policy. Determine a cost-effective waste hauling plan using an appropriate network.Question 1 (50 points) CIGER has just been awarded a major supply contract for the Post Ofce Department. It must deliver, within a month, 8,0[i units of a and 12,[i units of B. The firm does not currently have any workers to assign to these productions and it has no stock of these products. CIGER will therefore have to hire workers from two specialties if it wants to deliver the required productions within the given time frame. Workers from each specialty can be assigned to either production, although the productivity of workers from specialty 1 is higher when assigned to the production of product a, just as the productivity of workers from specialty 2 is higher when assigned to the production of product E5. The following table shows the number of units of it or B produced in one day by an employee in each specialty who is assigned all day to the production of only one of the products. Finally, an employee in specialty 1 who, for example, divides his workday equally between the production of i1 and B, produces 3*:- units of e and 34 units of B. Production in an exclusive situation CIGER explored the hiring market and was only able to nd a few candidates interested in applying. The following table provides information on these candidates: rst, the number of candidates found; second, Ihe hiring fees {in $fcandidate]; third, the maximum number of days the candidates would be willing to work; and fourth, the salary (in $fday). as soon as the required production is assured, the workers will be laid off