Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Reconsider the California Manufacturing Co. case study presented in Section 7.1. The mayor of San Diego now has contacted the companys president, Armando Ortega, to

Reconsider the California Manufacturing Co. case study presented in Section 7.1. The mayor of San Diego now has contacted the companys president, Armando Ortega, to try to persuade him to build a factory and perhaps a warehouse in that city. With the tax incentives being offered the company, Armandos staff estimates that the net present value of building a factory in San Diego would be $6.1 million and the amount of capital required to do this would be $3.5 million. The net present value of building a warehouse there would be $5.5 million and the capital required would be $3.2 million. (This option will only be considered if a factory also is being built there.) Armando has asked Steve Chan to revise his previous management science study to incorporate these new alternatives into the overall problem. The objective still is to find the feasible combination of investments that maximizes the total net present value, given that the amount of capital available for these investments is $10.2 million. a. Formulate a BIP model in algebraic form for this problem. (Please clearly define all the decision variables, clearly write down the objective function and each constraints) b. Formulate and solve this model on a spreadsheet.

image text in transcribed

Please show how to solve in solver. Thanks!

Time Periods Covered by Shift Time Period 1 2 3 4 5 Minimum Number of Agents Needed 6:00 AM to 8:00 AM 45 8:00 AM to 10:00 AM 75 10:00 AM to 60 noon Noon to 2:00 PM 81 2:00 PM to 4:00 PM 64 4:00 PM to 6:00 PM 73 6:00 PM to 8:00 PM 82 8:00 PM to 10:00 PM 42 10:00 PM to midnight 52 Midnight to 6:00 AM 16 Daily cost per agent $172 $150 $165 $181 $190

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Assurance And Risk

Authors: W Robert Knechel, Steven E Salterio

4th Edition

1315531720, 9781315531724

More Books

Students also viewed these Accounting questions