A consumer electronics firm produces a line of portable power banks for mobile phones. The costs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A consumer electronics firm produces a line of portable power banks for mobile phones. The costs for production of this product line are as follows. There is a fixed cost that is normally distributed with a mean of $30,000 and a standard deviation of $5,000; and a per item (i.e., per power bank) production cost that is uniformly distributed with a minimum of $12 and a maximum of $15. The company sells the power bank at a (list) price of $28. The anticipated demand for the product follows the demand curve formula (10,000 - 250*price), and since they set the price they produce exactly this quantity. (a) Create an @RISK Simulation Model that will allow you to analyze the distribution of the profit associated with this product line. Run this simulation model for 1,000 iterations. What is the expected profit? What is the probability of making more than $5,000? (b) Marcus Boyd, Vice President for Sales and Marketing questions the assumptions of the simulation model you have just built. He contends that the actual selling price is not fixed at the "list price" of $28. Rather, it varies because of various promotions between 80% of the list price and the actual list price. Hence he suggests that you use a triangular distribution to model the actual sales price with a minimum value of 80% of list price, most likely value of 90% of list price, and maximum value of actual list price. He also recognizes that actual demand (sales), may fall short of anticipated demand (which is calculated using the demand curve formula and the official list price of $28). Specifically, actual demand will follow a uniform distribution between 90% of anticipated demand and 100% of anticipated demand. So, the production quantity (and therefore production costs) will still be based on the anticipated demand (calculated based on the list price of $28), but revenue will be based on actual demand and the actual sales price. Create an @RISK Simulation Model that incorporates Mr. Boyd's assumptions, and use it to analyze the distribution of the profit associated with this product line. Run this simulation model for 1,000 iterations. What is the expected profit? What is the probability of making more than $5,000?. (c) What is the impact on the expected profit when Mr. Boyd's assumptions are incorpo- rated? What is the impact on the probability of making more than $5,000 when Mr. Boyd's assumptions are incorporated? A consumer electronics firm produces a line of portable power banks for mobile phones. The costs for production of this product line are as follows. There is a fixed cost that is normally distributed with a mean of $30,000 and a standard deviation of $5,000; and a per item (i.e., per power bank) production cost that is uniformly distributed with a minimum of $12 and a maximum of $15. The company sells the power bank at a (list) price of $28. The anticipated demand for the product follows the demand curve formula (10,000 - 250*price), and since they set the price they produce exactly this quantity. (a) Create an @RISK Simulation Model that will allow you to analyze the distribution of the profit associated with this product line. Run this simulation model for 1,000 iterations. What is the expected profit? What is the probability of making more than $5,000? (b) Marcus Boyd, Vice President for Sales and Marketing questions the assumptions of the simulation model you have just built. He contends that the actual selling price is not fixed at the "list price" of $28. Rather, it varies because of various promotions between 80% of the list price and the actual list price. Hence he suggests that you use a triangular distribution to model the actual sales price with a minimum value of 80% of list price, most likely value of 90% of list price, and maximum value of actual list price. He also recognizes that actual demand (sales), may fall short of anticipated demand (which is calculated using the demand curve formula and the official list price of $28). Specifically, actual demand will follow a uniform distribution between 90% of anticipated demand and 100% of anticipated demand. So, the production quantity (and therefore production costs) will still be based on the anticipated demand (calculated based on the list price of $28), but revenue will be based on actual demand and the actual sales price. Create an @RISK Simulation Model that incorporates Mr. Boyd's assumptions, and use it to analyze the distribution of the profit associated with this product line. Run this simulation model for 1,000 iterations. What is the expected profit? What is the probability of making more than $5,000?. (c) What is the impact on the expected profit when Mr. Boyd's assumptions are incorpo- rated? What is the impact on the probability of making more than $5,000 when Mr. Boyd's assumptions are incorporated?
Expert Answer:
Answer rating: 100% (QA)
Creating a full RISK simulation model for this scenario requires specialized software and data input that I cannot execute in this textbased interface ... View the full answer
Related Book For
Global Marketing management
ISBN: 978-0470505748
5th edition
Authors: Masaaki Kotabe, Kristiaan Helsen
Posted Date:
Students also viewed these finance questions
-
2.9.When gas is injected into a column of water, a liquid circulation pattern develops. Thus, upflow at a rate Q, (m/s) rises in the central core and downflow occurs at a rate Q, in the annulus. If...
-
A consumer electronics firm produces a line of battery rechargers for cell phones. The following distributions apply: Unit price: triangular with a minimum of $18.95, most likely value of $24.95, and...
-
Suppose that the stock price S, follows lognormal distribution St= Soe(a-8-0.50) t+oiz Prove that the conditional expectation of lognormal prices, when terminal stock price ST falls below Kis where d...
-
You have $300,000 saved for retirement. Your account earns 6% interest. How much will you be able to pull out each month, if you want to be able to take withdrawals for 20 years? $ Get help: Video
-
The oceans contain a tremendous amount of thermal (internal) energy. Why, in general, is it not possible to put this energy to useful work?
-
Describe the three major financial statements, including comparing and contrasting their uses in financial management. Compare and contrast the three major financial statements and their components....
-
Suppose that in the maintenance of a large medicalrecords file for insurance purposes the probability of an error in processing is 0.0010, the probability of an error in filing is 0.0009, the...
-
Orion Corporation has established the following standards for the prime costs of one unit of its chief product, dartboards. Standard Quantity Standard Price or Rate Standard Cost Direct...
-
What methodologies are employed in crisis anticipation, encompassing scenario analysis and risk assessment, to enhance organizational resilience ?
-
East Hill Home Healthcare Services was organized on January 1, 2014, by four friends. Each organizer invested $10,000 in the company and, in turn, was issued 8,000 shares of $1.00 par value stock. To...
-
Given: Y: a. domain b. range c. asymptotes d. x-intercepts e. y-intercepts 10 x+1 - -8 find:
-
Suppose your employer offers you a choice between a $5700 bonus and 120 shares of the company stock. Whichever one you choose will be awarded today. The stock is currently trading for $58 per share....
-
You have just taken out a five-year loan from a bank to buy an engagement ring. The ring costs $6000. You plan to put down $2000 and borrow $4000. You will need to make annual payments of $1250 at...
-
Consider the most appropriate research methodology to use when conducting a study of the motivation of sales representatives.
-
Suppose the current market price of corn is $4.23 per bushel. Your firm has a technology that can convert 1 bushel of corn to 3 gallons of ethanol. If the cost of conversion is $1.47 per bushel, at...
-
You currently have a four-year-old mortgage outstanding on your house. You make monthly payments of $2000. You have just made a payment. The mortgage has 26 years to go (i.e., it had an original term...
-
Graph the function f(x)=x-5. Plot the vertex. Then plot another point on the parabola. If you make a mistake, you can erase your parabola by selecting the second point and placing it on top of the...
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
How are regional and global strategies different? What are some advantages and disadvantages of a regional strategy?
-
What are the challenges posed by EMs in the area of distribution and communications? What are some of the solutions?
-
AOL Goes Far East (Case #24, Notes) Discussion Questions 1. Was Mitsui the best partner for AOL to enter the Japanese market? If so, why? If not, who (or what kind of company) would make a better...
-
Consider a stochastic process such that the underlying security \(S\) follows the model: \[d S_{t}=\mu S_{t} d t+\sigma_{t} S_{t} d Z_{t}\] where \(Z\) is a standard Brownian motion. Suppose the...
-
Calculate the solution to the following SDE: \[d X_{t}=\alpha\left(m-X_{t} ight) d t+\sigma d B_{t}\] with \(X_{0}=x\). The process satisfying this equation is called the meanreverting...
-
If \(X_{t} \sim N(0, t)\), calculate the distribution of \(\left|X_{t} ight|\). Calculate \(\mathbf{E}\left|X_{t} ight|\) and \(V\left(\left|X_{t} ight| ight)\).
Study smarter with the SolutionInn App