Question: complete the following excel sheet Problem 10-14 Data Table Week Demand Profit 200 Profit $50.00 1 2 3 4 5 Based on 1 replication: Average

complete the following excel sheet complete the following excel sheet Problem 10-14 Data Table Week Demand Profit

Problem 10-14 Data Table Week Demand Profit 200 Profit $50.00 1 2 3 4 5 Based on 1 replication: Average profit Prob (Profit >$2000) 51.786.54 0.1731 Based on 200 replications: Average profit Prob (Profit >= $2000) $1.756.54 0.1731 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 33 36 38 37 37 28 23 34 35 37 37 27 38 33 34 34 43 37 39 33 44 39 40 27 45 25 39 41 43 30 33 35 38 37 36 35 33 34 40 39 30 42 29 36 30 39 33 38 37 31 48 39 $1,650.00 $1,800.00 $1.900.00 $1,850.00 $1,850.00 $1,400.00 $1,150.00 $1,700.00 $1,750.00 $1,850.00 $1,850.00 $1,350.00 $1,900.00 $1,650.00 $1,700.00 $1,700.00 $2,150.00 $1,850.00 $1,950.00 $1.650.00 $2,200.00 $1.950.00 $2,000.00 $1,350.00 $2,250.00 $1,250.00 $1.950.00 $2.050.00 $2,150.00 $1,500.00 $1,650.00 $1.750.00 $1,900.00 $1,850.00 $1,800.00 $1,750.00 $1,650.00 $1,700.00 $2.000.00 $1.950.00 $1,500.00 $2,100.00 $1,450.00 $1,800.00 $1,500.00 $1.950.00 $1,650.00 $1,900.00 $1,850.00 $1,550.00 $2,400.00 $1,950.00 Prob >= Run Avg profit 1 $1,786.54 17.31% 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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 45 46 47 48 49 50 51 52 Problem 10-14 Data Table Week Demand Profit 200 Profit $50.00 1 2 3 4 5 Based on 1 replication: Average profit Prob (Profit >$2000) 51.786.54 0.1731 Based on 200 replications: Average profit Prob (Profit >= $2000) $1.756.54 0.1731 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 33 36 38 37 37 28 23 34 35 37 37 27 38 33 34 34 43 37 39 33 44 39 40 27 45 25 39 41 43 30 33 35 38 37 36 35 33 34 40 39 30 42 29 36 30 39 33 38 37 31 48 39 $1,650.00 $1,800.00 $1.900.00 $1,850.00 $1,850.00 $1,400.00 $1,150.00 $1,700.00 $1,750.00 $1,850.00 $1,850.00 $1,350.00 $1,900.00 $1,650.00 $1,700.00 $1,700.00 $2,150.00 $1,850.00 $1,950.00 $1.650.00 $2,200.00 $1.950.00 $2,000.00 $1,350.00 $2,250.00 $1,250.00 $1.950.00 $2.050.00 $2,150.00 $1,500.00 $1,650.00 $1.750.00 $1,900.00 $1,850.00 $1,800.00 $1,750.00 $1,650.00 $1,700.00 $2.000.00 $1.950.00 $1,500.00 $2,100.00 $1,450.00 $1,800.00 $1,500.00 $1.950.00 $1,650.00 $1,900.00 $1,850.00 $1,550.00 $2,400.00 $1,950.00 Prob >= Run Avg profit 1 $1,786.54 17.31% 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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 45 46 47 48 49 50 51 52

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 Accounting Questions!