1. XYZ Industries manufactures several lines of decorative and functional metal items. The most recent resent order has been for 1200 door lock units for an apartment complex developer. The sales and production department must work together to determine delivery schedules. Each lock unit consists of three components: the knob and face plate, the actual lock itself, and a set of two keys. Although the processes used in the manufacture of the three components vary, there are three areas where the production manager is concerned about the availability of resources. These three areas, their usage by the three components, and their availability are detailed in the table A quick look at the amounts available confirms that XYZ does not have the resources to fill this contract. A subcontractor, who can make an unlimited number of each of the three components, quotes the price below. Develop a linear programming model that would tell Larkin how to fill the order for 1200 lock sets at the minimum cost. Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. (Submit the complete Solver File)