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

APA FORMAT at least 750 WORDS 3 pages Martha Ballard’s

APA FORMAT at least 750 WORDS 3 pages Martha Ballard’s diary provides an intriguing look into the lives of women in late eighteenth and early twentieth century Maine.  That it exists at all is rarity.  Martha Ballard’s life was both unique and ordinary and the pages of her diary reveal

For this Discussion, you will use data to develop a

For this Discussion, you will use data to develop a specialization-specific scenario representing a need for change in your educational or community setting. (BASED ON Early Childhood Education) Note: You will develop the scenario in this Discussion for your colleagues to respond to and address the scenario from your perspective

Book Critique (The Lost Boy by Dave Pelzer)

As you read your selected book, identify the social policy(ies) that plays a role in the lives of the book’s character(s). Consider if the policy or policies are at the local, state, or federal level, and how the historical time in which the book is set impacts the policy issues.

Address the four questions associated with the chapter 11 Self-Assessment:

  Address the four questions associated with the chapter 11 Self-Assessment: Personality, Leadership, and Change on page 418 in a three to five page paper (excluding title, abstract, and reference pages). Include online references to support your assignment, presented in 7th edition APA compliance. Please use this strategy when you

Journal Article Analysis: PTSD and Gray Matter Reduction Experiencing traumatic

Journal Article Analysis: PTSD and Gray Matter Reduction             Experiencing traumatic events often is life-changing for the experiencer. For some, that traumatic event can cause severe neurological changes, negatively impacting the functioning and well-being of the individual. In the anxiety disorder known as posttraumatic stress disorder (PTSD) symptoms are mainly

Concept Map Template Primary Diagnosis: ___________________________________________________________ 1. Describe the pathophysiology of the

Concept Map Template Primary Diagnosis: ___________________________________________________________ 1. Describe the pathophysiology of the primary diagnosis in your own words. What are the patient’s risk factors for this diagnosis? Pathophysiology of Primary Diagnosis Causes Risk Factors (genetic/ethnic/physical) 2. What are the patient’s signs and symptoms for this diagnosis? How does the diagnosis

5-7 slides Analyze the effectiveness of your organization’s training and

5-7 slides Analyze the effectiveness of your organization’s training and development process. Prepare a PowerPoint presentation that addresses the following: Explain the training needs analysis approach that your organization uses to define training needs.  Describe the process for capturing needs for individuals, groups, and the wider skills for the organization. 

Please answer each question separately Q1 What cognitive and social

Please answer each question separately Q1 What cognitive      and social factors contribute to high-risk sexual behavior in some      adolescents? Some schools      teach outdated sex education programs. Explain why these programs are      still implemented, regardless of research. Q2 1. Discuss the law enforcement hiring process.  2. Explain what the minimum standards

NYU Autoimmune Disease of Myelin Abstract Nursing Assignment Help

`The disease is called MS You should read Wikipedia “Immune System”, “Antibody”,  “Antigen”, “T  cell”, “B cell”, “Macrophage”, “Dendritic cell”  for writing your abstract. It would also be good to read the Wikipedia article on MS.  The purpose of writing an abstract is to condense the material you have read

We are living in a data-rich world where consumers have

 We are living in a data-rich world where  consumers have fast and efficient access to significant quantities of  data to assist in their buying decisions. Prepare an  that  addresses these points related to the changing world of data gathering:  Identify a marketing research problem for a hypothetical company. Discuss how

Locate several (six or more) assessment instruments that you could

  Locate several (six or more) assessment instruments that you could consider using to assess the variables you have selected in your program evaluation design. Be sure to cite and reference each instrument in APA style. Include validity and reliability data for each instrument, and be sure to cite and

You may use the following formats for reflection. one of

You may use the following formats for reflection. one of these formats is to be used: all concepts from the reflection model MUST be utilized: Johns’ Model of Reflection Carper’s Ways of Knowing Sister Roach’s Six C’s of Caring Boud’s Model of Reflection Question: The current worldwide health crisis has

Overview is attached. Instructions: To complete this assignment, write a

Overview is attached. Instructions: To complete this assignment, write a 3–5 page paper in which you address the following items: Evaluate, discuss, and compare whether to purchase the new equipment or overhaul the old equipment. (Hint: For the old machine, the initial investment is the cost of the overhaul. For