Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Change the price to determine the change in units sold. 122 Current Scenario Selling Price Units Sold Revenue$3 639 699 975,00 Cost/Unit Variable Cost
2. Change the price to determine the change in units sold.
122 Current Scenario Selling Price Units Sold Revenue$3 639 699 975,00 Cost/Unit Variable Cost $771 699 970,00 Fixed Cost$1 272 400 000,00 Begin with the intial scenario assumptions. Use Excel Goals Seek to Adjust the following: $48 529 333,00 1. Change the units sold to determine the impact upon profit. 2. Change the price to determine the change in units sold. 3. Change the profit to a break even scenario to determine standard benchmarks to compare and contrast throughout your scenario development. Note: All actions are conducted via Goal Seek. Be sure to recognize the a break-even value should be set to zero. We need to eliminate the current loss scenario. Optimize with your revisions! 0 troughout your scenario developme Be sure to recognize the a 1 595 600 005,00$ Change Price 3 Selling Price 4 Units Sold 5 Revenue $3 639 699 975,00 6 Cost/Unit 7 Variable Cost $771 699 970,00 8 Fixed Cost$1272 400 000,00 9 Profit Change Units Sold Selling Price Units Sold Revenue$3 639 699 975,00 Cost/Unit Variable Cost $771 699 970,00 Fixed Cost $1 272 400 000,00 Profit1 595 600 005,00 $ Change Fixed Cost Selling Price Units Sold$48 529 333,00 Revenue $3 639 699 975,00 Cost/Unit Variable Cost $771 699 970,00 Fixed Cost $1 272 400 000,00 Profit $75,00 $48 529 333,00 $75,00 $48 529 333,00 $75,00 m0 $1,00 $1,00 1 595 600 005,00 $ 1 595 600 005,00 $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