Examlex
Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver.
The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection process.
Min 200x1 + 250x2 + 225x3 + 190x4 +215x5 + 245x6 + 235x7 + 220x8
s.t. x1 + x2 + x5 + x7 ? 1 {Building A constraint}
X1 + x2 + x3 ? 1 {Building B constraint}
X6 + x8 ? 1 {Building C constraint}
X1 + x4 + x7 ? 1 {Building D constraint}
X2 + x7 ? 1 {Building E constraint}
X3 + x8 ? 1 {Building F constraint}
X2 + x5 + x7 ? 1 {Building G constraint}
X1 + x4 + x6 ? 1 {Building H constraint}
X1 + x6 + x8 ? 1 {Building I constraint}
X1 + x2 + x7 ? 1 {Building J constraint}
Set up the problem in Excel and find the optimal solution. Which crews are selected?
Company's Records
Documentation and files that contain important information about a company's operations, financial transactions, and legal obligations.
Outstanding Checks
Checks that have been written and recorded in the issuing entity's accounting system but not yet cashed or cleared by the bank.
Bank Statement
A document issued by a bank detailing all transactions in an account over a specified period, including deposits, withdrawals, and fees.
Bank Reconciliation
The process of comparing and matching figures from the accounting records against those presented on a bank statement to ensure they are consistent and accurate.
Q20: The text suggests that before putting any
Q21: Changing the objective function coefficients may or
Q25: A firm has prepared the following
Q26: Evolutionary Solver is often faster than the
Q31: Variable cells<br> <span class="ql-formula" data-value="\begin{array} {
Q35: When Ellen watches films, she interprets the
Q44: When evaluating a project to determine the
Q52: A parameter analysis report can be used
Q68: To determine if an increase in an
Q69: When binary variables are used in a