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

The Competitive Profile Matrix (CPM) reveals how a focal firm

The Competitive Profile Matrix (CPM) reveals how a focal firm compares to major competitors across a range of key factors. This comparative analysis provides important strategic information regarding a firm’s competitive advantages or disadvantages in a given industry. In determining what factors to include in a CPM, tailor the factors

Short Paper Two Write a paper about race and how

  Short Paper Two Write a paper about race and how American films represent them using the course resources and addressing the questions below.  The paper should be 2-3 pages, double space, 11-12 point font.  Title pages, graphs, pictures and the “Films Mentioned” section will not count toward the length

Assignment Details Promotion and Pricing The following Course Outcomes are

   Assignment Details Promotion and Pricing The following Course Outcomes are assessed in this assignment: MT219-5: Apply promotion and price Marketing Mix elements to a product or service. GEL-1.03: Demonstrate college-level communication through the oral delivery of original materials in Standard English.  PC-2.3: Demonstrate integrity through the application of relevant

Scenario You work for Patagonia as VP of Operations and

Scenario You work for Patagonia as VP of Operations and your company has been nominated for the Citizens Award from the US Chamber of Commerce Foundation. Each nominee is to present its company’s Corporate Social Responsibility (CSR) and Sustainability initiatives at the Citizens Award Gala in Washington D.C. You will

How do you incorporate diverse languages and cultures? When the

How do you incorporate diverse languages and cultures?  When the child leaves the program to go to elementary school what does the philosophy say the child will be able to do?  What are the outcomes of your program?   Reggio Emilia Education: https://www.youtube.com/watch?v=7n2hCebmT4c History and Philosophy of the Reggio Emilia

Criminology and karl Marx

Consider the following to be one version of a Marxist explanation of the contents of the criminal law. The criminal law is made by the ruling class – the class that controls the important material and ideological resources in a society – in its own interests. How do you assess

What happens to the nurse when role stress or strain

What happens to the nurse when role stress or strain becomes too overwhelming? What happens to patient care? How is this related to possible ethic and legal issues? Discuss how nurses can manage or reduce role stress and role strain. Explain two issues that lead to nurse burnout and discuss

Due by Thursday (20 pts) As a compliance analyst, you may review several cases from your hospital to determine if consent was appropriately obtained. Write a response to one (or all if you wish) for Nursing Assignment Help

Due by Thursday (20 pts)  As a compliance analyst, you may review several cases from your hospital to determine if consent was appropriately obtained. Write a response to one (or all if you wish) for the following discussion questions: DQ 1. Compare implied consent and informed consent in the health care setting. DQ 2.

If you were an executive manager in an organization, how

 If you were an executive manager in an organization, how would you structure the organization for quality improvement?  Explain why it is not enough to simply clone the benchmarking partner’s process? Shewhart describes two kinds of variation, that resulting from common causes and that resulting from special causes. Define both.

So, when we look closely at the topic of IT

    So, when we look closely at the topic of IT and the global manager, Cash et al. (1988) advise that misalignment of information technology with global business strategy can severely hamper a firm’s efforts to seek global pre-eminence.  However, for the same reason, a good example would be

The purpose of this assignment is to evaluate an organization

The purpose of this assignment is to evaluate an organization and data for efficiency issues and apply process improvement methods and tools to identify and present the problem. You will evaluate a process within an organization or use case study information that will be provided (for those who are not

For the Section 4 Discussion Board, I would like you

For the Section 4 Discussion Board, I would like you to go back to the pdf on Theme in the Section 1 folder.  After you have reacquainted yourself with the terminology discussed there, I would like you to select THREE of the stories from the readings in this section and

For the attached data, find the multiple linear regression formula

For the attached data, find the multiple linear regression formula using X1 as the dependent variable and X2-X7 as the independent variables. Using whatever means necessary find the model of best fit and justify your choices. Determine what variables are significant at a sig. level of 10%.   State what independent

Discussion 1 , present a case that argues for whether

Discussion 1 , present a case that argues for whether or not there is a difference between a nonprofit and a for-profit organization. Support your case with one source. Discussion 2 Many leaders in the nonprofit sector state there are very few differences between how a nonprofit institution functions and