GARY'S GRUB AND GASOLINE \"Gloria, we have been operating this service station and diner for many years. Lately, I have the feeling that my income has declined. I think that there are opportunities out there that I have not taken advantage of. I want to pass this business on to my sons and am not comfortable with our current position and strategy.\" The words above, spoken to Gloria, the primary accountant for Gary's, reveal a number of concerns Gary has concerning his operation. Gary's Grub and Gasoline (Gary's) is an independently owned service station and restaurant on a major interstate highway. Gary has been in operation for over a decade and customers have liked to frequent his business. Often they choose their routes to stop at places like his with low fuel prices and to enjoy food like the juicy burgers and good food Gary's provides. He has a great reputation with his customers, especially truckers, and enjoys their business. Gary has noticed, however, that when busiest with truckers, fewer families stop by. Gary has made a pretty good living running the place. However, even though his income continues to seem satisfactory, it does not seem to buy as much as before. This perception, as well as the maturity of his sons, George and Gary Jr., has heightened Gary's concern over the future of his operation. Gary wants to know what he can do to make this a more profitable business and pass on a more effective operation to his sons. Gary knows that his operation attracts many commercial truckers. However, he is also popular with families stopping to use the facilities and eating in the restaurant after filling up the family vehicle on vacations. Over the past decade (33er typical markup on diesel is about 1 cent and on gasoline is about 1.5 cents. This fuel pricing follows the typical process in this business of taking the delivery price and marking it up between 1 and 5 cents per gallon. Gary has also noticed an ebb and flow by season summer and winter being highest and spring and fall being lower. (Winter is December, January, February. Summer is June, July and August.) Gary knows that he has some control over fuel prices and can alter the prices of his typical meal. The dilemma he faces is to know in what direction he should change them or whether or not he should modify his pricing practice at all. Also, he does not know what other activities or attractions he could add that might increase his profits. If he raises prices, he knows that he will reduce sales. At lower prices, he will sell more but incur greater costs. Gary is getting ready to step back from his business and turn the operation over to his sons. Before he does that, he wants to be comfortable in leaving his sons with a well-defined pricing strategy, based upon data. Following up on the expression of (33er future concerns, Gloria, his accountant, has gathered a substantial amount of information regarding his firm's performance over the past decade. This data is available in an Excel file on the course website. Specifically, Gary wants to know: 1. Whether or not recent inflation eroded his income? 2. Whether he should continue with his current fuel pricing practice of marking up diesel by 1 cent and gasoline by 1.5 cents per gallon? Should this practice continue even if fuel prices rise over $4.00 per gallon? 3. How seasonal demand affects his sales and what might be done to take better advantage of these fluctuations? Required: As members of your own consulting rm, Gary has turned this project over to your team. He wants you to prepare a business report for him. This report should address his concerns, including the standard executive summary, and make recommendations. Be sure to use the guidelines for writing a report as found on the course website. The lower division core topics that might be helpful in preparing your report include microeconomics topics 1, 3, and 5 and statistics topics 1, 4, and 7. U.S. Department of Energy, Energy Information Administration Excel Filename: PSW17.xIs Contact Data Administrator (202)586-8800 infoctr@eia.doe.gov These data are extracted from a database that is designed to contain the information that is released in hard copy publications. The official numbers Disclaimer: are contained in the publications. Any questions should be directed to the above contact. Updated on 07/21/2004 Version 2004 Available Worksheet Data *Click the worksheet name in the table or the worksheet tab at the bottom of this page Worksheet Name Description Frequency # Of Series Begin Date 1-Weekly U.S. Retail Motor Gasoline and On- U.S. Retail Motor Gasoline and On-Highway Diesel Fuel Prices Weekly 24 08/20/1990 2-Monthly U.S. Retail Motor Gasoline and On- U.S. Retail Motor Gasoline and On-Highway Diesel Fuel Prices Monthly 24 05/1 1/1992