Premium Essay

Bis 155

In:

Submitted By amanpunjab
Words 2755
Pages 12
1. (TCOs 2, 3, 7, 9) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state and wants to consider expanding within the same state. You have been presented with the sales figures for the last three years for each of your locations. Based on this information, you're tasked with analyzing current sales.

You have decided to compare the performance of the three stores to get a better idea of where expansion might be most beneficial. Respond fully to the following questions regarding this task:

A - (TCO 9) The data has been provided to you in one .csv file showing weekly sales for all three stores for the last three years. Explain the tasks you must complete in preparing the data for your analysis. You are going to need to save the file as an excel workbook. A .csv file won’t save any changes or allow for any formula functionality or formatting

B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. Remember that you have only weekly sales totals for each store in the data. I would set up the worksheet so that the first column gives you the dates that the weekly sales are available for. Then, I would have a column for each region.

C - (TCO 3) Explain how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performer (the North store) stand out. At the bottom of the weekly sales, there’s a total for annual sales. I would make sure that the North stood out by placing it next to the first column so that it’s the first column people look at.

D - (TCO 7) Once you have finished the above tasks, your Excel workbook will be placed on your company

Similar Documents

Premium Essay

Bis 155

...Getting Familiar with Excel (graded) | Excel was introduced in 1985. Since then, it has become a standard business tool. In this thread, discuss the different features of Excel that make it a valuable business tool. In addition, discuss why Excel skills are so important in today’s job market. I had taken a class in Excel years ago, but since I haven’t used it in such a long time, I am rather “rusty” at it. Hopefully it will start coming back to me as we progress, because I realize that I have forgotten so much. I do remember that I was both fascinated and excited, getting a glimpse of just some of its possibilities. In the workplace, though the initial set-up may take some time, it would be a tremendous help in the long run, when it was completed, by: * Reducing mathematical errors. * Supplying instant recalculations when inputted amounts needed to be corrected. * Charts and graphs could be easily prepared for those of us that grasp things better visually. * There is a security option if you want to make certain that it isn’t tampered with. * You can allow others to mark-up suggested changes; with you still having the final say. * With its reusability, the formulas are already prepared; ready for the following year’s numbers to simply be plugged in. A few of its benefits for small businesses were listed by Kathy Burns-Millyard, in her article, “How Do Businesses Use Excel?”: * Scheduling:  This is helpful when a department is allotted a certain...

Words: 428 - Pages: 2

Free Essay

Lab 6 Bis 155

...1. Judy Baca has combined art with community activism for thirty years. She is credited for the great work of art called the Great Wall of Los Angeles that has taken place over the years, in which it is consider the largest painting standing 14 feet tall and stretches for half a mile long. She had the help of many young troubled youth each separated into multi-ethnic groups to work together on the painting. By her letting them help with the painting she was offering them much needed work skills. The chance to create this piece was offered to Baca in 1974 by the Army Corps of Engineers in an effort to make flood control channel look better. To create such a large project this has required much support and assistance. The greatest support has come from government agencies, foundations, and corporations. Juvenile Justice funding was the largest funding for the project from the beginning since it was helping the juveniles. The way the process works for each section of the Mural is that supervisors will be hired to interview and recruit youth from ages 14 to 21. It takes a whole year to organize, research, and complete a section. The social implications to create this mural require a great deal of support and tolerance to work with different ethnic backgrounds. The economic implications require money to be raised to pay for the hiring the supervisors, artists, teachers, and the youth who will execute the painting. The economic requirement has been achieved through the years by fundraisers...

Words: 487 - Pages: 2

Free Essay

Bis 155 Course Project

