Could you assist with showing me how to put my answers into Excel, performing a sensitivity analysis .
Use the information from Assignment 2 to perform a sensitivity analysis using Excel. Assume that each scenario that follows is independent of the others. Unless stated otherwise, the variables are the same as in the base case.
1. How will total profit change if the Laser sales price increases by 10%? No Change
Answer: Based on the information given, a 10% increase in Laser sales will not affect the profit margin of $1,000,000.00. A total of 5667 printers provides an additional $701.00 in profit revenues.
2. How will total profit change if the Inkjet sales volume decreases by 4,000 units and the sales volume of other products remains the same?
Answer: Based on the information given, the profit change will result in more printers needing to be sold for $1,000,000.00 profit margin and the annual revenues will decrease from $21,042,000.00 to $16,559,121.00. Resulting in a total of 3,694 needed to be sold to break-even and thus show a profit in sales.
3. How will total profit change if fixed costs decrease by 20%?
Answer: Based on the information given, a decrease in original fixed costs totaling $5,250,000.00 will result in a recalculated fixed cost of $4,200,000.00. A fixed cost of $4,200,000.00 will increase the profit because it will cost less to produce the same quantity of printers. The original profit would be $21,042,000.00. A 20% decrease in fixed costs will produce a profit of $22,092,000.00.
Recently Asked Questions
- How working capital relates to the company's ability to generate cash flows?
- With the implications of operating in a global environment, Why does cultural understanding matter? How can HT and line partners ensure effectiveness?
- We know that cash is important - probably the most important asset a company has, but this chapter focuses on the use of cash. Why is the monitoring of cash