question archive Question3 Excel Formulas versus @Risk Formulas Recall the IBerry example that we have studied initially
Question3 Excel Formulas versus @Risk Formulas Recall the IBerry example that we have studied initially
Subject:AccountingPrice: Bought3
Question3 Excel Formulas versus @Risk Formulas Recall the IBerry example that we have studied initially. Below are the details of some of its parameters: A B C D E F G H 1 Selling Price per Unit 2 Administrative Costs 3 Advertising Costs $249.00 $500,000 $650,000 Parts Costs - - Uniform 4 Lowest Value Highest Value $75.00 $95.00 5 Labor Direct Labor - Discrete P(Cost) Left Endpoint 6 7 10% 0% Demand - Normal 8 20% 10% Mean Cost/Unit $67.00 $68.00 $69.00 $70.00 $71.00 9 40% 30% Standard Deviation Minimum 18,000 5,500 2,000 30,000 10 20% 70% 11 10% 90% Maximum 12 13 Labor Parts 14 Trial Cost/Unit Cost/Unit Demand Revenue Total Costs Net Profit Loss? 15 1 Fill the following table with the type of distribution of each variable and the formulas you would use You may use the answer KEY for the previous Daily HW for the Excel only column Type of Excel ONLY Formulas @Risk Formulas if/when Cell Name of the Distribution applicable Variable B15 C15 D15 E15 F15 G15 H15
