Please use Excel to answer the questions

The teacher did not provide if there was number of viewers... said it can be done without?

A hotel chain wants to put an advertisement in a magazine. Facts: Average Room Rate = $149 per night Magazine o Circ = 1,000,000 o Circ cost: $65/M: $65 x 1,000 = $65,000 O Production cost for ad = $25,000 Room Cost = $23.00 Questions: 1) What is the breakeven? a) Rooms b) Response Rate 2) Would you recommend this to your boss if the response rate is .79%? 3) Is it profitable? A hotel chain wants to put an advertisement in a magazine. Facts: Average Room Rate = $149 per night Magazine o Circ = 1,000,000 o Circ cost: $65/M: $65 x 1,000 = $65,000 O Production cost for ad = $25,000 Room Cost = $23.00 Questions: 1) What is the breakeven? a) Rooms b) Response Rate 2) Would you recommend this to your boss if the response rate is .79%? 3) Is it profitable