Question: Hello, actually I have made the optimization model on excel and solved it, but now i have to present it briefly, I want someone to
Hello, actually I have made the optimization model on excel and solved it, but now i have to present it briefly, I want someone to tell me how can i describe this model in best way briefly and also have to add it in technical report:
There are two sheets, one is Answer she*t and another on is Optimization model.
I'm sharing the file through google drive you can download or open it by clicking on link:
https://drive.google.com/file/d/1jov5_93BG3Z3GFwjB6IN8a1CXy9S3L6S/view?usp=sharing

Prescriptive: Decision . The number of bikes to be allocated is 1000 (or something larger if you wish). . Use the spreadsheet model developed to solve for the best initial allocation. Home Insert Page Layout Formulas Data View Add-ins Acrobat Team Tell me M11 D G H CitiBike: Maximize the number of trips taken (blue cell) by filling in the number of initial bikes (yellow cells) No. of 2 You have at most 500 bikes to place at the stations 3 P. bikes 500 Morning Demand Destination Station NYU Cooper U Williamsburg Bowery Canal S. cotal Bikes NYU 180 10 222 Cooper Union 10 Origin Station Williamsburg 11 Canal St 168 total 876 Initial Evening Demand Destination Station NYU Cooper U Williamsburg Bowery Canal St. sotal NYU Cooper Union Allocation 19 Origin Station Williamsburg MOONNO Bowery Canal St Demand total 23 0 Number trips Decisions Station Initial Allocation NYU Forecast Cooper Union Williamsburg Bowery Ole- must be less than or equal to 500 by hand +
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
