Art gallery

Assignment Help Web Project
Reference no: EM13724780

Choose one of the following topics for your Project. Make sure to complete all requirements listed. You may need to do research outside the textbook to learn how to do something new or to compile the data needed for the Project. Do not do just the bare minimum. Get creative and really show off what you have learned. Label additional work so that your professor knows where you have gone above and beyond the project requirements. If you select a topic that includes a starting file, you can download this from Blackboard.

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. Open the e06b1gallery.xlsx file from Blackboard and save it as e06b1gallery_LastnameFirstname. 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.

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)

Reference no: EM13724780

Questions Cloud

Survey of data mining and knowledge discovery software tools : You have to write critical review ( of about 3 to 4 pages) on A SURVEY OF DATA MINING AND KNOWLEDGE DISCOVERY SOFTWARE TOOLS article.
Corporate marketing vs small business marketing : ESSAY TOPIC: CORPORATE MARKETING VS. SMALL BUSINESS MARKETING
Construct a full conflict management strategy : Process for consensus decision making - Construct a full conflict management strategy and processes
Given its strengths weaknesses opportunities and threats : Using the same organization (Mcdonals) from Week# 2's discussion, research and describe its organizational structure. In your opinion is this the optimum structure for the organization given its Strengths, Weaknesses, Opportunities and Threats
Art gallery : Choose one of the following topics for your Project. Make sure to complete all requirements listed. You may need to do research outside the textbook to learn how to do something new or to compile the data needed for the Project. Do not do just the..
Analyze the inputs of materials or resources : Describe the logistics and supply chain management system of your firm or a firm you have researched - Analyze the inputs of materials or resources used in the business.
Give a detailed description of company : Provide a detailed description of your company. The description should include, at a minimum, the company's name, its history, founders, business purpose, and mission
Why u.s. companies are having issue with exporting : Discuss the five reasons that Crooks outlines in the article and finish your post by offering your opinion of whether The Economist's viewpoint or with The Industrialist's viewpoint is more agreeable.
Discuss the significance of the classic : Find an ADVERTISEMENT which uses the "classic" work of art. Compare and contrast the two. Discuss the significance of the "classic".

Reviews

Write a Review

 

Web Project Questions & Answers

  Implement the wireframe design

Implement the wireframe design and provide appropriate information about a current special offer, e.g. buy now and receive a discount

  Organizational dynamics change

Recall extensive change you have witnessed recently inside your corporation or a corporation you are familiar with. Has it been successful? Characterize why it won or failed.

  What is the project

Use the template that is provided following the case study as a basis for your work. If the case study does not provide enough information for a particular section, you may "embellish" the case study with additional information sufficient to allow..

  Time taken to get website page with embedded images

Assume you click on a link within your browser to get a Web page. The IP address for the associated URL is not cached in your local host, so a DNS look up is required to obtain the IP address.

  How to create free web tutorial for computer science

Write how to develop a free web tutorial exclusively for computer science students; the target of the project is to provide the required facilities

  Explain software development methodology

Using the first four laws of the text, show where these are either implemented or missing in each software development methodology (Total Two). If a law is missing, explain the consequences and suggest how the process might be improved.

  Develop a web-scraping program

Develop a web-scraping program that can obtain the html contents from a URL and parse the contents to extract data to be used as the source data for a system integration document. This needs to be done in Visual Studio, preferrably VB, C#, or C++.

  Describes functionality of application and the justification

The Design Report is a single team report that describes the functionality of the application in its final form. You should include descriptions of all of your functions and sketch the storyboard associated with each function.

  Discuss the apache web server

Discuss the Apache Web server in regard to cost, functionality, and compatibility. Are there certain implementations were it may not be suitable?

  It influences the behavior of organizations

Information technology influences the behavior of organizations. Name one effect of Information technology implementation and long-term usage you suppose having a positive contribution and one having a negative consequence.

  Question about saving a project

Assume that you have been assigned to save a project that is already over budget and past due. The assignment is still only half done.

  Replacing elements through style attribute

The style attribute is replacing some elements in always evolving HTML world. Many features that were implemented using elements in older versions of HTML are implemented using the style attribute.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd