Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Why is every one of my RiskDiscrete formula off by 2 in the first digit? I have provided some examples in the pics. The first

Why is every one of my RiskDiscrete formula off by 2 in the first digit? I have provided some examples in the pics. The first example should be 30000 not 50000.

image text in transcribed
X fix =RiskDiscrete($B$5:$8$6,$C$5:$C$6) A B C D E F G ow-cost, high-volume sales Distribution of sales Value Prob Price OW 30000 0.5 $20 High 70000 0.5 $15 Mean 50000 $ 17.50 Distribution of variable cost per unit Value Prob $10.00 0.20 $11.00 0.60 $12.00 0.20 Mean $11.00 Annual fixed cost $20,000 Simulation for part a Units sold Fixed cost Variable cost Revenue Profit 50000 $20,000 $550,000 #NAME? #NAME? Annual profit for part c, no uncertainty Units sold Fixed cost Variable cost Revenue Profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course In Differential Equations

Authors: Kumari Vandana

1st Edition

9353147123, 9789353147129

More Books

Students also viewed these Mathematics questions