A company manufactures two products on two machines. The number of hours of machine time and labour depends on the machine and product as shown below. The cost of producing a unit of each product depends on which machine produces it and these unit costs are also given. There are 200 hours available on each of the two machines and there are 400 labour hours available (NB: 400 hours are a total across the two machines). This month at least 200 units of product 1 and at least 240 units of product 2 must be produced. Also, at least half of the product 1 requirement must be made on machine 1 and at least half of the product 2 requirement must be made on machine 2.

1. Determine how the company can minimize the cost of meeting this month's requirements
2. Use two-way SoverTable to see how much the "at least half" requirements are costing the company. By changing both requirements from "at least half" to "at least x percent", where x ranges from 0% to 50% in increments of 5%.

Please provide a detailed step-by-step answer with all the formula and solver used in the process as well as column letters and row numbers, thank you in advance.

2 3 A B D E 1 Production on two machines data 2 3 Product 1 Product 2 4 Machine 1 Machine 2 Machine 1 Machine 2 5 Machine time 0.70 0.80 0.75 0.90 6 Labor 0.75 1.20 0.75 1.00 7 Unit costs $1.50 $2.20 $0.40 $4.00