Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Concepts With Applications

Authors: Charles P McKeague

1st Edition

1630983136, 9781630983130

More Books

Students also viewed these Mathematics questions

Question

Identify unusual values or outliers using Z scores

Answered: 1 week ago

Question

Methods of Delivery Guidelines for

Answered: 1 week ago