Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
A team of undergraduate business students was asked to recommend improvement to the data entry process at the county appraiser’s office. The team identified several types of errors, such as posting an incorrect name or entering an incorrect parcel number. The deed abstractors were asked to keep a record of the errors in data entry that were sent to them. The following table is a frequency distribution of errors:
Defect
Total
Posting error in name
Posting error in parcel
Property sold after tax bills were mailed
Inappropriate call transfer (not part of deeds>mapping)
Posting error in legal description>incompletelegal description
Deeds received after tax bills printed
Correspondence errors
Miscellaneous errors
23
21
5
18
4
6
2
1
a. Construct a Pareto diagram of these defects in data entry.b. What recommendations would you suggest to the county appraiser?
The manufacturer of running shoes conducted a study on its newly developed jogging shoe. Listed are the type and frequency of the nonconformities and failures found. A Pareto chart to show the major problem areas is given below. (Round your answers to 1 decimal place.)
Type of Nonconformity
Frequency
Type of Nonconformity
Frequency
Sole separation
34
Lace breakage
13
Heel separation
91
Eyelet failure
8
Sole penetration
60
Other
16
Fill in the blanks in the table below:
Type of nonconfirmity
Count
Percent
Cumulative %
Heel separation
91
Sole penetration
60
27.0
68.0
Sole separation
34
Other
16
7.2
90.5
Lace breakage
13
Eyelet failure
8
3.6
100.0
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”:
Week
Late flights
1
2
2
4
3
10
4
4
5
1
6
1
7
13
8
9
9
11
10
0
11
3
12
4
13
2
14
2
15
8
16
2
17
3
18
7
19
3
20
2
Calculate the upper and lower control limits for this chart.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- BlueMoon Bottlers has a bottle-filling process with a mean value of 64 ounces and a standard deviation of 8 ounces. Suppose the upper and lower specification limits are 71 and 57 ounces, respectively. What is the process capability index of this process? (Note: You MUST show every single step and detailed derivation for full credit)arrow_forwardChart and Regression analysis : What does the intercept predict? X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day) Equation: y=2.9x + 14.5 Slope:2.9 Intercept:14.5 Does the intercept mean the intercept is 14.5 means that the cars sold per day( Y) predicted number of cars on sale lot(X) to be 14.5, but this intercept has no meaning. So, I will not use to predict cars sold per day?arrow_forwardAbernathy, Inc., produces two different generators and is concerned about their quality. The company has identified the following quality activities and costs associated with the two products: Generator A Generator B Units produced 170,000 340,000 Warranty work (units) 1,700 850 Scrapped units (number) 3,400 850 Inspection (hours) 3,400 1,700 Quality training (hours) 85 85 Activities: Performing warranty work $816,000 Scrapping units 612,000 Inspecting 306,000 Quality training 85,000 Required: 1. Calculate the quality cost per unit for each product, and break this unit cost into quality cost categories. If required, round your answers to the nearest cent. Generator A Generator B Unit cost $fill in the blank 1 $fill in the blank 2arrow_forward
- Analyse the issues described below using root cause analysis techniques. A travel agency has recently lost several medium-sized and large corporate customers due to complaints about poor customer service. The management team of the travel agency decided to appoint a team of analysts to address this problem. The team gathered data by conducting interviews and surveys with current and past corporate customers and gathering customer feedback data that the travel agency has recorded over time. About 2% of customers complained about errors made in their bookings. On one occasion, a customer requested a change to a flight booking. The travel agent wrote an e-mail to the customer suggesting that the change had been made and attached a modified travel itinerary. However, it later turned out that the flight reservation system had not confirmed the modified booking. As a result, the customer was not allowed to board the flight, leading to a series of severe inconveniences for the customer.…arrow_forwardA well-known theoretician at Institution A is called by an experimentalist at Institution B to discuss what appears to be a new discovery, based on a highly original approach to the measurements in question. The discovery supports the theorists highly controversial approach to the problem. However there is a substantial amount of work needed before the results can be submitted for publication. The theorist has been invited to present a seminar at Institution C, where she is a candidate for a position, and where competitors of the experimentalist at Institution B are found. She was not told explicitly that his conversation with the experimentalist at Institution B was privileged.Questions What should she do in preparing for his visit? What are the potential conflicts of interests? What ethical considerations should the theorist consider in preparing her talk? Are there other actions that she could or should take in preparing for the visit? [OR]Suppose you have a strong interest in…arrow_forwardplease solve all parts within 30 minutes using excel.arrow_forward
- In a car manufacturing company, an automated painting process has been introduced, and the quality assurance team suspects there might be issues that require investigation. The team decides to conduct a root cause analysis to identify potential problems. Through the root cause analysis and further investigation, it appears that the drying time of the paint in minutes is affecting the overall quality of the finish. The aspect they need to examine is the variation in drying time across different colours of paint. Considering the ongoing concerns in the painting process, the team chooses to collect a sample of six drying time measurements every 20 minutes from various colours of paint. The recorded drying time values for a day's production are presented in Table 1. A total of 10 sets of measurements, each consisting of six drying time values in minutes, have been collected. Each time a set of measurements is taken, the individual drying time values are recorded. Table 1: Drying Time…arrow_forwardThe Hartono Corporation manufactures and sells industrial grinders. The following table presents financial information pertaining to quality in 19-6 and 19-7 (in thousands): 19-7 19-6Sales $12,500 $10,000 Line inspection 85 110 Scrap 200 250 Design engineering 240 100 Cost of returned goods 145 60 Product-testing equipment 50 50 Customer support 30 40 Rework costs 135 160 Preventive equipment maintenance 90 35 Product liability claims 100 200 Incoming materials inspection 40 20 Breakdown maintenance 40 90 Product-testing labour 75 220 Training 120 45 Warranty repair 200 300 Supplier evaluation 50 20 REQUIRED:1. Classify the cost items in the table into prevention, appraisal, internal failure, orexternal failure categories.2. Calculate the ratio of each COQ category to sales…arrow_forwardIn hydraulic fracture test, an induced fracture was created at 12.8 MPa. The fracture was reopened in three subsequent cycles. The reopening pressure at third cycle was found to be 6.4 MPa. If the tensile strength of rock is 6.3 MPa, and the pore water pressure is negligible. Determine the maximum and minimum principle stresses if the shut - in pressure was found to be 5.9 MPaarrow_forward
- In response to intensive foreign competition, the management of Florex Company has attempted over the past year to improve the quality of its products. A statistical process control system has been installed and other steps have been taken to decrease the amount of warranty and other field costs, which have been trending upward over the past several years. Costs relating to quality and quality control over the last two years are given below: Costs (in thousands) Last Year This Year Inspection $ 720 $ 909 Quality engineering $ 450 $ 765 Depreciation of test equipment $ 675 $ 270 Rework labor $ 1,080 $ 1,530 Statistical process control $ 0 $ 225 Cost of field servicing $ 1,350 $ 1,260 Supplies used in testing $ 45 $ 81 Systems development $ 720 $ 900 Warranty repairs $ 3,780 $ 1,620 Net cost of scrap $ 630 $ 1,170 Product testing $ 900 $ 1,800 Product recalls $ 3,150 $ 900 Disposal of defective products $ 810 $ 1,080 Sales have been flat over the…arrow_forwardTucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 tarrow_forwardASQ (The American Society for Quality) Defines a Six Sigma project as: Six Sigma is a method for reducing variation in manufacturing, service, or other business processes. Six Sigma projects measure the cost benefit of improving processes that are producing substandard products or services. Whether in manufacturing or service industries, such projects quantify the effect of process changes on delays or rework. The goal of each successful Six Sigma project is to produce statistically significant improvements in the target process; over time, multiple Six Sigma projects produce virtually defect-free performance. The Six Sigma Black Belt project is one that uses appropriate tools within a Six Sigma approach to produce breakthrough performance and real financial benefit to an operating business or company. The tools are generic. It is the structure of the project and the associated process (improvement model) that distinguish a Black Belt project from other similar quality improvement…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY