Given the following problem statement:
1. Define the decision variables, objective function, and constraints as listed in the LP Model Formulation Steps section. Insert answers per guidance and highlight cell in light green.
2. Use the results of the LP Model Formulation Steps to create an Objective Table and Constraint Table in the Results section.
3. Solve the Linear Programming Problem using "Solver."
4. Create a Answer Report.
5. Create a Sensitivity Report.
6. Create a Limits Report.
Variables
Problem Statement
A company manufactures airconditioners and fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each airconditioner takes 3 hours of wiring and 2 hours of drilling. Each must go through 2 hours of wiring and 1 hour of drilling. During the next production period, the 240 hours of wiring time is available, and up to 140 hours of drilling time may be used. Each airconditioner sold yields a profit of $25. Each fan yields a profit of $15. Determine a production mix of airconditioners and fans to maxmize profit.
Table 1.
Product Resource Requirements
Resources	Air conditioner	Fan	Total available
Drilling time (hrs)	2	1	140
Wiring time (hrs)	3	2	240
Profit ($)	25	15
LP Model Formulation Steps
1. Define the decision variables - one variable per row. Format: Variable label = Variable name
	A= Air conditioners
	F= Fans
2. Define the objective function - Format: Max/Min = equation using variable labels and values
	Maximize Profit= 25*A + 15*F
3. Define the constraints - one constraint per row. Provide a title for the constraint. Format = Title: equation
	Drilling time: 2*A + 1*F <= 140
	Wiring time: 3*A + 2*F <= 240
Results
Objective Table
	Decision Variables
	Air conditioner	Fan	Maximize Profit
Objective Function	25	15
Production Units	40	60	1900.00
Constraints Table
			Cell Reference	See Table Above	Constraint
Constraint Variables	Technical Coefficients	LHS (units used)	Constraint Sign	RHS (constraint)	Slack (-) or Surplus (+)
Drilling time	2	1	140	<=	140	0
Wiring time	3	2	240	<=	240	0
Answer Report
Instructions
1. Relabel the "Answer Report" tab to "Task 4_Answer Report"
2. Place immediately after the "Task 4_MinAndReports" tab.
	Questions to interpret the results of the Answer Report	Type answer in the box
	1. What is the maximum profit?	1900
	2. How many units of surplus are available for wiring time?	0
	3. How many units of slack are available for drilling time?	0
	4. Which ingredients are binding?	Drilling & Wiring
	5. Which ingredients are not binding?	None
Sensitivity Report
Instructions
1. Relabel the "Sensitivity Report" tab to "Task 4_Sensitivity Report"
2. Place immediately after the "Task 4_Answer Report" tab.
	Questions to interpret the results of the Sensitivity Report	Type answer in the box
	6. What is the allowable increase in fans's reduced cost?	1.6666
	7. What is the allowable decrease in air conditioner's reduced cost?	2.5
	8. What is the fan's reduced cost?	0
	9. What is the allowable increase in wiring time's shadow price?	40
	10. What is the allowable decrease in drilling time's shadow price?	20
	11. What is drilling time's shadow price?	5
Limits Report
Instructions
1. Relabel the "Limits Report" tab to "Task 4_Limits Report"
2. Place immediately after the "Task 4_Sensitivity Report" tab.
	Questions to interpret the results of the Limits Report	Type answer in the box
	12. What is the lower limit for fans?	0
	13. What is the upper limit for air conditioners?	40
	14. What is the upper limit objective function value for air conditioners?	`1900