Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Company A expects their production revenue in 2021 become RM250,500 with the overall fixed cost (FX) RM60,000 and variable cost (VC) RM100,000. The
The Company A expects their production revenue in 2021 become RM250,500 with the overall fixed cost (FX) RM60,000 and variable cost (VC) RM100,000. The standard deviation of revenue, FC and VC are described in Table Revenue Fixed Cost Variable Cost Expected 250,500 61000 110000 St. Dev. 15500 4100 41000 If the distribution the simulation is assumed NORMAL, by using Monte-carlo method in excel: a. Calculate the expected profit in the first calculation. b. Identify the calculation of 700 iterations for Mean, Standard Deviation, minimal and maximal value. c. Calculate potential risk of loss for 700 iterations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started