Business Management 2321 Case Study #3 – Version f due Thursday, April 17th, at the beginning of Recitation

Attached are five linear program formulations similar to those done in class. Input the formulations into EXCEL and use Solver to determine the optimal answer.

1. Download the EXCEL spreadsheet for Case Study 2 from Carmen

2. There is a worksheet for each of the problems.

a. The first worksheet contains a template for the Portfolio Analysis problem with the decision variables defined as column labels and the constraints defined as row labels.

• 
  Input the coefficients for the decision variables in the objective function and constraints.
  
• 
  Input the equations for the cells in the LHS column and the constants in the cells in the RHS column.
  
• 
  Run SOLVER by identifying the target cell, the changing cells, and the constraints and save the optimal solution.
  

• 
  Descriptively name the decision variables and constraints with labels with meaning to the problem (for example, don’t use X₁, X₂, etc. for the decision variables).
  
• 
  Input the coefficients for the decision variables in the objective function and constraints.
  
• 
  Input the equations for the cells in the LHS column and the constants in the cells in the RHS column.
  
• 
  Run SOLVER by identifying the target cell, the changing cells, and the constraints and save the optimal solution.
  

1. 
   Cover sheet from this document with all of the team member names (TYPED!) and signatures. (1 page portrait)
   
2. 
   Summary sheet with the answers to the 6 linear programs. (1 page portrait)
   

• 
  0.5” page margins on the top, bottom, and sides
  
• 
  Output centered vertically and horizontally. Do not increase the size of the output over 100% in an effort to fill the entire page!
  
• 
  Solution clearly identified in the spreadsheet
  
• 
  0.5” space between the title box and the solution.
  

e. Points will be deducted for excess output (there should be 9 pages total, DO NOT PRINT 2-SIDED).

1. Scheduling Aircraft

Brutus Etu is employed by Buckeye Airlines and has been given the following schedule of flights among the four cities it serves (“A”, “B”, “C”, and “D”). The numbers of passengers on each flight are in the columns with the heading “#”.