Reference no: EM133285951

Quality diagnosis at Braehearte Bikes

Examine the data provided in the file breaheartbikesdata2020.xlsx. This is a workbook with a number of pages, describing production for 2020, giving order data, the current quality scores, information about complaints, training details on the old workstations, and an analysis of the operation of the new workstations.

Produce descriptive summary statistics describing what has been happening in the company (addressing the observations given by the management team). Analyse the possible factors that might influence the quality scores and complaints. Some have been identified above but you may consider additional factors.

Describe what kinds of statistical tests you would employ to explore the concerns of the five senior managers (Marketing Director, Purchasing Manager, Production Manager, HR Director and CEO).

You must show in your report the complete application of at least two tests:
a parametric z-test
a non-parametric Chi-squared test

Using Dynamic Simulation Models at BraehearteBikes

All of the managers have decided that it would be useful to adopt a dynamic simulation tool to allow them to do multiple experiments with the factory layout and resources. They have decided to use Simul8 and have been given a 26-page document "An Introduction to Simul8". The company is aware that you have experience of Simul8 and so they have asked you to make a brief report to them, based on your experience and the content of this report on the following matters

Your Task: Part 2

You have also been asked to use your own initiative to discover how one other company has usefully used Simul8 for business purposes.

Explain how simul8 has been used by at least one other company in the world, and what it was used for.

Describe the key concepts of simul8, including the basic building blocks simul8, and how to build a basic simul8 model.

Explain how data from the descriptive analysis of Braeheart e-bikes could be used in the start point (entry work point) and the Activity (Work Centre) of a simul8 model.

Attachment:- Business Analytics Resit.rar