Question: Suppose a data processing department wishes to assign five programmers to five programming tasks (one programmer to each task). Management has estimated the total number

Suppose a data processing department wishes to assign five programmers to five programming tasks (one programmer to each task). Management has estimated the total number of days each programmer would take if assigned to the different jobs, and these estimates are summarized in the following table.

a. Suppose that your goal is to minimize the total programmer days required to complete all five jobs. Provide an LP formulation of this problem. Clearly define variables, constraints, and objective.

b. Use Excel Solver to solver your model.

c. Which programmer should be assigned to which task? What would be the total programmer days required?

d. Now, suppose that your goal is instead to minimize the maximum time it takes any programmer to complete their task. How would you change your model? You do not need to solve the updated model.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...

Explain how to determine the maximum or minimum value of a quadratic function.

Assume that the retaining wall shown in Figure 13.36 is frictionless. For each problem, determine the Rankine active force per unit length of the wall, the variation of active earth pressure with...

Use cash fl ow information to help analyze a company. AppendixLO1

4. Think of analogies that will make ideas easier to understand.

During the month of November the following transactions occurred. Assignment 1. Record the following transactions in the general journal and post them to the general ledger. 2. Prepare a trial...

Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget $2,982,000 $350,000 616,000 392,000 150,000 1, 508,000 1, 474,000 Sales (14,000...

Quantify the value that Carter brings to Hope. The purpose of your valuation is to educate the team on figures that will be helpful in developing a bidding strategy. There is a con- sensus that Hope...

Question 8 (2 points) Function /(x) = 3x - 4x is increasing in interval() O a) (1, OO) only O b) (-00, 0) only O c) (0, OO) only O d) (-00, 0) and (1, OO) only Oel (-00, 1) only Of) (0, 1) only

an 1800 kg vehicle travelling at 60.0km/h smashes into a concrete barrier and stops in 0.420s what is the magnitude of the collision force on the vehicle

Flo's Deli is determining how to ensure that their current process of serving customers during lunch rush is adequate. Which of the following is an example of how the restaurant can monitor its...

In an agile lifecycle, who should be involved in all overlapping sprints or releases? Select an answer: everyone on the product team the product manager only You should not overlap sprints or...

According to the concept of "position/legitimate power," the CEO has the ultimate responsibility for leading the tasks of forming, implementing, and executing a strategic plan for the whole...

Which of the following considerations is legally in sufficient? Tony bought a book for $100. Ruby offers to buy it for $10. Tony bought a text book for $100. He offers to give it to Ruby if Ruby...

Appendix 13ECalculating Risk-Based Capital Ratios 3 (continued) TABLE 1328Risk Weights for Calculating Risk-Weighted Assets for On-Balance-Sheet Items under Basel III Exposures Risk Weight (in...

QUESTION 2 The CEO of Farisha Hijab Sdn Bhd insisted on further investigation to be carried out that he also required Mr Muaz to conduct the analysis of variance for the material and labour of the...

In testing cash disbursements for the Jay Klein Company, you obtained an understanding of internal control. The controls are reasonably good, and no unusual audit problems arose in previous years....

You have been assigned to the confirmation of aged accounts receivable for the Blank Paper Company audit. You have tested the aged trial balance and selected the accounts for confirming. Before the...

Explain why auditors usually emphasize the detection of fraud in the audit of cash receipts. Is this consistent or inconsistent with the auditor's responsibility in the audit? Explain.

Demand for an item is projected to be 100 units per month. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a. Determine tire EOQ. b. If the vendor is...

Schaan Healthcare Products is a distributor of medical/surgical products in Saskatchewan. Schaan has a warehouse in Saskatoon that carries thousands of items, one of which is item #345-5870,...

A sausage factory can produce European wieners at a rate of 500 kg per day. It supplies wieners to local stores and restaurants at a steady rate of 100 kg per day. The cost to prepare the equipment...