Coffee House BI Report: Store Performance & Customer Satisfaction Analysis, Assignments of Business Strategy

Download Coffee House BI Report: Store Performance & Customer Satisfaction Analysis and more Assignments Business Strategy in PDF only on Docsity! Assessment Qualification: BSB51415 Training Package: BSB BSB Business Service Due Date: Week 4 Assessment Type: Knowledge and Skill Assessment Assessment Guidelines Please read the following assessment guidelines carefully. |. The purpose of this activity is to assess your knowledge and skills in Manage recruitment, selection and induction processes. 2. If you have any considerations that may affect your performance in the assessment, please inform your assessor immediately. Your assessor will provide you with a suitable alternative to complete this assessment. 3. Your assessor will mark your assessment and provide feedback and a grade to you via the assessment submission on Moodle. 4. If youfeel the decision made by your assessor was incorrect you have the rights to appeal the grading through filling out an appeals form which will then be handle by the Academic Manager. 5. A“NYS"” (not yet satisfactory) result of this task may be returned to you for are-assessment. Re-assessments must be submitted by an agreed date with your assessor. 6. The re-assessment work must address the specific performance tasks beyond doubt for the assessor to issue a satisfactory (pass) result. A repeat NYS outcome could lead to an administration fee for further reassessment. 7. All work must be done individually. Copied work will not be accepted and By adding my name to this document, | hereby declare the work is my own and has not been copied from any other source. Student NAME: Date: Question 1 In the table below, give examples of existing and emerging technologies and how they can be used in knowledge and information management. insert your responses into the table: Technology Use in Knowledge and Information Management Cloud computing Simulation technology Debit/Credit Cards Navigation technology In this assessment, you will undertake several tasks associated with formulating evidence-driven strategies to improve the business performance of a local coffeehouse chain, Coffee Huse, utilising its corporate knowledge. In this simulation, you will perform the following actions: ¢ obtain, analyse, and evaluate the organisation’s corporate knowledge derived from various sources e document evidence-driven recommendations incorporating data analysis to nourish the business e develop a decision support tool to aid in the managerial decision-making process e establish a knowledge repository in line with organisational requirements. Please ensure that you familiarise yourself with this set of requirements that underpin this activity. This includes understanding the background and the criteria you will be assessed on. They are in the Appendix of this document. Coffee Huse Coffee Huse is an Australian coffee company and coffeehouse chain based in Sydney, NSW. Coffee Huse is one of the largest coffeehouse company in the world with 2,861 stores in 12 countries. Coffee Huse specialises in selling superior coffee beans which are sourced from world’s top-quality coffee producers, including El Salvador, Colombia, Kenya, Indonesia, Guatemala, Panama, Brazil, Puerto Rico, and Hawaii. The company has its own coffee roastery facilities which are equipped with in-house roasting equipment. Coffee Huse also sells espresso machines and accessories which are used to brew espresso from coffee capsules. The company manufactures and sells both machines and capsules which can be purchased through a number of online stores and supermarkets. The new Area Manager has been appointed to the position and realised that the Mosman store has been facing a drastic drop in its business performance figures within the last few years. He has been verbally informed that the customers who have been not returning are loyal and long-term. other surrounding coffee shops and lowering the prices will solve the problem. Albeit this idea is compelling and reasonable, the Area Manager is not so sure of this and looking for someone to further investigate. HUSE 9 Mosman Shop Manager thinks it is because of the higher prices compared to Ga 6 The department currently operates on a traditional information system which is comprised of hard- copy files and spreadsheets. Email is used as a method of sharing confidential information. Currently, there is neither an enough management information system present, nor required skillset to conduct business intelligence analysis techniques to mine out the underlying business issues. Therefore, the Area Manager has contacted you, the Business Intelligence Officer, to further investigate on this matter and provide a timely report on the actual parameters. Task 1: Compile Business Report In this task, you will compile a report to create a business case regarding the Coffee Huse’s business performance to be presented to the higher management in future (Task 2). To achieve this, you will ensure the reliability of data collected, apply various statistical data analysis techniques, and document your findings in line with organisational requirements. 1.1 Review and prepare data 1. prepare survey and timeseries data 1.2 Set objective for analyses 1. Write the objective for further analyses required in the business 2. Include three business questions to be analysed 3. Explain how further analyses will benefit the organisation 1.3 Analyse store performances 1. calculate the corporate performance measure EBITDA for all stores and period 2. table store performances by EBITDA and year 3. visualise Mosman’s historical performance 1.4 Undertake statistical root-cause analysis 1. validate the Shop Manager’s hypothesis on poor performance by analysing the relationships between: © Price and customer satisfaction via regression analysis © Wait and customer satisfaction via correlation analysis 1.5 Undertake sensitivity analysis 1. create a spreadsheet model and apply the sensitivity analysis based on the management’s proposal received from the Area Manager 2. document suggestions on this proposal with a rationale Task 2: Take Decisions on Business Issues Identified In this task, you will develop an action plan in consultation with the Area Manager. This will involve you to present your evidence-driven solutions to the Area Manager and agree on solutions that are in line with the organisation’s values and decision-making procedures. 2.1 Manage risks for proposed actions 1. list three strategies to improve the store’s business performance 2. explain the rationale of each strategy 3. for each strategy, list three potential risks 4. for each risk, list two control measures