Darren Mack owns the "Gas n' Go" convenience store and gas station. After hearing a marketing lecture, he realizesthat it might be possible to draw more customers to his high-margin convenience store by selling his gasoline at alower price. However, the "Gas n' Go' is unable to qualify for volume discounts on its gasoline purchases, andtherefore cannot sell gasoline for profit if the price is lowered.Each new pump will cost $110,000 to install, but will increase customer traffic in the store by 11,000 customers peryear. Also, because the "Gas n' Go" would be selling its gasoline at no profit, Darren plans on increasing the profitmargin on convenience store items incrementally over the next five years. Assume a discount rate of 7 percent. Theprojected convenience store sales per customer and the projected profit margin for the next five years are given inthe table below.iYear12345Projected Convenience StoreSales Per Customer$4$5.50$8$10$12Projected ProfitMargin20%25%30%35%40%5a. What is the NPV of the next five years of cash flows if Darren had five new pumps installed?NPV=S (Enter your response rounded to two decimal places.)

Answered: Darren Mack owns the "Gas n' Go"…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

Please show all work and explain answer. OneRing Company sells memorabilia to residents of Middle-Earth. They are about to invest $6 million in a new ring making plant. Fixed costs of operating the plant are $1 million a year. The ring costs $60/unit to manufacture (variable cost) and will be sold for $200/unit. The plant will last for 5 years, and will be depreciated over 5 years to zero using the straight-line method. The plant will have no salvage value after five years. Net working capital requirements are negligible for this project. Assume there are no taxes in Middle-Earth, and that the appropriate discount rate for the project is ten percent. How many rings per year must OneRing sell in order to break even?
The corporate average fuel economy (CAFE) standard for mileage is currently 27.5 miles per gallon of gasoline (the defender) for passenger cars. To conserve fuel and reduce air pollution, suppose the U.S. Congress sets the CAFE standard at 36 miles per gallon (the challenger) in 2014. An auto will emit on average 0.9 pounds of carbon dioxide (CO2) per mile driven at 27.5 miles per gallon, and it will emit 0.8 pounds of CO2 per mile driven at 36 miles per gallon. Solve, a. How much fuel and carbon dioxide would be saved over the lifetime of a passenger car with the new standard? Assume a car will be driven 99,000 miles over its lifetime. b. If CO2 costs $0.02/lb to capture and sequester, what penalty does this place on the defender? Should this penalty affect the CAFE replacement analysis?
Muscat Distribution Electricity Company (MDEC) is going to perform energy audits on homes that are at least 28 years old. MEDC estimates that homeowner can save 9 RO per square meter annually as the result of energy conservation upgrades that include wall and roof insulation, window glazing, shading, and efficient air conditioning and lightning. 13 years is the expected lifetime of these upgrades, and the annual interest rate is 9%. How much is justified to spend on this project for a 219 square meter built up area home.
A department store sells a certain handkerchief for Php40 per piece. The store averages sales of 80 pieces each week. The store manager's past experience leads him to believe that for each Php2 increase in the price of the handkerchief, one less piece would be sold each week. What price would result in Php3,648 weekly sales?
Your answer is partially correct. An independent contractor for a transportation company needs to determine whether she should upgrade the vehicle she currently owns or trade her vehicle in to lease a new vehicle. If she keeps her vehicle, she will need to invest in immediate upgrades that cost $5,200 and it will cost $1,300 per year to operate at the end of year that follows. She will keep the vehicle for 5 years; at the end of this period, the upgraded vehicle will have a salvage value of $3,800. Alternatively, she could trade in her vehicle to lease a new vehicle. She estimates that her current vehicle has a trade-in value of $9,800 and that there will be $4,100 due at lease signing. She further estimates that it will cost $2,900 per year to lease and operate the vehicle. The independent contractor's MARR is 11%. Compute the EUAC of both the upgrade and lease alternatives using the insider perspective. Click here to access the TVM Factor Table Calculator. 1943.56 EUAC(keep): $…
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
An online store sells two types of speaker docks for smartphones. The higher-priced speaker dock sells for $190 and the lower-priced speaker dock sells for $70. Last week the store sold four times as many lower-priced speaker docks as higher-priced speaker docks. Combined sales totaled $4,230. How many lower-priced speaker docks did it sell?The store sold, lower-priced speaker docks.
Ian's monthly car payment is $292.34 Ian pays $112.98 every month for car insurance and he estimates he spends an average of $20 per month on car maintenance ends car gets 33 miles per gallon gas cost and 3.4 per gallon and Ian drives an average of about 873 miles per month estimate how much Ian spends on his transportation cost each month round your answer to the nearest whole dollar
Blue Sky Corporation is planning to issue $1,000 par value bonds. The bonds will have a coupon rate of 14 percent and will be sold at a market price of $1050. Flotation costs will amount to 6 percent of market value. The bonds will mature in 15 years and interest payments will be made semi-annually. The company's marginal tax rate is 21%. What is the firm's after-tax cost of debt financing? 9.38% 11.06% 11.23% 14.00% 14.21%
A carpet manufacturer, whose discount rate is 10%, can purchase texturizing equipment for $1,250,000 to process yarn. Incremental income before straight line depreciation from sales of texturized carpets is projected over the next five years as $95,000, $165,000, $357,000, $725,000 and $315,000, respectively. The company believes that the fashion will pass and demand in Year 6 will all but disappear. The machine can be sold at the end of Year 5 for $250,000. What should you advise the company to do? Select one: O A. Purchase the equipment as ARR is 10.9%. O B. Not purchase the equipment as the ARR is only 9.3%. O C. Not purchase the equipment as NPV is ($54,784). O D. Purchase the equipment as both the NPV and ARR are negative. O E. Purchase the equipment as NPV is $86,952. O
Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for expert advice on the available data to inform administrative and business policy. By applying this scenario, help her regress the quantity demanded of her apartments on price, advertising, and distance datasets by using Excel or SPSS. Observation or (Number of Apartments) Quantity…
Damen Ship Repair has just introduced a new service. For a fixed annual fee, Damen will predict what are the most likely repair parts you will need for each of your cargo ships over the next year. It will then preposition those parts either on your ships or at Damen’s shipyards depending on whether your crew can install that part or it must be done at a shipyard. Then all you pay for is the installation labor you actually use each year, which also comes at a discounted rate. a) Specify the key features and benefits that they would want to inform customers about b) Develop an integrated marketing communication plan for marketing the service

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS