I'm trying to find the capacity of a current line (on a conveyor-paced assembly). Each worker must perform at least one task. There are 6 tasks. Time to complete each task, starting with task 1, is 30, 25, 35, 40, 15, and 30 - all in seconds. There are 4 workers. Worker 1 completes Task 1; Worker 2 completes Task 2; Worker 3 completes Tasks 3 and 4; and Worker 4 completes Task 5 and 6.
Q: 1. The working system in a hospital is divided into 8 time periods, each of which is 3 hours, as in…
A: Formulate a spreadsheet as shown below to compute the minimum number of doctors while satisfying the…
Q: A company has two CNC machines and it produces four different products. The processing times of the…
A: Here the product can be produced on machine A or machine B, and the processing time is different for…
Q: Example: suppose that three jobs must be assigned to three machines, each machine must be assigned…
A: Let n be the number of allocations, where n=3 Step 1: Subtract the lowest value in each row from…
Q: In a worker paced assembly line, consider a situation where the daily requirement has suddenly…
A: An assembly line is used to move semi-finished products from one workstation to another workstation…
Q: In the employee scheduling example, suppose the company has 25 full-time employees and is not…
A: The decision variable are the number of workers starting from 5 days shift on various days. Work…
Q: At a machine tool plant, five jobs must be completedeach day. The time it takes to do each job…
A: Given data, Job time data Times to do jobs and setup times Jobs 1 Jobs…
Q: fi Auto mobile company manufactures cars and trucks. Each vehicle must be processed in the paint…
A: Given data, GHS Profit of Cars = $40,000 GHS Profit of Trucks = $ 60,000 For producing cars,…
Q: Scheduling Bank Tellers Note: Setup example below in excel and Minimize total daily manpower cost in…
A: Time Period No. of Teller Required 9 to 10 10 10 to 11 12 10 to 12 14 12 to 1 16 1 to 2 18…
Q: The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny…
A: A) Goal 1 Minimize overutilization of plastic 2 0.36 Goal 2 Minimize overutilization…
Q: Consider a long roll of wallpaper that repeats its pattern every yard. Four sheets of wallpaper must…
A: Given data is
Q: manager must decide which model of equipment to buy, model Ana or model Bea. The equipment can be…
A: Find the Given details below: Given details: Annual Volume Processing time per function (Hr)…
Q: Sleek Sdn. Bhd. is planning on introducing 2 new stool designs (Deni & Arni) for their 2022…
A:
Q: One possible solution method for the machine-to job assignment problem is the following heuristic…
A: Yes, this heuristic provides the most efficient method of task assignment because projects done on…
Q: A bond has a face value of $1,000, an annual coupon rate of 3.70%, an yield to maturity of 7.4%,…
A: MACAULAY DURATION Using analytic…
Q: A company produces three different products; x,y, and z. For the production of 1 unit of product x,…
A: This is simplex method Linear Programming problem and I have worked on formulating the LP first,…
Q: operate, and it can produce 400 barrels of high-grade oil, 300 barrels of medium-grade oil, and 200…
A: Below is the solution:-
Q: The company wants to know how many units of each product to produce on each machine to maximize…
A: Linear programming is a mathematical technique that is commonly used in operations management…
Q: #3. Tyler bakes Cookies (C) and Breads (B) with the help of two ovens in his little bakery. The time…
A: Given- Objective: Maximize Revenue 15C + 20B St. Constraints:Oven A available: 14C + 168 <=…
Q: A company produces 3 products A, B and C processed on 3 machines P, Q, R before completion. Machine…
A: Find the given details below: Given Details: Machines Products A B C Total Hours P 25…
Q: A company is developing its weekly production plan. The company produces two products, A and B,…
A: Given data is Fixed cost of A and B = $60 and $80 Unit profit of A and B = $17 and $21
Q: Since Powell has been requested to keep the security budget at a minimum, he needs to minimize the…
A: Linear programming (LP, also known as linear optimization) is a technique for achieving the optimal…
Q: may start at 12:01 A.M., 4:01 A.M., 8:01 A.M., 12:01 P.M., 4:01 P.M., and 8:01 P.M. Thus, the vari-…
A: The excel model of linear programming contains the formulas used in the mathematical model. Based on…
Q: um cycle time is the sum of all task times when the tasks are running in parallel . Select one: a .…
A: This statement is true as the maximum cycle is the sum of all task times when the tasks are running…
Q: In a job shop operation, four jobs may be performed on any of four machines. The hours required for…
A: The hours required by each job on each machine are described in the tabular form.
Q: A catering company must have the following number of clean napkins available at the beginning of…
A: Given, Minimum Cost = 6.66 Day 1: 15 Buy Day 2: 3 Buy, 9 Fast Service Day 3: 12 Fast Service, 6 Slow…
Q: A catering company must have the following number of clean napkins available at the beginning of…
A: The catering company requires clean napkins on day 1, day 2, day 3, and day 4. In order to have…
Q: Consider the classroom CS 206. There are a variety of groups that want to use this room - CS club,…
A: * Condition given - There is a classroom named CS 206 and there are various groups that may use…
Q: Angela manages a store that sells speakers. Each Boomer takes 38 hours to create the plastic pie…
A:
Q: A small shoe manufacturer makes two styles of shoes: oxfords and loafers. Two machines are used in…
A: Let x be the no. of oxfords style shoe y be the no. of loafers style shoe The total manufacturing…
Q: A machining center has the following small jobs from five of its customers. The jobs are listed in…
A: FCFS Job Total processing time Due date (in hours) Flow time Tardiness Patel 8 5 8 3 Smith 5…
Q: At modern woodworks, president and producer of apple crates sold to growers, has been able, with his…
A: Given Information- With Current Equipment, Total crates produced per 100 logs = 240 1 log takes 3…
Q: Dalton Desk makes two different types children's desks: a regular model (R) and a deluxe model (D)…
A: R be the number of Regular model. D be the number of Deluxe model.
Q: A small firm makes three similar products, which all follow the same three-step process, consisting…
A: Excel model and formula: Solver input:
Q: A small scale industry manufactures electrical regulators, with a small group of semi-skilled…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle.…
A: Goals Description Rank Wt Goal 1 Minimize overutilization of plastic 2 0.364 Goal 2 Minimize…
Q: A book binder has one printing press, one binding machine and manuscripts of 7 different books. The…
A: Job 1 2 3 4 5 6 7 Machine M1 20 90 80 20 120 15 65 Machine M2 25 60 75 30 90 35 50 1. The…
Q: Which of the following is the key identifier of a resource-allocation problem? I. Constraints with…
A: The issue of allocation of resources emerges because of the shortage of resources and alludes to the…
Q: A paper-making company has five machines that can produce four different types of papers. The…
A: Given data is The given problem was an unbalanced matrix so to balance the matrix a dummy column is…
Q: Carefully examine the following ASSIGNMENT problem. Which of the following constraints is not true?…
A: In assignment problem we assign one job to machine to get all the job done with a minimum cost…
Q: A concession stand at an athletic event is trying to determine how much to sell cola and iced tea…
A: Demand for Cola: 100 - 30x + 5y Demand for iced tea: 50 + 3x - 16y Price per cola = x Price per iced…
Q: A production line is to be designed for a job with four tasks. The task times are 2.4 minutes, 0.4…
A: Given details: Total No. of tasks = 4 Task times: 4 minutes 4 minutes 9 minutes 7 minutes
Q: Formulate an optimization model for this problem. b) Solve the optimization model using either the…
A: Let Xjk be the binary integer such that Xjk=1 When the Employee-j is working during Hour-k for…
Q: The stemplot below displays the times, in seconds, for 25 students to run 100 meters. 100-Meter…
A: The given data is 22, 23, 23, 24, 24, 24, 25, 25, 25, 25, 26, 26, 26, 26, 26, 27, 27, 27, 28, 28,…
Q: A catering company must have the following number of clean napkins available at the beginning of…
A: Minimum Cost = 6.66 Day 1: 15 Buy Day 2: 3 Buy, 9 Fast Service Day 3: 12 Fast Service, 6 Slow…
Q: he Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny…
A:
I'm trying to find the capacity of a current line (on a conveyor-paced assembly). Each worker must perform at least one task. There are 6 tasks. Time to complete each task, starting with task 1, is 30, 25, 35, 40, 15, and 30 - all in seconds. There are 4 workers. Worker 1 completes Task 1; Worker 2 completes Task 2; Worker 3 completes Tasks 3 and 4; and Worker 4 completes Task 5 and 6.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- According to the XYZ Apartment Rental Company ER diagram, which of the following is true? Each building must have more than one builder Each building must have multiple apartments Each building must have at least 8 apartments Each building must have more than 2 apartments Answer: ____A janitorial service, Mother’s Helpers, provide workers to clean office buildings during late evening hours using workers with two skill levels, 1 and 2. Each level 1 person is paid $12 per hour and each level 2 person is paid $8 per hour. The workers wash floors and vacuum offices. Each level 1 person can vacuum 9 offices per hour, whereas level 2 person can vacuum only 2 offices per hour. Each level 1 person can wash 2 floors per hour; whereas level 2 person can wash 3 floors per hour. In order to complete a new job in the allotted time, 18 offices must be vacuumed per hour and 12 floors must be washed per hour. Use Excel and determine the number of each type of person that will be needed to complete the job within the allotted time and minimum cost and provide algebraic modelThe 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.
- 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 10Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 800 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. (a) Formulate and solve for the recommended production quantities. component 1 unitscomponent 2 unitscomponent 3 units (b) What are the objective coefficient ranges for the three components? (If there is no upper or lower limit, enter NO LIMIT. Round your answers to the nearest integer.) component 1 blank to blank units…Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder is available for 110 hours. No more than 200 units of component 3 can be sold, but up to 900 units of each of the other components can be sold. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. (a) Formulate and solve for the recommended production quantities. component 1 unitscomponent 2 unitscomponent 3 units (b) What are the objective coefficient ranges for the three components? (If there is no upper or lower limit, enter NO LIMIT. Round your answers to the nearest integer.) component 1 to unitscomponent 2 to…
- Suppose that you are a manager in an organization and your staff required laptops for their routine work you have limited budget time and certain specifications required in laptops you have to solve this problem how can you solve this problem in a sequential manner?A machine shop manufactures two types of bolts. The bolts require time on each of the three groups of machines, but the time required on each group differs, as shown in the table below. Type I Type IIMachine 1 0.2 min 0.2 minMachine 2 0.6 min 0.2 minMachine 3 0.04 min. 0.08 min Production schedules are made up one day at a time. In a day, 300, 720, and 100 minutes are available, respectively, on these machines. Type I bolts sell for 15¢ and type II bolts for 20¢. (a) How many of each type of bolt should be manufactured per day to maximize revenue?(b) What is the maximum revenue?(c) Suppose the selling price of type I bolts began to increase. Beyond what amount would this price have to increase before a different number of each type of bolts should be produced to maximize revenue?ACE Hardware wants to develop a daily schedule for its employees in one of its stores in Omaha. Currently, this store has five employees and the store is opened from 12pm to 9pm. The store must always have at least two people on hand. Each employee must work at least four hours and no more than eight hours per day. Employee #1 goes to school and cannot start before 4pm while all other employees can work at any time. Furthermore, employee #1 earns $10 per hour while all other employees earn $12 per hour. Because all five employees live so close to the store, you must assume that they need to work consecutive hours. a) Formulate an optimization model for this problem. b) Solve the optimization model using either the Microsoft Excel Solver
- Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 7 5 2 5 5 3 5 2 The shaper is available for 125 hours, and the grinder is available for 95 hours. No more than 170 units of component 3 can be sold, but up to 1050 units of each of the other components can be sold. In fact, the company already has orders for 625 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively. If more time could be made available on the grinder, how much would it be worth? If required, round your answers to two decimal places.$ _____ per minute, since the dual value is _____ on the grinder at the optimal solution.At a machine tool plant, five jobs must be completedeach day. The time it takes to do each job depends on themachine used to do the job. If a machine is used at all, thereis a setup time required. The relevant times are given inTable 20. The company’s goal is to minimize the sum of thesetup and machine operation times needed to complete alljobs. Formulate and solve (with LINDO, LINGO, or ExcelSolver) an IP whose solution will do this. Machine 1 2 3 4 5 Time (Minutes)1 42 70 93 X X 302 X 85 45 X X 403 58 X X 37 X 504 58 X 55 X 38 605 X 60 X 54 X 20The Northside Bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operation of the bank, including adequate customer service, employee breaks, and so on. On Fridays, the bank is open from 9:00 A.M. to 7:00 P.M. The number of tellers necessary to provide adequate customer service during each hour of operation is summarized here. Time No. of Tellers Time No. of Tellers 9:00 a.m.-10:00 a.m. 6 2:00 p.m.-3:00 p.m. 7 10:00 a.m.-11:00 a.m. 5 3:00 p.m.-4:00 p.m. 6 11:00 a.m.-Noon 7 4:00 p.m.-5:00 p.m. 8 Noon-1:00 p.m. 11 5:00 p.m.-6:00 p.m. 7 1:00 p.m.-2:00 p.m. 9 6:00 p.m.-7:00 p.m. 5 Each full-time employee starts on the hour and works a 4-hour shift, followed by a 1-hour break and then a 3-hour shift. Part-time employees work one 4-hour shift beginning on the hour. Considering salary and fringe benefits, full-time employees cost the bank $15 per hour ($105 a day), and part-time employees cost…