Question

In: Operations Management

Please submit your solutions as ONE single workbook with the sheets clearly labelled to indicate the...

Please submit your solutions as ONE single workbook with the sheets clearly labelled to indicate the corresponding problem numbers as indicated on this test.

• For each problem, you are required to use a textbox to show the definition of your decision variables. You may include this textbox only with part a) of the problem if the following parts do not require additional variables to reformulate.

• If a problem requires sensitivity analysis, re-order the worksheets so that they appear in the order of the questions.

• Answers to the questions should be clearly described in a separate textbox of the corresponding labelled worksheets. Since you will only be credited with problems that have correct answers, please check carefully your report textbox.

• For each problem formulation, please highlight the decision variables in Yellow, the constriants (Left Hand Side) in Blue, and the Objective function in Red.

4)​The relevant project data are given as follows.

Activity

Predecessor(s)

Normal time (weeks)

Crash time

Normal cost

Crash cost

Possible number of weeks to crash

Cost/week to expedite

A

--

7

6

$7,000

$8,000

B

A

2

1

5,000

7,000

C

A

4

3

9,000

10,200

D

B,C

5

4

3,000

4,500

E

D

2

1

2,000

3,000

F

D

4

2

4,000

7,000

G

E,F

5

4

5,000

8,000

a) ​Draw the AOA (Activity-On-Arc) diagram as shown in Chapter 13's Excel Worksheets.

b) ​Formulate the problem of finding project completion time as a LP problem. [You would only need the first 3 columns of the table and the diagram from a) to do the job!]

c) ​Reformulate the problem when crashing the project completion time of 3 weeks is required. That is, reformulate the problem when the project completion time is required to be shorted by 3 weeks. Obviously, crashing is based on shortening the project completion time by 3 weeks with the minimal additional cost. In order to formulate the problem, you need to fill in the blank columns of the table.]

Solutions

Expert Solution

b) LP formulation to find the project completion time is following:

Let each alphabet denote the earliest completion time of respective activity. and T be the final project completion time.

Minimize T

s.t.

A >= 7

B - A >= 2

C - A >= 4

D - B >= 5

D - C >= 5

E - D >= 2

F - D >= 4

G - E >= 5

G - F >= 5

T - G >= 0

A, B, C, D, E, F, G, T >= 0

c) The completed table is following:

c) LP formulation to find the lowest cost to shorten the project completion time by 3 weeks is following:

Let each alphabet denote the earliest completion time of respective activity. and T be the final project completion time.

and, Xa, Xb, Xc, .... Xg be the number of weeks that respective is crashed by

Minimize 1000Xa+2000Xb+1200Xc+1500Xd+1000Xe+1500Xf+3000Xg

s.t.

A+Xa >= 7

B - A + Xb >= 2

C - A + Xc >= 4

D - B + Xd >= 5

D - C + Xd >= 5

E - D + Xe >= 2

F - D + Xf >= 4

G - E + Xg >= 5

G - F + Xg >= 5

T - G >= 3

Xa <= 1

Xb <= 1

Xc <= 1

Xd <= 1

Xe <= 1

Xf <= 2

Xg <= 1

A, B, C, D, E, F, G, T, Xa, Xb, Xc, Xd, Xe, Xf, Xg >= 0


Related Solutions

Please submit your solutions as ONE single workbook with the sheets clearly labelled to indicate the...
Please submit your solutions as ONE single workbook with the sheets clearly labelled to indicate the corresponding problem numbers as indicated on this test. • For each problem, you are required to use a textbox to show the definition of your decision variables. You may include this textbox only with part a) of the problem if the following parts do not require additional variables to reformulate. • If a problem requires sensitivity analysis, re-order the worksheets so that they appear...
QUESTION ONE (a) With the aid of a clearly labelled diagram, critically analyse the implications of...
QUESTION ONE (a) With the aid of a clearly labelled diagram, critically analyse the implications of a small nation, Mazyopa Republic, imposing a 100 percent ad valorem tariff on the commodity of its comparative disadvantage. [30 Marks] (b) Briefly describe the Leontief Paradox. What explanations were drawn from the paradox [20 Marks] [TOTAL: 50 MARKS]
Please provide solutions to the following problems. Please use Excel to solve the problems and submit...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit the Excel spreadsheet. A fair coin is tossed 15 times, calculate the probability of getting 0 heads or 15 heads A biased coin with probability of head being .6 is tossed 12 times. What is the probability that number of head would more than 4 but less than or equal to 10. You have a biased dice (with six faces numbered 1,2,3,4,5 and 6)...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit...
Please provide solutions to the following problems. Please use Excel to solve the problems and submit the Excel spreadsheet. You started a new restaurant. Based on invoices for the first 30 days, you estimated your average grocery bill to be $20,000 with a standard deviation of $2000. You want to start another restaurant in a similar neighborhood and you are planning to prepare a brochure for investors and to work out a deal with a whole sale food distributor. Prepare...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon 9% Maturity date   2027 Interest paid semiannually...
Your essay must be written concisely and not exceed 700 words. Indicate your choice clearly Discuss...
Your essay must be written concisely and not exceed 700 words. Indicate your choice clearly Discuss the possible impact of budget deficits on interest rates and private investment in small island economies in the Pacific.
*Please clearly indicate which answer is for what part.* Tim suffered greatly this year. In January...
*Please clearly indicate which answer is for what part.* Tim suffered greatly this year. In January a freak storm damaged his sailboat and in July Tim's motorcycle was stolen from his vacation home. Tim originally paid $30,600 for the boat, but he was able to repair the damage for $7,050. Tim paid $18,050 for the motorcycle, but it was worth $19,600 before it was stolen. Insurance reimbursed $1,540 for the boat repairs and the cycle was uninsured. a. Calculate Tim's...
Use Python to Complete the following on a single text file and submit your code and...
Use Python to Complete the following on a single text file and submit your code and your output as separate documents. For each problem create the necessary list objects and write code to perform the following examples: Sum all the items in a list. Multiply all the items in a list. Get the largest number from a list. Get the smallest number from a list. Remove duplicates from a list. Check a list is empty or not. Clone or copy...
Please submit as a single Excel file. To receive credit, appropriate detail needs to be provided....
Please submit as a single Excel file. To receive credit, appropriate detail needs to be provided. In addition, a professional presentation of findings is important. #1       Determine the total cost for this plan given the following forecast: Month 1 2       3       4       5       6 Forecast 380   400   420   440   460   480 Use steady regular output of 400 units per month, use overtime as needed for up to 40 units per month, and use subcontracting to make up any needed...
Complete the “July Journal Entries” tab in your workbook using the Step One data in the...
Complete the “July Journal Entries” tab in your workbook using the Step One data in the appendix. The following events occur in July, 2018: July 1: You take $10,000 from your personal savings account and buy common stock in Peyton Approved. July 1: Purchase $6,500 in baking supplies from vendor, on account. July 3: Your parents lend the company $10,000 cash in exchange for a two-year, 6% note payable. Interest and the principal are repayable at maturity. July 7: Enter...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT