Please see attached Excel Problem. Answers have to provided in excel. there are two sheets, one with the problem statement and one for showing the work.

Problem 1. 5 pts Green Thumb operates a chain of lawn fertilizer stores. Although the fertilizer is sold under the Green Thumb label, it is purchased from an independent manufacturer. Sue Smith, president of Green Thumb, is studying the advisability of opening another store. Her estimates of monthly costs for the proposed location are: Fixed costs: Occupancy costs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Other . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Variable costs (including cost of fertilizer) . . . . . . . . . . . . . . . . . . . . . . . . . . . $5,000 2,400 1,600 $12 per bag Although Green Thumb stores sell several different types of fertilizer, monthly sales revenue consistently averages $20 per bag sold. Instructions(show all detailed calculations for partial credit) 1. Compute the contribution margin ratio and the break-even point in dollar sales and in bags sold for the proposed store. 2. Calculate the targeted profit in sales dollars and units if the company wants $6,000 for income. 3. Smith thinks that the proposed store will sell between 1,500 and 1,800 bags of fertilizer per month. Prepare two Cost Volume Profit Income Statements. Please include per unit also. 4. Please identify what information you would need if I asked you to prepare a traditional income statement. 5. If the company purchases materials from a new vendor for $10 per bag but the quality will impact the sales price. How low can the sales price go and still maintain the same contribution margin