Business Analysis Report: Enhancing Kelpies Furniture Performance

The Kelpies Furniture Company : A Business Analysis Report (Or something more impactful) By Author(s)… (student number – no names ) date University of Stirling MANU9DA – Assignment 1 Business Analytics

Executive Summary << Insert here your executive summary… one page… max This is usually a one-page abstract of the entire report and may be all that a busy business executive reads. It should: • explain the terms of reference, the purpose and scope of the report, • state the key methods and approach used… describe your approach to analysis • list the main conclusions, • list the key recommendations. You usually do this last. It is not the same as the introduction . >> University of Stirling MANU9DA – Assignment 1 Business Analytics

Table of Contents 1 Introduction .............................................................................................................................. 4 2 Business Understanding ........................................................................................................... 4 2.1 Business Objectives ............................................................................................................ 4 2.1.1 Primary Objectives ....................................................................................................... 4 2.1.2 Current Business Situation ........................................................................................... 4 2.2 Performance Gaps .............................................................................................................. 4 3 Observations with the Company Data ...................................................................................... 5 4 Testing the Data ........................................................................................................................ 5 4.1 Issue 1: Your Analysis of this Issue Using Data .................................................................................. 5 4.2 Issue 2: Your Analysis of this Issue Using Data .................................................................................. 5 4.3 Issue …..n: Your Analysis of this Issue using Data .............................................................................. 5 5 Conclusions and Recommendations for Management .............................................................. 6 5.1 Key Findings ....................................................................................................................... 6 5.2 Recommendations .............................................................................................................. 6 5.3 Suggestions for Further Work ............................................................................................. 6 6 References ................................................................................................................................ 6 7 APPENDICES .............................................................................................................................. 7 University of Stirling MANU9DA – Assignment 1 Business Analytics

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1 Introduction Purpose of the Report: The purpose of this report is to conduct a comprehensive analysis of the current operational challenges faced by Kelpies Furniture Scotland (KFS), particularly focusing on staff absenteeism, quality issues, and demand concerns. The report aims to provide recommendations for addressing these issues and improving overall business performance. The report has been commissioned by the management team at KFS. Type of Report: This report is a diagnostic analysis report. It is intended for the management team at The Kelpies Furniture Scotland, specifically those responsible for overseeing operations, production, and human resources. The report aims to provide insights and recommendations to address the identified challenges. Scope: The scope of this report encompasses the following objectives:  Identify the root causes of staff absenteeism, quality problems, and demand concerns at both the original workshop location and the newly expanded site in Saline, Fife.  Propose targeted strategies to mitigate staff absenteeism and improve employee engagement and satisfaction.  Recommend quality control measures to enhance the production process and reduce product defects.  Develop strategies to manage and forecast demand effectively, ensuring optimal resource allocation. Methodology The analysis will be conducted through a multi-step approach: a. Data Collection: Gathering information through interviews, surveys, and analysis of operational records, focusing on absenteeism rates, quality metrics, and demand patterns at both workshop locations. b. Comparative Analysis: Comparing performance metrics between the original and new workshop sites to identify discrepancies and potential causes. c. Root Cause Analysis: Investigating underlying factors contributing to staff absenteeism, quality issues, and demand concerns, including organizational, operational, and cultural aspects. University of Stirling MANU9DA – Assignment 1 Business Analytics

d. Employee Engagement Survey: Conduct surveys with employees to gauge job satisfaction, identify concerns, and gather suggestions for improvement. e. Quality Assessment: Evaluating the production process, including material sourcing, assembly procedures, and quality control measures, to pinpoint areas for enhancement. f. Demand Forecasting Analysis: Analyzing historical data and market trends to develop more accurate demand forecasts and optimize production schedules. By employing this methodology, the report will provide a comprehensive understanding of the challenges faced by KFS, along with specific recommendations tailored to address each identified issue. The analysis will consider the recent expansion to Saline, Fife, and the subsequent impact on operations, production capacity, and overall business performance. University of Stirling MANU9DA – Assignment 1 Business Analytics

