***MUST USE SOLVER TOOL IN EXCEL TO JUSTIFY ANSWERS, PLEASE PROVIDE DECISION TABLES AND SOLVER INPUTS***

Mr. Armando, the owner of a high-end Mexican restaurant in Houston, was puzzled by the choices put before him by the Groupon sales representative. He could offer a daily deal at Groupon (a $60 coupon for $30) that would be seen by hundreds of thousands of Groupon subscribers in the area, or he could offer a more tailored discount at Savored, a restaurant reservation site also owned by Groupon. Business had been slow lately, especially during weeknights, and Mr. Armando wanted to spur demand. He wanted to make sure, however, that he did so in a way that actually increased profits. He estimated that demand on weeknights was uniformly distributed between 30 and 102. Given a capacity of 100 and only a single seating per table per night, there were empty tables on many nights.

Groupon and the Daily Deal

Launched in 2008, Groupon expanded rapidly on the basis of its daily deals. The daily deal amounted to a 50 to 70 percent discount coupon for a product or service offered by a local business. The deal was broadcast by Groupon to its subscribers; if the number of buyers exceeded a threshold, the deal was finalized and the company shared about half the revenues with the local business while keeping the rest as its commission. The local business thus received about 20 to 25 cents on the dollar of retail value. Customers who purchased a coupon using the daily deal then contacted the local business for their product or service. At restaurants like Mr. Armandos, Groupon buyers tended to get their reservations as soon as they purchased their coupon, which was well before regular customers tried to get their reservations.

The popularity of the daily deal among subscribers led to rapid growth at Groupon. After rejecting a $6 billion offer from Google, the company went public in 2011. Its stock has had a turbulent journey since then. After opening at $25, the stock hit a low of $4 by the end of 2012 before recovering to $10 by early 2014. The drop-in price could be attributed in part to the higher marketing costs and the negative publicity from some retailers who had used the daily deal. Some complained that the financials just cant work, whereas others called Groupon the worst marketing ever. Retailers complained that while Groupon brought in new customers, the margins were terrible because the 20 to 25 cents on the dollar recovered from a Groupon deal was much lower than the revenue the new customers provided.

A very popular blog post by Jay Goltz on the New York Times site offered retailers a way to evaluate the benefit of the daily deal. He suggested that retailers think of Groupon as advertising. Instead of writing a check to the advertising agency, retailers using the daily deal were choosing to lose money on sales. Thus, the only calculation that mattered was the cost per new customer acquired from a daily deal. The blog post suggested the following eight key metrics to decide whether the daily deal was cost effective advertising:

1. Incremental cost of sales 2. Size of the average sale 3. Percentage of coupons redeemed 4. Percentage of coupons purchased by current customers 5. Number of coupons purchased per customer 6. Percentage of new coupon customers who become regular customers 7. Value of all Groupon subscribers seeing the daily deal 8. Current cost to acquire new customer through advertising

The value of the daily deal depended on these numbers. In an example described on the blog, Mr. Goltz focused on a restaurant that sold 3,000 coupons with a face value of $75 for $35 (the restaurant received only $17.50, with Groupon keeping the rest as commission). He assumed that the restaurant spent 40 percent (of normal revenue, not discounted revenue) in incremental cost; customers spent, on average, $85 ($10 more than the coupon); only 85 percent of the coupons were redeemed; 40 percent of the coupons were purchased by current customers; two coupons were purchased per customer; and about 10 percent of the new customers came back to the restaurant.

In this case, the restaurant received a check of $52,500(= 3,00017.50) from Groupon and additional revenues of $25,500(= 3,0000.8510) because the customers who came to the restaurant spent $10 more than the face value of the coupon. The incremental cost of serving these customers was $86,700 (= 3,0000.85850.40). The restaurant thus lost $8,700 on this deal. If viewed as advertising expense, it was necessary to evaluate the number of new repeat customers that the deal brought in. Given that 2,550(= 3,0000.85) coupons were redeemed and each customer bought two coupons, the deal was used by a total of 1,275 customers. Given that 60 percent of these were new customers, the deal brought 765(= 1,2750.6) new customers to the restaurant. If 10 percent of them would return, the deal effectively brought in 76 new repeat customers. The restaurant then had to decide whether spending $8,700 to bring in 76 new repeat customers was more effective than other forms of advertising.

Savored and Restaurant Discounts

Groupon acquired Savored, a restaurant reservation engine, in September 2012. Savored offered discounts of up to 40 percent at upscale restaurants as long as customers made the reservations online in advance. Restaurants could vary the discount offered by time of day and day of week, with larger discounts for less popular times. Restaurants could also vary the number of tables available at the discount price. Savored suggested times when discounts should be offered after studying a restaurants traffic patterns. For example, all Saturday night slots at the Capital Grille on Wall Street were discounted because it attracted a workweek crowd, whereas the Fatty Crab in the West Village in Manhattan offered only a Saturday night discount at 11p.m. Savored had helped restaurants manage their idle capacity effectively. Le Cirque, an upscale Manhattan restaurant, had eliminated its cheaper pre-theater menu because Savored reservations filled those slots.

Questions

1. Assume a variable cost of $10 per table and an average spending of $60 per table. With the daily deal ($60 for $30 coupon), Groupon provides Mr. Armando with a revenue of $15 per table. The analysis provided in the New York Times blog indicates that Mr. Armando makes money ($5 per table) through the daily deal (rather than incurring advertising expense). Note, with Groupon, Mr. Armando cannot limit the number of tables allowed for the discount price. Do you think the analysis by the New York Times has included all aspects that need to be considered? Should Mr. Armando go ahead with the daily deal given that he can advertise while making a little bit of money per coupon? Explain your reasoning. (20 points)

2. With Savored, Mr. Armando can limit the number of tables he allows for the discount price. Assuming he makes the same revenue with Savored per discounted table as the daily deal ($15), do you think the ability to limit the number of tables at discount has any advantages? How many tables should be set aside for regular customers and how many should be for Savored customers? Show your calculations and explain your reasoning. (20 points)

3. Would you prefer to use Savored or the daily deal? Why? (10 points)

***MUST USE SOLVER TOOL IN EXCEL TO JUSTIFY ANSWERS, PLEASE PROVIDE DECISION TABLES AND SOLVER INPUTS***