Microsoft Office Tutorials and References
In Depth Information
c. Also, provide summary data for all the profit combinations for the problem–
average, max, min, and standard deviation.
d. Data elements for the problem:
i. Revenue $100 k and $190 k (Option Button)
ii. COGS % of Revenue with outcomes of 24 and 47% (Option Button)
iii. Variable costs % of Revenue with outcome 35 and 45% (Option Button)
iv. Fixed costs $20 k to $30 k in increments of $5 k (Scroll bar)
e. Create a Data Table that will permit you to change (with a scroll bar) the
fixed cost in increments of $1 k that will result in instantaneous changes
in the graph of the risk profile. Hint: combine (d-ii) and (d-iii) as a single
variable and as a single dimension of a two variable Data Table, while using
revenue as the second dimension. Fixed cost will act as a third dimension in
the sensitivity analysis, but will not appear on the borders of the two variable
Data Table.
Search JabSto ::

Custom Search