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

Hello, actually I have made the optimization model on excel and solved

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!