Foundations of Information Systems Business 2400 D E & F – Winter

Tasks 1 – 5 Using the information available in the Excel file Master Revenue W2019.xlsx and the business template 2Care4U Template.xltx prepare 5 workbooks, one per province – each one with as many sheets as locations in that province: The Ontario.xlsx workbook must include all these sheets The Quebec.xlsx workbook must include all these sheets The New Brunswick.xlsx workbook must include all these sheets The Nova Scotia.xlsx workbook must include all these sheets 2 The PEI.xlsx workbook must include all these sheets Don’t forget to enter your information in the documentation sheet. Subtask – Calculate 2019 KPIs Each location information must be used to calculate the key performance indicators (KPI) for 2019 based on this business rule: The goal is to have a 10% increase in revenue in 2019. To reach it, the company has established three indicators: Low, when revenue reaches 95% of 2018, Medium, when it reaches 2.5% above of 2018 and High, if it reaches the 10% increase.

Subtask – Generate 2018 Revenue Sparline Each location must also include a 2018 Revenue Sparkline in cell B17 – a line sparkline that shows its high and low points. Sparkline example Subtask – Calculate a Provincial Summary including Sparkline and Scatter Plot Once all locations have been created, each Provincial workbook must also include a Summary sheet where all these locations are reconciled. Besides the 2019 KPI and Sparkline, the summary sheet also needs to include a Scatter plot with Straight Lines as depicted below: 3 Scatter Plot example Task 6 – Create the 2Care4U Revenue 2018 workbook Once you have all 5 Provincial workbooks, use the template 2Care4U Template.xltx to generate a Summary for the 5 provinces named: 2Care4U Revenue 2018 – this file will have only two worksheets: The latter summarizes the 2018 revenue for all five Provinces using data available in the five Provincial workbooks. [To be able to do this work you must have all five workbooks open and in the same directory!] 

#Foundations #Information #Systems #Business #amp #Winter

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Read the following scenario and outline the steps that you

Read the following scenario and outline the steps that you take to address the concerns of the hospital in your initial post? Then, respond to at least three (3) of your fellow classmates. You are the newly hired Director of Risk Management for Westview Clinical Center, New York City’s largest

GTR has asked you to advise them on resources available

  GTR has asked you to advise them on resources available to users. Write a 1- to 2-page reference table that lists at least 4 resources available on the AWS website, such as FAQs, videos, whitepapers, tutorials, case studies, etc. The audience for your table will be business users engaged

Selecting the Instructional Setting. Training Media Selection Flowchart. (Best opened

  Selecting the Instructional Setting. Training Media Selection Flowchart. (Best opened in a web browser other than Chrome.) Conduct an Audience Analysis. Please respond to the following: Describe an evaluation type—formative, summative, or confirmative—that you believe would be ideal for your project. Describe the audience and the intended outcome of

Each week, you will be asked to respond to the

  Each week, you will be asked to respond to the prompt or prompts in the discussion forum. Your initial post should be 300 words in length, and, you should respond to two additional posts from your peers.  Retirement Planning Project your Social Security benefits on the organization’s website. Many retirement plans suggest that

1. What do you think of vitamin and mineral supplements? What about

1. What do you think of vitamin and mineral supplements? What about fat burning miracle supplements like carnitine? Do you take any supplements at all? If so, why? Find an article or YouTube on the pros/cons and /or safety/dangers of taking vitamin/mineral supplements and discuss.  2. The debate topic in chapter

APA format Parts 1 and 2 have the same questions,

  APA format   Parts  1 and 2 have the same questions, however, you must answer with references and different writing always addressing them objectively, that is as if you were different students. Similar responses in wording or references will not be accepted. 1) Minimum  6 full pages (No word

The purpose of this assignment is to clearly articulate the

  The purpose of this assignment is to clearly articulate the specific strategies and methods that will be utilized to manage the organizational changes associated with implementing the problem solution you have selected. Review the “Change Management Models Matrix” and other study materials to identify which change model you will

Please respond to the following: According to the textbook, many

Please respond to the following: According to the textbook, many model countries, including the United States, allow juveniles of a certain age to be tried as adults, what are your views about this? Specify the extent to which you believe a juvenile can be rehabilitated after he or she has

The news director for your television station has given you

The news director for your television station has given you an assignment to interview the rising senatorial candidate for your state. This candidate has a vision for a new America and has used this vision heavily on the campaign trail. Using the information from the textbook and resources for this

Nursing Theory Course (Nurse Practitioner)

 Interdisciplinary Philosophies and Theories Read the case of Mrs. MendezPreview the document. As an advanced practice nurse, identify the knowledge base that you draw upon from the biological, human, and social sciences in the care of Mrs. Mendez and her family. Identify key concepts relevant to the case study. Identify

Pan’s Labyrinth – Premium Paper Help

·         Pan’s Labyrinth ·         Wilde’s “The Happy Prince”; ·         Touré’s “Solomon’s Big Day”; ·         Arenas’ “The Glass Tower”; ·         Thurber’s “The Secret Life of Walter Mitty”; ·         Harrar’s “The 5:22”; ·         Bierce’s “An Occurrence at Owl Creek Bridge” Note: I would prefer that you use at least one of the

Critical Reflection on Practice – MI and other Coaching methods

Critically reflect on your practice of applying the learning from this module in your coaching conversations. Assignment 2 should draw on your application in your coaching conversation the models or techniques explored during this module, such as Motivational Interviewing (MI), Neuroscience Coaching. This assignment should be written in a self-reflective

Qualitative Methodology Discussion Nursing Assignment Help

The first step of the evidence-based practice process is to evaluate a nursing practice environment to identify a nursing problem in the clinical area. When a nursing problem is discovered, the nurse researcher develops a clinical guiding question to address that nursing practice problem.  For this assignment, you will create