PROFESSIONAL SKILLS FOR BUSINESS ANALYSIS – Assignment Case Study All questions relate to the…

/in /by

PROFESSIONAL SKILLS FOR BUSINESS ANALYSIS – Assignment Case Study

All questions relate to the following Case Study.

The national health insurance system “Medigood” that pays for patients' visits to family doctors has provided a new category of service that family doctors can be paid a bonus for using. This is for a phone or telehealth medical specialist consultation for a qualifying patient.  To qualify patients need to be any one of:

– over 65

– indigenous

– suffering chronic disease.

A consultation can occur when a family doctor with a patient links up for a consultation with a medical specialist using a telephone or telehealth equipment. Medigood will make a payment to both the family doctor and the specialist.

Currently the family doctor or office administrator needs to identify a qualifying patient and then try to find a suitable medical specialist who is available. The office administrators monitor scheduled appointments to see if there are qualified patients and then try to schedule link with specialists. Patients sometimes do not arrive on time or at all, doctors and specialists are often running late and overall it is too difficult; especially for busy doctors with many other patients waiting to see them.

Medigood has already provided Telehealth equipment to all doctors and specialists but to date very few doctors have taken advantage of this. You should do a search of the Internet to understand Telehealth and how it can be used.

Your friend Lee has come up with a new business idea that she wants to sell to doctors and has asked you for help due to your studies in Business Analysis. Lee proposes to develop a software package that will sit on the doctor's computer alongside any other patient management system (PMS) they may have taking advantage of available interfaces. Lee's software will monitor appointments and when it sees there is a qualifying patient with the doctor, or if a qualifying patient has a scheduled appointment, it will alert the doctor that the patient is eligible for a Telehealth consultation and search for an available medical specialist for an on-line telehealth consultation. Medical specialists are expected to register with the system which will monitor when they are on-line and potentially available for a Telehealth consultation with a patient and their family doctor. When the doctor and the specialist both accept the telehealth consultation, the Telehealth equipment at either end is activated. Once the consultation is completed, the software will process the claim for payment to the insurance for both the family doctor and medical specialist.

Engineering Risk Management – Disaster Plan Analysis Report Objectives: – Identify and analyse risk.

/in /by

Engineering Risk Management – Disaster Plan Analysis Report

Objectives:

– Identify and analyse risk (financial, legal, environmental, HR);
– Create a plan for measuring and monitoring performance;
– Describe the process used to analyse strategic issues;
How the Assessment fits into the subject/course:

The context of the subject is engineering; however the content is applicable across a range of other contexts and is relevant to industry. The assessment focus is on risk management, risk assessment and risk mitigation plans.
Assessment Linkages of Assessment 1 and Assessment 2:
Assessment is used to inform and build knowledge for Assessment 2 allowing students to examine concepts and in detail throughout the delivery of the subject.

Part 1

Students are to submit a disaster plan analysis report comprising of 1500 words focusing on the principles of risk management. Students are encouraged to utilise a range of resources in the report including relevant multi-media where appropriate, graphs, charts, etc. Ensure an evidence based approach is taken into the analysis drawing on theoretical frameworks from the research and literature, and from recent news accounts of the disaster.

Criteria
– Identification and analysis of risk (financial, legal, environmental, HR)
– Plan for measuring and monitoring performance
– Clear description of the process used to analyse strategic issues
– Understanding of research principles and methods applicable to MBA
– High level of personal autonomy and accountability

Learning Outcomes

– Critically examine key issues which have a significant impact on risks associated with engineering activities including safety and environmental management systems.
– Effectively employ identification and risk management tools to propose and analyse realistic risk scenarios and develop risk management strategies.
– Critically analyse the usefulness, applicability and limitations of risk assessment as a decision-making tool.
– Critically analyse risk perception and risk communication and effectively develop risk communication plans and skills.

Assessment – Case Study Report Learning Outcomes a) Describe and evaluate the objectives, aims and..

/in /by

Assessment – Case Study Report

Learning Outcomes a) Describe and evaluate the objectives, aims and the primary aspects of a strategic plan whilst taking into account the vision and mission of the organisation.
b) Discuss and evaluate the processes and forces that influence the strategic decision-making process in relation to business strategy.
c) Explain the significance of strategy as a means of identifying and realising opportunities for growth.
d) Analyse the managerial, planning and procedural tasks associated with implementing and executing organisational strategies and identify the key risks associated with this process.
e) Prepare and justify a strategic plan.
f) Demonstrate an ability to think strategically about an organisation, its position in the marketplace and how it can gain a sustainable competitive advantage.

