Pembina Oil Karl Olander runs a large refinery in the Pembina oil field in Drayton Valley area of Alberta. The refinery was a division of Pembina Oil, which removes crude oil from the land through their Extraction Division, and refines and sells products through Olander's Division (Refinery Division), and sells to internal and external buyers. An example of an internal buyer was the Commercial Asphalt Division. Olander's Refinery Division can purchase crude oil from the in-house Extraction Division or third-party sellers in the region, the same way they can sell to internal or external buyers. Refining oil involves heating the crude oil to separate out components based on their boiling points, see Exhibit 1 for more information on oil refinement. Olander's Refining Division heats and separates the crude oil. Then they can sell the petroleum products to various distributors such as gas stations, jet fuel firms, and asphalt producers. In Olander's Division, 45% of crude oil becomes gasoline, 35% becomes jet fuel, and 20% goes into asphalt production. Olander's refining facility typically processes 1 million crude oil barrels per year 1. The production process uses little direct labour, but Olander attributes $4.5 million of direct labour per year to the barrel loaders who empty crude oil barrels into the refinery process and allocates these direct labour costs proportionally to product outcome. The total overhead cost of operating the refinery is $82 million per year which also would be distributed proportionally to product outcomes. Jet Fuel Pembina Oil sells jet fuel directly to Edmonton International Airport's fuel service business. This fuel is then sold to various airlines and local pilots. Given demand in the market, Olander feels they could price the fuel using total cost + pricing. Question 1. Create a chart exploring what prices to set for all combinations of the products under the following scenarios: The price per barrel of crude oil could be $60,$75, and $90 per barrel. The desired margins to evaluate for each price is 10% and 20%. Please indicate in your chart your initial finding for total cost per litre in the chart under each potential scenario. For simplicity, Pembina Oil only produces gasoline, jet fuel and asphalt base. Exhibit 2 Expected sales price and external demand forecast