...Category Name Last Name First Name Country Order Date Product Unit Purchase Price Quantity Discount Level Dairy Products Buchanan Steven France 1-Aug-04 Mozzarella di Giovanni $34.80 5 0% Dairy Products Buchanan Steven France 1-Aug-04 Queso Cabrales $14.00 12 0% Grains/Cereals Buchanan Steven France 1-Aug-04 Singaporean Hokkien Fried Mee $9.80 10 0% Produce Suyama Michael Germany 2-Aug-04 Manjimup Dried Apples $42.40 40 0% Produce Suyama Michael Germany 2-Aug-04 Tofu $18.60 9 0% Grains/Cereals Leverling Janet France 5-Aug-04 Gustaf's Kn?ckebr?d $16.80 6 5% Seafood Peacock Margaret Brazil 5-Aug-04 Jack's New England Clam Chowder $7.70 10 0% Condiments Leverling Janet France 5-Aug-04 Louisiana Fiery Hot Pepper Sauce $16.80 20 0% Condiments Peacock Margaret Brazil 5-Aug-04 Louisiana Fiery Hot Pepper Sauce $16.80 15 15% Produce Peacock Margaret Brazil 5-Aug-04 Manjimup Dried Apples $42.40 35 15% Grains/Cereals Leverling Janet France 5-Aug-04 Ravioli Angelo $15.60 15 5% Dairy Products Peacock Margaret Belgium 6-Aug-04 Camembert Pierrot $27.20 40 0% Dairy Products Peacock Margaret Belgium 6-Aug-04 Geitost $2.00 25 5% Confections Peacock Margaret Belgium 6-Aug-04 Sir Rodney's Marmalade $64.80 40 5% Beverages Leverling Janet Brazil 7-Aug-04 Chartreuse verte $14.40 42 0% Dairy Products Leverling Janet Brazil 7-Aug-04 Gorgonzola Telino $10.00 20 0% Confections Leverling Janet Brazil 7-Aug-04 Maxilaku $16.00 40 0% Beverages Buchanan Steven Switzerland...

Words: 29813 - Pages: 120

Premium Essay

Bis 155 Week 7 Ilab

...BIS 155 WEEK 7 ILAB TO purchase this tutorial visit following link: http://wiseamerican.us/product/bis-155-week-7-ilab/ Contact us at: SUPPORT@WISEAMERICAN.US Week 7 iLab BIS 155 Scenario/Summary Hopefully you will find this week’s iLab activity fun and useful. We’ll be exploring the world of statistics from a business perspective this week, allowing you to practice your skills with descriptive statistics, formatting, graphs, and regression analysis. As discussed in the lesson, the value of statistics lies in the ability to analyze data more effectively for the purpose of improving decision making. You might have heard the expression that “statistics never lie, and only liars use statistics”. There is an obvious truth in this statement, in that, depending on the questions being asked and the data collected, the statistics can skew reality. For example, it is true that as ice cream sales increase, accidents at swimming pools increase. Does this mean that the more ice cream that is sold, the more accidents it causes (correlation/causation)? Of course not, but the data, if not interpreted correctly, could lead to false conclusions. It just so happens that both are correlated to a rise in temperature in the summertime. The hotter it is outside, the more kids flock to swimming pools, leading to more accidents, and the more ice cream is sold. So you see, although statistics are vital in the world of decision making, you have to be wise, and ask the right questions. Software...

Words: 1748 - Pages: 7

Free Essay

International Business

