Soft pretzels. Build a spreadsheet model that contains the following information. Market size 100,000 units Normally...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Soft pretzels. Build a spreadsheet model that contains the following information. Market size 100,000 units Normally distributed with a standard deviation of 10,000 units 22% Market share Triangular distribution, minimum = 16%, most likely = 22%, maximum = 28% Price per unit Variable cost per unit Fixed cost $0.50 $0.10 $7,833 Determine: the profit Profit = Revenue - (Variable cost per unit) (# of units) - Fixed cost Remember that (# of units) = (Market size)(Market share) Revenue = (Market size) (Market share) (price per unit) Find the expected mean and standard deviation for the profit. Attach your output graph. Use 1000 iterations. Enter the profit in the box to the nearest dollar, but enter only the number (no $ sign). Soft pretzels. Build a spreadsheet model that contains the following information. Market size 100,000 units Normally distributed with a standard deviation of 10,000 units 22% Market share Triangular distribution, minimum = 16%, most likely = 22%, maximum = 28% Price per unit Variable cost per unit Fixed cost $0.50 $0.10 $7,833 Determine: the profit Profit = Revenue - (Variable cost per unit) (# of units) - Fixed cost Remember that (# of units) = (Market size)(Market share) Revenue = (Market size) (Market share) (price per unit) Find the expected mean and standard deviation for the profit. Attach your output graph. Use 1000 iterations. Enter the profit in the box to the nearest dollar, but enter only the number (no $ sign).
Expert Answer:
Answer rating: 100% (QA)
Expected mean profit 11233 Standard deviation of profit 3063 further explan... View the full answer
Related Book For
Business Math
ISBN: 978-0133011203
10th edition
Authors: Cheryl Cleaves, Margie Hobbs, Jeffrey Noble
Posted Date:
Students also viewed these accounting questions
-
A printing machine is expected to be operational for 90,000 hours. If the machine costs $84,500 and has a projected salvage value of $2,900, find the unit depreciation. The machine is used for 3,853...
-
Use @RISK to draw a triangular distribution with parameters 200, 300, and 600. Then superimpose a normal distribution on this drawing, choosing the mean and standard deviation to match those from the...
-
Use @RISK to draw a triangular distribution with parameters 300, 500, and 900. Then answer the following questions. a. What are the mean and standard deviation of this distribution? b. What are the...
-
A 110 g hockey puck sent sliding over ice is stopped in 15 m by the frictional force on it from the ice. (a) If its initial speed is 6.0m/s, what is the magnitude of the frictional force? (b) What is...
-
What are the potential advantages and disadvantages of DANs (Direct Access Notes) to investors compared to conventional bonds?
-
A loan of $880 can be repaid in 15 months by paying the principal sum borrowed plus $104.50 interest. What was the rate of interest charged?
-
What information should an auditor request from a client's legal counsel in a letter of audit inc]uiry?
-
My Belle Cosmetics is a large business that has sales well ahead of any other regional cosmetics firm. As an organization, it is very sensitive to color, because it introduces new color lines in its...
-
Hudson Company reports the following contribution margin income statement. HUDSON COMPANY Contribution Margin Income Statement For Year Ended December 31 Sales (9,600 units at $225 each) Variable...
-
You work in the human resources department of your company helping new employees fill out the necessary paperwork to get their first paycheck. There are a number of decisions that employees must make...
-
Assume that instead of having available capacity, Windsor is currently operating at capacity and is selling everything it produces to its usual external customers. If Windsor takes on this special...
-
What are the primary elements of vocalics?
-
How can you use informational interviews to learn about career options?
-
What does it mean to be closed-minded?
-
What makes an interruption competitive?
-
Compare and contrast the primacy and recency effects and explain their relevance to the perception-making process.
-
Problem 2 (30 pts) (Explain your answers!) Firm A has the production function f(l, k) = 21+2k where I is units of labor, with price w = 2 and k is capital, with price r = 1. The output price is p....
-
What are the key elements of a system investigation report?
-
If STS resells the phone time all an average of 6 cents per minute, how much profit will it make on the purchase?
-
Which of the two options yields the greatest return on your investment of $2,000? Option 1: 8% annul interest compounded quarterly for four years Option 2: 8 % annul interest compounded annually for...
-
An investment of $1,000 is made for two years and is compounded semiannually at 5%. Find the future value and compound interest at the end of the two years?
-
Electronic devices contain electric circuits etched into wafers made of silicon. These silicon wafers are sealed with an ultrathin layer of silicon dioxide, in a process known as oxidation. This can...
-
Using the data in Exercise 2: a. Find the first and third quartiles of the profit. b. Find the median profit. c. Find the upper and lower outlier boundaries. d. Are there any outliers? If so, list...
-
For each of the following scatterplots, state the type of association that is exhibited: Choices: positive linear, negative linear, positive nonlinear, negative nonlinear, weak linear. b. d. e.
Study smarter with the SolutionInn App