Context:

You are a strategic analyst for a management consulting firm that specialises in the analysis of Australian organisations. Your task is to write a report based on a case study of an Australian corporation. You are to use the framework models of strategic management, in order to evaluate the environment the organisation operates within and its mission goals and strategic choices. Additionally, you will provide some recommendations that both support and critique the strategic direction the organisation has chosen to pursue.

Instructions:

This assessment requires that you write a report on one of the following organisations:

Telstra

Over the past few years, Telstra, Australia's largest provider of telecommunications services, has faced increasing competition from domestic and overseas providers. Rapid changes in technology, consumer behaviour, and the introduction of the NBN (National Broadband Network) have become a catalyst for the organisation to change its approach to both customer service and product innovation. Pressure to deliver returns to shareholders are ever-increasing; formulating and delivering a successful strategy is critical

Westpac

The Australian banking environment is dominated by a small number of large banks. In the last few years, the banking industry has come under increasing pressure from the government and public, due to the high levels of profit that they report. This has culminated in a government investigation into the industry which is currently underway. Westpac has an innovative strategy which embraces digital technology and a dedicated focus on customer service. Westpac has also led the industry in community banking and sustainability initiatives.

Woolworths Group

Woolworths Group is a large integrated provider of retail and leisure. Best known for their supermarket operations, they have faced strong competition over the last few years from the Australian incumbent, Coles, as well as new overseas entrants such as Aldi and Costco. Woolworths has recently had a change in chief executive officer (CEO), following a profit downgrade and a failed attempt at entering the DIY retail business with their Masters Home Improvement stores. They are facing increased pressure on profit margins and their strategic direction.

To prepare for this assessment, the following steps are advised:

Step 1 – Read the subject materials for modules 1 to 4 (weeks 1 to 8).
Step 2 – Decide which of the three organisations you will choose as the case study for your report by reading the relevant parts of their websites, annual reports and other media sources.
Step 3 – Undertake additional research on the organisation you choose as well as source- relevant journal articles that will help you in writing your report.

A suggested structure for your report is as follows:

Executive Summary (150 words)

Table of contents (not included in word count)

