Minimize the cost of purchasing the needed computers

Assignment Help Operation Management

Reference no: EM132129108

Show your work with Excel and Solver:

State University must purchase 1300 computers from three vendors. Vendor 1 charges $600 per computer plus a total delivery charge of $5,000. Vendor 2 charges $400 per computer plus a total delivery charge of $4,000. Vendor 3 charges $300 per computer plus a total delivery charge of $6,000. Vendor 1 will sell the university at most 500 computers, vendor 2, at most 900, and vendor 3, at most 600. The minimum order from a vendor is 200 computers. Determine how to minimize the cost of purchasing the needed computers.

Interpretation “a” - Each vendor must supply at least the minimum. Hence all vendors are used and all delivery charges are incurred.

Interpretation “b” - Each vendor must supply at least the minimum only if that vendor is used. Hence delivery charges are incurred only for those vendors used. Hint - A fixed cost can be modeled by using a binary integer variable (to be discussed in class).

Reference no: EM132129108

Questions Cloud

What are the different types of internet of things devices : What are the different types of Internet of Things devices?

School baseball game at local high school baseball field : Robin attended a high school baseball game at the local high school baseball field.

Describe the geographic segmentation variables : Describe the Geographic segmentation variables that the LeBron 15 shoe is used to target their customers vs a dress shoe. How are they different from each other

ERP solution have on company network infrastructure : What effect would an ERP solution have on company's network infrastructure?

Minimize the cost of purchasing the needed computers : The minimum order from a vendor is 200 computers. Determine how to minimize the cost of purchasing the needed computers.

Sells radio frequency inventory tags : National Scan Inc. sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

Under the current salary payment scheme : Why might one stockbroker be willing to help another under the current salary payment scheme? What do they get out of it?

Prepare forecast for september : A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. Prepare a forecast for September.

Which legislatures are free to criminalize speech : Share your understanding of the extent to which legislatures are free to criminalize speech on particular topics and then explain the speech categories

User Account

All Pages