2 Business Understanding 2.1Business Objectives 2.1.1 Primary Objectives The following can be listed as The Kelpies Furniture Scotland (KFS)'s main goals: a. Increase Operation Efficiency : Reduce operating expenses while meeting increasing demand by streamlining and optimizing production processes. b. Enhance Quality Control: To lower rework and customer complaints, consistently attain a quality score of 70 and higher for all furniture goods. c. Handle Room and Storage Problems : Reduce space-related difficulties by figuring out how to use fewer storage units and looking at options for affordable storage solutions, particularly because of the Fife lease's impending expiry in 2025. The recommendations that follow should be based on these main goals, which are to make KFS a more productive, cost- conscious, and quality-aware company. 2.1.2 Current Business Situation Important Business Data: Metric 2021 2022 Total no. of ordered furniture X X Quality Score 70 Mean 81 Rework Rates <5% >10% Table 1: Key aspects of KFS's current business scenario Storage Capacity and Space Utilization: • Stirling and Fife share storage units due to KFS's current shortage of storage capacity, which raises operating expenses. • The Fife location's lease is scheduled to end in 2025. • Workstations: Except for quality control and packaging, which only have one workstation, each station can accommodate up to two. University of Stirling MANU9DA – Assignment 1 Business Analytics

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Quality Inspection and Rework Rates: • Regardless of the kind or material of furniture, quality control inspectors advise aiming for a quality score of 70 or better to prevent redo. • Production schedules and dispatch timeframes have been disrupted by the more than twofold increase in redo rates over the previously allowed 5% threshold. • A rise in customer complaints suggests discontent on the part of the customers. 2.2Performance Gaps The following performance gaps have been discovered based on the data provided by KFS: • Quality Inspection: Furniture goods currently have a mean quality rating of 81, which is higher than the advised level. However, there is a lot of variation in this score, which can mean that the quality is not constant. • Rework Rates: There have been more delays in production and shipment timelines as a result of the redo rates exceeding the permissible threshold of 5%. • Customer Complaints: A decrease in satisfaction among consumers and possible problems with product quality are reflected in the volume of consumer complaints, which has increased. The performance gaps that have been discovered are important regions for progress that direct plans and proposals for implementing change, with an end goal of bringing KFS's operations into line with its main goals. University of Stirling MANU9DA – Assignment 1 Business Analytics

3 Observations with the Company Data << Explore relationships in the company data >> <<Include explicitly addressing the concerns of the senior management team. Evaluate whether the data acquired tells a compelling story. Conclude this section with a list of key issues to explore further based on your discoveries. This is a very graphics and table-based presentation section with descriptive statistics and short narratives All graphics and tables are to be enumerated and titled. The enumeration should be referred to in the text to explain to the reader why it is important. You can make internal forward references – eg, this pattern will be further explored in section x.x >> 4 Testing the Data 4.1 Issue 1: Your Analysis of this Issue Using Data << Tell the story of the issue and what the data is telling you >> 4.2 Issue 2: Your Analysis of this Issue Using Data << Tell the story of the issue and what the data is telling you >> … 4.3 Issue …..n: Your Analysis of this Issue Using Data << Tell the story of the issue and what the data is telling you >> University of Stirling MANU9DA – Assignment 1 Business Analytics

5 Conclusions and Recommendations for Management 5.1Key findings <<What you have discovered, and what is most significant>> <<With reference to what has been discovered in your analysis, highlight those issues that you believe should be acted upon.>> 5.2Recommendations << A set of action plans and expected outcomes using the analysis findings. Suggest your best option but leave management with enough to make informed decisions >> 5.3Suggestions for Further Work << Scope a few ideas for an extended study to improve some aspect of the current analysis – usually led by a list of limitations of the current study. >> University of Stirling MANU9DA – Assignment 1 Business Analytics

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

6 References • https://stirling.instructure.com/courses/13749/files/3482874?wrap=1 (Accessed: 05 November 2023). • https://stirling.instructure.com/courses/13749/files/3482875?wrap=1 (Accessed: 05 November 2023). • University of Leeds, U. of L. (2017) Report writing. Available at: https://library.leeds.ac.uk/info/14011/writing/114/report_writing (Accessed: 05 November 2023). • University of South Australia, U. (2017) Study help: Report writing. Available at: https://www.youtube.com/watch?v=GV4yMF8vx6o (Accessed: 05 November 2023). • University of Stirling MANU9DA – Assignment 1 Business Analytics

• University of South Australia, U. (2017) Study help: Report writing. Available at: https://www.youtube.com/watch?v=GV4yMF8vx6o (Accessed: 05 November 2023). 7 APPENDICES << Any appendices you wish to add – especially the detailed data log of your statistical work. Use Excel. >> University of Stirling MANU9DA – Assignment 1 Business Analytics

MANU9DA BusinessAnalyticsReportTemplate

Related Documents