{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

GuptaShashank8 - Costperdishwashwer RetailPrice...

Info icon This preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Cost per dishwashwer 400 Retail Price 550 cdf Demand Probability After new model 350 2% 6 2% Gift card loss 50 7% 7 5% 17% 8 10% Stock level Err:509 32% 9 15% 52% 10 20% Demand Err:509 67% 11 15% 82% 12 15% sales 0 92% 13 10% left over Err:509 97% 14 5% Missed customers Err:509 100% 15 3% 100% Revenue Err:509 cost Err:509 expected v 10.52 gift card loss Err:509 profit Err:509 Answer 1b overage 50 underage 200 critical ratio 0.8 optimal order quantity 11
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
YASAI Simulation Output Workbook hw8 (1).xlsx YASAI Version: 2.2 Sheet Q1a Use Same Seed? Yes Start Date 12/13/2010 Random Number Seed: 82985.03 Start Time 11:03:05 PM Run Time (h:mm:ss) 0:00:14 Scenarios: 10 Sample Size: 1000 Parameter Scenario Stock level 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 15 Output Name Scenario Observations Mean profit 1 1000 674.150 103.731 profit 2 1000 869.150 98.618 profit 3 1000 1051.650 97.284 profit 4 1000 1206.650 119.761 profit 5 1000 1325.400 178.260 profit 6 1000 1398.150 249.983 profit 7 1000 1431.150 320.429 profit 8 1000 1426.150 371.358 profit 9 1000 1395.650 400.161 profit 10 1000 1353.400 414.922 optimal profit 1431.150 optimal scenario 7 optimal no 12 Standard Deviation
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Minimum 450.000 500.000 550.000 550.000 600.000 600.000 600.000 650.000 650.000 700.000 750.000 750.000 800.000 800.000 800.000 850.000 800.000 850.000 950.000 950.000 990.000 1000.000 1000.000 1000.000 750.000 950.000 1050.000 1150.000 1150.000 1150.000 1150.000 1150.000 700.000 900.000 1100.000 1100.000 1250.000 1300.000 1300.000 1300.000 650.000 850.000 1050.000 1050.000 1250.000 1250.000 1250.000 1450.000 600.000 800.000 1000.000 1000.000 1200.000 1200.000 1200.000 1400.000 550.000 750.000 950.000 950.000 1150.000 1150.000 1150.000 1350.000 500.000 700.000 900.000 900.000 1100.000 1100.000 1100.000 1300.000 450.000 650.000 850.000 850.000 1050.000 1050.000 1050.000 1250.000 5th Percentile 10th Percentile 15th Percentile 20th Percentile 25th Percentile 30th Percentile 35th Percentile
Image of page 4
650.000 650.000 700.000 700.000 700.000 700.000 750.000 750.000 850.000 850.000 850.000 900.000 900.000 900.000 950.000 950.000 1000.000 1050.000 1050.000 1050.000 1100.000 1100.000 1100.000 1150.000 1200.000 1200.000 1200.000 1250.000 1250.000 1250.000 1300.000 1300.000 1300.000 1350.000 1350.000 1400.000 1400.000 1400.000 1450.000 1450.000 1450.000 1450.000 1450.000 1500.000 1550.000 1550.000 1600.000 1600.000 1400.000 1400.000 1400.000 1600.000 1600.000 1600.000 1700.000 1750.000 1350.000 1350.000 1350.000 1550.000 1550.000 1550.000 1750.000 1750.000 1300.000 1300.000 1300.000 1500.000 1500.000 1500.000 1700.000 1700.000 1250.000 1250.000 1250.000 1450.000 1450.000 1450.000 1650.000 1650.000 40th Percentile 45th Percentile 50th Percentile 55th Percentile 60th Percentile 65th Percentile 70th Percentile 75th Percentile
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Maximum 750.000 800.000 800.000 850.000 900.000 950.000 1000.000 1000.000 1002.500 1050.000 1150.000 1150.000 1200.000 1200.000 1200.000 1300.000 1300.000 1350.000 1350.000 1350.000 1450.000 1500.000 1500.000 1500.000 1500.000 1600.000 1650.000 1650.000 1650.000 1650.000 1750.000 1800.000 1800.000 1800.000 1800.000 1750.000 1850.000 1950.000 1950.000 1950.000 1700.000 1900.000 1900.000 2050.000 2100.000 1650.000 1850.000 1850.000 2050.000 2250.000 80th Percentile 85th Percentile 90th Percentile 95th Percentile
Image of page 6
Cost per dishwashwer 400 Retail Price 550 possible stock levels After new model 350 0 Gift card loss 50 5 10 Stock level Err:509 15 20 No. of days per model Err:509 25 Demand Err:509 30 35 sales 0 40 left over Err:509 45 Missed customers Err:509 50 55 Revenue Err:509 60 cost Err:509 gift card loss Err:509 profit Err:509 overage 50 underage 200 critical ratio 0.8 optimal order quantity Since the demand is based on two distribution functions, we cannot
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
t use the critical ratio method to find the optimal quantity
Image of page 8
YASAI Simulation Output Workbook GuptaShashank8.xlsx YASAI Version: 2.2 Sheet Q1c Use Same Seed? Yes Start Date 12/14/2010 Random Number Seed: 50468.7 Start Time 2:01:08 PM Run Time (h:mm:ss) 0:01:04 Scenarios: 13 Sample Size: 1000 Parameter Scenario Stock level 1 0 2 5 3 10 4 15 5 20 6 25 7 30 8 35 9 40 10 45 11 50 12 55 13 60 Output Name Scenario Observations Mean profit 1 1000 -889.450 860.416 profit 2 1000 -63.450 764.268 profit 3 1000 518.550 757.101 profit 4 1000 902.300 958.623 profit 5 1000 1120.300 1255.294 profit 6 1000 1227.050 1583.960 profit 7 1000 1256.050 1907.761 profit 8 1000 1215.800 2193.673 profit 9 1000 1122.050 2437.903 profit 10 1000 989.800 2646.646 profit 11 1000 834.050 2835.383 profit 12 1000 651.800 2984.673 profit 13 1000 448.550 3097.583 optimal profit 1256.050 optimal scenario 7 optimal quantity 30 Standard Deviation
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Minimum -5250.000 -2650.000 -2050.000 -1750.000 -1460.000 -1250.000 -1065.000 -950.000 -4250.000 -1650.000 -1050.000 -750.000 -460.000 -250.000 -250.000 -50.000 -3250.000 -650.000 -500.000 -300.000 -100.000 0.000 100.000 300.000 -2250.000 -750.000 -550.000 -350.000 -150.000 50.000 250.000 450.000 -1250.000 -850.000 -600.000 -400.000 -200.000 0.000 200.000 400.000 -1250.000 -1050.000 -850.000 -650.000 -450.000 -250.000 -50.000 350.000 -1500.000 -1300.000 -1100.000 -900.000 -700.000 -500.000 -300.000 100.000 -1750.000 -1550.000 -1350.000 -1150.000 -950.000 -750.000 -550.000 -150.000 -2000.000 -1800.000 -1600.000 -1400.000 -1200.000 -1000.000 -800.000 -400.000 -2250.000 -2050.000 -1850.000 -1650.000 -1450.000 -1250.000 -1050.000 -650.000 -2500.000 -2300.000 -2100.000 -1900.000 -1700.000 -1500.000 -1300.000 -900.000 -2750.000 -2550.000 -2350.000 -2150.000
Image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}