You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Cliente A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Now consider that each employee can carry out at most three jobs during the day. State and solve the problem thorugh excel solver.

You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Cliente A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Now consider that each employee can carry out at most three jobs during the day. State and solve the problem thorugh excel solver.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

JOHNSON’S RULE Five specialty jobs at a La Crosse, Wisconsin, tool and die shop must be processed through two workcenters (drill press and lathe). The time for processing each job follows:Work (processing) Time for Jobs (hours)JOBWORK CENTER 1(DRILL PRESS) WORK CENTER 2(LATHE)A5 2B3 6C8 4D 10 7E 7 12
The Safe Zone Restaurant, a 24-hour restaurant, faces changing requirements from hour to hour. More workers are needed for peak hours, and fewer are needed in between. The following table shows the worker requirement for the first 12 hours in the restaurant: Table 8. Staff Requirement at the Safe Zone Restaurant Time Period 10 11 12 1 PM|2 PM|3 PM|4 PM|5 PM|6 PM 7 PM|8 PM|9 PM АM | АM | РМ Requirement 7 Assigned On Duty Overstaffed 9 10 10 8 6 6. 8 8 12 12 8 a) You are required to apply the first-hour principle to staff each hour with the required number of cafeteria staff, showing how many staff are on duty each given hour, the number of staff you have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts. ii. Schedule the staff to work in 4-hour shifts. b) Indicate with at least one reason, which schedule would be more optimal from an Operations Scheduling perspective?
The Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. Use different colors to distinguish the data.
Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line (i.e., a machine-paced line flow). Each worker must perform at least one task. There exists unlimited demand unless stated otherwise. Time to Complete Task (seconds): Task 1: 30 Task 2: 25 Task 3: 15 Task 4: 20 Task 5: 15 Task 6: 20 Task 7: 50 Task 8: 15 Task 9: 20 Task 10: 25 Task 11: 15 Task 12: 20 The current conveyor-paced assembly-line configuration assigns the workers in the following way: • Worker 1: Tasks 1, 2, 3 • Worker 2: Tasks 4, 5, 6 • Worker 3: Tasks 7, 8, 9 • Worker 4: Tasks 10, 11, 12 What is the direct labor content (in seconds per unit)?
The Mechanical Engineering department has a student team that is designing a formula car for national competition. The time required for the team to assemble the first car is 100 hours. Their improvement (or learning rate) is 0.8, which means that as output is doubled, their time to assemble a car is reduced by 20%. Use this information to determine: the time it will take the team to assemble the 10th car. Create an excel spreadsheet having the following table. You must show the formula used in the excel sheets to calculate values in the columns. Plot Number of Units vs Time (in hours) and Number of Units vs Cumulative Time (in hours) in the same plot. N (no of Units) Time to Produce Nth Cumulative Time (1 to N) 1 2 3 4 5 6 7 8 9 10
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Client A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 b) Now consider that each employee must carry out at least one job during the day. State and solve the problem throught excel solver
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Client A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Solve it through excel solver.
William Beebe owns a small shoe store. He has 10 pairs of shoes that requireresoling and polishing. He has a machine that can resole one pair of shoes at atime, and the time required for the operation varies with the type and condition of theshoe and the type of sole that is used. Shoes are polished on a machine dedi-cated tothis purpose as well, and polishing is always done after resoling. His assistant generally does the polishing while Mr. Beebe does the resoling. The resoling and polishingtimes (in minutes) are Shoes Resoling Time Polishing Time1 14 32 28 13 12 24 6 55 10 106 14 67 4 128 25 89 15 510 10 5In what order should the shoes be repaired in order to minimize the total makespanfor these 10 jobs?
A department has four subordinates, and four tasks to be performed. The subordinates differ inefficiency and the tasks differ in their intrinsic difficulty. His estimate of time each man wouldtake to perform each task is given in the matrix below.Job StaffTerry Jane Tom TarilJob A 18 26 17 11Job B 13 28 14 26Job C 38 19 18 15Job D 19 26 24 10Determine how the tasks should be allocated one to one man so as to minimize the total manhours
Consider a manufacturing process depicted by the following flowchart. A1 B: 4 minutes A2 A3 B Either of C1 and C2: 2 minutes. C1 Station A has 3 parallel operators, A1, A2, and A3. Station C has 2 parallel operators, C1 and C2. Each unit only needs to be processed by one of the operators A1, A2 and A3. After being processed at Station B, a unit then needs to be processed by either C1 or C2. The process time of the individual operators are given as follows. Each of A1, A2, and A3: 20 minutes C2 What is the capacity (in units/hour) of the whole process? Round your final answer to 2 decimal places if it is not a whole number.
Tasty Tim’s is a specialty taco restaurant. The following tasks are required for the successful assembly of a Tasty taco (times are in seconds per taco): Chop and trim meat – 30 Chop vegetables – 20 Grill meat – 240 Grill vegetables – 180 Prepare toppings - Lettuce - 10 - Tomato - 15 - Guacamole - 40 Assemble taco - Add meat - 5 - Add vegetables - 5 - Add cheese - 5 - Add toppings - 10 Wrap taco - 20 During the lunch hour, Tasty Tim’s encounters demand for 120 tacos. What is the Takt time (in seconds/unit) takt time for Tasty Tim’s taco shop?
Adham is the HR manager at XYZ Company since 2013. Adham successfully performs various HR activities including recruitment, selection, appraisal, pay, and so forth. However, when it comes to performing job analysis tasks, he always seeks the assistance of an HR external consultant. Adham has lately been preparing information relating to the "digital marketing expert" vacancy. He has mentioned that the candidate is expected to: (1) hold a bachelor's degree in marketing, (2) have two years of experience in the digital marketing field, and (3) be fluent in English and French. Once Adham finished preparing the necessary information, he contacted the HR consultant for further assistance. The scenario shows that the form of outsourcing taking place is and that the HR consultant will most likely advise Adham to place the above-mentioned points under the announcing the vacancy to the public. section before Discrete services outsourcing job specification Business process outsourcing, job…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Cliente	A	B	C	D
Arkitex	3	3	2	1
Bravia	3	3	4	3
Cúbika	4	5	6	4
Doratta	8	6	5	7
Evergreen	3	4	2	2
Fenix	5	6	3	4
Golden	3	3	1	4
Horizon	6	8	6	5
Icónika	5	5	5	5
Luxus	4	4	1	2