How much usage it might receive and where to set the price

Assignment Help Database Management System
Reference no: EM131325412

Assignment

Project Description:

Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used for tubing. The management is trying to figure out how much usage it might receive and where to set the price in order to make a profit. The company seeks to make sure the project would at least break even the first year after development costs. Management has tasked you with developing a worksheet to analyze the situation.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step Instructions

1 Start Excel. Open the downloaded spreadsheet named e05ws10_grader_h1.xlsx. Save the file with the name e05ws10_grader_h1_LastFirst, replacing LastFirst with your name.

2 The company would like a break-even analysis completed. On the Break-Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell D7.

3 Enter the correct formula to calculate the Total Fixed Costs in D13.

4 Enter the correct formula to calculate the Total Variable Costs in D17.

5 Enter the correct formula to calculate the Total Expenses in D18.

6 Enter the correct formula to calculate the Net Income in D19.

7 Management thinks an average of 75 guests a day would be a realistic average. Use Goal Seek to find out what the price would need to be to come out exactly even with 75 guests per day.

8 Fill in the Expenses, Revenue, and Net Income columns (range G4:I19) using a data table.

9 Format the range G4:I19 as Currency.

10 Copy the information in range A3:D19 from the Break-Even Analysis worksheet and paste it in range A3:D19 on the worksheet PriceAndGuest. Keep the source column widths.

11 Create a data table in the range F5:N21. The price (row 4) needs to start at $3 and increase to $10 in $1 increments, and the number of guest (column F) needs to start at 25 and increase in increments of 5.

12 Format the data in the data table so any net profit under -$5,000 has a light red background and dark red text, data that is above or equal to -$5,000 and below $5,000 will have a light yellow background and dark yellow text, and anything $5,000 or greater will have a light green background and dark green text.

13 Format cell F5 to hide the result of the formula in the cell.

14 Copy the information in range A3:D19 from the Break-Even Analysis sheet to the range A3:D19 on the sheet DaysAndPrice. Keep the source column widths.

15 Add a scroll bar to the right of the inserted cells in column F that will change the days of operations per year between the values of 200 and 250 one day at a time. Enter the text Days of Operations per Year in cell F21.

16 Add a scroll bar to the right of the first scroll bar in column I that will change the price between the values of $3 and $10 by $1 increments. Enter the text Price in cell I21.

17 Close the spreadsheet and submit the spreadsheet as directed.

Attachment:- alqadheeb_e05ws10_grader_h1_2.xlsx

Reference no: EM131325412

Questions Cloud

Human being has when he is born : How many kidneys does a human being has when he is born?
Comment on the current credit risk assumed : Comment on the current credit risk assumed for each of the following positions. Treat them separately; that is, not combined with any other instruments.
Compute the snr and rate : Repeat using a five-level quantizer. Compute the SNR for each case, and compare the rate distortion performances using a one-tap and two-tap predictor.
How innovative benefits could be tied to specific jobs : Determine how innovations in employee benefits can improve the overall competitive compensation strategy of the organization. Explain how innovative benefits could be tied to specific jobs
How much usage it might receive and where to set the price : YOF EWS10 H1 - Extreme H20 1. In a nearby community, there is a small river that can be used for tubing. The management is trying to figure out how much usage it might receive and where to set the price in order to make a profit.2:
Anolis occultus or anolis evermanni : Is Anolis cristatellus more closely related to Anolis occultus or Anolis evermanni?
Beneficial to improve human health : What designer-drug would be beneficial to improve human health? Is our ability to use PCR in forensics a problem for civil liberty?
Name six specimen types that are often tested : Name six specimen types that are often tested in forensic toxicology; e.g. blood. Under what circumstances is each specimen preferred?
Responsible for production : What is the specialised cell that is responsible for production?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Design a high-level conceptual view of a data warehouse

Design a high-level conceptual view of a data warehouse using Microsoft Visio that shows the following: Integration layers and The data warehouse

  Prepare a document containing the logical design

State any assumptions you make about the problem, especially those required for correct interpretation of your diagram.

  Present an entity-relationship model?

The company has several branch offices. Each branch is identified by a branch_number. The name, address (street, city, ZIP), and revenue_target of each branch office are maintained.

  Database and data warehousing design

This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it i..

  Describe three examples in which databases could be used

Describe three (3) examples in which databases could be used to support decision making in a large organizational environment. Describe three (3) examples in which data warehouses and data mining could be used to support data processing and trend a..

  Address what makes database connectivity so complex

Address what makes database connectivity so complex and what could be done to simplify it.

  As a dba it is vital that you understand in detail how a

as a dba it is vital that you understand in detail how a query is processed by the dbms. since team retail is using

  Design the necessary database tables

Design the necessary database tables.-  State the primary key for each table as well as all other necessary attributes.

  Create the database using three tables

Create the database using three tables: one for student information, one for advisor information, and one for department information.

  Design and develop a database using professional principles

Design and develop a database using professional principles and standards. Provide a logical and physical design of the database. Use relational database software application to develop database.

  How virtual applications and desktops or both will delivered

Regional Gardens Ltd is a company that runs number related gardening enterprises. It has a large display garden that it opens for public inspection a number of times in a year.

  Types of keys used in relational database

Explain with examples different types of keys used in relational database, how they help relating different tables.

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