I need the assignment completed using excel the outline for the assignment is uploaded below. Art Gallery
Your sister runs an art gallery where she teaches art classes. Her clients pay monthly dues and can take as many classes as they want. Her gallery is losing money, and she asked you to help identify how she can become profitable. Your first step is to perform a simple what-if analysis using Goal Seek in which you set a target profit of $15,000 by changing the membership dues. Be sure that you do not change the resulting values as you move through the project. Next, construct a one-variable data table using dues ranging from $50 to $70 at $2 increments and show results for the revenues and income. Then create a two-variable data table using the same dues substitution values and memberships ranging from 2,500 to 3,100 at 200 increments to show results for income. Format the tables (including substitution values, results, and headings) appropriately. Apply a fill color to the result cells closest to the break-even point without creating a deficit. Create a Scenario Summary report using the following scenarios: (1) Best Case 3100 Members, $70 Dues (2) Worst Case 2,300 Members, $50 Dues (3) Most Likely 2,600 Members, $60 Dues. Show results for the Income. In your Summary report, modify the cell references to show appropriate labels for the data. Select landscape orientation, adjust the margins, and then adjust the column widths. Create a footer with your name, the sheet name code, and the file name code. Save and close the workbook, and submit to Blackboard.
Creative Art Gallery
Monthly Expenses
Lease $28,300
Overhead 9,785
Supplies 9,450
Salaries 102,750
Education Programs 3,247
Studio Maintenance 1,267
Total Expenses $154,799
Monthly Revenues
Members 2,564
Dues $50
Total Revenues $128,200
Budget
Total Revenues $128,200
Total Expenses 154,799
Income $(26,599)
