Preview

Adding Data Entry to Management

Satisfactory Essays
Open Document
Open Document
662 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Adding Data Entry to Management
Adding Value to Data for Management Decision Making
Team Assignment – Paige Phillips, Mark Webb
Bus 140-006 R. McLeish

1. Which are the best performing sales regions by Total Sales? Query1 | Sales Region | Total Sales | East | $529,124.80 | South | $234,595.05 | North | $233,832.75 |

2. Which are the best performing stores by Total Sales? Query2 | Store No | Total Sales | 6 | $267,648.90 | 7 | $170,040.85 | 5 | $158,334.00 | 8 | $91,435.05 | 1 | $90,281.10 | 3 | $90,051.25 | 4 | $75,498.75 | 2 | $54,262.70 |

3. What are the best-selling products by Total Sales?

Query1 | Item Description | Total Sales | Desktop CPU | $833,800.95 | 17" Monitor | $139,461.00 | 101 Keyboard | $18,294.15 | PC Mouse | $5,996.50 |

4. Which are the best performing sales regions by Units Sold?

Query1 | Sales Region | SumOfUnits Sold | East | 1532 | North | 882 | South | 763 |

5. Which are the best performing stores by Units Sold?

Query1 | Store No | SumOfUnits Sold | 6 | 727 | 5 | 615 | 7 | 548 | 1 | 325 | 3 | 306 | 4 | 267 | 8 | 257 | 2 | 132 |

6. What are the best-selling products by Units Sold?

Query1 | Item Description | SumOfUnits Sold | Desktop CPU | 981 | 101 Keyboard | 917 | PC Mouse | 670 | 17" Monitor | 609 |

7. Which are the best performing sales regions by Weekly Sales? (Sort by weeks, then by total sales)

Query1 | Sales Region | Week Ending | Total Sales | East | 12/29/2006 | $186,218.55 | East | 11/24/2006 | $181,965.35 | East | 10/27/2006 | $160,940.90 | North | 11/24/2006 | $81,578.90 | South | 10/27/2006 | $79,203.95 | South | 11/24/2006 | $78,416.80 | North | 10/27/2006 | $77,577.90 | South | 12/29/2006 | $76,974.30 | North | 12/29/2006 | $74,675.95 |

8. What are the best-selling products by Weekly Sales? (Sort by weeks, then by total sales)