1. Introduction (100 words)
2. Evaluating the organisation's environment (550 words)
a. External – use Porter and the most relevant 2 elements of PESTEL, (not required to use each one).
b. Internal – use core competencies and value chain analysis.
3. Analysis of competitive advantage (200 words)
a. Discuss competitive rivalry
4. Strategy formulation and choice (550 words)
a. Vision
b. Goals
c. Initiatives – cost leadership vs differentiation
5. Recommendations and conclusions (450 words – write this section in ‘first' person)
a. With rationale for support of strategy
b. With rationale for critique of strategy Reference List (not included in word count) Appendices (not included in word count)
Please note the following additional information:

You should adhere to the correct use of academic writing, presentation and grammar. You should write the report in the third person apart from the recommendations section which you should write in the first person.
You are advised to include a minimum of 7 academic references which should be textbooks or journals. Appropriate websites may be used in addition to these.
It is important to check your similarity in Turnitin. All highlighted sentences must be either paraphrased in your own words or put in quotes and referenced accordingly. You should be aiming for as low a similarity score as you can. Similarities highlighted in a contents page, reference list or appendices is nothing to be concerned about.
It is important to adopt the appropriate use of the APA 6th edition style when citing and referencing research. Please comply with all academic standards of legibility, referencing and bibliographical details (including reference list).

The Assignment Task The assignment task relates to the Sage business case: Super Seats Ltd. case…

/in /by

The Assignment Task

The assignment task relates to the Sage business case: Super Seats Ltd. case study

(http://sk.sagepub.com.ezproxy.northampton.ac.uk/cases/super-seats-co)

Produce a professional business report critically analysing the organisational context and providing strategic HR recommendations. Your report should include:

1. An executive summary

2. An introduction to the report

3. An external environmental analysis of the case study organisation using a recognized analytic framework (e.g. STEEPLE, Porters’ Five Forces).

4. An analysis of the internal strengths and weaknesses of the case study organisation using a recognised analytic framework (e.g. SWOT) with particular attention to management and employment issues.

5. A conclusion bringing together the overall findings from your analyses and assessing the implications / consequences of your findings.

6. A recommended HR strategy that will respond to the issues / challenges you have identified. Your recommendations should be based on your conclusions, justified and have consideration for cost, resource and practicality.

7. Reference list

Your assignment should be presented in a business report format.

You must draw upon relevant theory and research to support your work with appropriate academic references using the Harvard Referencing system

Topic: Select one of the following countries and discuss its business customs, culture, political,..

/in /by

Topic:   Select one of the following countries and discuss its business customs, culture, political, legal and economic landscape regarding the sustainable issue.

Countries can include:

Japan, Singapore, China, United States of America, United Kingdom and South Africa

As a consultant, write a recommendation on how a fictitious Australian company can expand into and manage its presence in this location.

Task Details: Students complete a research-based analysis and evaluation on topical sustainability issues. The response needs to be developed into a professionally presented report.

Task – You must answer the two problem-type questions below, using the ILAC (Issues, Law,…

/in /by

Task – You must answer the two problem-type questions below, using the ILAC (Issues, Law, Application, Conclusion) format, a worked example of which is in the Resources folder.

Question 1 – Qantas Airlines Ltd signs a contract with Airbus Corporation Ltd for Airbus to build a new aeroplane. On average, Qantas would make $ 800 000 profit per day from using such an aircraft.

The contract has 545 terms. Term 56 says that the plane must be able to travel 10 000 km at 800 km per hour. Term 455 says that the aircraft must have an in-flight video system capable of showing 36 channels of entertainment to passengers.

After the contract is signed, Airbus sends to Qantas a package containing a large number of documents, including the contract itself and examples of the colour scheme that will be used. In the middle of these documents there is also a new document headed 'Limitation of Liability', the key part of which states as follows:

The liability of Airbus Corporation Ltd for breach of contract is capped at $ 300 000.

When the plane is delivered, its engines are as required, but, due to confusion at the factory, the wrong software has been loaded into the entertainment system, which has only 34 channels. It would take a week to re-configure the software. Advise Qantas Airlines fully as to what its legal position is, citing relevant case law.

Question 2 – Frank runs a shop that sells appliances such as ovens, fridges and freezers. He is a sole trader – his business is not incorporated.  Gemma is employed by Frank as a salesperson. Among the second-hand appliances in the shop is a dishwasher, priced at $ 350. One day Tom, is browsing in the store, sees the dishwasher, and says to Gemma “That's a great price – I will just go home to see if I have space for it”.

Gemma's niece, Frances, is getting married next month. Gemma knows that Frances needs a dishwasher. Gemma quickly phones Frances and says “Get to the store quickly – I think I can get my boss to agree to take $ 300 for a fantastic dishwasher”. Gemma tells Frank that she doesn't think that the dishwasher will ever sell for $ 350, but that a customer might pay $ 300. Frank authorises Gemma to sell the dishwasher for $ 300. Frances comes in and Gemma sells it to her at that price. Later, while Gemma is on her lunch break, Tom comes in to the store. When he inquires about the dishwasher, Frank tells him that it was sold that morning for $ 300. Tom tells Frank that he would gladly have paid     $ 350 for it.

Another salesperson, Bob, has the job of selling large quantities of washing machines to commercial laundries. He has  frequently negotiated with Angela, who owns a chain of laundries, to sell her washing machines. Bob frequently comes to work late and is sometimes drunk. One Friday afternoon, Frank says to Bob “You are fired with immediate effect – clear out your desk and leave”. Frank then rushes off to a meeting across town without making sure that Bob actually leaves the premises.

Bob sends an email to Angela, saying that he has just received ten new industrial washing machines which he can sell to her for $ 1 000 each. Angela agrees, and makes an electronic transfer of $ 10 000 in payment, saying that she will collect the machines on Monday. Bob withdraws the $ 10 000 from the Home Appliance Specialists bank account and disappears overseas with it. When Angela comes to collect the machines on Monday, Frank refuses to give them to her, saying that Bob had no authority to sell them as he had been fired. Angela has sued Frank for delivery of the machines.

Give Frank legal advice in relation to the above situations.

Please check that your assignment complies with the rules in the Style Guide before you hand it in.

Rationale – This assessment will allow you to demonstrate your ability to:

engage in legal research;

identify the legal issues arising out of novel factual situations, to analyse the applicable law and to differentiate between which rules are applicable and which are not and then apply the law to the problem;

to explain and summarise the applicable law in such a way as to create a report for a client which states what liabilities arise from novel factual situations

And more specifically:

your knowledge of the law of contract

your knowledge of the law of agency

your ability to undertake an assessment task relevant to the workplace and professional practice.

Analysing the Impact of Digital Business Assessment – Moral Dilemma Analysis Report Learning Outcome

/in /by

Analysing the Impact of Digital Business Assessment – Moral Dilemma Analysis Report

Learning Outcome –

Justify resolutions to ethical dilemmas faced by IS professionals resulting from competing personal, organisational and client interests using ethical theories and frameworks.

Present convincing resolutions to ethical dilemmas in written form, and self-evaluations in written and oral form.

Description / Requirements

This is an individual assignment where you will research and then produce a written Moral Dilemma Analysis report using the Ethical Decision-Making Framework introduced in topics 3 and 4. The moral dilemma is as follows: Is it moral to expect professional workers to work beyond the hours they are paid?

For this moral dilemma, assume a company meets its service deadlines by assuming workers will work beyond their 8 hour paid shift.  The staff are well aware of this expectation and are working unpaid overtime in order to keep their jobs. You are a new manager overseeing the organisation and have just learnt of this practice becoming part of the company culture.  It appears the CEO is well aware of this expectation as well.

While the case above relates to professional staff, you may investigate the morality of this issue for any type of professional or non-professional staff working in any industry.

Research work for the Moral Dilemma Analysis report

It is essential that you do not decide whether the above dilemma is moral or not until after you have conducted research. The report is not about your personal views about the dilemma. Instead, you will investigate and argue whether this practice is moral based only on research evidence/facts.

More specifically, the research you undertake should enable you to determine the answers to all the questions (directly or indirectly) in the Ethical Decision-Making Framework in relation to a range of stakeholders. You will then come to your conclusion after this investigation.

The research sources you must find and cite in the body of your report will be credible academic resources (e.g. journal articles, PhD theses, conference papers, credible research studies). Identify articles in particular which report empirical research (e.g. experiments, surveys, case studies, interviews) relating to the moral dilemma (not opinions of researchers) in terms of how it might affect one or more of the following types of stakeholders (see topic 3):

The organisation selling products/services

Individual staff

The organisation's business clients

The public

The industry / profession

You must ensure that your research and analysis of this dilemma is balanced. It is typical for people and organisations to focus on their own self-interest (e.g. revenue, profits), and justify the impact on other stakeholders (e.g. clients, the public, staff). This is not a balanced approach. Your research and analysis should instead include all potential negative implications (based on the ethical decision-making framework) for the various stakeholder groups. As required by the ACS Code of Professional Conduct, the most important stakeholder group is “the public”, not the organisation, not the staff, etc. The public does not necessarily benefit when organisations make a profit!

For this reason, a report focusing mainly on the organisation manufacturing the product/providing a service and/or the individual staff will not receive a good result in this assignment. You are only required to consider the stakeholder types listed above, and no other stakeholder types are required.

Business Information Systems Assignment 1. Aims: To analyse a set of data (in Microsoft Excel), and.

/in /by

Business Information Systems Assignment

1. Aims:

To analyse a set of data (in Microsoft Excel), and write a brief report (in Microsoft Word), identifying and explaining your insights into the operation of Todd Restaurants.

2. Learning Objectives:

In the process of this assessment task you will:

Plan, schedule and execute project tasks with a view to improve your personal productivity;

Gain awareness of some typical issues related to the operation of a small-to-medium size business;

Use the functionality of Microsoft Excel to manipulate data, analyse it and visualise it in tabular and chart form; and

Use the functionality of Microsoft Word to write a brief report of your business observations and recommendations.

3. Case Background:

Feastive Restaurants offer a national chain of full-service, casual-themed restaurants across Australia. You have been offered the job of vice president of operations for Feastive Restaurants. During your first week on the job, David Feast, your boss and CEO of the company, has asked you to provide an analysis of how well the company's restaurants are performing. Specifically, he would like to know which units and regions are performing extremely well, which are performing moderately well, and which are underperforming.

4. Assignment Instructions:

The CEO asks you to identify where to spend time and focus efforts to improve the overall health of the company.

1. Review and use the data that Mr Feast has provided you from the Festive restaurants data warehouse in the itech1005_2017-27_assign_Data.xlsx file. Rename the spreadsheet as: Lastname_StudentID.xlsx.

2. Use the Information worksheet for your calculations and analysis to provide results for each of the following tasks:

Use 'Restaurant Size (by Sales)' column in 'Information' worksheet to categorise each restaurant size as 'Small', 'Medium', 'Large' or 'Huge' according to their 'Annual Sales' by using the following table. (You need to use VLOOKUP function for this; and the table needs to be stored in the 'Information' worksheet:)

Annual   Sales Levels

Size   Label

$0

Small

$1,000,000

Medium

$2,000,000

Large

$3,000,000

Huge

Calculate the number of years each restaurant is operating in the 'Restaurant Age (years)' column. Hint: you need to use a formula that calculates (the current date – 'Restaurant Opening Date')/365.25.

Calculate the 'Taxes payable on annual sales' by each restaurant for annual sales using the following information. All restaurants pay a base tax rate of 15% based upon sales and in addition some regions require additional taxes, as the table underneath indicates, and in one case the additional rate depends on the value of sales. Hint: a similar method might be used as for restaurant size but VLOOKUP only works on ordered/sorted lists while other formulae will work for unsorted lists – requires some research

For example a small restaurant in Victoria with $1000 sales must pay $200 total taxes.

Region

Regional Business Tax Rate

Victoria Small   – Medium 5%

Large   – Huge 7.5%

NSW

7%

Queensland

5%

SA

6%

WA

0

NT

6%

TAS

5%

ACT

7.5%

Calculate 'Cost of Sales ($)' on 'Information' worksheet. Use 'Advertising (% sales)' column in 'Information' worksheet to calculate actual advertising costs for each restaurant with all additional costs of sales calculated using the following table. The percentages applied for costs of sales (aside from advertising costs, which each restaurant decides for itself) are independent of region:

Area

Total   Cost of Sales (not including advertising) as Percentage of Sales

City

60%

Metro

52%

Country

56%

For example, a city restaurant with $1000 sales has $600 cost of sales in addition to any advertising costs.

Calculate 'Profit ($)' for each restaurant on the 'Information' worksheet. Profit is a basic calculation of: sales – cost of sales – advertising costs – taxes.

Calculate 'Sales per Seat ($)', 'Sales per square metre ($)', 'Profit per Seat ($)', and 'Profit per square metre ($)' in relevant columns on the 'Information' worksheet.

Calculate the Sum (i.e.Total), Mean, Median, Maximum, Minimum, Range and Standard Deviation for all relevant columns, at the bottom of the dataset on the 'Information' worksheet.

3. Using the 'Information' worksheet, Mr Feast needs to have summary tables for each of (i) region, (ii) area and (iii) restaurant size. The summaries should include the following:

a. Total Annual Sales

b. Total number of Seats

c. Average Annual Sales

d. Average Store Age (years)

e. Total number of Restaurants

f. Total number of advertising Restaurants

Use the table in the 'Summary Report' worksheet for your calculations. For this report you should not use any Pivot Table analyses.  Instead you need to use functions such as SUMIF, AVERAGEIF, COUNTIFS, etc…

The report table needs to be sorted by ' Total Annual Sales' column in descending order.

All the cells in the summary tables need to be formatted appropriately.

4. Using the Information worksheet, Mr Feast also needs to have some analyses report for the following specific questions:

a. Which region has the highest 'Annual Sales' for 'Large' size restaurants?

b. Which region has the lowest 'Annual Sales' for 'Large' size restaurants?

c. Which region has the best 'Average Profit' for 'Small' size restaurants?

d. Which region has the worst 'Average Profit' for 'Small' size restaurants?

e. Which area has the lowest 'Profit per square metre' for 'Medium' size restaurants?

f. Which area has the highest 'Profit per square metre' for 'Medium' size restaurants?

g. What is the total number of seats for 'Medium' size restaurants in the region with highest total 'Annual Sales'?

h. What is the average floorspace for 'Huge' size restaurants in the region with highest 'Annual Sales'?

i. What is the restaurant with the best 'Annual Sales' at the worst region?

j. What is the restaurant with the worst 'Annual Sales' in the best region?

k. What is the restaurant with the lowest 'Age' in the highest 'Annual Sales' area?

l. What is the restaurant with the highest 'Age' in the lowest 'Annual Sales' area?

m. What is the most profitable restaurant with no advertising expenditure?

n. What is the least profitable restaurant with no advertising expenditure?

You should use Pivot Tables for these analyses – include these on the 'Pivot Tables' worksheet. Provide your answers on the 'Specific Questions Summary' worksheet using cell referencing to the results from your pivot tables.

Note: Create as many pivot tables as needed to show your results but be sure to use filtering and/or sorting where needed to get exact results.

Important: Be sure to follow the instructions for the pivots tables at the top of the 'Pivot tables' worksheet.

For each of the paired questions a-b, c-d, e-f, provide a chart with clear indication of the best/worst results. You can show both best and worst in a same chart – include these three charts (i.e. graphs) on the 'Charts' worksheet.

Note: Create as many additional charts as needed to demonstrate your results for the specific questions and the report (see below).

Important: be sure to follow the instructions for charts at the top of the 'Charts' worksheet.

5. Prepare a Report in Microsoft Word that includes:

An introduction

The results from the Excel worksheets. You need to follow the exact question sequence and copy and paste the necessary analyses (pivot tables, summary tables and graphs) from the Excel file into the report.

Discussion of your observations and your recommendations for Festive Restaurants. In your report include discussion of:

i. restaurants, areas and regions which are performing extremely well and/or poorly (if any) and what might be done to improve; and

ii. whether Festive Restaurants should spend more or less on advertising (e.g. in certain areas or regions)?

iii. the types of data quality issues the company might be experiencing from analysis of the provided dataset and how they might be overcome.

Note: you are looking for distinctive features or patterns in the data you have created in order to report meaningfully to Mr Feast. For example, you might consider how restaurants of like-size are performing relative to each other.

Save your report as Lastname_StudentID_Report.docx.

Attachment:- Assignment Files.rar

Due Date: Saturday 6-April-2019 11:59 PM Singapore Time Note: Singapore Time (20% of Final Grade)…

/in /by

Due Date: Saturday 6-April-2019 11:59 PM Singapore Time

Note: Singapore Time

(20% of Final Grade)

Case Study

“Red Dot Dance!” is a small dance school located in Orchard Central in Singapore. Vanessa Linardi is the owner Manager and has been running the school for the past two years. Vanessa handles bookings, accounts and organises the teaching timetable and roster for the casual dance instructors she employs. (Pay rates have been determined by both age and qualifications.) The dance school offers a range of dance classes for both children and adults. She also offers private. Classes are booked per semester.

Since purchasing the dance school Vanessa has been operating the same timetable and has continued to employ the same staff. Last semester, in an effort to encourage new and current students to take extra classes she introduced a discount scheme. A discount is offered if two or more members of the one family enrol in a class or if a student enrols in two or more classes.

Vanessa has set up a spreadsheet. She has asked you to use the data to complete relevant calculations and to use excel ‘tools’ to analyse the data she has given you. She then requires you to write a business report which analyses and discusses profit growth and discusses the various options available to help increase future profitability.

A spreadsheet has been provided – containing the data for ‘Red Dot Dance!’ enrolments changes to the currecfit growth and options regarding changes to the currect timetable.  er overall profits growing? for semester 1 and 2 in 2018 and 2019. (Semester 2 is booked ahead.)

Vanessa believes that it is time to review the effectiveness of her dance studio’s profitability. Is the business growing? Are her overall profits growing? What is the likely future trend? She wants to revise the timetable to further increase profits and has asked you to,

Analyse the       past two year’s data,

Provide an         overview of profitability trends and perform a predictive analysis,

Discuss the        various options regarding possible future changes to the timetable based on your analysis,

Make 2-4 recommendations for future changes which might assist in further         improving profitability. Briefly justify these recommendations. (The         suggestions should make business sense.)

PREPARING THE BUSINESS REPORT

Report Content

The analysis, findings and recommendations which you prepare for Vanessa should be outlined in a professional business report.

This report should include :

A Title      Page – With a   relevant graphic, report title, student name/ number, course name     (Business Computing 1), course number (ISYS2059), your         workshop time and your workshop tutors’ names .

A Table     of Contents (TOC) generated by      Microsoft Word . Default settings    for the table of contents should not be altered.

A brief Introduction that outlines clearly the purpose of the report.

A brief presentation of the analysis you have      carried out and a discussion regarding the results of this analysis.

A discussion, which is based       on the results of your analysis and outlines possible options for   increasing future profitability.

Identification/discussion    regarding at least one area where further analysis could/should be        conducted.

A short concluding   summary of the        content of the report.

Finally, at least three clear recommendations that Vanessa can adopt. These recommendations must be drawn from the         analysis that you have carried out, and must have been discussed in         the body of your report.

Report Format

The report should be developed using the guidelines covered in the Pearson etext – Chapter 8 Online Business Communication Workshop>>Consolidation Learning Activities>>Online Business Communication – CLA.pdf

Specifically you should:

Ensure your report is concise: 1000 words. This word count includes title page and TOC. It        does not include appendices. (Note: a 10% variance is acceptable.)

Present the report in a       professional, business format with no spelling or grammatical      errors.

Use appropriate headings and    subheadings throughout the body of the report.

Use double or 1.5 spacing

Include a page header with a      suitably formatted title (the header must     not appear on the    title page).

Include a page footer with your name, id number and page number (the footer must         not appear on the      title page).

Include at least two, but no        more than four charts, which you have created – either in the body   of your report (appropriately labelled) or as an appendix at the end of the report. The material in the charts must be discussed as part         of the paper.

In an appendix include screen    shots of calculations which you have used to assist in your     analysis. (note: you do not need to refer to this appendix in the         body of your report)

Report Submission

The Business Report must be submitted, in MS Word format, via the link provided in the “Assignments” area on the ISYS2059 Business Computing 1 site on Canvas.

A Guide to inserting a screen shot in ‘Word’ .

Open and/or minimise the program/sheet you wish to create the screen shot from (in this case       your excel document) As your screenshots are designed to show         calculations you should make sure you have highlighted the relevant         cell and the function is clearly visible in the function dialogue      (fx) box.

Open your ‘Word’ document

Select       insert/screenshot/screen clipping

Select the sheet you wish to       create the screenshot from. The screen should fade and a + appear. Use the + as a cropping tool to select the required screenshot.        Note: there is no need to show every cell. (see figure one in which        one of the relevant cells is highlighted (B3) and the function for         column B is clearly visible.

Label the screenshot appropriately

No   Figure 1 – Screen shot of Countif function

If      you need to create a screenshot of a column that is not located near         the fx box you can:

Select the relevant cell.               Double click on the cell to show the formula

Create screen clipping as            per instructions above. Provide an appropriate la el

Figure      2 – Screenshot of Sumif function

To show several formulas in the one screenshot:

Select       Formulas/Formula auditing/show formulas

Take the screenshot as per the directions above. (NOTE: Text needs to be large enough to ready clearly.)

Figure 3 – Screenshot showing functions in several columns

1. Aims To analyse a set of data (in Microsoft Excel), and write a brief report (in Microsoft Word),

/in /by

1. Aims

To analyse a set of data (in Microsoft Excel), and write a brief report (in Microsoft Word), identifying and explaining your insights into the operation of Todd Restaurants.

2. Learning Objectives

In the process of this assessment task you will:
– Plan, schedule and execute project tasks with a view to improve your personal productivity;
– Gain awareness of some typical issues related to the operation of a small-to-medium size business;
– Use the functionality of Microsoft Excel to manipulate data, analyse it and visualise it in tabular and chart form; and
– Use the functionality of Microsoft Word to write a brief report of your business observations and recommendations.

3. Case Background:
Feastive Restaurants offer a national chain of full-service, casual-themed restaurants across Australia. You have been offered the job of vice president of operations for Feastive Restaurants. During your first week on the job, David Feast, your boss and CEO of the company, has asked you to provide an analysis of how well the company's restaurants are performing. Specifically, he would like to know which units and regions are performing extremely well, which are performing moderately well, and which are underperforming.

4. Assignment Instructions

The CEOasksyou to identify where to spend time and focus efforts to improve the overall health of the company.
1. Review and use the data that Mr Feast has provided you from the Festive restaurants data warehouse in the itech1005_2017-27_assign_Data.xlsx file. Rename the spreadsheet as: Lastname_StudentID.xlsx.

2. Use the Information worksheet for your calculations and analysis to provide results for each of the following tasks:
– Use ‘Restaurant Size (by Sales)' column in ‘Information' worksheet to categorise each restaurant size as ‘Small', ‘Medium', ‘Large' or ‘Huge' according to their ‘Annual Sales'by using the following table. (You need to use VLOOKUP function for this; and the table needs to be stored in the ‘Information'worksheet:)

Annual Sales Levels

Size Label

$0

Small

$1,000,000

Medium

$2,000,000

Large

$3,000,000

Huge

– Calculate the number of years each restaurant is operating in the ‘Restaurant Age (years)' column. Hint: you need to use a formula that calculates (the currentdate – ‘Restaurant Opening Date')/365.25.

– Calculate the ‘Taxes payable on annual sales' by each restaurant for annual sales using the following information. All restaurants pay a base tax rate of 15% based upon sales and in addition some regions require additional taxes, as the table underneath indicates, and in one case the additional rate depends on the value of sales. Hint: a similar method might be used as for restaurant size but VLOOKUP only works on ordered/sorted lists while other formulae will work for unsorted lists – requires some research

Region

Regional Business Tax Rate

Victoria Small – Medium 5%

Large – Huge 7.5%

NSW

7%

Queensland

5%

SA

6%

WA

0

NT

6%

TAS

5%

ACT

7.5%

– Calculate ‘Cost of Sales ($)' on ‘Information' worksheet. Use ‘Advertising (% sales)' column in ‘Information' worksheet to calculate actual advertising costs for each restaurant withall additional costs of sales calculated using the following table. The percentages applied for costs of sales (aside from advertising costs, which each restaurant decides for itself) are independent of region:

Area

Total Cost of Sales (not   including advertising) as Percentage of Sales

City

60%

Metro

52%

Country

56%

– Calculate ‘Profit ($)' for each restauranton the ‘Information' worksheet. Profit is a basic calculation of: sales – cost of sales – advertising costs – taxes.

– Calculate ‘Sales per Seat ($)', ‘Sales per square metre ($)', ‘Profit per Seat ($)', and ‘Profit per square metre ($)' in relevant columns on the ‘Information' worksheet.

– Calculate the Sum (i.e.Total), Mean, Median, Maximum, Minimum, Range and Standard Deviation for all relevant columns, at the bottom of the dataset on the ‘Information' worksheet.

3. Using the ‘Information' worksheet, Mr Feastneeds to have summary tablesfor each of (i) region, (ii) area and (iii) restaurant size. The summaries should includethe following:
a. Total Annual Sales
b. Total number of Seats
c. Average Annual Sales
d. Average Store Age (years)
e. Total number of Restaurants
f. Total number of advertising Restaurants

Use the table in the ‘Summary Report' worksheet for your calculations. For this report you should not use any Pivot Table analyses. Instead you need to use functions such as SUMIF, AVERAGEIF, COUNTIFS, etc…

The report table needs to be sorted by ' Total Annual Sales' column in descending order.
All the cells in the summary tables need to be formatted appropriately.

4. Using the Information worksheet, Mr Feast also needs to have some analyses report for the following specific questions:
a. Which region has the highest ‘Annual Sales' for ‘Large' size restaurants?
b. Which region has the lowest ‘Annual Sales' for ‘Large' size restaurants?
c. Which region has the best ‘Average Profit' for ‘Small' size restaurants?
d. Which region has the worst ‘Average Profit' for ‘Small' size restaurants?
e. Which area has the lowest ‘Profit per square metre' for ‘Medium' size restaurants?
f. Which area has the highest ‘Profit per square metre' for ‘Medium' size restaurants?
g. What is the total number of seats for ‘Medium' size restaurants in the region with highest total ‘Annual Sales'?
h. What is the averagefloorspace for ‘Huge' size restaurants in the region with highest ‘Annual Sales'?
i. What is the restaurant with the best 'Annual Sales' at the worst region?
j. What is the restaurant with the worst 'Annual Sales' in the best region?
k. What is the restaurant with the lowest 'Age' in the highest ‘Annual Sales' area?
l. What is the restaurant with the highest 'Age' in the lowest ‘Annual Sales' area?
m. What is the most profitable restaurant with no advertising expenditure?
n. What is the least profitable restaurant with no advertising expenditure?

– You should use Pivot Tables for these analyses – include these on the ‘Pivot Tables' worksheet. Provide your answers on the ‘Specific QuestionsSummary' worksheet using cell referencing to the results from your pivot tables.

Note: Create as many pivot tables as needed to show your results but be sure to use filtering and/or sorting where needed to get exact results.

Important: Be sure to follow the instructions for the pivots tables at the top of the ‘Pivot tables' worksheet.

– For each of the paired questions a-b, c-d, e-f, provide a chart with clear indication of the best/worst results. You can show both best and worst in a same chart – include these three charts (i.e. graphs) on the ‘Charts' worksheet.

Note: Create as many additional charts as needed to demonstrate your results for the specific questions and the report (see below).

Important: be sure to follow the instructions for charts at the top of the ‘Charts' worksheet.

5. Prepare a Report in Microsoft Word that includes:
– An introduction
– The results from the Excel worksheets. You need to follow the exact question sequence and copy and paste the necessary analyses (pivot tables, summary tables and graphs) from the Excel file into the report.
– Discussion of your observations and your recommendations for Festive Restaurants.In your report include discussion of:

i. restaurants, areas and regions which are performing extremely well and/or poorly (if any) and what might be done to improve; and

ii. whether Festive Restaurants should spend more or less on advertising (e.g. in certain areas or regions)?

iii. the types of data quality issues the company might be experiencing from analysis of the provided dataset and how they might be overcome.

Note: you are looking for distinctive features or patterns in the data you have created in order to report meaningfully to Mr Feast. For example, you might consider how restaurants of like-size are performing relative to each other.

Attachment:- Restaurant Attributes.xlsx