For this assignment, use Microsoft Excel to create a data table and original graphical representation that summarizes the data outlined in the Results Presentation and Discussion section of the case study provided in the Module One Readings and Resources. Copy your graphic into a Microsoft Word document and add a brief explanation of how the data relates to the problem and goals you identified in Milestone One. Conclude with a clear explanation of how your graphical representation will more effectively help stakeholders in the case make informed decisions.

Specifically, the following critical elements must be addressed:

Data: Create a data table identifying the data provided in the case study. Explain how the data relates to the problem the company needs to solve. How does the data show you that the company is not meeting its goals?

Graphical Representation

Creation: Create a clearly labeled, original graphical representation of the data provided in the case study. For example, you could create a Pareto chart, an X$-$bar and R chart, or a histogram.

Explanation: Explain the graphical representation. What does it show? How will it help the stakeholders make informed decisions?Business Management Dynamics

Vol$\mathrm{.}11,$ No$\mathrm{.}07,$ June $2022,$ pp$\mathrm{.}01-19$

$\copyright$Society for Business and Management Dynamics

Proposal of Cost Reduction in the Production Process of Soft Drinks Concentrate from

Tholor Do Brasil Based on the Use of Integrated PDCA$/$DMAIC Tools

Francisco de Assis Mour$ã$o J$ú$nior$,$ Ed$í$lson Marques Magalh$ã$es$,$ Tirso Lorenzo Reyes Carvajal

Abstract

The general aim of this work was to show a proposal of cost reduction,

for the production process of soft drinks concentrate from Tholor do Brasil Ltda

in Manaus, using the integrated PDCA$/$DMAIC tools, based on the philosophy

of lean manufacturing system and six sigma methodology. About the

methodology, it is a case study that contemplates a documental field research,

carried out with the use of questionnaires to $12$ employees from the soft drinks

concentrate production area of the company, which made possible to achieve the

goals of this work, highlighting from the production employees$’$ perspectives,

what improvements can be implemented in the general production process of the

soft drinks concentrate production. The results show that with the

implementation of the integrated PDCA$/$DMAIC tools, in the course of six

months, the loss rate will be reduced by at least $30\%,$ proving the efficiency of

the present proposal, demonstrating the opportunity and modification viability

in this company process, emphasizing the project integration Lean Six Sigma to

the production, through integrated PDCA$/$ DMAIC tool, standardizing methods

to optimize the use of equipment$’$s$,$ increasing the labor productivity at all stages

and operational actions of the entire production process, avoiding waste, reducing

cost and increasing the operational efficiency.

Keywords: Concentrate, Tools,

Six Sigma, Lean System, Soft

drinks.

Available online

www$.$bmdynamics.co