Aggregate Planning "Problem",

N P Q R This is a problem similar to one that we solved in online lecture. Use solver to see 1. how many products you want to produce, Anwer: Spring Production Plan: 78,000 Summar Production Plan: 50,000 Fall Production Plan: 150,000 Winter Production Plan: 120,000 2. how many worker you want to hire or fire in each period. Answer: Spring Hired: 0 Spring Fired: 10 Summar Hired: O Summar Fired: 0 Fall Hired: 40 Fall Fired: 0 Winter Hired: O Winter Fired: 30 The Rubric Decision variables in Excel and Soplver Objective function in Ecxel and Solver Constraints in Excel and Solver C D E F G H $ $ B B 100.00 500.00 0.50 This is a problem simila 1. how many products Anwer: $2 A 1 Hirine Cost 2 Firing Cost 3 Inventory Carrying Cost 4 5 Production cost 6 regular time 7 8 Production Capacity 9 regular time 10 11 Beginning Workforce 12 Workers' productivity 13 14 Beginning inventory 15 Ending Inventory Requirement 16 17 Spring Production Plan: 78,00 Summar Production Plan: 50,0 Fall Production Plan: 150,000 Winter Production Plan: 120, 200,000 100 1,000 2. how many worker y Answer: 2,000 50,000 Spring Hired: 0 Spring Fired: 10 Summar Hired: 0 Summar Fired: 0 Period Demand Prouction Plan Hired Fired Inventory Work-Force Work-Force Hiring Need 18 19 20 Initial 21 Fall Hired: 40 Fall Fired: 0 Spring 80,000 78,000 0 10 22 Summer 50,000 0 0 50,000 150,000 Winter Hired: O Winter Fired: 30 23 Fall 120,000 40 D 30 Winter 150,000 120,000 0 0 24 25 26 Production Cost The Rubric Decision variables in Exce Objective function in Ecxe Constraints in Excel and S Hiring Cost Firing Cost Inventory Cost Total Cost 27 TOTAL 2a 29 30 21 22 33 35 36 N P Q R This is a problem similar to one that we solved in online lecture. Use solver to see 1. how many products you want to produce, Anwer: Spring Production Plan: 78,000 Summar Production Plan: 50,000 Fall Production Plan: 150,000 Winter Production Plan: 120,000 2. how many worker you want to hire or fire in each period. Answer: Spring Hired: 0 Spring Fired: 10 Summar Hired: O Summar Fired: 0 Fall Hired: 40 Fall Fired: 0 Winter Hired: O Winter Fired: 30 The Rubric Decision variables in Excel and Soplver Objective function in Ecxel and Solver Constraints in Excel and Solver C D E F G H $ $ B B 100.00 500.00 0.50 This is a problem simila 1. how many products Anwer: $2 A 1 Hirine Cost 2 Firing Cost 3 Inventory Carrying Cost 4 5 Production cost 6 regular time 7 8 Production Capacity 9 regular time 10 11 Beginning Workforce 12 Workers' productivity 13 14 Beginning inventory 15 Ending Inventory Requirement 16 17 Spring Production Plan: 78,00 Summar Production Plan: 50,0 Fall Production Plan: 150,000 Winter Production Plan: 120, 200,000 100 1,000 2. how many worker y Answer: 2,000 50,000 Spring Hired: 0 Spring Fired: 10 Summar Hired: 0 Summar Fired: 0 Period Demand Prouction Plan Hired Fired Inventory Work-Force Work-Force Hiring Need 18 19 20 Initial 21 Fall Hired: 40 Fall Fired: 0 Spring 80,000 78,000 0 10 22 Summer 50,000 0 0 50,000 150,000 Winter Hired: O Winter Fired: 30 23 Fall 120,000 40 D 30 Winter 150,000 120,000 0 0 24 25 26 Production Cost The Rubric Decision variables in Exce Objective function in Ecxe Constraints in Excel and S Hiring Cost Firing Cost Inventory Cost Total Cost 27 TOTAL 2a 29 30 21 22 33 35 36