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

The controller of Sandhill Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Total Total Month Maintenance Costs Machine Hours January $2,570 3,400 February 2,940 3,920 March 3,510 5,880 April 4,410 7,760 May 3,100 4,900 June 4,506 7,800
Describe one current technology that can be used to ensure the safety of event operations. ( 30-50 words )
Which item would be considered an order winner in an automobile developed for high-end users? Voice-activated music system Compact disc players Full-sized spare tire Air bags
What is the nature of the product /service of Blackberry play book. An overview of its concept and objectives
5.9)
XYZ Healthcare Center receives reimbursement from C.H.E.A.T.E.M. insurance company. XYZ receives P20 per physical therapy session. Each session lasts 15 minutes. Because of a shortage of physical therapists, XYZ often finds it necessary to use a temporary service to provide therapists. Assume collections and other variable cost amount to P3 per visit and all other facility costs are fixed. What is the most (per hour) XYZ should pay for physical therapist ?
A new highway is to be constructed. Design A calls for a concrete pavement costing $80 per foot with a 20-year life; four paved ditches costing $3 per foot each; and two box culverts every mile, each costing $9,000 and having a 20-year life. Annual maintenance will cost $1,800 per mile; the culverts must be cleaned every five years at a cost of $350 each per mile. Design B calls for a bituminous pavement costing $55 per foot with a 10-year life; three sodded ditches costing $1.45 per foot each; and four pipe culverts every mile, each costing $2,100 and having a 10-year life. The replacement culverts will cost $2,350 each. Annual maintenance will cost $2,900 per mile; the culverts must be cleaned yearly at a cost of $215 each per mile; and the annual ditch maintenance will cost $1.35 per foot per ditch. Compare the two designs on the basis of equivalent worth per mile for a 20-year period. Find the most economical design on the basis of AW and PW if the MARR is 6% per…
Walmart first announced the use of shelf-scanning robots in 2017, aiming to replenish inventory faster and save employees time when products run out. However the retail giant plans to end its contract with Bossa Nova Robotics and plans to replace the machines with human workers. Why did Walmart make this decision?
Teachers at With-Hope Comprehensive school is attending a 4-day course at the Mamelodi Community Development Center to learn presentations of lessons using a data projector. All thanks to an anonymous donor who donated multiple data projectors which the school can use for presenting lessons. Which purpose regarding training and development manifests in the above scenario
Snip
At a local concert hall, the owner charges $7 per ticket. The owner must pay his band $1200. Every customer receives a brochure that costs the owner $2 for each person. What system would determine when he breaks even?.
Use the following information for the next 3 problems: ABC Company plans to construct a 60,000 sq. ft private warehouse and rent public warehouse as needed. Warehouse inventory turns at the rate of 2 times per month. One pound of merchandise occupies 0.2 cubic feet of warehouse space and can be stacked 10 feet high. Given aisles, and normal operating efficiency, only 50 percent of the total warehouse space is actually used for storage. Assume the facility is being built to size so no additional space is allowed for future product growth. A private warehouse can be constructed for $36 per sq. ft. and can be amortized over 20 years. Annual fixed costs amount to $20 per sq. ft. of total space. The cost of operation is $0.03 per pound of throughput. Space may also be rented for a storage charge on inventory of $0.06 per pound per month and a handling charge of $0.05 per pound of throughput. Monthly demands for a typical year are as follows: Month Demand (lb) Jan 2,000,000…