Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Students are advised to download SIMULATION WORKSHEET 1 from Additional Course Material, understand and generate their own worksheet. Do write your name on top. You
Students are advised to download SIMULATION WORKSHEET 1 from Additional Course Material, understand and generate their own worksheet. Do write your name on top. You may change the ranges for demand, selling price, unit production and material costs.
AutoSave Off WORKSHEET FOR SIMULATION (1) (3) - Protected View Search A mjensinee@gmail.com M File Home Insert Page Layout Formulas Data Review View Help Share Comments i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate X B34 X ESTDEV(B10:B29) A D H J K L M N o Q R F 3 This worksheet simulates weekly profit for 20 weeks and computes statistics. 4 5 There are four uncertainties and they are: demand selling price, unit production, and material costs. 6 Weekly demand and unit production cost are normally distributed. 7 Selling price and unit material cost are uniformally distributed. 8 Unit Production cost 1 9 No 10 1 11 2 12 3 13 4 14 5 15 6 16 7 17 8 18 9 19 10 20 11 21 12 22 13 Weekly Demand 560 522 437 506 507 501 475 487 543 579 497 537 515 Selling Price 96.39 96.48 94.73 84.90 99.85 94.63 93.45 81.08 80.07 96.91 85.47 88.66 82.05 Weekly Revenue 53961.58 50369.97 41358.28 42919.04 50649.50 47427.67 44408.48 39494.32 43483.53 56081.72 42462.84 47615.71 42287.40 51.88 76.56 62.99 57.66 55.28 62.38 47.27 26.97 51.77 44.23 57.49 53.04 46.72 Unit Material Cost 30.53 32.29 31.76 36.09 35.33 30.99 36.87 37.82 33.18 30.77 35.86 35.21 39.01 Total Weekly cost 46136.31 56830.38 41368.01 47396.56 45965.58 46796.93 39983.46 31564.92 46135.47 43406.37 46379.27 47390.07 44182.25 Weekly Profit 7825.27 -6460.42 -9.73 -4477.52 4683.92 630.75 4425.02 7929.40 -2651.94 12675.35 -3916.42 225.64 -1894.85 Sheet1 + @ 100% AutoSave Off WORKSHEET FOR SIMULATION (1) (3) - Protected View Search A mjensinee@gmail.com M File Home Insert Page Layout Formulas Data Review View Help Share Comments i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X i SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled. Reactivate X B34 X ESTDEV(B10:B29) A D H J K L M N o Q R F 3 This worksheet simulates weekly profit for 20 weeks and computes statistics. 4 5 There are four uncertainties and they are: demand selling price, unit production, and material costs. 6 Weekly demand and unit production cost are normally distributed. 7 Selling price and unit material cost are uniformally distributed. 8 Unit Production cost 1 9 No 10 1 11 2 12 3 13 4 14 5 15 6 16 7 17 8 18 9 19 10 20 11 21 12 22 13 Weekly Demand 560 522 437 506 507 501 475 487 543 579 497 537 515 Selling Price 96.39 96.48 94.73 84.90 99.85 94.63 93.45 81.08 80.07 96.91 85.47 88.66 82.05 Weekly Revenue 53961.58 50369.97 41358.28 42919.04 50649.50 47427.67 44408.48 39494.32 43483.53 56081.72 42462.84 47615.71 42287.40 51.88 76.56 62.99 57.66 55.28 62.38 47.27 26.97 51.77 44.23 57.49 53.04 46.72 Unit Material Cost 30.53 32.29 31.76 36.09 35.33 30.99 36.87 37.82 33.18 30.77 35.86 35.21 39.01 Total Weekly cost 46136.31 56830.38 41368.01 47396.56 45965.58 46796.93 39983.46 31564.92 46135.47 43406.37 46379.27 47390.07 44182.25 Weekly Profit 7825.27 -6460.42 -9.73 -4477.52 4683.92 630.75 4425.02 7929.40 -2651.94 12675.35 -3916.42 225.64 -1894.85 Sheet1 + @ 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started