don't simply copy and paste the answer which is already in the Chegg... i want the clear working and with the explanation about this problem.... i think the answer which is posted in Chegg is wrong so I'm asking with working in excel sheet

(hedging with forward contracts) The specialty Chemical company operates a crude oil refinery located in New Iberia, Louisiana. The company refines crude oil and sells the by products to companies that make plastic bottles and jugs. The firm is currently planning for its refining needs for one year hence. Specifically, the firm's analysis estimate the Speciality will need to purchase 1 million barrels of crude oil at the end of the current year to provide the feed stock for its refining needs for the coming year. The 1 million barrels of crude will be converted into by-products at an average cost of $40 per barrel that specialty expects to sell for $170 million, or $170 per barrel of crude used. The current spot price of oil is $125 per barrel and Specialty has been offered a forward contract by its investment banker to purchase the needed oil for a delivery price in on year of $130 per barrel.

(A) Ignoring taxes, what will specialty's profits be if oil prices in one year are as low as $110 or as high as $150, assuming that the firm does not enter into the forward contract?

(B) If the firm were to enter into the forward contract, demonstrate how this would effectively lock in the firm's cost of fuel today, thus hedging the risk of fluctuating crude oil prices on the firm's profit for the next year.