The simulation run is complete this week. Please get your week 7 input in asap. I will try to have it run by Monday night if all input comes in.
There’s a recurring problem with input that I have to ask you to check for rigorously! If you accidentally order a large amount of production, such as 35000 instead of 3500, you will be hit with large penalty fees, and will have an enormous amount of inventory, since demand averages around 2400 per week. That is what happened to the Lions in the Central division when they went $1M in the hole. When you send me your spreadsheets, and I create the input files, I try to have a look, and I have warned some of you when it looked suspicious. But sometimes I miss it. That is what happened to the Lions.
The problem is, the program won’t handle numbers that are too big, such as losses over $1Million. so to make it run after that, I have to go in and change numbers in the history file to -$999999.99, which actually distorts the results for everyone in that division.
I don’t want to have to modify the program to handle this type of error– it would be a big job. It affects both the report (which I did fix) but also the history data which is passed to the next week, and also the computer input to the next week’s run. Because of the problem for the Lions I am having to modify the history next week as well.
SO PLEASE CHECK YOUR PRODUCTION INPUT FOR THE CORRECT NUMBER OF DECIMAL PLACES! THIS IS ON THE FIRST DECISION SHEET IN THE SPREADSHEET!
Thanks a lot!
Supply Chain and Logistics 