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 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Hotels charge lower prices in the off-season to attract guests to fill up vacant rooms. This strategy is based on the of services. Perishable Variability Intangible Inseparability
Deja Brew, Inc., produces and sells 1,000 pallets of tea. Selling price per pallet: $700 Variable cost per pallet: $100 Annual fixed costs: $20,000 How many units would Deja Brew, Inc., need to sell to make $10,000? Round to the nearest whole pallet.
Service winners can become qualifiers over time. O a. True O b. False
A service that does not include any tangible component, such as with counseling is called a : High quality service tangible product Pure service Mixed product
Fee-for-service payments give each service a point value. True or False?
Which distributed benefits can be associated with the demand portion of the value chain?
Gas Me Up is considering offering bagged ice sales through a self-service company that would locate a machine on the edge of the parking lot. IceBox would charge a monthly lease fee of $325 for setup and maintenance and there is a utilities’ cost Gas Me Up incurs of $0.07 for every bag of ice. KeepItCool would charge a monthly lease of only $225, but the added energy cost for every bag of ice is $0.11 due to the larger size of the machine. Customers purchase each bag of ice for $2.50, regardless of the company, but Gas Me Up only earns 40% of the total revenue for each bag of ice sold. What is the annual break-even point for each option? At what volume in number of bags of ice would the two options have the same cost? At what forecasted volume should Gas Me Up select IceBox and what volume should the company select KeepItCool and why?
Submit a single Excel file with formulas within answer cells. Show the formulas for the answer County Hospital contracts for an anesthesiologist’s services for a guaranteed cost of $15,000 a month. For every service the anesthesiologist provides on a procedure, the hospital budgets an incremental $200 toward the anesthesiologist’s salary. Every time the anesthesiologist provides a service, the hospital gains revenue of $1200, which is a sixth of the overall procedure’s revenue. Be sure to make excel do the calculations and indicate any units for the answer. How many procedures would an anesthesiologist have to work on monthly for the hospital to Break Even?
The sales department receives all orders from the customers. While receiving the order, the sales team authorizes the payment and check line items. If authorization is failed, a cancelation message is sent to the customer. On the other hand, each line item is checked with the stock. If it is in stock, assigned to the order otherwise the item is removed from the list. If stocks are available for all products and payment is authorized, the sales team dispatched the order.Shipping teams ship the order to the customer. The method of delivery is decided conditionally. Depending on the condition either the Urgent Delivery activity or the Regular Delivery activity is performed. The delivery procedure is finished when the customer receives it and signs in. Draw an Activity diagram based on the above scenario.
Which business model will take a shorter amount of time to pay off its overhead? Hint: Calculate the revenue and the variable cost at the “day” level
Consider a chain of modular kitchen manufacturers who use postponement methods to design and install them. What would allow the chain to deliver a modular kitchen to a client in a reasonable period? How does this approach affect safety inventories, product differentiation, and responsiveness in the supply chain?
The cash-to-cash cycle time is?