All of your problems can be solved using the Excel Solver feature. I am sharing all the solutions in the attached Excel File and giving brief instructions so you can learn how to solve them yourself.
Follow these steps:
Create an Excel workbook and set up a table with the following columns: "Product," "Wiring (hours)," "Drilling (hours)," and "Profit."
Enter the product names (Air Conditioner and Heater), their respective wiring and drilling requirements, and the profit for each product.
In a new row, specify the total available wiring and drilling hours (240 and 140, respectively).
Calculate the total profit using the SUMPRODUCT function for each product's profit and production quantity.
Create cells to input the number of Air Conditioners and Heaters to be produced.
Set constraints for wiring and drilling hours to ensure they do not exceed the available hours.
Click "Solve" in the Solver Parameters dialog to find the optimal solution.
The solver will determine the number of Air Conditioners and Heaters to produce, as well as the optimal profit value.
In this problem, I have used the Excel solver to get the minimum cost. You can use the heuristic northwest corner method. For this, you will start inserting values in cell range B10:D12 from cell B10, and you have to insert values using your guess.
Also, in this case, I have used the Excel Solver. But you can insert values manually.
If you have any further queries, please inform us in the reply. Thanks.