Lecture_14_Final__Video_ - Rent the Runway Inventory Model(For a single size\/style of a $750 Inputs Variable Name Unit Purchasing Cost PURCH Profit per

Lecture_14_Final__Video_ - Rent the Runway Inventory...

This preview shows page 1 - 2 out of 5 pages.

Rent the Runway Inventory Model (For a single size/style of a $750) Week Starting Inventory Returns Available to Rent Demand Rentals Lost Sales Inputs 1 14 14 3 3 0 $ 2,752 90% Variable Name Value 2 11 11 11 11 0 1 Unit Purchasing Cost PURCH 149 3 0 3 3 5 3 2 2 Profit per Rental PROFIT_RENTAL 32 4 0 11 11 3 3 0 3 Shortage Penalty SHORT_PENALTY 5 5 8 3 11 8 8 0 4 Number of Rental Units NUM_UNITS 14 6 3 3 6 10 6 4 5 7 0 8 8 11 8 3 6 Outputs 8 0 6 6 8 6 2 7 Variable Name Value 9 0 8 8 10 8 2 8 10 0 6 6 6 6 0 9 11 0 8 8 6 6 0 10 12 2 6 8 8 8 0 11 13 0 6 6 9 6 3 12 14 0 8 8 11 8 3 13 15 0 6 6 5 5 0 14 16 1 8 9 10 9 1 15 17 0 5 5 4 4 0 16 18 1 9 10 9 9 0 17 19 1 4 5 3 3 0 18 20 2 9 10 8 8 0 19 21 2 3 5 6 5 1 20 22 0 8 8 3 3 0 21 23 5 5 10 6 6 0 22 24 4 3 7 8 7 1 23 25 0 6 6 2 2 0 24 26 4 7 11 3 3 0 25 Total 172 154 22 2981.16 0.884942 Profit $ 2,752 Service Rate 90% Number of Rental Units Replication 0 #DIV/0! #DIV/0! ### #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '13
  • KATOK,ELENA
  • Probability theory, Cumulative distribution function, Runway, DIV/0

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture