Archives: Solution Manual
978-0134731889 Case Teaching Note
Copyright © 2019 Pearson Education, Inc. Chapter 11 – Teaching Note for Pricing and Delivery at KAR Foods 1. What do you think of the discounting scheme that KAR had used historically? Do you think it was justified given the […]
978-0134731889 Case Moonchem Case Study Answers
Chapter 11 – MoonChem Case Study 1. What is the annual cost of MoonChem’s strategy of sending full truckloads to each customer in the Peoria region to replenish consignment inventory? MoonChem’s customer profile appears in Table 11-4 and is reproduced […]
978-0134731889 Case Moonchem Case Study
Type Number Consumption D Q D/Q SSD/Q HQ/2 Total Cost / Customer Total Cost nQ/2 Small 12 1,000 12,000 40,000 0.30 $400 $120 $5,000 $5,120 $61,440 240000 Medium 6 5,000 60,000 40,000 1.50 $400 $600 $5,000 $5,600 $33,600 120000 Large […]
978-0134731889 Example
Supply Chain Coordination with Commodity Products Manufacturer (M) DO (R ) Monthly Demand 10,000 10,000 Fixed Order Cost, S250$ 100$ Holding Cost, h20% 20% Cost, C2.00$ 3.00$ Sale Price 3.00$ Calculated Lot Size 6,325 Sum of Order and Holding Cost […]
978-0134731889 Case
Supply Chain Coordination with Commodity Products KAR Customer Monthly Demand 10,000 10,000 Fixed Order Cost 4,000.00R$ 100.00R$ Holding Cost 20% 20% Cost 2.50R$ 4.00R$ Sale Price 4.00R$ Calculated Lot Size 5,477 Sum of Order and Holding Cost 89,004.92R$ 4,381.78R$ Material […]
978-0134731889 Exercise 9 – 6
Data Input Data Demand Forecast Costs Month Demand Forecast Item Cost January 280 Materials cost/ton 1,000$ February 301 Inventory holding cost/ton/month 100$ March 277 Marginal cost of stockout/unit/month April 302 Hiring and training cost/worker May 285 Layoff cost/worker June 278 […]
978-0134731889 Exercise 9 – 5
Data Input Data Demand Forecast Costs Month Demand Forecast Item Cost January 280 Materials cost/ton 1,000$ February 301 Inventory holding cost/ton/month 100$ March 277 Marginal cost of stockout/unit/month April 302 Hiring and training cost/worker May 285 Layoff cost/worker June 278 […]
978-0134731889 Exercise 9 – 4
Data Input Data Demand Forecast Costs Month Demand Forecast Item Cost January 12,000 Materials cost/unit 35$ February 11,000 Inventory holding cost/unit/month 4$ March 14,000 Marginal cost of stockout/unit/month April 20,000 Hiring and training cost/worker May 25,000 Layoff cost/worker June 27,000 […]
978-0134731889 Exercise 9 – 3
Data Input Data Demand Forecast Costs Month Demand Forecast Item Cost January 10,000 Materials cost/unit 40$ February 11,000 Inventory holding cost/unit/month 3$ March 15,000 Marginal cost of stockout/unit/month April 18,000 Hiring and training cost/worker May 25,000 Layoff cost/worker June 26,000 […]
978-0134731889 Exercise 9 – 2
Data Input Data Demand Forecast Costs Month Demand Forecast Item Cost January 10,000 Materials cost/unit 40$ February 11,000 Inventory holding cost/unit/month 3$ March 15,000 Marginal cost of stockout/unit/month April 18,000 Hiring and training cost/worker 1,000$ May 25,000 Layoff cost/worker 2,000$ […]
978-0134731889 Exercise 9 – 1
Data Input Data Demand Forecast Costs Month Demand Forecast Item Cost January 10,000 Materials cost/unit 40$ February 11,000 Inventory holding cost/unit/month 3$ March 15,000 Marginal cost of stockout/unit/month April 18,000 Hiring and training cost/worker May 25,000 Layoff cost/worker June 26,000 […]
978-0134731889 Example Chapter 8 9 – Examples
Tables 8-2, 8-3 Aggregate Planning (Chapter 8-9) Demand Forecast Month Demand Forecast January 1,600 February 3,000 March 3,200 April 3,800 May 2,200 June 2,200 Costs Item Cost Materials cost/unit 10$ Inventory holding cost/unit/month 2$ Marginal cost of stockout/unit/month 5$ Hiring […]
978-0134731889 Example Chapter 8
Tables 8-2, 8-3 Aggregate Planning (Chapter 8-9) Demand Forecast Month Demand Forecast January 1,600 February 3,000 March 3,200 April 3,800 May 2,200 June 2,200 Costs Item Cost Materials cost/unit 10$ Inventory holding cost/unit/month 2$ Marginal cost of stockout/unit/month 5$ Hiring […]
978-0134731889 Case Teaching Note For Gulmarg Skis
Chapter 9 – Teaching Note for Promotion Challenges at Gulmarg Skis As Gulmarg plans its response for the coming season, the company must make its plans without quite knowing what Kitz plans to do. The choices for Gulmarg are to […]
978-0134731889 Case Mintendo – Case Study Answers
Chapter 9—Mintendo Game Girl The results for this case are obtained using the accompanying spreadsheet Mintendo – Case Study. 1. A comparison of the three options for the case with a $5 discount follows: Basic Model The decision variables are […]
978-0134731889 Case Mintendo – Case Study
Sheet1 Aggregate Planning Demand Forecast Month Demand Forecast January 100,000 February 110,000 March 130,000 April 180,000 May 250,000 June 300,000 Costs Item Cost Materials cost/unit 12.00$ Inventory holding cost/unit/month 2.00$ Marginal cost of stockout/unit/month 10.00$ Hiring and training cost/worker 3,000.00$ […]
978-0134731889 Exercise – Exercise Answers
Chapter 9: Sales and Operations Planning We define a comprehensive set of decision variables that are utilized in Exercises 9-1–9- 3 depending on the problem context. Decision Variables: Ht = # of workers hired in month t (t = 1,..,12) […]
978-0134731889 Exercise 8 – 7
Input Data (Demand) Input Data (Costs etc.) Month Routers Switches Item Router Switch January 1,800 1,600 Materials cost/unit February 1,600 1,400 Inventory holding cost/unit/month 3.0 1.0 March 2,600 1,500 Marginal cost of stockout/unit/month April 2,500 2,000 Hiring and training cost/worker […]
978-0134731889 Exercise 8 – 6(b)
Input Data (Demand) Input Data (Costs etc.) Month Routers Switches Item Router Switch January 1,800 1,600 Materials cost/unit February 1,600 1,400 Inventory holding cost/unit/month 3.0 1.0 March 2,600 1,500 Marginal cost of stockout/unit/month April 2,500 2,000 Hiring and training cost/worker […]
978-0134731889 Exercise 8 – 6
Input Data (Demand) Input Data (Costs etc.) Month Routers Switches Item Router Switch January 1,800 1,600 Materials cost/unit February 1,600 1,400 Inventory holding cost/unit/month 3.0 1.0 March 2,600 1,500 Marginal cost of stockout/unit/month April 2,500 2,000 Hiring and training cost/worker […]
978-0134731889 Exercise 8 – 5(b)
Input Data (Demand) Input Data (Costs etc.) Month Routers Switches Item Router Switch January 1,800 1,600 Materials cost/unit February 1,600 1,400 Inventory holding cost/unit/month 3.0 1.0 March 2,600 1,500 Marginal cost of stockout/unit/month April 2,500 2,000 Hiring and training cost/worker […]
978-0134731889 Exercise 8 – 5
Input Data (Demand) Input Data (Costs etc.) Month Routers Switches Item Router Switch January 1,800 1,600 Materials cost/unit February 1,600 1,400 Inventory holding cost/unit/month 3.0 1.0 March 2,600 1,500 Marginal cost of stockout/unit/month April 2,500 2,000 Hiring and training cost/worker […]
978-0134731889 Exercise 8 – 4
Input Data (Demand) Input Data (Costs etc.) Month Routers Switches Item Router Switch January 1,800 1,600 Materials cost/unit February 1,600 1,400 Inventory holding cost/unit/month 3.0 1.0 March 2,600 1,500 Marginal cost of stockout/unit/month April 2,500 2,000 Hiring and training cost/worker […]
978-0134731889 Exercise 8 – 3
Input Data (Demand) Input Data (Costs etc.) Month Demand Item Cost January 1,000 Materials cost/unit 20.0 February 1,100 Inventory holding cost/unit/month 3.0 March 1,000 Marginal cost of stockout/unit/month April 1,200 Hiring and training cost/worker 800.0 May 1,500 Layoff cost/worker 1,200.0 […]
978-0134731889 Exercise 8 – 2
Input Data (Demand) Input Data (Costs etc.) Month Demand Item Cost January 1,000 Materials cost/unit 20$ February 1,100 Inventory holding cost/unit/month 3.0 March 1,000 Marginal cost of stockout/unit/month April 1,200 Hiring and training cost/worker May 1,500 Layoff cost/worker June 1,600 […]
978-0134731889 Exercise 8 – 1
Input Data (Demand) Input Data (Costs etc.) Month Demand Item Cost January 1,000 Materials cost/unit 20$ February 1,100 Inventory holding cost/unit/month 3.0 March 1,000 Marginal cost of stockout/unit/month April 1,200 Hiring and training cost/worker May 1,500 Layoff cost/worker June 1,600 […]
978-0134731889 Example 9 – Examples
Tables 8-2, 8-3 Aggregate Planning (Chapter 8−9) Demand Forecast Month Demand Forecast January 1,600 February 3,000 March 3,200 April 3,800 May 2,200 June 2,200 Costs Item Cost Materials cost/unit 10$ Inventory holding cost/unit/month 2$ Marginal cost of stockout/unit/month 5$ Hiring […]
978-0134731889 Case Quicktronics Case
Chapter 8 – Teaching Note for Smartphone production at QuickTronics The case is designed to help students learn how to set up a basic aggregate planning model using linear programming in Excel. The case illustrates the value of volume flexibility […]
978-0134731889 Case Kph Case
Chapter 8 – Teaching Note for Kloss Planters and Harvesters The case is designed to help students understand the benefits of using the same assembly line for counter cyclical products such as planters and harvesters. All results are from the […]
978-0134731889 Case – Quicktron – Case
Input Data (Costs etc.) Item Cost (‘000s) Material cost/unit 500 Inventory holding cost/unit/month 50 Marginal cost of stockout/unit/month 100 Hiring and training cost/worker 400 Layoff cost/worker 800 Team labor hours required/ thousand units 8 Regular time cost/hour 4 Over time […]
978-0134731889 Case – Kph – Case
Input Data (Costs etc.) Item Cost Material cost/unit 20,000$ Inventory holding cost/unit/month 300$ Marginal cost of stockout/unit/month 2,000$ Hiring and training cost/worker 3,000$ Layoff cost/worker 5,000$ Labor hours required/unit 100 Regular time cost/hour 20$ Over time cost/hour 30$ Maximum overtime […]
978-0134731889 Exercise 7 – 10
Exercise 7-10: Dishwashers Deseasonalized Analysis (to estimate initial values) Year Quarter Period Sales Deseasonalized Level Level from Regression Seasonal Factor Seasonal Factor Estimate Regression – Deseasonalized Level vs. Period 0 1I 11,934 0.94 II 21,276 0.45 Regression Statistics III 33,991 […]
978-0134731889 Exercise 7 – 9
Exercise 7-9: Smartphones Deseasonalized Analysis (to estimate initial values) Year Quarter Period Sales Deseasonalized Level Level from Regression Seasonal Factor Seasonal Factor Estimate Regression – Deseasonalized Level vs. Period 0 1I 1513 0.50 II 2932 0.79 Regression Statistics III 3 […]
978-0134731889 Exercise 7 – 8
Exercise 7-8 Period Demand Level Forecast EtAtBias MSE MAD Percent Error MAPE TS 1517 2510 3557 4498 5498 516 6444 501 516 72 72 72 5,184 72 16.2 16.2 1.00 7526 505 501 -25 25 47 2,895 32 4.7 10.4 […]
978-0134731889 Exercise 7 – 7
Exercise 7-7 A&D Electronics Holt’s Model Holt’s model with alpha = 0.5 and beta = 0.5 Period Sales Level Trend Forecast EtAtBias MSE MAD Percent Error MAPE TS 0948 109 1 1,000 1,029 94.8 1,057 57 57 57 3,249 57 […]
978-0134731889 Exercise 7 – 6
Exercise 7-6 A&D Electronics Exponential Smoothing Period Sales Level Forecast EtAtBias MSE MAD Percent Error MAPE TS 0 1,659 1 1,000 1,461 1,659 659 659 659 434,281 659 66 66 1.00 2 1,113 1,357 1,461 348 348 1,007 277,797 504 […]
978-0134731889 Exercise 7 – 5
Exercise 7-5: Hot Pizza Week Demand Week Demand Week Demand 1108 596 9112 2116 6119 10 102 3118 796 11 92 4124 8102 12 91 Alpha = 0.1 Period Demand Level Forecast EtAtBias MSE MAD Percent Error MAPE TS 0106 […]
978-0134731889 Exercise 7 – 4
Static Method Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2,000 3,000 2,000 5,000 5,000 FEB 3,000 4,000 5,000 4,000 2,000 MAR 3,000 3,000 5,000 4,000 3,000 APR 3,000 5,000 3,000 2,000 2,000 MAY 4,000 5,000 […]
978-0134731889 Exercise 7 – 3
Exercise 7-3: Flowers Exponential Smoothing Year Quarter Period Sales Level Forecast EtAtBias MSE MAD Percent Error MAPE TS Regression – Sales vs. Period 0 132.6 1I 198 129.1 132.6 34.6 34.6 34.6 1194.6 34.6 35.3 35.3 1.00 Regression Statistics II […]
978-0134731889 Exercise 7 – 2
Exercise 7-2: Hot Pizza Week Demand Week Demand Week Demand 1108 596 9112 2116 6119 10 102 3118 796 11 92 4124 8102 12 91 Period Demand Level Forecast EtAtBias MSE MAD Percent Error MAPE TS 1108 2116 3118 4124 […]
978-0134731889 Exercise 7 – 1
Exercise 7-1: ABC Corporation Sales Year 1 Year 2 Year 3 Year 4 Year 5 JAN 2,000 3,000 2,000 5,000 5,000 p = 12 (even) FEB 3,000 4,000 5,000 4,000 2,000 MAR 3,000 3,000 5,000 4,000 3,000 APR 3,000 5,000 […]
978-0134731889 Example Examples 1 – 4
Week Demand Level Forecast Forecast Error 1120 2127 3114 4122 120.75 5125 122 120.75 -4.25 Week Demand Level Forecast Forecast Error 0 120.75 1120 120.675 120.75 0.75 2127 121.308 120.68 -6.33 3114 120.577 121.31 7.31 4122 120.719 120.58 -1.42 5 […]
978-0134731889 Case Spc Case Study Answer
SPC Year Quarter 1I II p = 4 (even) III IV 2I II III IV III IV Black Plastic Quarter Period Demand Dt Deseasonalized Demand (7.2) Deseasonalized Demand (based on regression) Seasonal Factor St Forecast EtAtBias MSE MAD Percent Error […]
978-0134731889 Case Spc – Part A – Case Discussion
1 Chapter 7—Specialty Packaging Corporation, Part A The results for this case are obtained using the accompanying spreadsheet Chapter 7—SPC case study answer. Given the clear seasonal pattern in the data, the forecast is made using the static forecasting method […]
978-0134731889 Exercise Exercises 6 5 6 6 7
Problem 6-5 Discount Factor 0.1 Current Capacity in Asia = 2,400,000 Current Capacity in N. America = 4,200,000 Current Annual Demand in Asia = 2,000,000 No Addition Current Annual Demand in N. America = 4,000,000 Year 0 Year 1 Year […]
978-0134731889 Exercise 6 – 3
Exercise 6-3: Alphacap Option 1: Multichem Cost/Unit 1.20$ Discount Rate 20% Expected Cost of Option 1 Option 2: Mixemat $208,281 Cost/Unit 0.90$ High Demand Max 90,000 Expected Cost of Option 2 $257,930 Spot Market High Demand Price 4.00$ Low Demand […]
978-0134731889 Exercise 6 – 2
Exercise 6-2: Unipart Discount Rate 20% Option 1: Parts4u.com Option 1 Expected Cost Commission 5% $10,917,969 Option 2: AllMRO Option 2 Expected Cost 2 Year Fee $10,000,000 $10,516,927 Commission 1% Cost of B2B Marketplace at T=0 Past Year Year 1 […]
978-0134731889 Exercise 6 – 1
Excersise 6-1: Moon Micro Current Capacity 10,000 Option 1: Add Capacity to Santa Clara Plant E(Incremental Profit Option 1) Server Sales Price $15,000 Additional Capacity 10,000 $58,000,000 Raw Material/Server $8,000 Annualized Fixed Cost 10,000,000$ Labor/Server 500$ E(Incremental Profit Option 2) […]
978-0134731889 Example Trips Logistics Example
Trips Logistics Example • Demand = 100,000 units • 1,000 sq. ft. of space for every 1,000 units of demand • Revenue = $1.22 per unit of demand • Sign a three-year lease or obtain warehousing space on the spot […]
978-0134731889 Example Example Trips Logistics
Trips Logistics Discounted Cash Flows—Trips Logistics Demand 100,000 units Revenue per Unit 1.22$ Warehouse Space 1,000 sq ft per 1000 units Lease Cost 1.00$ Spot Market Cost 1.20$ Discount Rate 0.10 Expected Annual Profit if Warehousing Spacee Is Obtained from […]