Essay on Business Information System

Submitted By Anis-Maredia
Words: 1120
Pages: 5
Open Document
ITECH1005

Business Information System

Anis Ali

ANALYSIS FOR SAM’S RESTAURANTS
Introduction:
The main aim of this report is to provide Joshua an analysis regarding the physical strength and weakness of the company. Further, this analysis will help the management to determine the future plans for the company in different strategic decision-making. As the vice president of operations for Sam’s Restaurants I investigate the data and convert in to meaningful information that will help to understand management of the company, that in which any particular region is performing well and which region need more attention to get better sales result. The data I have received for the analysis; I came up with the final outcomes that I will explain in my report as explain below

VLOOPUP
Question 2
The data was analyzed by using VLOOUP formula to figure out which restaurants are falling in to small, medium, large and really big categories in regards to annual sales.
By using (Data collection date’ – store opening date’)/365 formulas I calculate the store age (years).
Lastly by using Mean, Median, Maximum, Minimum, Range and standard Derivation formulas I am able to calculate Annual sales of each store and store aged (years) etc.

SUMMARY REPORT FOR EACH REGION
Question 3
By using formulas such as SUMIF, AVERAGEIF & COUNTIF i am able to find out the total and average annual sales etc.
1. By using the SUMIF formula I calculate the total annual sales for each region and sort the regions in descending order by total annual sale.
2. By using the SUMIF formula I calculate the total number of seats for each region. 3. By using the AVERAGEIF formula I calculate the average annual sales for each region. 4. By using the AVERAGEIF formula I calculate the average store age for each region Page | 1

ITECH1005

Business Information System

Anis Ali

5. By using the COUNTIF formula I calculate the total numbers of restaurant in each region.
6. By using SUMIF formula I calculate each region that has advertising.

Page | 2

ITECH1005

Business Information System

Anis Ali

ANALYSES REPORT FOR THE FOLLOWING QUESTION
Question 4
Task A & B: The data analysis made below is about which region has the highest and the lowest annual store sales for really big size restaurants. The pivot chart based on the pivot table which demonstrates the below results
Northeast has the highest annual store sales for really big size restaurant
South central has the lowest annual store sales for really big size restaurant.

$10,000,000.00

$9,000,000.00

$8,000,000.00

$7,000,000.00

$6,000,000.00

NORTHEAST

$5,000,000.00

FLORIDA

$4,000,000.00

CALIFORNIA

$3,000,000.00

SOUTH CENTRAL

$2,000,000.00

$1,000,000.00

$-­‐

NORTHEAST

FLORIDA

CALIFORNIA SOUTH CENTRAL

Page | 3

ITECH1005

Business Information System

Anis Ali

Task C: In this part I analyzed the total number of seats for medium size restaurants in the highest annual store sales region. So I have created a pivot table and chart which shows the below results
Texas has got the highest annual store sales for medium size restaurant with a total number of 5247 seats.

6000 5000 4000 3000 2000 1000 0

$50,000,000.00

$45,000,000.00

$40,000,000.00

$35,000,000.00

$30,000,000.00

$25,000,000.00

$20,000,000.00

$15,000,000.00

$10,000,000.00

Sum of Seats / Store Sum of Annual Store Sales

$5,000,000.00

$-­‐

Page
Show More

Related Documents: Essay on Business Information System

Essay on Business Information Systems

understanding of managing business information systems within Amazon. The topics of information systems impact communication, how information systems safeguard their information, as well as how legal, privacy, security, and ethical issues of business information systems. All these issues and more are serious issues that affect all businesses and must be addresses. Since all of these issues are serious concerns, it is important for businesses to make sure that their systems, which can contain customer…

Words 1070 - Pages 5

Essay on Business Information Systems

term "Information Age" has now been in so much use in recent years that you are expected to know what it means. It conjures up images of people who make their living solely by pushing information about, such as lawyers and teachers, or programmers and stockbrokers. Others argue that what makes today the Information Age is the fact that so many people rely on computers, especially since the advent of the personal computer and the Internet. Sociologists would have us believe that the Information Age…

Words 828 - Pages 4

Information Systems In Business Today

