MUST USE EXCEL AND EXCEL SOLVER.

Solve the following problem. A USAID contractor produces two sizes of cans-regular and large. The cans are produced in 12,000- can lots. The cans are processed through a stamping operation and a coating operation. The company has 30 days available for both stamping and coating. A lot of regular-size cans requires 2 days to stamp and 4 days to coat, whereas a lot of large cans requires 4 days to stamp and 2 days to coat. A lot of regular-size cans earns $800 profit, and a lot of large-size cans earns $900 profit. In order to fulfill its obligations under a shipping contract, the company must produce at least nine lots. The company wants to determine the number of lots to produce of each size can (X1 and x2) in order to maximize profit. 1. (3pts) Formulate a linear programming model for this problem. Steps: A. identify decision variables; B. write down objective function; C. write down constraints; 2. (3 pts) Solve this model by using graphical analysis performed in class. Steps: A. Plot constraints ; B. List corner points; C. Identify values of the decision variables in the corner points; D. Calculate value of the objective function in the corner point; E. Chose optimal decision; F. Write down decision (in words). Draw graphs accurately using a ruler. Points will be deducted for negligence. You may want to use MS Word drawing tool or Paint graphical editor or Excel to draw the graph; You can plot