Linear Programming Product Mix with SolverA company makes do…

Lineаr Prоgrаmming Prоduct Mix with SоlverA compаny makes doors and windows. Each door earns $300 profit, and each window earns $500 profit.Resource usage and weekly availability are: Plant Door Hours Window Hours Available Hours Plant 1 1 0 4 Plant 2 0 2 12 Plant 3 3 2 18 Let D = number of doors and W = number of windows. Use Excel Solver to maximize:300D+500Wsubject to the plant-hour constraints and nonnegativity. What is the optimal solution?Source: Adapted from the Wyndor Glass product-mix example, Chapter 5.