15.26. The Best Wheels Bicycle Company has scheduled the produc- tion of the following bicycles this month: Week Model 1 2 3 4 [B2610] 26-inch 10-speed 50 100 195 150 [B2003] 20-inch 3-speed 15 30 65 45 [B2001] 20-inch 1-speed 20 40 80 60 The two critical work centers for producing these bikes are welding and assembly. Welding has an efficiency of 95% and a utilization of 90%. Assembly has an efficiency of 90% and a utilization of 92%. The time required (in hours) by each bike in the two work centers is as follows: Welding Assembly B2610 0.20 0.18 B2003 0.15 0.15 B2001 0.07 0.10

15.26. The Best Wheels Bicycle Company has scheduled the produc- tion of the following bicycles this month: Week Model 1 2 3 4 [B2610] 26-inch 10-speed 50 100 195 150 [B2003] 20-inch 3-speed 15 30 65 45 [B2001] 20-inch 1-speed 20 40 80 60 The two critical work centers for producing these bikes are welding and assembly. Welding has an efficiency of 95% and a utilization of 90%. Assembly has an efficiency of 90% and a utilization of 92%. The time required (in hours) by each bike in the two work centers is as follows: Welding Assembly B2610 0.20 0.18 B2003 0.15 0.15 B2001 0.07 0.10

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A #2 pencil (P) is made from a wood subassembly (WS), a band (B) to hold the eraser on and an eraser (E). The wood subassembly is made from 2 wood halves (WH) and a piece of lead (L), the wood halves are made from wood blanks (WB). (For this question we will ignore the need for glue and paint.) The lead times for each of these are given below Lead Time (Weeks) P 2 WS 4 B 6 E 2 WH 2 L 2 WB 1 If nothing is in inventory (that is, all on hand quantities are equal to zero), and it is now the beginning of period 20, then when is the earliest that we can promise to ship No. 2 pencils?
If Jose’s established rest day is scheduled on Saturdays. Jose asks the company to pay him an additional compensation of at least thirty percent (30%) of his regular wage. Is Jose correct?
The project manager of the gas station project shown inFigure 7.3 needs to change the project’s WBS so that itcan be compared with cost and productivity informationcollected by the company. Level II should be changedto General Field Administration, Earthwork, ConcreteWork, Masonry Work, Metal Work, Carpentry, and Others.Complete the WBS of this project using this new arrangementfor Level II.
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?
"Mr. X is the supervisor for a dry cement packaging company. His work crew iscomposed of unskilled workers who load large transport trucks with bags ofcement, gravel, and sand. The work is hard, and the employee turnover rate ishigh. Employees record their attendance on separate time cards. Mr. Xauthorizes payroll payments each week by signing the time cards and submittingthem to the payroll department. Payroll then prepares the paychecks and givesthem to Mr. X, who distributes them to his work crew." Is there an internal control issue or none? Justify your answer.
Karina Nieto works for New Products Inc., and one of hermany tasks is assigning new workers to departments. Thecompany recently hired six new employees and would likeeach one to be assigned to a different department. The em-ployees have completed a two-month training session ineach of the six departments from which they received theevaluations shown below (higher numbers are better).Determine how the new employees should be assigned todepartments so that overall performance is maximized.
A processor makes two components, A and B, which are then packaged together as thei nal product (each product sold contains one A and one B). The processor can do onlyone component at a time: Either it can make As or it can make Bs. There is a setup timewhen switching from A to B.Current plans are to make 100 units of component A, then 100 units of component B,then 100 units of component A, then 100 units of component B, and so forth, where thesetup and run times for each component are given below.Component Setup/Changeover Time Run Time/UnitA 5 minutes 0.2 minuteB 10 minutes 0.1 minuteAssume the packaging of the two components is totally automated and takes onlytwo seconds per unit of the i nal product. This packaging time is small enough that youcan ignore it. What is the average hourly output, in terms of the number of units of packagedproduct (which includes one component A and one component B)?
For a time study of a health insurance claims-adjusting process, the analyst uses the continuous method of recording times. The job is divided into four work elements. Shown in Figure are the performance rating factors, RF, and the continuous method recorded times, r, for each work element.a. Calculate the normal time for this job. b. Calculate the standard time for this job, assuming that the allowance is 20 percent of the normal time. c. What is the appropriate sample size for estimating the time for element 2 within {10 percent of the true mean with 95 percent confidence?
Data Products, Inc., packages and distributes a variety ofpersonal computer-related products. A time study hasbeen conducted for a job packaging 3.5-inch personalcomputer diskettes for shipment to customers. The jobrequires a packager to place 20 diskettes in a rectangularplastic bag, close the bag with a twist tie, and place thefilled bag into a bin, which is replaced by another workerwhen it is filled. The job can be broken into four basic elements. The elemental times (in minutes) were ob-tained from the time study for 10 job cycles shown in the following table. a. Using an allowance factor of 16%, determine the stan-dard time for this job. b. Determine the number of cycles for this time studysuch that the company would be 95% confident that theaverage time from the time study is within 4% of thetrue average cycle time.
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.
Given the following information on job times and due dates, determine the optimal processingsequence using (1) FCFS, (2) SPT, (3) EDD, and (4) CR. For each method, find the average jobflow time and the average job tardiness. Jobs are listed in order of arrival.JobJob Time(hours)Due Date(hours)a 3.5 7b 2.0 6c 4.5 18d 5.0 22e 2.5 4f 6.0 20
An assembly task was broken down into four elements, and timed using the continuous timing method. The resulting data and performance ratings are provided below. Calculate the total standard time for this task. Element 1 2 3 4 Watch Time 1.85 2.96 5.42 7.10 Observed Time Rating 95 105 120 115 Normal Time Total ST Standard Time