I need this done within an hour. Let me know if you can.

Excel Problem: 20pts 50 minutes only Run Dog operates a chain of grooming salons for pets. Nancy Smith, president of Run Dog, is studying the advisability of opening another store. Her estimates of monthly costs for the proposed location are: Costs: Rent. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Other costs which remain the same each month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Cost for all required products per pet(like shampoo, conditioner etc). . . . . . . . . . . . . . . . . . . . . . . . . . . $5,000 4,000 1,600 $20 per pet Although Run Dog stores offer several different types of services, monthly sales revenue consistently averages $80 per client served. Instructions- Please use formulas when preparing your information. It will allow me to understand your calculations. 1. Compute the contribution margin ratio. 2. Calculate the break-even point in sales dollars AND in number of clients serviced for the proposed store. 3. Calculate the targeted profit in sales dollars AND units if the company wants $15,000 for income. 4. Smith thinks that the proposed store will service between 375 and 400 pets per month. Prepare two Cost Volume Profit Income Statements. Please include per unit also. 5. If the company purchases materials from new vendors for $15 per pet(reduction of $5 from original cost above) but the quality will impact the sales price. How low can the sales price go and still maintain the same contribution margin