A manager has 5 subordinates and 5 tasks in his department. Each subordinate differs in efficiency. His estimate the task each would do cost given in the following table. By applying the assignment method, how the task should be allocated to his people so the total cost of his department is minimum? And how much? Cost (in thousand USD$) Task 1 2 3 4 5 Subordinate A 9 10 11 8 8 B 9 8 9 9 8 C 9 9 8 8 8 D 9 8 8 8 9 E 9 8 8 9 8

A manager has 5 subordinates and 5 tasks in his department. Each subordinate differs in efficiency. His estimate the task each would do cost given in the following table. By applying the assignment method, how the task should be allocated to his people so the total cost of his department is minimum? And how much? Cost (in thousand USD$) Task 1 2 3 4 5 Subordinate A 9 10 11 8 8 B 9 8 9 9 8 C 9 9 8 8 8 D 9 8 8 8 9 E 9 8 8 9 8

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

A company is setting up an assembly line to produce 90 units per hour. The table below identifies the work elements, times, and immediate predecessors. Work Element Time (Sec.) Immediate Predecessor(s) A 25 - B 18 A C 20 A D 5 B, C E 12 C F 8 E G 16 D, F H 12 G Use one of the heuristic decision rules described in Table below to balance the assembly line so that it will produce 90 units per hour. Clearly state the decision rule you use and complete the below table using the selected rule. Decision Rule Logic Longest work element Picking the candidate with the longest time to complete is an effort to fit in the most difficult elements first, leaving the ones with short times to “fill out” the station. Shortest work element This rule is the opposite of the longest work element rule because it gives preference in workstation assignments to those work elements that are quicker. It can be tried…
Consider a project with seven tasks. Three tasks – tasks 3, 4, and 5 – require a specific resource for completion; all needed resources must be available at the site before a task can be started. Task Duration Predecessor (s) Units of Value of Resource Completed Task Needed 3 3 10 $4000 3 1 10 S3000 3 12 $5000 1 4 7 2, 5,6 Each resource unit cost $100; no quantity discounts are available. In addition, it costs $2 per unit per time period to hold this resource in stock, and it costs $45 just to place an order for materials (independent of the number of units ordered). When should each task in the project be started and when and how many resources should be ordered to minimize total project costs? 1. 1, en en 1. 2. en
2-Al Madena Cements focus much on the quantity of resource consumed by each and every activity of the company to assign the cost of a resource to an activity or cost pool. The measure of the quantity of resource consumed by an activity.is known as: a. Resource cost driver b. Resource cost driver c. Cost Object d. None of the given options
1 Cara's clients, Emily and Dave, have just had a baby and she would like to do something nice for them. She signs them up for a baby registry that sends them a small gift. Emily and Dave will be sent information and service lists that are geared toward helping new parents. She provided their names, address and phone numbers so that they will not miss any of the activities provided in the package. Has Cara dealt with her clients appropriately? NUYLOTNQhObm1bEVKUTO90 a0 Cara did not protect her clients' privacy when she shared their personal information with the baby registry. O Cara should not make this a regular practice. Her clients will begin to expect gifts and she will not be able to sustain this. CO Cara should have set up an appointment to re-evaluate her clients' needs now that they have had a baby. 40 Cara's gift is very thoughtful and will help to build a relationship with her clients. NUTYks10TNRUQ2h0bmkbEVKUTO90
Three jobs are to be assigned to three machines. Costs for each job-machine combination appear in the table below. Find the total cost using the assignment method. Machine A Machine B Machine C Job 1 11 14 6 Job 2 8 10 11 Job 3 9 12 7 Choose the correct answer: A) 25 B) 28 C) 29 D) 21 E) 34
An R&D project in a company is working on a project to make a sample product to be displayed at an international fair in Las Vegas held in 18 months. With additional equipments, the company can make sure they make the sample in 18 months. Develop an optimal crashing time-cost solution to help the company in this project to be ready on time for the fair. C, 4 B, 3 А,5 H,7 D, 3 F, 9 G, 2 Cost per month Activity Normal Time to crash 9,000 4,000 6,000 4,000 2,000 5,000 2,000 9,000 A В C 4 E F 9. G 2 H 7 Duration Path Activity to crash (months) АВСН ADEH FGH
Based on the provided information: a) Develop an optimization model to help the manager allocate the optimal number of hours for each task. b) Express the developed model in its standard form.
What is the minimum cost of crashing the following project that Roger Solano manages at Slippery Rock University by 4 days? Normal Crash Activity Time (days) Time (days) A B C The total cost of crashing the project by 4 days is $. (Enter your response as a whole number.) E 5 8 6 5 By how many days should each activity be crashed to reduce the project completion time by 4 days? Fill in the table below. (Enter your responses as whole numbers.) 4 6 5 3 Activity A B C D E Normal Cost $800 $200 $600 $750 $1,200 Total Cost with Crashing Immediate Predecessor(s) $1,100 $400 $650 $1,500 $1,650 Each Activity Should be Reduced BY (days) AC
Today you got the budget approval from the Vice President to schedule the training session and pay Prof. Jim Salu his professional fee and reimburse him for expenses up to GH¢500.00. He will have to submit all receipts and an itemised list of expenses to be reimbursed. You cannot reimburse him if he does not have receipts. You also have to explain the mechanics of the training session. You will use the company conference room, which has a screen, flip charts an overhead projector and VCR, but you will need to reserve them if the Professor wants to use them. Write a letter to Professor Jim Salu. You do not have to persuade him since he had already informally agreed, but you do want him to look forward to the job and to do his best work.
B/U pe Activity A B D 11. A project has the activity duration and cost information indicated in the table where all times are in weeks. There is a penalty of $4,000 per week for every week the project exceeds 37 weeks. What is the lowest total cost for completing this project? Predecessor Time 18 11 A A B C E D Normal A H 12 15 3 19 Asbe de ABC' AMBBC RACE AB 7 8 12 6 Normal Cost Crash Time Crash Cost $22,000 $32,000 $62,000 $18,000 $35,000 $8,000 $23,000 $32,000 $56,000 $12,000 5 $18,000 19 $22,000 $9,000 $15,000 $5,000 $13,000 $20,000 $45,000 2 5 4
Given the data for a project in table Q3, using the following assumptions: 1. 8 hours as working day 2. The company will work all days. 3. Maximum number of workers available per day is 6 4. Activities cannot be break down 5. Budget will distributed equally per day, except for activities (B, H and L), the payment will be after two days of working: means that the first payment will be at the end of day2, then day four and so on. 6. They estimate that the work will starts on the first of November 2017 Develop a report containing the followings: Date of finish BAD O GYEK 1. 2. Early start and Slack time for each activity 3. Resource histogram 4. Cumulative Budget baseline curve 5. Interpret the final report co Table Q3 Duration (Hrs) No of Workers Budget Activity predecessor A None 48 12000 64 32000 C 16 10000 32 4. 12000 B,C 32 8000 B,C 16 6000 G B,C 16 4 10000 H. 64 16000 3. 16 4000 32 1 12000 K 32 3 16000 H. 48 1 12000 Total Budget of RM150000
10.6 This optional problem requires knowledge of statistics. Heywood Home Healthcare is evaluating a project with the following net cash flows and probabilities: Time 0 Year 1 Year 2 Year 2 Year 3 Year 4 Prob = 0.2 ($100,000) 20,000 20,000 20,000 20,000 30,000 Prob = 0.6 ($100,000) 30,000 30,000 30,000 30,000 40,000 Prob = 0.2 ($100,000) 40,000 40,000 40,000 40,000 50,000 The year 5 values include salvage value. Heywood’s corporate cost of capital is 10 percent. What is the project’s expected NPV on the basis of the scenario analysis? What is the project’s standard deviation of NPV? Assume that Heywood’s managers judge the project to have lower-than-average risk. Furthermore, the company’s policy is to adjust the corporate cost of capital up or down by 3 percentage points to account for differential risk. Is the project financially attractive?