An oil and gas exploration firm invested $2,000,000 in drilling for natural gas in a nev gas field. The firm's geologist believes the field has the potential to produce gas for many years. The revenue resulting from the gas well the first year after drilling is $600,000; based on previous experiences with similar types of wells, it is expected the annual revenue will decrease at an annual rate of 3%. Likewise, the costs of operating the well the first year totals $100,000; costs are expected to increase at an annual rate of 7%. If the firm's MARR is 17%, how long will it take for the firm to recover its investment? Hint: Using Excel's Goal Seek or SOLVER tool leave cell for the number of years required to recover the investment empty. Click here to access the TVM Factor Table calculator. n = L: %3D years

An oil and gas exploration firm invested $2,000,000 in drilling for natural gas in a nev gas field. The firm's geologist believes the field has the potential to produce gas for many years. The revenue resulting from the gas well the first year after drilling is $600,000; based on previous experiences with similar types of wells, it is expected the annual revenue will decrease at an annual rate of 3%. Likewise, the costs of operating the well the first year totals $100,000; costs are expected to increase at an annual rate of 7%. If the firm's MARR is 17%, how long will it take for the firm to recover its investment? Hint: Using Excel's Goal Seek or SOLVER tool leave cell for the number of years required to recover the investment empty. Click here to access the TVM Factor Table calculator. n = L: %3D years

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A company wants to plan production for the ensuing year to minimize the combined cost of production and inventory costs. In each quarter of the year, demand is anticipated to be 130, 160, 250, and 150 units, respectively. The plant can produce a maximum of 200 units each quarter. The product can be manufactured at a cost of $15 per unit during the first quarter, however the manufacturing cost is expected to rise by $1 per quarter. Excess production can be stored from one quarter to the next at a cost of $1.50 per unit, but the storage facility can hold a maximum of 60 units. How should the production be scheduled so as to minimize the total costs? Please answer using python Formulate an LP model to minimize costs. Solve the LP (provide exact values for all variables and the optimal objective function).
Reviewing the past history of LIH applications, David estimated the probability that the application decision would be delayed beyond 60 days to be 20%. David then estimated that the probability that the outcome of the new proposal is favourable is 70%. Given that the outcome of the new proposal were favourable, David estimate that the probability of the LIH plan to be approved is 75%; if the outcome were unfavourable, the probability of approval is 30%. Finally, David estimated the probability that the property would still be available for purchase after the policy revision (if Real Estate took no action) to be 80%. David next went to work on the financial analysis of the development project. The estimated profit of the new development project under the LIH plan would be $850,000. This value includes the purchase cost of the property, the cost of renovations, annual maintenance costs, annual rental incomes, and applicable tax shelters. If LIH plan approval were not granted for the…
PLZ SOLVE BY EXCEL
There are N problems numbered 1..N which you need to complete. You've arranged the problems in increasing difficulty order, and the ith problem has estimated difficulty level i. You have also assigned a rating vi to each problem. Problems with similar vi values are similar in nature. On each day, you will choose a subset of the problems and solve them. You've decided that each subsequent problem solved on the day should be tougher than the previous problem you solved on that day. Also, to make it less boring, consecutive problems you solve should differ in their vi rating by at least K. What is the least number of days in which you can solve all problems? Input Format The first line contains the number of test cases T. T test cases follow. Each case contains an integer N and K on the first line, followed by integers v1,...,vn on the second line. Constraints 1 <= T <= 1001 <= N <= 3001 <= vi <= 10001 <= K <= 1000 Output Format Output T…
Sprocket manufacturing. The manager of this production firm is faced with a potential problem: shortages in the supply of a vital gear sprocket. He is considering the development of an in-house capability to make the sprockets, knowing that the firm needs 35,000 such sprockets each year. If the firm elects to make the sprockets internally, then it must select one of the three possible production processes. Each has different costs, as shown in Table 10.17. Adopting a manual process may lead to union problems. The manager estimates the probability of these problems as 25%, and knows that if they do occur, then the variable cost will increase by $0.50 per sprocket. Further, if the semi-automatic or fully automatic option is selected, then additional training of personnel will be required. The amount and therefore the cost of training are uncertain. For the semi-automatic process, the fixed cost of basic training will add $15,000. However, there is a 20% chance the workers will need extra…
Earned Value is a method of calculating project status. It does this from two perspectives: Time (schedule) and Cost. After applying the earned value method, the project manager will know whether the project is behind/ahead of schedule and over/under budget. Note: PV=Planned Value, AC=Actual Cost, EV = Earned Value. Explain, with description and calculations, what you can tell about the health of the project based on the following graphs.
Equipment for immersion cooling of electronic components has an installed value of $182,000 with an estimated trade-in value of $40,000 after 15 years. For year 2 use DDB book depreciation to determine the depreciation charge.
Question 31 A survey on pollution has been conducted on four cities. The degree of pollution is classified as not polluted, moderately polluted, and heavily polluted. The results of the survey are illustrated in the table below: City city1 city2 city3 city4 Xi1: not polluted 0.3 0.2 0.1 0.7 X12: moderately polluted 0.4 0.2 0.2 0.4 Xi3: heavily polluted 0.3 0.6 0.5 0.1 Use the cosine amplitude method to develop the fuzzy relation R that relates the pollution degree to the city.
The library uses a library management system (LMS) through which 10 books can be issued to its employees per day. To keep track of each book, there is a function that gets the details such as title, faculty name, date of borrowing, and the duration required. The issue) function determines whether the books requested should be granted or not based on the value (cost), year of publication, and the number of books being requested if the book costs more than Rs 1000 or is published in the current year, or if the book count is one, then the book is to be issued for no more than two days. Also, the LMS keeps track of the top 5 books in the library to determine which book is more valuable than another. Your task is to create a LMS based on the above scenario by creating a structure and implementing the functions required (Not Use pointers to the defined structure).
Compute the volumes of cut and fill between stations 88+30 to 88+68 using the slope stake notes in the table on the following page. Use the average end area equation except for when the section produces a pyramid. In those situations, use the equation for a pyramid. Assume: Base Widths: cut = 50 ft; fill = 40 ft | Side Slopes: 2:1 | Gradient: -2% SURFACE GRADE STA L CL R ELEV. (ft) ELEV. (ft) C18.1 C10.2 92+00 891.6 874.63 C17.0 61.2 45.4 0 0 0 0 91+52 8575.6 875.59 0.0 25 20 20 25 F6.9 F11.4 91+00 864.5 876.63 F12.1 33.8 42.8 F8.2 F10.1 90+50 867.3 877.63 F10.3 36.4 40.2 F12.8 90+05 875.3 878.53 F3.2 20 45.6 C16.3 F12.2 89+73 879.2 879.17 57.6 44.4 C17.4 F8.3 89+59 885.6 879.45 C6.1 59.8 14 36.6 C10.2 F7.3 89+43 879.8 879.77 45.4 34.6 F16.1 89+08 873.7 880.47 F6.8 20 52.2 C16.8 F12.9 88+68 881.3 881.27 58.6 45.8 C24.0 88+30 890.9 882.03 C8.9 73.0 25
An optimum solution only applies to a mathematical model that represents the issue
A company manufactures 3 products in 2 different factories. The cost of production and time required for production for each product varies depending on which factory produces it. The time and cost required for production of each product in each factory is provided in the tables in this worksheet. Demand for products 1, 2 and 3 are 200, 240 and 100 units, respectively. There are a total of 3,000 hours available in each factory. Additionally, at least 60% of the total units of Product 1 must be produced in Factory A, and at least 40% of of the total units of Product 2 must be produced in Factory B. Create a linear programming model and use the Solver add-in to determine the optimal production plan that will minimize total cost. Note: The cost is per unit not per hour. All demand must be met.