Query1 | Item Description | Week Ending | Total Sales | Desktop

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Hsm 260 Week 4 Case Study

    • 660 Words
    • 3 Pages

    Sales revenue | $580,000 | $600,000 | $20,000 | U | Cost of goods sold | $385,000 | $360,000 | $25,000 | F |…

    • 660 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    - Antivirus programs protect computers against viruses by identifying and removing any computer viruses found in memory, on storage media, or on incoming files. A virus hoax is an e-mail message that warns users of non-existent virus or other malware.…

    • 300 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Record Control Management

    • 783 Words
    • 4 Pages

    The medium facilities that use electronic charts do not have a need for circulation or do…

    • 783 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    1) Offer a minimum of 10-12 CE Hours per branch/region (does not include Rocky Mountain Green and Green Schools CE Hours).…

    • 437 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Management Information Systems (MIS) is the study of people, technology, organizations and the relationships among them. MIS professionals help firms realize maximum benefit from investment in personnel, equipment, and business processes. Business intelligence (BI) is collective information about your customers, your competitors, your business partners, your competitors, your business partners, your competitive environment, and your own internal operations that gives you the ability to make effective, important, and often strategic decisions (Haag & Cummings, 2011). Management Information Systems is a broad business function and the study of the use of IT and IT is a set of tools and a resource within management information systems. Management Information Systems (MIS) and Information Technology (IT) are all involves computers and the manipulation of information. Computers are relied upon to handle the massive amounts of information that needs to be disbursed, maintained and managed quickly and efficiently…

    • 1450 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    First of all, I am thankful to God, because without him nothing would be possible. Without him, I would not have the strength and vigor to complete this project. I am also thankful to the lecturer, Mrs. Merlene Senior, for giving us this project to do and challenging us with it, and using it to help us increase our knowledge and to understand Management Information System to a further dept.…

    • 3156 Words
    • 13 Pages
    Powerful Essays
  • Good Essays

    A NEW SYSTEMS INITIATIVE Houston Area Windows Company (HAWC) is an twelve-year-old company based in Houston, Texas. HAWC headquarters is located on the South East side of Houston. Currently, there are four local service centers providing installation and repair services for the greater Houston area. HAWC is organized into five logical units: Sales and Marketing, Product Installation and Repair, Training, Accounting and Finance, and Human Resources. All units except Product Installation and Repair are located at HAWC headquarters on the South East side of Houston. Product Installation and Repair services are performed from all locations. Many of HAWC's business activities involve collaboration between professionals in different departments – often in different geographic locations. To serve customers properly, communication between team members must be as effective as possible. HAWC employees sometimes must have corporate information available at their fingertips. In order to meet customer expectations and remain competitive, managers at HAWC want to extend the access to communications and information that their employees have available at the home office and make the information available to them at service centers and, eventually, at other locations outside the headquarters office. As part of an ongoing effort to improve business performance within HAWC, managers have become aware of complaints made by various customers. Several customers have complained that products and services provided by HAWC have not met the standards of quality which they expected. In some cases this has happened because sales representatives have made promises which could not be delivered by the Product Installation and Repair employees. In some cases, the Product Installation and Repair employees were not even aware of the promises made by the sales reps. As products and services are being sold, unforseen circumstances occur and new information becomes…

    • 7431 Words
    • 30 Pages
    Good Essays
  • Better Essays

    Management Information System

    • 12620 Words
    • 51 Pages

    Mark C. Paulk, Charles V. Weber, Suzanne M. Garcia, Mary Beth Chrissis, and Marilyn W. Bush,…

    • 12620 Words
    • 51 Pages
    Better Essays
  • Powerful Essays

    Business processes are Manners in which work is organized, coordinated, and focused to produce a valuable product or service. They are concrete work flows of material, information, and knowledge—sets of activities. They are also refer to unique ways to coordinate work, information, and knowledge, and the Ways in which management chooses to coordinate work. Many Business Processes may be tied to functional area or be cross-functional…

    • 2235 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    “The study of MIS is not about the use of computers, it is about the provision and use of information relevant to the user. Computers are one - albeit important - means of producing information and concentration on the means of production rather than the needs of the user can lead to expensive mistakes." (Lucey [1997] pg 195)…

    • 3468 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    2.What are the Technologies used by United Parcel Service? How are these technologies related to UPS’s business strategy?…

    • 358 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    DATA MANAGEMENT

    • 887 Words
    • 3 Pages

    Data mining is the process of analyzing data from different perceptions and summarizing it into useful evidence that can be used to increase revenue, cut costs or both. Data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many different dimensions or angles, categorize it and summarize the relationships identified. Association, Clustering, predictions and sequential patterns, decision trees and classification are the data mining techniques. It is a promising and relatively new technology. Data mining is defined as a process of discovering hidden valuable knowledge of analyzing large amounts of data, which is stored in databases or data warehouse, using various data mining techniques such as machine learning, artificial intelligence and statistical.…

    • 887 Words
    • 3 Pages
    Better Essays
  • Powerful Essays

    Currently, no computers exhibit full artificial intelligence (that is, are able to simulate human behavior). The greatest advances have occurred in the field of games playing. The best computer chess programs are now capable of beating humans. In May, 1997, an IBM super-computer called Deep Blue defeated world chess champion Gary Kasparov in a chess match.…

    • 5256 Words
    • 22 Pages
    Powerful Essays
  • Powerful Essays

    i. Interoperability: The data entered into your accounting software can be productively used by various business applications in HR, sales, shipping and other key business sectors. Conversely, you may want your accounting program to draw information in from other software products. That's why you'll want to check on an accounting program's ability to interoperate with other software before deciding on whether to purchase it.…

    • 2181 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    When developers start to acquire equipment or software, the __________ stage of the SDLC has been reached.…

    • 603 Words
    • 3 Pages
    Satisfactory Essays

Related Topics