Linear programming

Linear programming
I. Optimize the following information using linear programing and a mathematical model, linear programing softwares to be used are the following lingo and excel solver.
II. information
The following Data can be retrieved from the information provided:

• The problem would be determine products quantities that can be produced each month in order to satisfy the total demand
• The planning horizon for the company will be: 4 months, June, July, August, September.
• There are three product: roof vaults, interior wall panel, and exterior wall panel.
• Product initial stocks = 0
• Maintenance cost per period & unit: 5% of the unit cost
• Unit cost (production): 22 for the roof vaults, 35 for interior wall panels, and 45 for exterior wall panel
• Demand:
month product
roof vaults interior wall panel exterior wall panel
June 1500 350 150
July 1000 200 150
August 1200 250 150
September 500 150 250
total 4200 950 700
• Capacity:
month
labor hours available machinery hours available
June 2300 3300
July 2300 3300
August 2300 3300
September 2300 3300

• Required resources for each product:
hours roof vaults interior wall panel exterior wall panel
machinery hours 2 4 5
labor hours 1.5 2 3