View the step-by-step solution to:

Could you assist with showing me how to put my answers into Excel, performing a sensitivity analysis . Use the information from Assignment 2 to...

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

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question