{"id":130529,"date":"2022-10-20T00:00:00","date_gmt":"2022-10-20T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/10\/20\/assignment-1-one-of-latoils-main-products-is-crude-oil\/"},"modified":"2022-10-20T00:00:00","modified_gmt":"2022-10-20T00:00:00","slug":"assignment-1-one-of-latoils-main-products-is-crude-oil","status":"publish","type":"post","link":"https:\/\/www.studyproessays.com\/help\/assignment-1-one-of-latoils-main-products-is-crude-oil\/","title":{"rendered":"Assignment 1 One of Latoils main products is crude oil"},"content":{"rendered":"<p>Latoil is a fictional Norwegian multinational energy company headquartered in Stavanger, Norway. The company\u2019s main business is petroleum, and the company operates several oil fields, refineries, petrol stations and other related activities.<\/p>\n<p>Assignment 1<br \/>\nOne of Latoils main products is crude oil. Crude oil can be sold directly abroad (exported) or be used as an input in a local refinery. At this local refinery one barrel of oil (which is about 159 liters) can be used as an input to produce the following products:<br \/>\nDiesel<br \/>\nHeating oil<br \/>\nJet fuel<br \/>\nHeavy fuel oil<br \/>\nLiquified petroleum gases<br \/>\nGasoline<\/p>\n<p>It takes 1 liter of crude oil as an input to produce 1 liter of each of the above-mentioned products. In addition, each product requires a certain amount of labour, testing and materials to produce 1 liter. The production technology is shown in the table below:<\/p>\n<p>Production technology at the refinery: Requirement to produce 1 liter of each product<br \/>\nInput<br \/>\n(measured in units)\tCrude oil\tDiesel\tHeating oil\tJet fuel\tHeavy fuel oil\tLiquified pertroleum<br \/>\ngases\tGasoline<br \/>\nCrude oil (1 liter)\t\t1,00\t1,00\t1,00\t1,00\t1,00\t1,00<br \/>\nLabour\t0,10\t0,20\t0,20\t0,25\t0,50\t0,20\t0,20<br \/>\nTesting 1\t0,05\t\t0,02\t0,01\t0,05\t0,01<br \/>\nTesting 2\t\t0,02\t0,02\t0,01\t0,02\t0,01\t0,02<br \/>\nMaterial 1\t\t\t0,05\t0,40\t0,05\t0,08\t0,03<br \/>\nMaterial 2\t0,05\t0,05\t\t0,40\t0,05\t\t0,05<\/p>\n<p>The price and total availability for each of the inputs is:<\/p>\n<p>Input\tCost\tMaximum amount available<br \/>\nLabour\t10,00 NOK\t49.500 units<br \/>\nTesting 1\t15,00 NOK\t13.500 units<br \/>\nTesting 2 \t20,00 NOK\t14.600 units<br \/>\nMaterial 1\t1,00 NOK\t12.300 units<br \/>\nMaterial 2\t2,50 NOK\t18.900 units<\/p>\n<p>Each product has a minimum amount that must be produced due to contract obligations. There is also a highest possible production, and we assume, for simplicity, that all production is sold. Both the minimum and maximum number of units produced, along with the price of each product (all converted into NOK per liter), is shown in table below:<\/p>\n<p>Product\tPrice in NOK per liter\tLowest possible production\tHighest possible production<br \/>\nCrude oil\t6\t50.000 liter\t310.000 liter<br \/>\nDiesel\t15\t5.000 liter\t48.900 liter<br \/>\nHeating oil\t5\t1.000 liter\t16.800 liter<br \/>\nJet fuel\t24\t2.500 liter\t21.200 liter<br \/>\nHeavy fuel oil\t9\t3.000 liter\t25.400 liter<br \/>\nLiquified petroleum gas\t10\t2.000 liter\t22.300 liter<br \/>\nGasoline\t16\t10.000 liter\t42.200 liter<\/p>\n<p>The company wants to maximize its profits.<br \/>\nOpen the starting file Assignment1.xls. Construct the model and determine what type of model this is.<br \/>\nUse Solver to find the optimal solution, meaning the production of each product that gives the company the highest profit.<br \/>\nLatoil is considering allocating more inputs (meaning labour, testing 1 etc) to this refinery. Which inputs should the company prioritize the most? Which inputs should the company not prioritize? Explain your answers.<br \/>\nUse a sensitivity analysis to determine how changes in the price of crude oil affects the optimal decision (use at least 10 different values of the crude oil price).<\/p>\n<p>Assignment 2<br \/>\nLatoil must supply several markets with different products. In this assignment only two products are considered (i) Crude oil; and (ii) Processed oil. For oil to be processed, crude oil must be delivered to the refinery. For simplicity, we assume that processing 1 barrel of crude oil gives 1 barrel of processed oil.<\/p>\n<p>Latoil must manage a network with:<br \/>\n8 oil fields: Oil fields extract the crude oil and sends them to onshore installations<br \/>\n5 onshore installations: Receives the crude oil from the oil fields and either sends them to the refineries to be processed or sells the crude oil directly to the market<br \/>\n6 refineries: Receives the crude oil from the installation and processes the oil before selling it to the market<br \/>\n9 markets: Each market must receive a certain amount of crude oil from the installations and a certain amount of processed oil from the refineries<\/p>\n<p>The oil fields have a minimum and maximum capacity, and can only supply certain onshore installations:<\/p>\n<p>Oil field nr.\tMinimum\tMaximum\tInstallations that can be supplied<br \/>\nOil field 1\t730 barrels\t19.970 barrels\tInstallation 1, 2, 3 and 4<br \/>\nOil field 2\t1.100 barrels\t17.700 barrels\tInstallation 1, 2, 3 and 4<br \/>\nOil field 3\t1.220 barrels\t7.750 barrels\tInstallation 1, 2, 4 and 5<br \/>\nOil field 4\t2.160 barrels\t17.150 barrels\tInstallation 1, 2, 3, 4 and 5<br \/>\nOil field 5\t2.260 barrels\t20.940 barrels\tInstallation 4 and 5<br \/>\nOil field 6\t1.860 barrels\t11.510 barrels\tInstallation 1, 2, 3, 4 and 5<br \/>\nOil field 7\t660 barrels\t7.680 barrels\tInstallation 1, 3, 4 and 5<br \/>\nOil field 8\t2.020 barrels\t14.250 barrels\tInstallation 1, 2, 3 and 5<\/p>\n<p>Each onshore installation also has a minimum capacity (the maximum production capacity is considered non-binding), and can only supply certain markets and refineries:<\/p>\n<p>Installation nr.\tMinimum\tRefineries that can be supplied\tMarkets that can be supplied<br \/>\nInstallation 1\t1.270 barrels\tRefinery 3, 4, 5 and 6\tMarket 1, 2, 3, 4, 5 and 6<br \/>\nInstallation 2\t1.910 barrels\tRefinery 1, 2, 3, 4, 5 and 6\tMarket 1, 2, 4, 5 and 6<br \/>\nInstallation 3\t1.680 barrels\tRefinery 1, 2 and 3\tMarket 7, 8 and 9<br \/>\nInstallation 4\t780 barrels\tRefinery 1, 2, 3, 4, 5 and 6\tMarket 1, 2, 3, 6, 7, 8 and 9<br \/>\nInstallation 5\t1.330 barrels\tRefinery 3, 4, 5 and 6\tMarket 1, 3, 4, 6, 7, 8 and 9<\/p>\n<p>Each refinery also has a minimum capacity (the maximum production capacity is considered non-binding) and can deliver processed oil to certain markets:<\/p>\n<p>Refinery nr.\tMinimum\tMarkets that can be supplied<br \/>\nRefinery 1\t2.510 barrels\tMarket 1, 3, 4, 7, 8 and 9<br \/>\nRefinery 2\t2.160 barrels\tMarket 1 and 9<br \/>\nRefinery 3\t2.320 barrels\tMarket 1, 2, 3, 4, 6, 7, 8 and 9<br \/>\nRefinery 4\t2.500 barrels\tMarket 1, 2 and 3<br \/>\nRefinery 5\t1.960 barrels\tMarket 1, 2, 3, 4 and 9<br \/>\nRefinery 6\t2.650 barrels\tMarket 3, 4, 5, 6, 7, 8 and 9<\/p>\n<p>Each final market needs to be supplied with a certain quantity of crude oil and processed oil:<\/p>\n<p>Market nr.\tMinimum amount of crude oil\tMinimum amount of processed oil<br \/>\nMarket 1\t1.780 barrels\t6.960 barrels<br \/>\nMarket 2\t7.170 barrels\t7.350 barrels<br \/>\nMarket 3\t1.740 barrels\t4.460 barrels<br \/>\nMarket 4\t4.240 barrels\t1.590 barrels<br \/>\nMarket 5\t9.540 barrels\t12.210 barrels<br \/>\nMarket 6\t9.570 barrels\t8.850 barrels<br \/>\nMarket 7\t1.540 barrels\t1.180 barrels<br \/>\nMarket 8\t4.680 barrels\t7.160 barrels<br \/>\nMarket 9\t3.300 barrels\t8.200 barrels<\/p>\n<p>Open the starting file Assignment2.xls which shows the cost in NOK for each barrel transported. This is a typical example of a network model. Draw the network model with nodes and arcs (either using office, some other software or just by hand and paste it in the excel sheet).<br \/>\nAssume the objective is to minimize costs. Construct the model and find the optimal order plan.<br \/>\nLatoil is considering expanding the production capacity of the oil fields to expand the maximum production. Which oil fields would should be considered and in which order? Explain you answer.<\/p>\n<p>Assignment 3<br \/>\nThe research department at Latoil has invested in eight potential new products. A production facility has been allocated some inputs from Latoil to start producing these products. The quantity and the opportunity cost of these inputs are shown below:<\/p>\n<p>Input\tQuantity allocated\tCost per unit<br \/>\nBarrels of crude oil\t48.800\t640 NOK<br \/>\nOther material\t96.400\t420 NOK<br \/>\nLabour hours\t75.000\t250 NOK<br \/>\nTesting hours\t55.000\t430 NOK<\/p>\n<p>The eight products require a different combination of these inputs to produce one unit. If one product is produced, a fixed cost incurs, but not if the product is not produced. Also, if the product is produced a minimum number must be produced due to economies of scale. There is also a sales constraint for each product. Finally, each of the products has a sales price. All this information is summarized in the table below:<\/p>\n<p>Prod.1\tProd.2\tProd.3\tProd.4\tProd.5\tProd.6\tProd.7\tProd.8<br \/>\nBarrels of crude oil\t6\t6\t4\t4\t4\t4\t6\t4<br \/>\nOther material\t11\t8\t6\t8\t8\t8\t6\t12<br \/>\nLabour hours\t9\t9\t3\t5\t11\t9\t2\t8<br \/>\nTesting hours\t5\t5\t1\t1\t4\t3\t5\t4<br \/>\nFixed cost if produced in NOK\t500.000\t800.000\t1.500.000\t1.500.000\t1.200.000\t700.000\t600.000\t1.400.000<br \/>\nMininium production if produced\t500\t300\t300\t100\t50\t350\t400\t350<br \/>\nMaximum sale\t2.000\t1.500\t3.000\t1.000\t500\t5.000\t1.000\t2.500<br \/>\nSales unit price in NOK\t15.960\t15.044\t7.046\t9.342\t17.005\t15.261\t9.982\t11.630<\/p>\n<p>Latoil wants to know which products should be produced and how many of each with the objective being to maximize profits.<br \/>\nOpen the starting file Assignment3.xls. Set up the problem in excel.<br \/>\nFind the optimal solution and comment on the results.<br \/>\nThe leadership of the company wants to know how the optimal solution changes given the amount of labour allocated to the production of these products. Conduct a sensitivity analysis which allows the allocated labour to vary from 50.000 hours to 100.000 hours.<\/p>\n<p>Assignment 4<br \/>\nThe marketing department at Latoil has recently been able to negotiate a deal giving the company sole access to a new market for petrol stations. Latoil will therefore operate as a monopolist and the two main products supplied are diesel and gasoline. It is assumed that the preferences in the market are comparable to Norway, meaning that Norwegian data on prices and demand can be used to estimate the demand function in the market.<br \/>\nOpen the starting file Assignment4.xls and answer the following questions<br \/>\nThe starting files contains monthly price and sales data for diesel and gasoline for a three-year period. Graph this relationship using a scatterplot. Use the graph to find the equation for a linear demand function and a power demand function.<br \/>\nThe company wants to know which demand function describes the data most accurately. One way to calculate the accuracy of the prediction is to calculate the mean absolute percentage error (MAPE). It means that you need to calculate absolute percentage error for each observation given by:<\/p>\n<p>APE=|Observed demand-Predicted demand|\/(Observed demand)<\/p>\n<p>The term |Observed demand-Predicted demand| is the absolute value of the difference between observed and predicted demand. The MAPE is the average APE for all observations. The curve with the smallest MAPE is the one that fits the data the best. Based on this criterion, which curve fits the gasoline data the best? Which curve fits the diesel data the best?<br \/>\nUse the demand curves that fit the data the best to be used in the model (if you are unable to answer b) use the linear functions). Latoil has the following cost functions for gasoline and diesel in the new market:<\/p>\n<p>Cost function diesel production\t:\tC_D=x_D^2+20x_D+75<br \/>\nCost function gasoline production\t:\tC_G=0,5x_G^2+10x_G+50<\/p>\n<p>Where x_D is the production of diesel in million of liters and x_G is the production of gasoline in million of liters. Assume that the objective is to maximize profit. Set up the model and find the optimal prices for diesel and gasoline and the associated profit.<br \/>\nLatoil must also decide the total capacity it wants to use in the market. Assume that the cost of capacity is 11 NOK per liter of diesel and 9 NOK per liter of gasoline. It is common practice among gas stations to vary the price during the week. Let\u2019s assume that Latoil considers three different periods during the week:<\/p>\n<p>Diesel\tGasoline<br \/>\nHigh demand\tx_D^H=390-4,6p_D^H+0,2p_D^N+0,1p_D^L\tx_G^H=135-2,8p_G^H+0,1p_G^N+0,1p_G^L<br \/>\nNormal demand\tx_D^N=325-4,6p_D^N+0,3p_D^H+0,2p_D^L\tx_G^N=125-2,8p_G^N+0,1p_G^H+0,1p_G^L<br \/>\nLow demand\tx_D^L=290-4,6p_D^L+0,1p_D^H+0,3p_D^N\tx_G^L=85-2,8p_G^L+0,1p_G^H+0,2p_G^N<\/p>\n<p>The notation is as follow:<br \/>\nx_D^H: Diesel demand in millions of liters in the high demand period<br \/>\nx_D^N: Diesel demand in millions of liters in the normal demand period<br \/>\nx_D^L: Diesel demand in millions of liters in the normal demand period<br \/>\np_D^H: Diesel price in NOK in the high demand period<br \/>\np_D^N: Diesel price in NOK in the normal demand period<br \/>\np_D^L: Diesel price in NOK in the low demand period<br \/>\nx_G^H: Gasoline demand in millions of liters in the high demand period<br \/>\nx_G^N: Gasoline demand in millions of liters in the normal demand period<br \/>\nx_G^L: Gasoline demand in millions of liters in the normal demand period<br \/>\np_G^H: Gasoline price in NOK in the high demand period<br \/>\np_G^N: Gasoline price in NOK in the normal demand period<br \/>\np_G^L: Gasoline price in NOK in the low demand period<\/p>\n<p>Let the cost function be the same as above in 4a). Find the optimal price of diesel and gasoline for the three different periods (you can assume all three periods are of the same duration). Also find the associated optimal capacity and profit.<\/p>\n<p>Assignment 5<br \/>\nThe Norwegian market for jet fuel is assumed to have six major fictional customers:<\/p>\n<p>Customer\tMarginal willingness to pay<br \/>\nBrian Air\tp=115-5x<br \/>\nSinnair\tp=105-7x<br \/>\nKEM\tp=124-4x<br \/>\nHorwegian\tp=120-3x<br \/>\nMAS\tp=114-6x<br \/>\nVidere\tp=100-4x<\/p>\n<p>For the marginal willingness to pay, the price p is per liter whilst the quantity, x, is in millions of liters. The cost function of producing jet fuel (in million NOK) is given by:<\/p>\n<p>Cost function\tC(x)=10x+100<\/p>\n<p>We make the simplifying assumption that all jet fuel produced is sold, meaning no inventory and no uncertainty. Latoil is evaluating the profit for different pricing strategies. Find the optimal price(s), quantity sold and profit for the following different strategies:<br \/>\nSingle unit price for all consumers.<br \/>\nEach consumer pays a separate unit price.<br \/>\nA two-part tariff, meaning all consumers pay the same fixed price and the same unit price.<br \/>\nThe government introduces a \u201cjet fuel tax\u201d of 10 NOK per liter in a bid to reduce emissions from aviation. How does the tax change the optimal solution in each of the cases above?<\/p>\n<p>Assignment 6<br \/>\nLatoil wants to adopt a more environmentally friendly approach, and even considers changing its name to Aquanor to highlight an increased emphasis on hydroelectrical power and on windmills constructed at sea. Latoil needs to deliver electricity to the following markets:<\/p>\n<p>Market\tDemand market<br \/>\nMarket 1\t351 GWh<br \/>\nMarket 2\t267 GWh<br \/>\nMarket 3\t423 GWh<br \/>\nMarket 4\t416 GWh<br \/>\nMarket 5\t472 GWh<br \/>\nMarket 6\t153 GWh<br \/>\nMarket 7\t343 GWh<br \/>\nMarket 8\t192 GWh<br \/>\nMarket 9\t164 GWh<\/p>\n<p>One Giga Watt hour (GWh) is the same as one million Kilo Watt hours (KWh). The unit price for electricity is 477.300 NOK per GWh (equivalent to 0,4773 NOK per KWh). Latoil has interests in three different kinds of electricity producers. First, Latoil controls eight power plants based on fossil fuel technology, which deliver electricity to specific markets. The capacity of each of these is:<\/p>\n<p>Fossil fuel power plant\tMaximum production capacity<br \/>\nFossil fuel power plant 1\t239 GWh<br \/>\nFossil fuel power plant 2\t279 GWh<br \/>\nFossil fuel power plant 3\t281 GWh<br \/>\nFossil fuel power plant 4\t234 GWh<br \/>\nFossil fuel power plant 5\t207 GWh<br \/>\nFossil fuel power plant 6\t299 GWh<br \/>\nFossil fuel power plant 7\t281 GWh<br \/>\nFossil fuel power plant 8\t200 GWh<\/p>\n<p>Second, Latoil has an interest in six windmill parks with the following production capacity:<\/p>\n<p>Windmill park\tMaximum production capacity<br \/>\nWindmill park 1\t161 GWh<br \/>\nWindmill park 2\t119 GWh<br \/>\nWindmill park 3\t131 GWh<br \/>\nWindmill park 4\t180 GWh<br \/>\nWindmill park 5\t117 GWh<br \/>\nWindmill park 6\t194 GWh<\/p>\n<p>Finally, Latoil has an interest in two hydroelectrical power plants with the following production capacity:<\/p>\n<p>Hydro power plant\tMaximum production capacity<br \/>\nHydro power plant 1\t486 GWh<br \/>\nHydro power plant 2\t488 GWh<\/p>\n<p>For each GWh delivered the company incurs a unit cost and a unit of pollution. The unit of pollution is a number that implies that a higher number generates more pollution.<\/p>\n<p>Latoil has two major objectives: (i) To maximize profit; and (ii) To minimize pollution. These objectives cannot be ranked.<br \/>\nOpen the starting file to assignment 6. The file contains the unit costs and the pollution for each of the potential delivery routes. Construct the model with two different objectives functions, one to maximize profits and the other to minimize pollution. Solve the model for each objective function and interpret the optimal solution in each case.<br \/>\nFind the efficiency frontier between pollution and costs. Graph this relationship and give an economic interpretation. Explain why any optimal solution must be pareto efficient.<br \/>\nLatoil has until now maximized profits (and not taken pollution into consideration). If Latoil changes its name to Aquanor, it plans to weight pollution twice as important as profit (meaning that the company wants to reduce pollution by 2\/3 of its total pollution reduction when moving from the maximum profit to the minimum pollution solution). Which solution will the company chose and what will the change in profit and pollution following the name change?<\/p>\n<p>Assignment 7<br \/>\nThe brent oil price is important for Latoils profits. Go to the EIA (US Energy Information Administration) website (https:\/\/www.eia.gov\/dnav\/pet\/hist\/rbrteD.htm) and download the monthly brent spot price in USD for the period may 1987-february 2019 by using the \u201cdownloand data (xls file)\u201d option.<br \/>\nUse the data you downloaded to create your own starting file and save it as \u201cAssignment 7 Starting File.xls\u201d. Use the Pivot Table to answer the following questions:<br \/>\nWhat is the average oil price for all February months?<br \/>\nFor which month is the oil price on average the highest?<br \/>\nFor which month is the oil price the most volatile measured by standard deviation?<br \/>\nThe price of a forward for January 2020 is 69,27 USD, which is also the expected spot price for January 2020. The company considers three scenarios:<br \/>\nLow oil price: One standard deviation below the expected oil price with a probability of 30 %<br \/>\nMedium oil price: The expected oil price with a probability of 50 %<br \/>\nHigh oil price: One standard deviation above the expected oil price with a probability of 20 %<\/p>\n<p>The standard deviation used is for the all January months (use the data from a). Latoil has already agreed to a delivery of 25.000 barrels in January 2020, but now needs to decide whether to hedge the price. Only two options are considered, a full hedge (using the forward) or no hedge (not to use the forward). The company wants to have the highest expected revenue possible. Show the decision tree related to this problem and find the expected monetary revenue. Should Latoil hedge the price?<br \/>\nLatoil could hire a firm dealing with oil price forecast, Fystad Energy. Their predictions are considered among the most accurate in the market, and their services will cost the company 10.000 USD. Historically, Fystad has the following accuracy on their predictions:<\/p>\n<p>Fystad predicted a high price\tFystad predicted a medium price\tFystad predicted a low price<br \/>\nActual outcome: High price\t72,7 %\t23,7 %\t3,6 %<br \/>\nActual outcome: Medium price\t19,3 %\t60,7 %\t20,0 %<br \/>\nActual outcome: Low price\t8,0 %\t15,6 %\t76,4 %<\/p>\n<p>Make a new decision tree which takes this option into account for Latoil. Should the company hire Fystad Energy? When should Latoil use a forward?<br \/>\nFind the expected monetary value of sample information (EVSI) and the expected value of perfect information (EVPI) for c).<\/p>\n<p>Assignment 8<br \/>\nLatoil is considering an investment in a new oil field. There are several uncertain variables that affect the profitability of the project ( help with nursing paper writing from experts with MSN &#038; DNP degrees).<br \/>\nInvestment cost incurs in year 0 and the installation takes 2 years to construct (this is assumed not uncertain). Production starts in the beginning of the year the installation is completed. In addition, the following is known about the investment cost:<br \/>\nOil production can start once the installation is completed. The cost of the project ( help with nursing paper writing from experts with MSN &#038; DNP degrees) is most likely at 80 million NOK. The company knows that the cost will not be below 40 million NOK and could be as high as 200 million NOK.<br \/>\nAdditional investments are needed to construct the pipelines for gas transportation to allow natural gas production (investments costs also incur in year 0). These investments are done at the same time as the oil field installation investment above, and the construction time is the same. It means that gas production can start at the same time as oil production. The cost of the project ( help with nursing paper writing from experts with MSN &#038; DNP degrees) is most likely at 100 million NOK. The company knows that the cost will not be below 20 million NOK and could be as high as 120 million NOK.<br \/>\nAll oil and gas production are assumed sold (no inventories). The following information is given for production:<br \/>\nOil production varies each year. The production is never going to be below than 20.000 barrels and cannot exceed 100.000 barrels. The most likely production is 75.000 barrels.<br \/>\nGas production also varies each year. Most likely the production is 9,6 million Sm\u00b3 (standard cubic meter). Gas production is never below 2,4 million Sm\u00b3 and cannot exceed 12 million Sm\u00b3.<br \/>\nPrices vary each year and both are assumed to be normally distributed (Hint: In @Risk \u201cRiskNormal(Mean;Standarddeviation)\u201d is used for a normal distribution)<br \/>\nThe oil price has a mean of 677 NOK per barrel (80 USD with an exchange rate of 8,5 NOK per 1 USD) and a standard deviation of 223 NOK.<br \/>\nThe price of natural gas is measured in Sm\u00b3 (standard cubic meter) and has a mean of 5,5 NOK per Sm\u00b3. The standard deviation is 1 NOK per Sm\u00b3.<br \/>\nReserves are partially unknown with the following information currently available:<br \/>\nOil: The known reserves at the present time is 1 million barrels, but there could be a potential maximum of 0,6 million barrels in additional reserves. The most likely is an additional reserve of 0,4 million barrels.<br \/>\nGas: The known reserves are 120 million Sm\u00b3 gas. At most there is an additional 80 million Sm\u00b3 more in reserves, with their most likely being 50 million Sm\u00b3 more in reserves.<br \/>\nOther relevant information:<br \/>\nAnnual fixed cost is known. For oil production it is 1,5 million NOK and for gas production it is 1,0 million NOK.<br \/>\nUnit costs are also known. For oil production it is 400 NOK per barrel and for gas production it is 4,2 NOK per Sm\u00b3 (standard cubic meter).<br \/>\nThe discount rate is 5 % and is also known in advance<\/p>\n<p>The student version of @Risk only allows 100 inputs, which is less than is needed to run the entire model. Therefore, you should make two different models, one for oil and one for gas. Open the starting files Assignment8 Oil.xls. and Assignment8 Gas.xls. Set up the two models with the net present value of the investment being the objective function (Note: One should only have one excel file open at a time when running @Risk).<br \/>\nRun simulations on both models with @Risk using 1000 iterations with the net present value of profit and the number of years of production being the main outputs (To store the results it is recommended you take a screenshot of the simulation results). Find:<br \/>\nThe mean years of production for the oil and gas fields, the standard deviation, the lowest number of years in operation and the highest number of years in production.<br \/>\nMean net present value, the standard deviation, the lowest net present value and the highest net present value.<br \/>\nBased on the results in b) and c) above, make a recommendation for Latoil on whether to invest in oil production? Should they in addition invest in gas production?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Latoil is a fictional Norwegian multinational energy company headquartered in Stavanger, Norway. The company\u2019s main business is petroleum, and the company operates several oil fields,\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8827,10099,10540,10536,10892,10538,10539,10537,10891],"tags":[10549,10616,10615,7687,10627,8857,10552,10295,10548,10622,8907],"class_list":["post-130529","post","type-post","status-publish","format-standard","hentry","category-australia-essays","category-buy-essay","category-cheap-essay-writers","category-get-assignments-done","category-page-paper","category-phd-essay-writers","category-research-paper-writing-service-for-any-topic","category-study-bay-essay","category-write-my-assignment-ireland","tag-ai-plagiarism-free-essay-writing-tool","tag-australian-best-tutors","tag-best-trans-tutors","tag-buy-essay-uk","tag-cheap-dissertation-writer","tag-help-with-writing-an-essay","tag-help-write-my-paper-ai-free","tag-homework-for-you","tag-online-essay-writers","tag-phd-essays","tag-write-my-essay-for-me"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/130529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=130529"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/130529\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=130529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=130529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=130529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}