MGMT 484 Fall2020 Project Instructions 1.Download "Project Data.xlsx" file from Canvas. 2.In the "Past Demand Data" work
Posted: Tue Jul 05, 2022 11:43 am
- Mgmt 484 Fall2020 Project Instructions 1 Download Project Data Xlsx File From Canvas 2 In The Past Demand Data Work 1 (399.32 KiB) Viewed 11 times
1 INTRODUCTION A brief introduction about your report main idea and topic organization. (2 paragraphs) 2 DEMAND FORECAST Talk briefly about your past demand data, and your calculations for the future demand. 3 AGGREGATE PLANNING SCENARIOS Provide a brief introduction to your scenarios. 3.1 SCENARIO 1 3.2 SCENARIO 2 3.3 SCENARIO 3 4 COST CALCULATIONS Show a provide a detailed explanation about all the costs included in each scenario. Use proper citation if you use external resources (Heizer, Render, & Munson, 2017).
4 COST CALCULATIONS Show a provide a detailed explanation about all the costs included in each scenario. Use proper citation if you use external resources (Heizer, Render, & Munson, 2017). 5 DISCUSSION Compare the results and choose the best scenario. Explain why this scenario is superior to others. 6 CONCLUSION Conclude your project by expressing what you have learned and how it would be useful to you and to others in real life applications.
Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 9 Aug-16 10 Sep-16 Oct-16 12 Nov-16 13 Dec-16 Jan-17 15 Feb-17 16 Mar-17 17 Apr-17 18 May-17 19 Jun-17 2 3 4 6 7 b 2 9972 ANN 20 Jul-17 21 Aug-17 22 Sep-17 23 Oct-17 24 Nov-17 Dec-17 83 88 93 96 98 101 103 107 110 113 115 120 122 125 129 132 135 137 139 142 147 151 154
26 Jan-18 27 Feb-18 28 Mar-18 29 Apr-18 May-18 30 31 Jun-18 m m 32 Jul-18 33 Aug-18 34 Sep-18 Oct-18 36 Nov-18 37 Dec-18 38 Jan-19 000 39 Feb-19 40 Mar-19 41 Apr-19 May-19 Jun-19 Jul-19 45 Aug-19 42 43 44 DADA A R 46 Sep-19 Oct-19 Nov-19 Dec-19 47 48 49 156 160 164 169 171 175 177 180 184 189 191 193 197 199 203 207 210 213 217 221 225 229 231 235
39 Feb-19 40 Mar-19 41 Apr-19 42 May-19 43 Jun-19 44 Jul-19 45 Aug-19 46 Sep-19 47 Oct-19 48 Nov-19 49 Dec-19 50 Jan-20 51 Feb-20 52 Mar-20 53 Apr-20 54 May-20 55 Jun-20 56 Jul-20 57 Aug-20 58 Sep-20 59 Oct-20 60 Nov-20 61 Dec-20 62 199 203 207 210 213 217 221 225 229 231 235 237 241 243 247 249 254 ? ? ? P ? Sheet1 Scenario 1 Scenario
1 2 B 4 5 6 7 A 9 10 11 12 13 14 15 16 17 Working Days per MonthMKWARNION THROUND HOWL www. Starting Inventory Starting Number of WorkersNKIA Time Required to Make One Product Regular Working Hours Maximum Allowable Overtime Regular Labor Cost Overtime Cost Inventory Carrying Cost Stockout Costs Hiring Costs Layort Costs Subcontracting Costs 18 19 Est Month 20 2nd Month 21 3rd Month 22 4th Month 23 5th Month 24 6th Month Scenariny Previous Month 25 26 Regular Labor Cost 27 Overtime 28 Subcontracting Sheet1 Scenario 1 Demand: 13 21 days ONTMONCHUST 10 15 10 5 hours 8 hours a day 3 hours in addition to 8 hours $15 an hour. $20 an hour 52 per item per month Scenarb S40 per item $40 per person $80 per person $10 per product Scenario 3 Demand 1st Month 2nd Month 3rd Month th Month 5th Month 6th Month Planned Productionventory 112 HUGMADHANYA Scenario Constant Average Production Level Scenaria Constant Minimum Production Level Overtime +3 Scenario Variable Production Level to match the expected. How many workers required? Hiring Layoff 23 BLOWN ANDEM ERHOKAMU Overtime Stockout Subcontracting
2nd Month 3rd Month 4th Month 5th Month 6th Month Regular Labor Cost tracting TOTAL COS Scenario
1 2 9 4 5 6 17 0 9 10 7 11 12 13 14 15 16 47 Worlding Daja per Month Starting Inventory Starting Number of Workers Time Requied to Make One Regular Working Hours Maximum Allov able Overtime Regular Labor Con Overtime Com Inventory Canying Cos Stockour Costs Hring Costs Lavolf Costs Subcontracting Costs Soenario 2 Previous Month 181st Month 32nd Month 20 3id Monthl 21 4thMonth 22 5th Morth 23 6th Month 24 25 Regular Labor Cost 26 Overtime 27 Subcontracting 2 Inventory 29 Hiring 30 Layoll 31 32 TOTAL COST 33 10 Shours 8 hours a day Shours in addkon to 8 hour 21 days 5 7 3 P 3 7 £15 an hour $20 anhcut Demand $2 peremper month 140 per tem $40 per person $50 per person $10 per product Demand 1st March 2nd Morth 3rd Month 4th Month 5th Mord 6th Mort Sheet1 Scenario 1 Scenario 2 Scenario 3 2 7 4 3 121 2 Plamed capacil Number of workers 21 Overtime capacity Scenario 1 Scenario 2 Scenario 3 Constant Average Production Late Constant Minimum Production Level+Overtime Subcontracting Vable Production Laval to match the expected demand, no overtime and no subcontracting Regular Production Overime Production Execontracting venice Hring Layof Recebi. Yar Check if you do or fire wysed in the lat mouth
1 2 3 4 5 6 7 8 9 10 11 Working Days per Month Starting Inventory Starting Number of Workers Time Required to Make One Product Regular Working Hours: Maximum Allowable Overtime Regular Labor Cost Overtime Cost Inventory Carrying Cost Stockout Costs Hiring Costs Layoff Costs Subcontracting Costs 12 13 14 15 16 17 18 19 1st Month 20 2nd Month 21 3rd Month 22 4th Month 32 5th Month Scenario 3. Previous Month Sheet! Scenario 1 8 hours a day 3 hours in addition to 8 hours Demand 12 12 21 days 5 10 5 hours ? $15 an hour $20 an hour $2 per item per month $40 per item $40 per person $80 per person $10 per product 2 12 Scenario 2 Scenario 3 Planned production + Demand 1st Month 2nd Month 3rd Month 4th Month 5th Month 6th Month ? 2 ? ? ? ? Workers required Actual Production. Scenario 1 Constant Average Production Level Scenario 2 Constant Minimum Production Level + Ove Scenario 3 - Variable Production Level to match the e Inventory Hiring Layoff 5 FEEL I I 1000
12 13 14 15 16 17 18 19 1st Month 20 2nd Month 21 3rd Month 22 4th Month 23 5th Month Hiring Costs Layoff Costs Subcontracting Costs 24 6th Month 25 Scenario 3 Previous Month 26 Regular Labor Cost Overtime 28 Subcontracting 29 Inventory 30 Hiring 31 Layoff 32 33 TOTAL COST 21 $40 per person $80 per person $10 per product Demand Sheet1 Scenario 1 Scenario 2 Scenario 3 Planned production O Workers required G Actual Production H Inventory Hiring Layoff K