s. Calculate the total profit for different scenarios assuming 50%o,60%,70".,80", 90% und 100". f crude sold in highest prices (Hint, Use What if Analysis) . 6 Create the summary in the Pivot tabl report along with pivot chart. Apply various filters to the Pivot table and and see the various dimensions of the data in the Pivot chart.

Perform goal seek to set the total profit as '' 2800000''

- t Excel | - 91 - Arial A A A- * % = = = = = UIB E B A C Crude Oil Prices % sold for the highest price Total barrels on One Day 2 3 4 5096 1000000 5 Profil per barrel Planned Sales per barrel 25 $ 500000 Highest price 8 - 25 1500000 Lowest price | I 10 Total Profit $ 25,000,000 0000000 11 12 12 3 EMG . . W - t Excel | - 91 - Arial A A A- * % = = = = = UIB E B A C Crude Oil Prices % sold for the highest price Total barrels on One Day 2 3 4 5096 1000000 5 Profil per barrel Planned Sales per barrel 25 $ 500000 Highest price 8 - 25 1500000 Lowest price | I 10 Total Profit $ 25,000,000 0000000 11 12 12 3 EMG . . W