subject
Business, 24.06.2020 05:01 bbqchicken243

Develop an Excel worksheet simulation for the following problem. The management of Paragon Household Products is considering the introduction of a new product. The fixed cost to begin the production of the product is $25,388. The variable cost for the product is uniformly distributed between $15 and $20 per unit. The product will sell for $42 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1200 units and a standard deviation of 300 units. Develop a spreadsheet simulation that uses 500 simulation trials:A. What is the mean profit for the simulation?B. What is the probability that the project will result in a loss?C. What is your recommendation concerning the introduction of the product?

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 11:50
The basic difference between macroeconomics and microeconomics is that: a. microeconomics looks at the forest (aggregate markets) while macroeconomics looks at the trees (individual markets). b. macroeconomics is concerned with groups of individuals while microeconomics is concerned with single countries. c. microeconomics is concerned with the trees (individual markets) while macroeconomics is concerned with the forest (aggregate markets). d. macroeconomics is concerned with generalization while microeconomics is concerned with specialization.
Answers: 3
question
Business, 22.06.2019 12:30
True or false entrepreneurs try to meet the needs of the marketplace by supplying a service or product
Answers: 1
question
Business, 22.06.2019 20:20
An economic theory that calls for workers to take control of factories is .
Answers: 3
question
Business, 22.06.2019 21:10
This problem has been solved! see the answerthe xyz corporation is interested in possible differences in days worked by salaried employees in three departments in the financial area. a survey of 23 randomly chosen employees reveals the data shown below. because of the casual sampling methodology in this survey, the sample sizes are unequal. research question: are the mean annual attendance rates the same for employees in these three departments? days worked last year by 23 employees department days worked budgets (5 workers) 278 260 265 245 258 payables (10 workers) 205 270 220 240 255 217 266 239 240 228 pricing (8 workers) 240 258 233 256 233 242 244 249 picture click here for the excel data filefill in the missing data. (round your p-value to 4 decimal places, mean values to 1 decimal place and other answers to 2group mean n std. dev variancesbudgets payables pricing total one factor anova source ss df ms f p-value treatment error total
Answers: 2
You know the right answer?
Develop an Excel worksheet simulation for the following problem. The management of Paragon Household...
Questions
question
Mathematics, 11.03.2021 05:10
question
Business, 11.03.2021 05:10
Questions on the website: 13722360