Homework Case Study Example | Topics and Well Written Essays - 500 words

Homework - Case Study Example A pivot table can then break down the numbers to show the amount sold by each employee. Then, it could even go further and break those numbers down by cities. So you would know which employee made the most number of sales, in which city the most number of sales were made, and which singular employee made the most number of sales in just one city. Data from the pivot table could then be used to allocate funds and estimate future sales based on the data from the pivot table. Comparisons could then be made across previous time periods and a comparison could be made to show the trends of certain employees or locations. Changes could then be made based off this data by either firing an employee or stop selling products in a city that is underperforming. 1- Because they are amazing tools used to quickly explore and manipulate data from a spreadsheet. A pivot table uses existing data and allows users to sort that data by any field they choose. The user can select which fields they would like to be displayed and whether it should be a column or a row header. That table can then be manipulated by integrating formulas into the table to quickly get inventory counts, cost percentages, sales commissions, regional growth, or anything else you need to determine. Using pivot tables to explore crosstab data is much easier than searching through spreadsheets, pulling out the pertinent data, then creating a new spreadsheet with the data necessary. Pivot tables make analyzing large quantities of data a user-friendly experience. You can actually create a pivot table in as few as 10 mouse clicks! You are correct in that using a pivot table can significantly reduce the time it takes to analyze data. All it needs is for just a few spaces to be filled in and the pivot table will display all the information you need in a nice and easy format. You might want to mention though that the use of pivot tables is not simply reduced to business-related activities but can

Artificial reefs on the gulf coast and why funding should remain for Essay

Artificial reefs on the gulf coast and why funding should remain for them - Essay Example The fact that they are artificial means that they are manmade. It follows that man has to effect necessary measures including funding in order to protect this type of unique environment. Once the funding is provided it is expected that the relevant authorities will ensure that is properly used for the good of the artificial reefs in general. The emergence of artificial reefs can be compared to oases in deserts. Artificial reefs can also be described as safe underwater havens made up of hard surfaces on which invertebrates attach themselves. These invertebrates include corals, bryozoans, barnacles, hydroids and clams. A simple theory has always been that invertebrates will start living around the reef once it has been established. A marine food will therefore develop in that ecosystem. Naturally, other forms of marine life will also be attracted in the area (Bortone, Brandarini and Otake, 251). A typical scenario is that bigger fish will head for the reef in order to feed on the smaller ones that arrived earlier thus the common saying that larger fish are usually right behind the smaller ones. Some areas such as Florida used to establish artificial reefs by sinking any object for instance refrigerators, fridges, washing machines among others. This was a haphazard approach of building the reefs since they would soon be de stroyed by hurricanes or tropical storm. Today, establishment of an artificial reef requires careful planning and choice of materials. Bortone et al (260) asserts that the main objectives are to enhance the original habitat at the bottom of the sea and increase the population of local fish. Generally looking at the Gulf coast, the area with the most number of permitted artificial reefs is the state of Florida. The Florida Fish and Wildlife Conservation Commission is thus the one responsible for establishing guidelines for the deployment of artificial reefs. There are close to 2,700 artificial reefs along Florida’s