Archives: Solution Manual
Management Chapter 13 Homework Go back through in more detail, covering low-level coding, lot-for-lot ordering, and working through a product-tree and developing a material requirements plan
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Thirteen – Inventory Management Example 13 Templates: ABC Classification System (B) Example 14a Basic Economic […]
Management Chapter 12 Homework Each job is accompanied by a set of bar codes that I.D. the job and the operation. As each operation is completed, the operator removes
Chapter 12 – MRP and ERP Week Straight Plastic Grip (LT = 2 weeks) Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements 600 Scheduled receipts On hand Net requirements 600 Planned order receipts 600 Planned order […]
Management Chapter 12 Homework Emphasize the difference between independent and dependent demand, even though it repeats material covered in the previous chapter
Chapter 12 – MRP and ERP 12-21 11. a. Master Schedule Period Beg. Inv. 1 2 3 4 5 6 7 8 Quantity 120 E LT = 1 wk. Beg. Inv. 1 2 3 4 5 6 7 8 Gross […]
Management Chapter 12 Homework The MRP system uses backward scheduling. It uses low-level-coding and starts at the end item level and explodes requirements level-by-level
Chapter 12 – MRP and ERP 12-1 CHAPTER 12 MRP AND ERP Teaching Notes When covering the material the following points should be emphasized: • Dependent demand item needs are generated from higher level item needs of which they are […]
Management Chapter 12 Homework Maintaining a constant workforce has the advantage of making estimation of labor costs relatively easy, is good for morale
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Twelve – MRP and ERP Templates: Component Requirements Solved Problems: Solved Problem 1 Examples: Example […]
Management Chapter 11 Homework Suppliers would need to know projections of initial demand and demand growth over time, and product characteristics that would relate to new materials
Chapter 11 – Aggregate Planning and Master Scheduling 11-13 10. Plan B: Hire one worker and subcontract. Workforce = 20 + 1 = 21 workers. Period 1 2 3 4 5 6 7 8 9 Total Forecast 190 230 260 […]
Management Chapter 11 Homework Even though the aggregate plan is a function of many different factors, the key factor is the forecasted demand over the length of the medium-range planning horizon
Chapter 11 – Aggregate Planning and Master Scheduling CHAPTER 11 AGGREGATE PLANNING AND MASTER SCHEDULING Teaching Notes In the earlier chapters, we have looked at certain problems that involve long range planning such as facility location, layout and major equipment […]
Management Chapter 11 Homework The problem is that even when the machine is functioning as well as it can, unacceptable output will result
Solved Problem 3 Master Scheduling <Back Week 0 1 2 3 4 5 6 7 8 Forecast 70 70 70 70 Customer Orders Clear Page 14 (committed) 80 50 30 10 Projected on-hand inventory 20 50 80 10 10 10 […]
Management Chapter 11 Homework Control charts are based on the premise that a process which is stable will reflect randomness: statistics of samples taken from the process
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Eleven – Aggregate Planning and Master Scheduling Templates: Aggregate Planning (B) Solved Problems: Solved Problem […]
Management Chapter 10 Homework The trade-in and repair program, while appeasing customers in the short run, may be too costly and will not be correcting the root cause of the problem
Chapter 10 – Quality Control 10–13 15. Day Amount Day Amount Day Amount 1 B 27.69 − 21 B 28.60 U 41 B 26.76 D 2 B 28.13 U 22 B 20.02 D 42 B 30.51 U 4 B 30.31 […]
Management Chapter 10 Homework As a result of increased global competition, a rapidly growing number of companies of all sizes are paying much more attention to issues involving quality and productivity
Chapter 10 – Quality Control 10-1 CHAPTER 10 QUALITY CONTROL Teaching Notes As a result of increased global competition, a rapidly growing number of companies of all sizes are paying much more attention to issues involving quality and productivity. Many […]
Management Chapter 10 Homework Brainstorming is a technique in which a group of people share ideas and thoughts in a relaxed atmosphere on various problems in order to stimulate unrestrained collective thinking
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Ten – Quality Control Templates: Normal Distribution (B) Example 5 Mean Control Chart (s known) […]
Management Chapter 10 Homework Quality management emphasizes preventing mistakes or correcting them after they occur. There is a direct trade-off between investment
UCL = 16.26632152 LCL = 0 Calculations: c Average 7.857142857 Sample c 1 4 210 314 4 8 5 9 6 6 7 5 812 913 10 7 11 6 12 4 13 2 14 10 Chapter 10 – Problems […]
Management Chapter 10 Homework A major component of the quality-ethics interface involves firms knowingly allowing substandard products to be manufactured and sold or organizations
Solved Problem 3 Normal Distribution <Back Mean = 0 Std Dev = 1 -3.5 0.000873 -1.4 0.149727 z = 1.9 -0.7 0.312254 P(<x) = 0.97128344 00.398942 P(>x) = 0.02871656 0.7 0.312254 1.4 0.149727 P(two tail) = 0.05743312 2.1 0.043984 2.8 […]
Management Chapter 10 Homework Views quality not only as a technical operational issue but also views it from a strategic orientation that leads to enhanced long term planning
67 68 69 70 71 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 72 73 74 75 76 77 78 79 80 81 p-Chart <Back Average proportion 0.11 UCL […]
Management Chapter 10 Homework Design quality refers to the degree to which a product or service would ideally be fit for use. Quality of conformance refers to how well a product or service
Basic Template: You can simply copy the basic template below and paste into another worksheet. ^Top p-Chart Average proportion 0.11 UCL = 0.203866927 LCL = 0.016133073 Calculations: p Average 0.11 Sample p 10.04 20.1 30.12 40.03 50.09 60.11 70.1 80.22 […]
Management Chapter 9 Homework This case provides the opportunity for students to acquire some insight into analyzing quality problems. You may prefer to give them some initial guidance
Chapter 09 – Management of Quality 9-15 7. Methods Procedures Tolerances Poka-Yoke Controls Quality at the Source Organization Culture Working Conditions Qualifications Morale Motivation Selection Training Personnel Controls Operator Error Wear Set-up Maintenance Machine Expertise Defective Machine Parts Materials Suppliers […]
Management Chapter 9 Homework Encourages empowerment of the employees in the work place in order to improve job design, job performance and continuous improvement in all aspects of the organization
Chapter 09 – Management of Quality 9-1 CHAPTER 9 MANAGEMENT OF QUALITY Teaching Notes This chapter is devoted to quality management. It presents a definition of quality, discusses the importance of quality and the determinations of quality, highlights the views […]
Management Chapter 8 Homework Determine the weighted distance value for the first and second proposed plant locations based on Euclidean distance and decide where the new plant should be located.
Chapter 08 – Location Planning and Analysis 8-17 DWA = (.4)(8) + (.6)(5.831) = 6.7 Exercise Problems 2. Refer to textbook Problem 14 in Chapter 8, and measure the Euclidean distance between destination 1 and destination 5. 3. Refer to […]
Management Chapter 8 Homework Facility Location refers to the location of a service or manufacturing facility with respect to customers, suppliers and other existing facilities such that it allows
Chapter 08 – Location Planning and Analysis 8-1 CHAPTER 08 LOCATION PLANNING AND ANALYSIS Teaching Notes Facility Location refers to the location of a service or manufacturing facility with respect to customers, suppliers and other existing facilities such that it […]
Management Chapter 8 Homework It is better to export than to manufacture overseas a less mature product requiring design changes because dealing with significant changes away
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Eight – Location Planning and Analysis Templates: Locational Cost-Profit-Volume Analysis Center of Gravity Method (B) […]
Management Chapter 7 Homework Political problems and instability in the targeted country does not affect exporting as much as it affects overseas manufacturing.
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Seven – Work Design and Measurement Templates: Sample size (B) Solved Problems: Solved Problem 1 […]
Management Chapter 7 Homework Self-directed work teams or self-managed teams are designed to achieve a higher level of teamwork and employee involvement
management include the following: a) Workers may be somewhat inflexible in terms of the functions they can perform. b) They are more likely to have less motivation, and higher absenteeism. From the standpoint of workers, the advantages include clearer job […]
Management Chapter 6 Homework Transportation Distance Solved Problems note that tasks which are eligible to be assigned next are shown in red tin the table on the right
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Six – Process Selection and Facility Layout Templates: Line Balancing Solved Problems: Solved Problem 1 […]
Management Chapter 6 Homework Two-way trips can not be used here because of the one-way route restriction. Consequently, students are forced to develop a heuristic that will yield reasonable assignments
Solved Problem 1 Line Balancing <Back Step 1: Fill in predecessors and times Task Predecessors Time Step 2: Enter cycle time a0.3 Cycle time CT = 1.6 b0.6 c a 0.4 g e 0.1 a h h f g 0.5 […]
Management Chapter 6 Homework Facility Layout involves physical placement of departments and/or arrangement of equipment within a plant or a service facility.
Chapter 06 – Process Selection and Facility Layout 6-1 CHAPTER 06 PROCESS SELECTION AND FACILITY LAYOUT Teaching Notes Facility Layout involves physical placement of departments and/or arrangement of equipment within a plant or a service facility. A good layout will […]
Management Chapter 5 Homework Salt production would be a low variety, high volume operation which would place it as a repetitive production or continuous flow in the product-process matrix
Example 4 Comparative Breakeven Analysis <Back Process 1 2 3 4 5 6 Fixed Cost FC = 9600 15000 20000 Revenue per unit R = 40 40 40 Volume V = 580 DV = 10 Process 1 2 3 4 […]
Management Chapter 5 Homework the template computes the breakeven point at V = 1,200. Point out on the graph thatis the point where the cost and revenue lines cross and the profit line crossed the x-axis
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Five – Strategic Capacity Planning for Products and Services Templates: Efficiency (B) Solved Problems Solved […]
Management Chapter 5 Homework Capacity is an upper bound on the load that a facility or a plant can serve or manufacture. We measure the capacity of a plant, machine department
considerations related to variations in capacity requirements caused by seasonality, randomness, and so on. 5-1 Capacity planning refers to the activities of the firm in determining the capacity of a plant or a facility in terms of equipment, machines, space, […]
Management Chapter 4 Homework In planning the production system, major decisions are made concerning the design of the product or services as well as the design of the production processes.
5. Product Design (concurrent engineering, computer aided design, remanufacturing). 7. Quality Function Deployment. customer dissatisfaction, government regulation, competition, liability claims, technological innovation (products and methods) and changes in costs and availability of such inputs as materials, labor and energy. can […]
Management Chapter 3 Homework This worksheet displays results only, you must copy the shaded area into the corresponding template to make additional calculations
Da = 0.1 MSE = 11.80 Period Actual Forecast Error 119 #N/A 218 19 -1 315 18 -3 3. Exponential Smoothing a = 0.1 MAD = 1.60 Da = 0.1 MSE = Period Actual Forecast Error 188 #N/A 289.6 88 […]
Management Chapter 3 Homework The size of the graph may also be increased. The range of the y-axis may also adjusted to better view the tracking signal
Example 9 Simple Linear Regression <Back Slope = 0.0159 r = 0.9166657 x y Forecast Error 7 0.15 0.1621124 -0.0121124 2 0.1 0.0824612 0.0175388 6 0.13 0.1461822 -0.0161822 4 0.15 0.1143217 0.0356783 0.25 0.3 Y 14 0.25 0.273624 -0.023624 15 […]
Management Chapter 3 Homework Demonstrate that each forecast is the average of the previous 2 actual data points by using the spinner button below the graph to set the period and using the cursor
Tracking Signal 34 #N/A #N/A 35 #N/A #N/A 36 #N/A #N/A 37 #N/A #N/A 48 #N/A #N/A 49 #N/A #N/A 50 #N/A #N/A 51 #N/A #N/A 52 #N/A #N/A 53 #N/A #N/A 54 #N/A #N/A 55 #N/A #N/A 56 #N/A […]
Management Chapter 3 Homework You can simply copy the basic template below and paste into another worksheet. If you also copy the graph you will have to fix the cell references in the graph
Trend Adj Expon Smooth 236 #N/A 237 #N/A 238 #N/A 239 #N/A 240 #N/A 241 #N/A 242 #N/A 243 #N/A 244 #N/A 245 #N/A 246 #N/A 247 #N/A 248 #N/A 249 #N/A 250 #N/A Page 41 Trend and Seasonal Basic […]
Management Chapter 3 Homework Exponential Smoothing Exponential Smoothing Basic Clear To display more data on the above graph, right click on the x-axis, 20 select Format Axis, and set Maximum to higher value
Exponential Smoothing Exponential Smoothing Basic Period Actual Forecast Error 142 #N/A 240 42 -2 343 41.8 1.2 440 41.92 -1.92 541 41.728 -0.728 639 41.6552 -2.6552 746 41.38968 4.61032 844 41.850712 2.149288 945 42.0656408 2.9343592 5 10 15 10 38 […]
Management Chapter 3 Homework See the Forecasting tutorial for a demonstration of the these templates. See Instructions template for complete instructions
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Three – Forecasting Example 7b Example 8 Templates: Forecast Accuracy (B) Example 9 Compute Seasonal […]
Management Chapter 3 Homework The errors may be cyclical, suggesting that there may be a cyclical component in demand that is being overlooked in the forecast
Chapter 03 – Forecasting 3–33 b. Month Error Error2 38.120 9 345 20 1 20 2== − n e 1 –8 64 2 –2 4 3 4 16 4 7 49 The errors may be cyclical, suggesting that there […]
Management Chapter 3 Homework Either one might already be in use, familiar to users, and have past values for comparison. If control charts are used, MSE would be natural
Chapter 03 – Forecasting 3–21 18. Deseasonalize the values, where: Deseasonalized sales = (Actual sales) / (Seasonal relative) Deseasonalized sales for quarter 1 is (88) / (1.1) = 80 19. a. SA Method WEEK Season SA Season 1 2 3 […]
Management Chapter 3 Homework I try to emphasize an intuitive approach to forecasting, with frequent reference to the importance of plotting the data to assist the decision-maker in determining
Chapter 03 – Forecasting 3-1 CHAPTER 03 FORECASTING Forecasting is placed early in the text mainly because it is a point of departure. Some instructors like to emphasize the operations part of operations management and de-emphasize the design part. Other […]
Management Chapter 2 Homework the graph is a simple bar chart comparing the productivity for each line entered the template will compute the productivity per dollar using the following formula
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Chapter Two – Competitiveness, Strategy, and Productivity Templates: Productivity (B) (B) – includes Basic template Lecture […]
Management Chapter 2 Homework Higher productivity relative to competitors is very important for a nation because it provides the nation with a competitive advantage in the marketplace
many cases, service jobs include intellectual activities and a high degree of variability, which makes productivity improvements difficult to achieve. Manufacturing jobs, on the other hand, lend themselves to productivity improvements mainly because they are able to utilize computer-based technology […]
Management Chapter 1 Homework Many students come to this course with negative feelings, perhaps because they have heard that the course includes a certain amount of quantitative material
3. Different ways of classifying (and understanding) production systems. 5. Major characteristics of production systems. 7. Operations as essentially managerial (planning, staffing, etc.) c. Lower worker skills. d. Low skill entry-level positions. e. Higher employee turnover. f. Higher input variability. […]
Management Chapter 1 Homework Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl General Instructions Index of Templates Index of Tutorials
Excel Templates to accompany Operations Management, Eleventh Edition created by Lee Tangedahl Copyright © 2012 by The McGraw Hill Companies, Inc. All rights reserved. Instructions for Using Excel Templates General Instructions Index of Templates Index of Tutorials Copyright © 2012 […]
Chapter 17-18-19 Homework Suppose all data is stored partitioned in round robin fashion. The partition operator can be specified in the form part where r is a relation
47 C H A P T E R 1 7 D a t a b a s e S y s t e m A r c h i t e c t u r e s , P a […]
Chapter 12-13 Homework Consider external sorting using replacement selection. What is the minimum, average, and maximum length of the runs generated
C H A P T E R 1 2 Q u e r y P r o c e ss i n g and Q u e r y O p t i m i z a t i o […]
Chapter 3-4 Homework Give an example of a pair of relations with integrity constraints, and inserts into both of them such that, regardless of whichever insert is first, the integrity
5 C H A P T E R 3 SQL ( C h a p t e r s 3 and 4) Questions on SQL covering Chapters 3 and 4 are provided here. E x e r c i s […]
Chapter 1-2 Homework Introduction And Relational Model Currently Introduction and Relational Model We have not provided any questions for Chapter 1
C H A P T E R 1 I n t r o du c t i o n and R e l a t i o n a l M o d e l ( C h a p […]
Chapter 24 Homework Show pictorially how a database can be modeled as a queueing system and explain under what circumstances it is appropriate to use the queueing model
C H A P T E R 2 4 A d v a n c e d A pp li c a t i o n D e v e l o p m e n t E x e […]
Chapter 23 Homework Student name and information on courses taken by the student including course number, year, semester, and grade)
55 C H A P T E R 2 3 X M L E x e r c i s e s 23.1 What is meant by recursion in a DTD. Explain with an example. . . .3 23.2 Given […]
Chapter 22 Homework Hardware swizzling is generally associated with page level locking. Suppose you want to implement fine granularity locking in spite of having hardware swizzling
53 C H A P T E R 2 2 O b j e c t – B a s e d D a t a b a s e s E x e r c i s e s […]