could someone help me highlighting the lowest unit price that will provide the max profit please?

Lab7-cm Saved to OneDrive Randolph-Macont AutoSave Tell me what you wa Review View Help Power of File Insert Page Layout Formulas Data Home 018 +jA E G H F Lemon Coats, Inc. Exercise 1: Alweb ome Statemen Use a one-way Data Table to find the minimum Unit Prices for break even profit. Revenue Uhvta Sold L200 Unk Price w0 t 120 000 Total levenue Variable Eupenses Unk Produced Materia Cost per Uhi 1200 26 300 48700 Unit Ptce Total Marerial Co Manulactuning CoR per Un Totw Manut actrng Espena Total Vatiable Expenser 54 40700 14 60 -24700 28700 Fixed Expenses 70 22700 Leang Salay and benefes Aduertisng Adminisatione 5000 75 15700 s 45000 80 10700 5000 4700 2500 1300 Total Fized Expense 7300 Total Expenses 13300 Total Expenses 106.700 tn0 24 Summary 25300 Operating Profit (Loss) # 13.300 31300 120 37300 43000 43000 t 55000 30 140 61300 145 67300 32 73300 I50 34 38 1 Exercise 1 - Data Table Exercise 2 Data Table Exercise 3- Data Table E 4 teady Type here to search 5 Exercise 1 Dato Toble Use a one-way data table to find the break-even point for Unit Price-that is, find the minimum Unir Price that results in a near-zero Operating Income. To do this, start by choosing a cell in a bienk area of the worksheet (perhaps cell J9) and enter the formula of interest. For our exercise, this will be the profit formula that is in F25 Next, sterting in the cell just to the left and below the formula (that is, in 110), start a range of values for the Unit Price. Choose a range of values that brackets the existing value of $100-perhaps choose a range from $50 to $150 in $5 steps Create a one-way data table that includes the formula cell (F25) and the range of values you Just made. Select the appropriate Column Input Cell for the Unit Price, and complete the toble. Highlight the cell that shows the lowest Unit Price that will provide a positive profit. Add additional formatting to the values and the data table as deemed appropriate. Exercise 2-Dota Toble Use a similar series of steps to create a one-way data table to analyze a range of Number of Units Sold to determine the minimum number needed to be sold to find the break-even point. Consider using a range of values that brackets the existing number of units sold using 25 increments. The input values should be in range 39:330. Incorporate the same formatting rules as noted in Exercise 1 Data Table Highlight the cells representing with the break-even point associated with the minimum number needed to be sold. Add additional formatting to the values and the data table as deemed appropriate. Exercise 3-Doto Toble Use a similar series of steps to create a one-way data table to analyze the range of Material Cost per Unit to determine the maximum unit cost that still results in break even. Remember: a break-even point is when values transition from positive to negative. Consider using a range of values that brackets the existing material cost using $2 increments. The input values should be in range )9:330, Incorporate the same formatting rules as noted in Exercise 1-Data Table Highlight the cells representing with the break-even point assOciated with the maximunm unit cost. Add additional formatting to the values and the data table as deemed appropriate. Exercise 4-Data Table Use a two-way data table to explore how changes in both Number of Units Sold and Material Cost per Unit affect the bottom line. You will need to utilize different ranges and increments for both units sold and material cost. Assess the best way to setup and implement the two-way table. Consider reusing the range of values from Exercises 2- Data Table and Exercise 3-Data Table for a more consistent comparison To enhance the formatting of the data table, apply conditional formatting color scales to your results CSCI 106 Page 3 of 6 Lab7-cm ! AutoSave On Po View Help Review Formulas Data Page Layout Insert File Home (=TABLE(E7)) J14 A 2 Lemon Coats, Inc. Monthly Income Statement Revenue 6 Units Sold 1,200 7 Unit Price 100 Total Revenue 120,000 Variable Expenses 10 Unts Produced 1,200 11 Material Cost per Unt 26 12 Total Material Cost 31,200 13 Manufacturing Cost per Unit 15 14 Total Manufacturing Expense S 18.000 15 Total Variable Expense 49,200 Fixed Expenses 16 17 Leasing 5,000 18 Salary and benefits 45,000 19 Advertising S 5,000 20 Administration S 2,500 21 Total Fixed Expense S 57.500 Total Expenses 22 23 Total Expenses 106.700 Summary 24 25 Operating Profit (Loss) 26 13.300 27 28 29 30 31 32 22 Exercise 1-Data Table Exercise 2-Data Table Exercise 3-Deta Table Ready Type here to search esc