Create in Excel an Operational Simulation model to meet the following criteria.

You are an operation technician working for the railroad. Your job is to model the productivity of a train that has 5 stops on a specific line. You need to monitor riders, determine whether train cars will fill before the end of the line and whether additional cars will be needed during certain parts of the day. You will need to input passengers, number of cars, amount of time that is required between stops, the number of stops on the line, whether the train arrives on time at the destination. You also need to know at any time how many riders are waiting at each station, and how many riders are in transit. Use a random generator as your input for number of riders. Make sure to limit the values to realistic numbers.

Your model should

#1 Allow inputs, with explanations for formatting

#2 Provide outputs, with explanation of results

#3 Incorporate internal loops based on data input

#4 Assign a random number generator within your simulation.

#5 Spreadsheet should clearly define how each cel changes based on inputs or other manipulations.

Upload your Excel Simulation through this Assignment. Be sure that your simulation meets all of the requirements for this assignment