Calculating the Probability Distribution Assignment
Order ID |
53563633773 |
Type |
Essay |
Writer Level |
Masters |
Style |
APA |
Sources/References |
4 |
Perfect Number of Pages to Order |
5-10 Pages |
Description/Paper Instructions
Calculating the Probability Distribution Assignment
Question 1: Probability Distribution (35 points)
We are given a sample of past 100 daily profits of a store. Examine the following distribution fit to the profit generated with @Risk:
Answer the following question:
- a) (3 pt.) Determine whether variable profit in this sample is continuous or discrete and explain.
- b) (3 pt.) What is the mean and standard deviation of the profit sample?
- c) (3 pt.) Determine the best distribution fit (based on the Chi-square statistic) from the list of candidate distributions used.
- d) (8 pt.) The analytical consultant of the store suggests using a Normal distribution to simulate future daily profits of the store and use that to estimate the annual profits. Do you agree with this consultant? Explain!
- e) (8 pt.) Another analytical consultant argues that using an empirical distribution to simulate future profits is better than fitting a theoretical distribution. Do you agree with this consultant? Explain!
- f) (10 pt.) If you were an analytical consultant, what would be your recommendation to simulate future profits (in terms of distribution)?
Question 2: Simulation (35 points) – Do not build simulation model –
Alphans, Inc. is a small company that designs, produces and sells Ski jackets and other coats. The creative design team has labored for weeks over its new design for the coming winter season. It is now time to decide how many Ski jackets to produce in the production run. Because of the lead times involved, no other production runs will be possible during the season. Predicting sales of Ski jackets months in advance of the selling season can be quite tricky. Alphans has been in operation for only 3 years, and its Ski jacket designs were quite successful in two of those years. Based on realized sales from the last 3 years, current economic conditions and professional judgment, the company has estimated demand for their new design for the upcoming season.
To assist in the decision on the number of units for the production run, management has gathered the data below. Note that R is the price Alphans charges retailers. If Alphans does not produce enough jackets, there will be a shortage cost S per unit of demand that is not satisfied. Any Ski jackets that do not sell during the season can be sold by Alphans to discounters for V per jacket. The fixed cost of plant and equipment is F. This cost is incurred regardless of the size of the production run. The variable cost per jacket is C.
Variable production cost per unit (C): |
$70 |
Shortage cost (S) |
$10 |
Retail price per unit (R): |
$100 |
Salvage value per unit (V): |
$20 |
Fixed production cost (F): |
$50,000 |
You have been asked to assist the Alphans management in deciding on the best quantity for the production run. They are interested in maximizing their mean profit, but at the same time they do not want to be exposed to large downside risk because they do not have large cash reserves as a young company.
You realize that simulation can be quite helpful. In particular, you realize the demand (D) is uncertain and your goal is to pick the best quantity (Q) for the production run. You use the normal distribution with mean 9,000 units and a standard deviation of 1,500 units to estimate the demand based on the prediction of the employees.
- a) (8 pt.) Given the above information (C, S, R, V, F, D, and Q), formulate an expression to calculate the profit from Ski jackets. Be as specific as possible for full credit.
Assume you built a simulation model that calculates the expected profit for Alphans when 9,000 Ski jackets are produced based on 1,000 iterations. The profit distribution generated is given in the figure below:
- b) (7 pt.) Explain the shape of the distribution. In particular: why is there a spike?
- c) (7 pt.) How would the profit change if the standard deviation of the demand increases? Answer in terms of expectedprofit and risk.
- d) (7 pt.) How would the profit change if you simulated 2,000 iterations of demand, instead of 1,000 iterations? Answer in terms of expectedprofit and risk.
Now, assume you use the RiskSimTable() function to test multiple values of Q, ranging from 5,000 to 12,000 in increments of 1,000, and compute the Mean, Standard Deviation, and the Probability that a profit will be below $0 (probability of loss). The simulated table is given below:
- e) (3 pt.) Given this table, what is the value of Qthat maximizes the expected profit?
- f) (3 pt.) If you were risk averse, what is your recommended quantity (Q) for the production? Explain.
Question 3: Optimization (30 points) – Do not build optimization model –
Ossur, a small prosthesis manufacturer has been contracted by the Red Cross to provide artificial legs and arms for those injured in the Haiti earthquake, at the manufacturing cost (so Ossur gets no profit, but does not lose money either). Ossur specializes in two types of prosthesis, socket limb made out of silicon and aluminum, and flex-foot mostly made of aluminum and plastics. Due to the size of the humanitarian situation in Haiti, all limbs produced by Ossur can be used by the Red Cross.
Ossur has set up a linear optimization model to maximize the number of artificial limbs produced given the limited extra capacity Ossur has for the Haiti production. The information about the excess capacity available and the time each product takes during each production step is given below.
|
Socket
limb |
Flex-
foot |
Excess Capacity
(hrs) |
Manufacturing (hrs) |
3 |
4 |
800 |
Silicon Molding (hrs) |
2 |
|
200 |
Packaging (hrs) |
0.5 |
0.2 |
120 |
- a) (6 pts) Define the decision variables for Ossur’s problem.
- b) (3 pts) Specify the objective for this problem.
- c) (9 pts) Formulate the constraints for this problem as a function of the inputs specified in the problem and the decision variables defined in (a).
Assume you run the model defined in (a)-(c) in Excel Solver.
- d) (3 pts) If the manufacturing constraint has a shadow price of 0.25, would that imply that manufacturing is a binding or non-binding constraint? Explain.
- e) (9 pts) Assume that the optimal solution uses 75 units of the packaging capacity. Would the solution (decision and objective) change if we –
- increase packaging capacity by 35? Explain.
- increase packaging capacity by 75? Explain.
iii. decrease packaging capacity by 50? Explain.
5.0%90.0%5.0%
-$174,873$216,544
Profit
Profit
Minimum-$500,000.00
Maximum$219,946.88
Mean$112,376.91
Std Dev$132,466.49
Values1000
@RISK Textbook Version
For Academic Use Only
Simulation Run1
2
3
4
5
6
7
8
Order quanity (Q)5000
6000
7000
8000
9000
10000
11000
12000
Mean profit59,795$ 98,814$ 134,241$ 159,565$ 166,109$ 149,566$ 114,248$ 68,825$
Standard deviation of profit15,041$ 15,757$ 21,732$ 39,682$ 66,636$ 92,751$ 109,921$ 117,501$
Probability of loss0.00180.00190.00480.01310.03410.07880.15930.2803
RUBRIC
QUALITY OF RESPONSE |
NO RESPONSE |
POOR / UNSATISFACTORY |
SATISFACTORY |
GOOD |
EXCELLENT |
Content (worth a maximum of 50% of the total points) |
Zero points: Student failed to submit the final paper. |
20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. |
30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. |
40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. |
50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. |
Use of Sources (worth a maximum of 20% of the total points). |
Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. |
5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. |
10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. |
15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. |
20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. |
Grammar (worth maximum of 20% of total points) |
Zero points: Student failed to submit the final paper. |
5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors |
10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors |
15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. |
20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. |
Structure of the Paper (worth 10% of total points) |
Zero points: Student failed to submit the final paper. |
3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. |
5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper |
7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. |
10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. |
|
|
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
|
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!! |
|
|
PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!