PJ Shops is planning to expand its facilities. Currently they are planning for a new manufacturing facility in Lyman. The shop they have purchased for this expansion has 50,000 square feet of useable space. The budget for the expansion project is 10,000,000. Management is attempting to allocate this space among four departments. Historical trends are shown in the following table:

Profit (sqft)      Invest (sqft)      Min. Size          Max. Size  

Grind               40.00               120                  10,000             25,000

Broach 30.00               240                  20,000             35,000

Mill                  25.00               150                  5,000              10,000

Assemble         15.00               50                   2,000              10,000

Additionally, the Grind department cannot be more than 15% larger than the Broach department

Requirement 1: provide your profit-maximizing LP formulations (state the objective function and constraints)

Requirement 2: provide the Excel Solver solution in a screen capture for the problem.