Igonz532-QMB4680-Final Exam - Excel Laura Gonzalez Garcia O X File Home Insert Page Layout Formulas ata Review View Help Team 9 Tell me what you want to do Share i) From Text/CSV Recent Sources fault&mobileredirect=true& Do From Web Queries & Connections 21 4 Clear [ Existing Connections Properties Group - + 2, Solver Refresh Al Sort To Reapply Filter Text to 1 08 Ungroup . Data - Will From Table/Range All - Edit Links Advanced Columns Ed . ) Analysis forecast Subtotal Get & Transform Data Queries & Connections Sort & Filter Data Tools Forecast Outline Analyze Al 1 X V fx = Q2 " ! B C D E G H K QUESTION 2 Mariah Enterprises makes a variety of consumer electronic products. Its camera lenses manufacturing plant is currently evaluating produc Fixed costs for the operations of the plant are estimated to be $20,250. The production costs per unit for each type of lens are as follows : The probability distribution for the demand of for each type of camera lenses is shown on the following tables Type 1 Probability Type 2 Probability Type 3 Proba 230 0.31 400 0.22 50 290 0.29 580 0.4 200 360 0.15 660 0.28 320 500 0.25 740 0.1 350 9 Conduct a sampling experiment using the random numbers given to estimate the TOTAL PRODUCTION COSTS for the plant and calculate its mean, minimum Price $28.50 Total Type 2 Production Type 1 Variable Varia 11 tal Production Costs Costs RANDOM# Variable Costs RANDOM Costs RANDOM# Cos 12 0.10408 0.81991 0.70763 0.25591 0.48158 0.83403 N m N m 14 H NM Th 0.44990 0.92026 0.85002 15 Maximum 0.12397 0.66826 0.2319 0.93666 0.20524 0.77342 17 Minimum 0.56463 0.62361 0.32086 18 0.38722 0.16142 0.14892 19 Standard deviation 8 0.78177 0.55414 0.65277 0.68921 0.6364 0.53025 10 0.4724 10 0.66346 | INFO | Q1 Q2 Q3 Q4 / Q5 / 26 | 97 | 08 Point Type here to search 79.F Mostly sunny ~ () 11:14 AM 1 0 O Hi Tka F10 ES F6Data . From Table/ All - Edit Links Text to Advanced Columns 20 - What-If F Analysis . Sheet Subtotal Get & Transform Data Queries & Connections Sort & Filter Data Tools Forecast Outline Analyze Al X V fx = Q2 "! E G H K M N P Q 1 f consumer electronic products. Its camera lenses manufacturing plant is currently evaluating production costs for their top 3 type of lenses. plant are estimated to be $20,250. The production costs per unit for each type of lens are as follows : Type 1 : $28.50, Type 2 : $19.25 and Type 3 :$13.00 pe emand of for each type of camera lenses is shown on the following tables : Type 1 Probability Probability Type 3 Probability 230 0.31 400 0.22 50 0.23 + in 10 1 00 290 0.29 580 0.4 200 0.29 360 0.15 660 0.28 320 0.15 500 0.25 740 0 . 1 350 0.33 9 bers given to estimate the TOTAL PRODUCTION COSTS for the plant and calculate its mean, minimum, maximum and standard deviation. Price $28.50 Type 2 Type 3 Type 1 Variable Variable RANDOM# Variable Costs RANDOM# Costs RANDOM# Costs 1 0.10408 0.81991 0.70763 0.25591 N 0.48158 0.83403 0.44990 m 0.92026 0.85002 0.12397 0.66826 0.23191 0.9366 0.20524 0.7734 0.56463 6 0.62361 0.32086 0.38722 0.16142 0.14892 0.78177 0.55414 0.65277 0.6892 9 0.63648 0.53025 21 10 0.51969 10 0.47244 10 0.66346 22 23 INFO | Q1 Q2 Q3 Q4 | Q5 | 06 | 07 | 98 | @ Point Type here to search 79.F Mostly sunny ~ (3) 1:14 AM DELL FS FO F10