Lecture 1: Information Systems in Business Today 1.1 Coursework and Assessment • 1.2 Summative assessment: Method of Assessment % Detail (length, hours) Presentation 20 % David will explain the details Contribution to learning: active participation in class activities 20 % David will explain the details Written Exam 60 % End of the term Learning Objectives • The Role of Information Systems in Business Today – How are information systems transforming business and what is their relationship…

Words 1120 - Pages 5

Business Information Systems Essay example

Business Information Systems Business Information Systems ASSIGNMENT ASSIGNMENT TABLE OF CONTENTS INTRODUCTION PAGE 1 BODY-QUESTION ONE 1.1 PAGE 2&3 1.2 PAGES 1.3 PAGES QUESTION TWO 2.1 PAGES 2.2 PAGES 2.3 PAGES QUESTION THREE 3.1 PAGE 3.2 PAGE 3.3 PAGE 3.4 PAGE CONCLUSION PAGE REFERENCE PAGE Introduction…

Words 6871 - Pages 28

Essay about Introduction to Business Information Systems

INF10003 - Introduction to Business Information Systems Coversheet Individual Theory Concepts Semester S, 2014 (Refer to unit outline regarding penalty for late submission) To be completed and attached as the first page of your summary Tutorial day/time: Wednesday & Friday / 11:30 AM Maryam Nikpour Tutor’s name: Inability to provide the appropriate details may result in your assignment not being assessed I declare that no part of this submission has been copied from any other student's work…

Words 1283 - Pages 6

Information Systems Transform Business And Empower A Business To Have A Global Market

1. Information systems transform businesses and empower any sized business to have a global market. Businesses do not now have to be structured together geographically. Managers can be in New York, manufacturing can occur in California and the technical support for their product can be centered in India. Three major trends that are happening is that data is driving the applications instead of applications driving the data. Another trend is that technology is becoming cheaper and more accessible…

Words 522 - Pages 3

Business Driven Management Information Systems: A Study Guide Essay

ISYS210 (Fall 2013) Exam 1 Study Guide Chapter 1
 Section 1.1 – Business Driven MIS 1) Information Age – when infinite quantities of facts are widely available to anyone who can use a computer 2) Core Drivers of the Information Age A) Data- raw facts that describe the characteristics of an event or object Information- data converted into a meaningful and useful context Business Intelligence- (BI)- Information collected from multiple sources such as suppliers, customers, competitors, partners…

Words 4338 - Pages 18

An Analysis Of 7-Eleven's Strategic Business And Information Systems Needs

An analysis of 7-Eleven’s Strategic Business and Information Systems Needs. Q1. Evaluate 7-Eleven’s competitive advantage using the Michael Porter’s Five Forces model. The 7-ELEVEN convenience store concept was created in 1927 by the Southland Corporation which, at that time, operated mainly as an ice, milk, and eggs retailer. By 1946, the Southland Corporation introduced a new convenience service that involved prolonging the opening time from 7 a.m. to 11 p.m. This was how the legendary 7-ELEVEN…

Words 2155 - Pages 9

Business Information Systems: Dollar General: Strategic Global Project

INSC 20263-50 Business Information Systems Dollar General Strategic Global Project Submitted to Layne Bradley By Linc Kendall, Tommy Jewett, Eric Powell, Reid Anderson, and Kaity Wegen 10/20/2011 Table of Contents 1. Executive Summary- TEAM (Add the page number for each heading. Number the pages) 1.1 Background 1.2 Alternatives 1.3 Recommendations 2. Analysis- LINC 2.1 Proposed Global Geographic Location 2.2 Country Research 2.3 Industry Research 2.4 Industry Environment-Porter’s Five Forces…

Words 1044 - Pages 5

Analyse Fundamental Concepts To Extrapolate The Nature Of Information Systems And Their Role In Business

TITLE Information Systems UNIT CODE WDB1005 PRE-REQUISITES Nil CREDIT POINTS N/A MODE OF DELIVERY Off Shore LOCATION Onshore UNIT COORDINATOR Wendy Lyle Wendy.Lyle@vu.edu.au 99199228 OTHER TEACHING STAFF TBA DESCRIPTOR This unit of study introduces students to the nature and types of Information Systems and their importance to business processes. The unit provides an introduction to the principles that need to be applied in the development and application of effective Information Systems in business…

Words 2393 - Pages 10