Walton_Multiple_Inputs_Complete_ (1)

.xlsx

School

Boston University *

*We aren’t endorsed by this school

Course

323

Subject

Economics

Date

Jan 9, 2024

Type

xlsx

Pages

25

Uploaded by GeneralWhale2068 on coursehero.com

Simulation of Walton's Bookstore with multiple inputs Demand distribution - all triangular Supply distribution Demand @ reg price Demand @ sale price Minimum 125 0 100 0 0 0 Most likely 200 1.6 175 1 50 2.67 Maximum 250 0 300 0 75 0 125 200 250 0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 Supply Distribution 100 175 300 0 0.2 0.4 0.6 0.8 1 1.2 Regular Demand Distribution 0 50 75 0 0.5 1 1.5 2 2.5 3 Sale Demand Distribution A B C D E F G H I J K L M N O P Q R S T 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
Simulation of Walton's Bookstore with multiple inputs Cost data Demand distribution - all triangular Unit cost 1 $7.50 Supply distribution Demand @ reg price Demand @ sale price Unit cost 2 $7.25 Minimum 125 100 0 Regular price $10.00 Most likely 200 175 50 Sale price $5.00 Maximum 250 300 75 Decision variable Order quantity 200 Cost Qty Left over Sale Demand Sale revenue Profit 0.927 229 200 $1,500.00 0.611 201 $2,000.00 0 0.211 28 $0.00 $500.00 Random Number 1 Supplier's Ability Supply Received Random Number 2 Demand at regular price Revenue at Reg Price Random Number 3 A B C D E F G H I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help