Here is the question I am having difficulty in finding the answers to. The data is listed in paragraph and I have to complete the chart in Task 2 with information listed in paragraph and chart above labled 1. Please help

MMIS 671 Homework 1. Constrained Optimization Problems A company produces 3 types of cables: A, B, and C. In-house production costs per foot of cables A, B, and C are $6, $8, and $10, respectively. The production process requires 5 resources: Drawing, Annealing, Stranding, Extrusion, and Assembly. For each resource, the table below specifies the number of minutes of the resource needed to produce a foot of each type of cable. For example, to produce each foot of Cable C, we need 0.1 minutes of Drawing, 0.2 minutes of Annealing, 0.3 minutes of Stranding, 0.1 minutes of Extrusion, and 0.4 minutes of Assembly. The column Available hours, specifies the number of hours of each resource available during a production period. For the next production period the firm is contractually obligated to produce 60,000 feet of A, 40,000 feet of B, and 120,000 feet of C. Due to limited resource availability, these demands cannot be met by in-house production alone. The company must procure cables from an outsourcing partner, at higher costs, to meet the demand. The costs per foot for purchasing cables A, B, and C from the outsourcing partner are $8, $10, and $15, respectively. The production manager must decide how much of each type of cable to produce in-house and how much to purchase from the outsourcing partner to meet the demands at minimum cost. Relevant data is summarized in the table below: A B C Available hours 60,000 $6 $8 40,000 $8 $10 Cable Type Demand (ft) Production Cost/ft Purchase Cost/ft Drawing (mins/ft) Annealing (mins/ft) Stranding (mins/ft) Extrusion (mins/ft) Assembly (mins/ft) 120,000 $10 $15 0.1 0.1 0.2 400 0.1 0.2 0.2 600 0.1 0.3 0.3 800 0.1 0.1 500 0.3 0.1 0.2 0.4 1000 Task 2. Solve the LP and report your optimal solutions. (4 Points) Minimum cost attainable = $ Decision variable values under optimal solutions: B C Cable Type Produce (feet) Procure (feet) Resource use: Under the columns "Used and Not Used, specify the number of minutes of each resource used, and left unused, under the optimal solution. Resource Used (minutes) Not Used (minutes) Drawing Annealing Stranding Extrusion Assembly Available (minutes) 24,000 36,000 48,000 30,000 60,000