\fProfit Analysis Parameters Unit price Unit cost Quantity sold Fixed costs Model Unit price Unit cost Quantity sold Fixed costs Revenue Variable costs Total costs Profit Min $18.95 $12.00 Likely $24.95 Max $26.95 $15.00 Mean Std Dev 0 $30,000 10 $5,000 R&D Planning Parameters R&D Costs Product Life Yearly Sales Sale Price Mfg. Cost Cost of Capital Minimum $4,000,000 3 100 $20,000 $11,000 Most Likely $7,000,000 Sales Revenue 300 $13,000 10% Maximum $9,000,000 10 500 $25,000 $15,000 Calculations R&D Costs Product Life Sale Price Mfg. Cost Yearly results Year 1 2 3 4 5 6 7 8 9 10 NPV Cost Profit Health Claims Parameters Employees EE Contribution Claim cost 11,124 $125 $250 Emp Growth Min growth -2% Claim Mean 1% Model Month 1 2 3 4 5 6 7 8 9 10 11 12 Total cost Employees Average claims Monthly cost Max growth 5% St. Dev. 2% OM 420 Computer Simulation Fall 2016 Homework #2 Due: Tuesday, September 13 @ 5pm You should work individually on this assignment, but you may discuss and debate your answers with your classmates. 1. SUS: p. 67, #1 2. SUS: p. 67, #2 3. SUS: p. 67, #6 Note: when developing all spreadsheet simulation models, make sure to apply the spreadsheet design principles as discussed in class. Inappropriate/poor spreadsheet design is subject to point deductions. You should use three separate worksheets for each problem (simulation model) under the same workbook. In other words, you are supposed to submit only one excel file that contains your solution with respect to the three problems asked in the assignment. Don't forget to upload your completed assignment to Bb Learn prior to the due date