Question
Question 1 A wholesale company located in San Juan provides organic avocados to several local retailers. Avocados are sold in boxes of fifty pounds. Until
Question 1
A wholesale company located in San Juan provides organic avocados to several local retailers. Avocados are sold in boxes of fifty pounds. Until a year, the wholesaler had received no complaints regarding the weight of the boxes. Since then, several retailers have protested because "... on average, the weight of the boxes is less than Stipulated ". To know the legitimacy of this concern, the wholesaler decided to carry out an experiment consisting of taking random samples (12 bags), every hour of a eight-hour work shift, for five consecutive days. The Excel table attached (at end of question) contains the file with the data (see the "Actual" sheet). The "weights" are in pounds per case sampled. With this information, process control limits were established in 3?.
Once the wholesaler received the results of the experiment, he concluded that indeed t here was a discrepancy in the weight of the boxes. Management concluded that it was necessary to make improvements in the process, since (1) on average each box weighed less than 50 pounds and (2) the process was out of control. To ensure that the decision
was correct, the administration decided to carry out the same experiment, in the same conditions, obtaining the results shown in the "Improvements" sheet. Explain and illustrate in detail if the decision to make the best ones was justified.
Question 2
A week ago, the wholesaler of Situation 1, began to experience another situation in the company, the company located in Ponce. Historically, this company has maintained under control the weight of boxes of organic avocados that it distributes. Recently, several retailers in the area have complained about the amount of decomposed avocados (or in advanced decomposition processes) into an average box of avocados. The administration has given itself the task of knowing if the argument of the retailers is valid., they carried out a study that involves the random selection of 30 boxes of avocados, for a period of time statistically reasonable. Each box of fifty pounds contains between 185-210 avocados (see tab"Avocados" at end of question within the document). Based on the results, what is your recommendation to the company?
(Support your claim, with information, graph, etc., using 3?.)
Excel Sheet: https://docs.google.com/spreadsheets/d/e/2PACX-1vQIbRaVSTChNUeL98VHvS5kxAJIfCmZLcakLF6aHL7XNc4CDy_os8Ax4OtKPyXtrByLnPBGLUYnNJLF/pub?output=xlsx??
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started