24. Darron Mack owns the Gas n' Go convenience store and gas station. After hearing a marketing lecture, he realizes that it might be possible to draw more customers to his high-margin convenience store by selling his gasoline at a lower price. However, the Gas n' Go is unable to qualify for volume discounts on its gasoline purchases, and therefore cannot sell gasoline for profit if the price is lowered. Each new pump will cost $95,000 to install, but will increase customer traffic in the store by 1,000 customers per year. Also, because the Gas n' Go would be selling its gasoline at no profit, Darren plans on increasing the profit margin on convenience store items incrementally over the next 5 years. Assume a discount rate of 8 percent. The projected convenience store sales per customer and the projected profit margin for the next 5 years are as follows: Projected Convenience Store Sales Per Customer Projected Profit Margin Year 1 $5.00 20% 2 $6.50 25% 3 $8.00 30% 4 $10.00 35% $11.00 40% a. What is the NPV of the next 5 years of cash flows if Darren had four new pumps installed? b. If Darren required a payback period of 4 years, should he go ahead with the installation of the new pumps?

24. Darron Mack owns the Gas n' Go convenience store and gas station. After hearing a marketing lecture, he realizes that it might be possible to draw more customers to his high-margin convenience store by selling his gasoline at a lower price. However, the Gas n' Go is unable to qualify for volume discounts on its gasoline purchases, and therefore cannot sell gasoline for profit if the price is lowered. Each new pump will cost $95,000 to install, but will increase customer traffic in the store by 1,000 customers per year. Also, because the Gas n' Go would be selling its gasoline at no profit, Darren plans on increasing the profit margin on convenience store items incrementally over the next 5 years. Assume a discount rate of 8 percent. The projected convenience store sales per customer and the projected profit margin for the next 5 years are as follows: Projected Convenience Store Sales Per Customer Projected Profit Margin Year 1 $5.00 20% 2 $6.50 25% 3 $8.00 30% 4 $10.00 35% $11.00 40% a. What is the NPV of the next 5 years of cash flows if Darren had four new pumps installed? b. If Darren required a payback period of 4 years, should he go ahead with the installation of the new pumps?

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

4. Astore is currently offering a 60% discount on all items purchased. Your cashier is trying to convince you to open a store credit card and says to you, "In addition to the 60% discount you are receiving for purchasing these items on sale today, you will get an additional 20% off for opening a credit card account. That means you are getting 105% off!" %3D a. What is the mistaken assumption here? b. Why is that assumption incorrect? c. If you did truly have 80% discount, explain what should happen when you go to the counter to buy $500 worth of items? show calculation d. If you got your 60% discount and opened up the card for an additional 20%, what is the actual % discount you would receive? show calculation e. Is it better to apply the 60% discount first or the 20% discount first?_show calculation
Pane 3. Assume a company receives cash from different geographic areas of $500,000 daily. The average float of the cash receipt is 4 days. Interest rate on savings is 6% per year. If the company institutes a lock-box system, it will reduce the float to two days. It will cost $80,000 to install the lock-box system and an additional monthly fee of $1,000 to operate it. Should the company install the lock-box system?
Power O Exponential Logarithmic O Polynomial QUESTION 9 If you try different startinng values for the changing cells and obtain different solutions: you can be confident there is no solution you can keep the best solution you have found and hope that it is indeed optimal O there must be a mistake in your objective function O there must be a mistake in one of your constraints QUESTION 10 In pricing models (i.e., Example 7.1), elasticity of demand is an input with specifies the: sensitivity of price to changes in demand O sensitivity of demand to changes in price range of demand lovol
Annie bought one dozen smartphones for 200,000 pesos with a discount of 5%. She sold half dozen at a price of 18,000 pesos per unit. However, a new model of smartphone became available in the market, so she sold the remaining half dozen at 12,000 pesos each unit. What was her profit or loss? Compute the following requirements: a. Gross profit rate b. Operating profit margin rate c. Net profit margin rate d. Return on investment
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 000י7 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000
David Austin recently purchased a chain of dry cleaners innorthern Wisconsin. Although the business is making amodest profit now, David suspects that if he invests in a newPROBLEMS • GO Tutorialpress, he could recognize a substantial increase in profits.The new press costs $15,400 to purchase and install and canpress 40 shirts an hour (or 320 per day). David estimatesthat with the new press, it will cost $0.25 to launder andpress each shirt. Customers are charged $1.10 per shirt.a. How many shirts will David have to press to break even?b. So far, David’s workload has varied from 50 to 200shirts a day. How long would it take to break even onthe new press at the low-demand estimate? at the highdemand estimate?c. If David cuts his price to $0.99 a shirt, he expects to beable to stabilize his customer base at 250 shirts per day.How long would it take to break even at the reducedprice of $0.99? Should David cut his price and buy thenew press?
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?
B 8,000 A 4,000 10,000 20,000 Disposable income Figure 1.2 2) Refer to Figure 1.2. The slope of the line between Points A and B is A) 0.4. C) 2.5. B) 1.2. D) indeterminate from this information. Consumption
Use the table provided below showing rooms available, rooms sold and rooms revenue for 7 properties (subject hotel + comp set) for one month to compute occupancy index for the subject hotel. ITI Rooms Available (Supply) Rooms Sold (Demand) Revenue The subject hotel 10'000 7'000 700'000 Hotel A 9'000 3'000 400'000 Hotel B 9'000 8'000 700'000 Hotel C 10'000 7'000 700'000 Hotel D 7'000 5'000 500'000 Hotel E 11'000 8'000 700'000 Hotel F 8'000 4'000 400'000 Select one: a. None of the above b. 106.67 c. 108.00 / d. 92.59
If a monopolist produces q units, she can charge 100 4q dollars/unit. The fixed cost of production is $50, and thevariable per-unit cost is $2. How can the monopolistmaximize profits? If a sales tax of $2/unit must be paid bythe monopolist, then would she increase or decreaseproduction?
Hh1. Account Choose the stakeholder that is MOST likely to ask the following question. Will the business be able to pay for its purchases on time? Select one: a. Canada Revenue Agency management of a retailer b. c. business owner d. lender (e.g. banker) e. supplier (e.g. a wholesaler) f ou mor
Economics Daegu considers producing electric razors for men. If the market demand is high, he would get a return of $100,000, but if there were a low demand for this type of razor, he would lose $60,000. Daegu also considers the possibility of ordering a market survey to gather additional information about the market demand. The survey includes a sophisticated questionnaire administered to a test market and costs $5,000. Daegu believes that there is a 62:38 chance that the market information will be favorable (i.e., predicting a high market demand) and unfavorable (i.e., predicting a low market demand). Furthermore, the probabilities of a favorable survey given a high market demand and an unfavorable survey given a low demand are both 0.8. Daegu is not sure if the value of the survey is worth the cost Draw the decision tree and advise Daegu