Reference no: EM133179378

Question - A small construction firm specializes in building and selling single-family homes. The firm offers two basic types of houses, Model A and Model B (in whole numbers). Model A houses require 4,000 labor hours, 2 tons of stone and 2,000 board feet of lumber. Model B houses require 10,000 hours of labor, 3 tons of stone and 2,000 board feet of lumber. The firm has currently 400,000 hours of labor, 150 tons of stone and 200,000 board feet of lumber. Model A yields $1000 profit and model B yields $2000 profit. Construct your own template and use Solver to determine how the firm can maximize its profit on Q3.