MS6000 Final ExamDETAILS AND INSTRUCTIONS:The final exam consists of 3 sections, A, B and C.Questions 1 – 10 in part A are price 3 factors every, for a complete of 30 factors.Sections B and C include issues it’s worthwhile to mannequin in excel and utilizing Solver (Part B) and/ or Macros (Part C). In complete,they’re every price 35 factors.Please comply with these directions rigorously: Your final exam submission ought to consist of 1 single Excel doc. The first tab shouldcontain your solutions to all questions within the final exam, the place one column corresponds to the Question Assignment # and the column to the best of itcontains your reply. The subsequent two tabs ought to include your fashions for sections B and C, respectively. Your Excel file must benamed together with your title, the course # and the phrases ‘final exam’ as: lastname_firstname_MS6000_final exam.xlsx. The file must beemailed to me as an attachment by 11:59pm Might 07, 2016 or you’ll not obtain credit score.Good Luck!SECTION A: A number of Alternative and True/FalseUse the under determination tree illustrating the R&D course of for a brand new drug to reply questions 1 and 2:Offered Greenback quantities within the determination tree are in tens of millions.1) Which of the next is a call node?A) whether or not or not medical trials are successfulC) whether or not the market is giant, medium, or smallB) whether or not or to not search FDA approvalD) whether or not or not FDA authorized12) What’s the likelihood that the drug reaches to a big market?A) zero.054B) zero.700C) zero.108D) zero.0183) Which of the next finest defines payback interval?A) It’s the quantity of time intervals earlier than the web expenditure exceeds the quantity of the preliminary funding.B) It’s the quantity of time intervals earlier than the quantity of the preliminary funding exceeds the money inflows of aproposed venture.C) It’s the quantity of time intervals earlier than the money inflows of a proposed venture exceed the quantity of theinitial funding.D) It’s the quantity of time intervals earlier than the money inflows of a proposed venture equal the quantity of theinitial funding.Use the under payoff desk with 4 mortgage choices to reply Question Assignment four:four) Which of the next selections has the very best common payoff?A) 1-year ARMB) 30-year fixedC) 3-year ARMD) 5-year ARM5) In linear optimization fashions, an goal perform is the.A) unknown worth that the mannequin seeks to determineB) limitation or requirement that call variables should satisfyC) set of values that satisfies all of the constraintsD) amount that we search to attenuate or maximize6) An optimum resolution is.A) the limitation or requirement that call variables should satisfyB) often known as the constraint functionC) the amount that we search to attenuate or maximizeD) any set of determination variable values that maximizes or minimizes the target function7) Theis the distinction between the right- and left-hand sides of a constraint.A) shadow priceB) slackC) optimum solution2D) allowable increase8) Integer linear optimization fashions differ from nonlinear optimization fashions in that integer linear optimizationmodels.A) include phrases that can not be written as fixed occasions a variableB) include some or all variables which can be restricted to being complete numbersC) use solely equalities to explain the constraintsD) use solely inequalities to explain the constraints9) What’s Monte Carlo simulation?A) It’s a ratio of the departure of an estimated parameter from its notional worth and its customary error.B) It’s a measure of the correlation between two variables X and Y that falls completely between the values+1 and -1.C) It’s the course of of producing random values for unsure inputs in a mannequin, computing the outputvariables of curiosity, and repeating this course of for a lot of trials with a view to perceive the distribution ofthe output outcomes.D) It’s an method for growing a complete understanding and consciousness of the chance associatedwith a selected variable of curiosity.10) Danger Assessment seeks to look at the impacts of uncertainty within the estimates and their potential interplay withone one other on the output variable of curiosity. True or False?3SECTION B: Linear Optimization ModelingProblem: Burger Workplace Tools produces two varieties of desks: customary and deluxe. Deluxe desks haveoak tops and dearer hardware and require further time for ending and sprucing. Standarddesks require 80 sq. ft. of pine and 10 hours of labor, whereas deluxe desks require 60 sq. ft. of pine, 18 sq.ft. of oak, and 16 hours of labor. For the following week, the corporate has 5,000 sq. ft. of pine, 750 sq. ft. ofoak, and 400 hours of labor out there. Commonplace desks web a revenue of $150, whereas deluxe desks web a profitof $320. All desks could be bought.1) Develop a linear mathematical optimization mannequin to find out what number of of every desk thecompany ought to make subsequent week to maximise revenue contribution.2) Implement your mannequin on a spreadsheet and discover an optimum resolution utilizing Solver.3) Clarify the decreased value related to customary desks.four) What constraints are binding?5) If 25% of the oak is set to be cosmetically faulty, how will the optimum resolution beaffected?6) The store supervisor has instructed that his employees be allowed to work a further 50 hours atan additional time premium of $12/hr – is that this a good suggestion? Why or why not?SECTION C: Monte Carlo SimulationProblem: Suppose an worker begins working after finishing her MBA at age 30 at a beginning wage of$50,000. She expects an annual wage enhance to be at minimal 1%, at most 5%, with a uniformdistribution. Her retirement plan requires that she contribute eight% of her wage, and her employer matchesthat by including a further 35% of her contribution. She anticipates an annual return on her retirementportfolio (i.e., return on funding) to be a traditional distribution with a imply of four% and customary deviationof 3.5%. She plans to retire at age 60. Create a spreadsheet mannequin to forecast her common return oninvestment (i.e., retirement account steadiness) when she retires at age 60 based mostly on 5,000 simulation trials.1) What’s the anticipated common steadiness of her retirement account when she retires at age 60?2) What’s the likelihood that her ending retirement steadiness at age 60 might be over $450okay?Generate a histogram or density chart that reveals this.SECTION D: Additional Credit score- Monte Carlo Simulation with Linear Optimization (+15 factors) – Saveyour workbook as macro enabled.Downside: You wish to optimize the amount of product shipped to your 11 retail shops out of your fourdistribution facilities to attenuate the price. Nonetheless, you have no idea what demand might be at your retailstores. You’ve got some concept of anticipated demand (imply) and the dispersion (customary deviation) and1) Wish to estimate what your most anticipated prices might be 70% of the time?2) You wish to know the likelihood of prices being not more than $50,000?four

Published by

Essays

View all posts