... CONTENTS Solving the problem * The consultation process * Research proposal * Preliminary scope * Human resources * Financial resources * Physical resources * External research assistance * Research location * Methods used for research * Sample size * Budget * Time frame * Client interview * Research plan * Objectives * Scope * Research methods * Type of data * Sources of data * Data gathering methods * Sampling * Processing methods * Feasibility Introduction: Coles Supermarkets is an Australian supermarket chain owned by Wesfarmers. It has 741 stores nationally, including 45 BI-LO Supermarkets that also stock Coles private label brands, and more than 100,000 employees. Coles was founded by George James (G.J.) Coles when what was called the "Coles Variety Store" opened on 9 April 1914 in Smith Street in the Melbourne suburb of Collingwood. Expansion to more stores occurred and the chain was regarded as leaders in providing value to Australian shoppers (G. J. Coles learned the retail trade working for his father's "Coles Store" business at Wilmot, Tasmania between 1910 and 1913). Coles' interest in food retailing was spurred in 1958 when it acquired 54 John Connell Dickins grocery stores. It then acquired the Beilby's chain in South Australia in 1959 and 265 Matthews Thompson grocery stores in New South Wales in...

Words: 2028 - Pages: 9

Free Essay

Coles

...Responsible sourcing ............................................................10 Australia first ............................................................................ 12 Our sustainability ................................................................... 13 Our community ....................................................................... 14 Our 3 year performance summary ..................................17 Cover image: supplier to Coles for over 20 years, apple grower Harvey Giblett of Newton Brothers Orchards, located in Manjimup, Western Australia. About us Coles is a leading national food, liquor and convenience retailer in Australia. We employ more than 102,000 team members across our brands, which include Coles and Bi-Lo supermarkets, Coles Express, 1st Choice Liquor Superstore, Liquorland, Vintage Cellars and Spirit Hotels. Our goal What we want to achieve “To give the people of Australia a shop they trust, delivering quality, service and value.” Our values What we believe in Our customers come first – always! We support each other to get things done. Our circle for success Our ways of working Our six point plan to deliver our goal How we work together Lead effectively Act collectively Support consistently...

Words: 5776 - Pages: 24

Free Essay

Bis 155 Complete Course (Dqs - Quizes - Labs & Course Project) Devry

...BIS 155 Complete Course, BIS 155 Complete Class, BIS 155 Entire Course, BIS 155 Entire Class, Strayer BIS 155 , BIS 155 LAW , BIS 155 All Assignments, BIS 155 All Dqs, BIS 155 ExerCises, BIS 155 Final, BIS 155 Week 1, BIS 155 Week 2, BIS 155 Week 3, BIS 155 Week 4, BIS 155 Week 5, BIS 155 Week 1-5, BIS 155 mcqs, BIS 155 , BIS 155 DeVry, BOSP 434 Complete Course, BOSP 434 Complete Class, BOSP 434 Entire Course, BOSP 434 Entire Class, Strayer BOSP 434 , BOSP/434 , BOSP 434 All Assignments, BOSP 434 All Dqs, BOSP 434 ExerCises, BOSP 434 Final, BOSP 434 Week 1, BOSP 434 Week 2, BOSP 434 Week 3, BOSP 434 Week 4, BOSP 434 Week 5, BOSP 434 Week 1-5, BOSP 434 mcqs, BOSP 434 , BOSP 434 DeVry, BUS 100 Complete Course, BUS 100 Complete Class, BUS 100 Entire Course, BUS 100 Entire Class, BUS 100 , BUS 100 New Course, BUS 100 All Assignments, BUS 100 All Dqs, BUS 100 ExerCises, BUS 100 Final, BUS 100 Week 1, BUS 100 Week 2, BUS 100 Week 3, BUS 100 Week 4, BUS 100 Week 5, BUS 100 Week 1-5, BUS 100 , BUS 100 , BUS 100 Strayer, BUS 475 Complete Course, BUS 475 Complete Class, BUS 475 Entire Course BUS 475 Entire Class, Strayer BUS 475 , BUS 475 New Course, BUS 475 All Assignments, BUS 475 All Dqs, BUS 475 ExerCises, BUS 475 Final, BUS 475 Week 1, BUS 475 Week 2, BUS 475 Week 3, BUS 475 Week 4, BUS 475 Week 5, BUS 475 Week 1-5, BUS 475 mcqs, BUS 475 , BUS 475 Strayer, BUSN 319...

Words: 1473 - Pages: 6

Premium Essay

Marketing

...Looking Beyond The Boundaries – A strategy to gain competitive advantage for the Coles Group of Australia By Aruna Kulatunga MGG9352 Management Processes and Systems. Semester 1, 2007 Looking Beyond The Boundaries – A strategy to gain competitive advantage for Coles Group Executive Summary The Coles Group of Australia has allowed its competitive advantage to slip away to rival Woolworth by failing to differentiate its core strategies and by failing to articulate well the strategies that could have been differentiated. In a bid to gain competitive advantage, this report suggests that the Coles Group should look beyond the company boundaries, extending its value chain to suppliers, partners and customers in a seamless manner, employ process like Total Quality Management and Business Process Reengineering in extending the value chain, bedded in a well structured change management programme and look towards globalisation and franchising along with such counter-intuitive, yet innovative, location strategies such as competitive clustering and saturation marketing to regain its competitive advantage. Page 2 23/10/07 Looking Beyond The Boundaries – A strategy to gain competitive advantage for Coles Group Introduction Strategy gurus Porter (1998, p. 2), Mintzberg (1994), Hamel (1998), Hamel and Prahalad, (1994) Champy and Nohria (1996) and Hammer (quoted in Champy and Nohria, (1996)) agree in principle that in order to meet business needs, specific actions need to be...

Words: 4601 - Pages: 19

Free Essay

Cole

...Analysis of the grocery industry Coles Supermarkets Australia October 2012 Analysis of the grocery industry Contents Glossary ..................................................................................................................................... i Executive Summary.................................................................................................................. iii 1 Introduction .................................................................................................................... 1 1.1 1.2 Project approach and objectives........................................................................................ 1 Report structure ............................................................................................................... 2 2 3 Coles – an overview ........................................................................................................ 3 Economic contribution of Coles ....................................................................................... 5 3.1 3.2 3.3 3.4 3.5 3.6 3.7 Modelling approach .......................................................................................................... 5 Direct economic contribution ............................................................................................ 6 Indirect economic contribution ......................................................................................... 6 Total economic contribution .......

Words: 19655 - Pages: 79

Free Essay

About Schoolworkyard

...Wiliam Gajski Ja idem na biologiju about an hour ago via mobile · Like Luka Lapanja iz cega ces ucit? jel imas nekakve knjige, skripte ili neki k pa da mogu fotokopirat about an hour ago via mobile · Like Wiliam Gajski Imam skripte kaj mi je dala od zene neka frendica kaj ide na pripreme iz bio.. briem da ima oko 130 str about an hour ago via mobile · Like · 1 Luka Lapanja Aj jel moš to donijet u školu, pa da si fotokopiram to 4 minutes ago · Like Wiliam Gajski moram pogledat dal mi opce doma il kod zene about a minute ago via mobile · Like Luka Lapanja dobro, samo molim te ako možeš to dofurat ovih dana a few seconds ago · Like Luka Lapanja pa ti ja slijedeći vratim a few seconds ago · Like Options OLDER POSTS Diana Dee Dee Jašarević jel ko napiso eng??? koja tema je najlaksa ( makar meni nijedna nije xd ) Like · · Follow Post · 5 hours ago Seen by 15 View all 9 comments Dominik Cvijanović Eee paa sad 4 hours ago · Like Diana Dee Dee Jašarević joj joj ... sto reci 4 hours ago · Like Options Antonija Gabrić jel gledala potacek izostanke? Like · · Follow Post · 8 hours ago Seen by 16 Luka Lapanja and Diana Dee Dee Jašarević like this. View all 15 comments Diana Dee Dee Jašarević kurvaa 7 hours ago via mobile · Like Antonija Gabrić 7 hours ago · Like Options Dominik Cvijanović Laura Šeremet nam je u vezi sa Biciklom tj sad je sa Motorkom hahahahahhahaha eee ako ona moze nac decka onda svatko moze hahahahaha ...

Words: 15156 - Pages: 61

Free Essay

Bshs 441 Complete Class

...BSHS 441 COMPLETE CLASS To purchase this Click here: http://www.activitymode.com/product/bshs-441-complete-class/ Contact us at: SUPPORT@ACTIVITYMODE.COM BSHS 441 COMPLETE CLASS BSHS 441 Week 1 Individual Assignment Paper on a Specific Population and the Advocate Role BSHS 441 Week 1 DQ 1 BSHS 441 Week 1 DQ 2 BSHS 441 Week 2 Individual Assignment Literature Review of Mediation and Advocacy BSHS 441 Week 2 Team Assignment Interview of a Social Service Agency Using Advocates BSHS 441 Week 2 DQ 1 BSHS 441 Week 2 DQ 2 BSHS 441 Week 3 Individual Assignment Paper on the Challenges of Being an Advocate and Neutral Facilitator (Mediator) BSHS 441 Week 3 Team Assignment Interview of a Social Service Agency on Their Use of Mediation BSHS 441 Week 3 DQ 1 BSHS 441 Week 3 DQ 2 BSHS 441 Week 4 Individual Assignment Paper Based on Literature Review BSHS 441 week 4 Team Assignment Interview With a Social Services Lobbyist BSHS 441 Week 4 DQ 1 BSHS 441 Week 4 DQ 2 BSHS 441 Week 5 Individual Quiz BSHS 441 Week 5 Team Assignment Presentation on the Use of Mediation within an Agency Setting BSHS 441 Week 5 DQ 1 BSHS 441 Week 5 DQ 2 Activity mode aims to provide quality study notes and tutorials to the students of BSHS 441 COMPLETE COURSE in order to ace their studies. Activity mode, BSHS 441 COMPLETE COURSE, Home Work Tutorials, Home Work Solutions, Home Work Essay, Home Work Questions.ACC 565 Wk 7 Assignment 3, ACC403 week 2 assignment, ACC565 Week 10, ACCT 212 (Financial...

Words: 1003 - Pages: 5

Free Essay

Bshs 441 Entire Course

...BSHS 441 ENTIRE COURSE To purchase this Click here: HTTP://WWW.ACTIVITYMODE.COM/PRODUCT/BSHS-441-ENTIRE-COURSE/ Contact us at: SUPPORT@ACTIVITYMODE.COM BSHS 441 ENTIRE COURSE BSHS 441 Week 1 Individual Assignment Paper on a Specific Population and the Advocate Role BSHS 441 Week 1 DQ 1 BSHS 441 Week 1 DQ 2 BSHS 441 Week 2 Individual Assignment Literature Review of Mediation and Advocacy BSHS 441 Week 2 Team Assignment Interview of a Social Service Agency Using Advocates BSHS 441 Week 2 DQ 1 BSHS 441 Week 2 DQ 2 BSHS 441 Week 3 Individual Assignment Paper on the Challenges of Being an Advocate and Neutral Facilitator (Mediator) BSHS 441 Week 3 Team Assignment Interview of a Social Service Agency on Their Use of Mediation BSHS 441 Week 3 DQ 1 BSHS 441 Week 3 DQ 2 BSHS 441 Week 4 Individual Assignment Paper Based on Literature Review BSHS 441 week 4 Team Assignment Interview With a Social Services Lobbyist BSHS 441 Week 4 DQ 1 BSHS 441 Week 4 DQ 2 BSHS 441 Week 5 Individual Quiz BSHS 441 Week 5 Team Assignment Presentation on the Use of Mediation within an Agency Setting BSHS 441 Week 5 DQ 1 BSHS 441 Week 5 DQ 2 Activity mode aims to provide quality study notes and tutorials to the students of BSHS 441 ENTIRE COURSE in order to ace their studies. Activity mode, BSHS 441 ENTIRE COURSE, Home Work Tutorials, Home Work Solutions, Home Work Essay, Home Work Questions.ACC 565 Wk 7 Assignment 3, ACC403 week 2 assignment, ACC565 Week 10, ACCT 212 (Financial...

Words: 1003 - Pages: 5

Premium Essay

Ldr 531 Week 3 Individual Leadership Style

...LDR 531 WEEK 3 INDIVIDUAL LEADERSHIP STYLE To purchase this visit here: http://www.activitymode.com/product/ldr-531-week-3-individual-leadership-style/ Contact us at: SUPPORT@ACTIVITYMODE.COM LDR 531 WEEK 3 INDIVIDUAL LEADERSHIP STYLE The paper has two parts. 1. Select and describe a leader you admire. Your selected leader may be either a real-life individual or a fictional character from television, the movies, or a book. Using leadership theories, analyze your selected leader to identify characteristics and provide specific examples of leadership qualities you think contributed to that person's success. 2. Evaluate your own leadership style and identify your own leadership characteristics in the same way ALONG with a plan to improve upon your leadership - which could include things likeundertaking specific training, joining professional association, seeking out situations at work or as a volunteer to develop your abilities.  1500 words  Format your paper consistent with APA guidelines  Evaluate your chosen leader and yourself, based on the leadership theories.  This is a graduate program paper. Use the texts and course readings to analyze/discuss leadership style and characteristics. The texts have specific theories and models of leadership style. How does the style of your selected leader compare to such models? How do you compare to such models?  Use two peer reviewed journal article in your discussion. There is a list of suggest journals in a posting...

Words: 1139 - Pages: 5

Premium Essay

Law 531 Week 6 Presentation

...LAW 531 WEEK 6 PRESENTATION To purchase this visit here: http://www.activitymode.com/product/law-531-week-6-presentation/ Contact us at: SUPPORT@ACTIVITYMODE.COM LAW 531 WEEK 6 PRESENTATION Prepare a Powerpoint presentation of no more than 15 minutes. In week 5, I will assign teams a set or multiple sets (depending on the number of teams) the Question #(s) to answer. Your presentation should explain to the class the answers to the following questions: Question 1: Explain the term of office for board of directors. Give an account of the director’s and corporate officer’s duty of care towards the corporation. Explain Self-dealing. And finally, What is the CEO and CFO provision laid out by the Sarbanes-Oxley Act of 2002? Question 2: Distinguish between general government regulation and specific government regulation. Explain in brief the types of federal administrative agencies with examples. Distinguish between substantive rules and interpretive rules. What is a statement of policy? When are searches by administrative agencies considered reasonable? And finally, How is the general public protected from harassment by administrative agencies? Question 3: What is the United Nation’s Biosafety Protocol for genetically altered food? Give an account of the regulation of medicinal devices in the United States? What are the powers of the Consumer Product Safety Commission? Name some consumer products excluded from the purview of CPSC. Question 4: Describe the purpose and...

Words: 1261 - Pages: 6

Free Essay

Leg 505 Assignment 5

...LEG 505 ASSIGNMENT 5 To purchase this visit here: http://www.activitymode.com/product/leg-505-assignment-5/ Contact us at: SUPPORT@ACTIVITYMODE.COM LEG 505 ASSIGNMENT 5 LEG 505 Assignment 5 - Recommendations to Manage Common Compliance Issues A guide to best practices for contract administration•Refer the following resources to complete this assignment: (http://www.acquisition.gov/bestpractices/bestpcont.html) As the Contract Officer, you know it is time to assemble a team to manage compliance of the contract. Create a PowerPoint presentation based on the scenario you created to bring the team you have assembled up-to-date on what has occurred thus far. Prepare a twelve to twenty (12-20) slide PowerPoint presentation with speaker notes in which you: Analyze the importance of roles and responsibilities of contracting officers and administrators. Identify the various options of administrative and judicial processes available and select the appropriate process to resolve the dispute. Analyze the importance of improving methods of creating contract schedules and using a compliance matrix in government contract situations. Present ideas for brainstorming with your team in order to develop a policy that explains the role the Contract Officer should have played in the dealings between the government and the contractor, from the time the contract was awarded through completion of the work. Recommend three (3) best practices (one [1] from each section...

Words: 1265 - Pages: 6