Description
TQM Analysis using the attached data
- Create a histogram and a Pareto analysis to analyze this data
- What are the next steps
- What can be done to determine the root cause(s)
- Create a proposal for specific actions supported by the data Include any general thoughts on what impact those actions may have on scope, schedule, and/or budget
Unformatted Attachment Preview
As a way to assure quality, “lessons learned” from similar, previous projects be reviewed to make sure
the same mistake is not made twice. 2 years ago, a similar project, Wonderland, a comprehensive them
park was delivered. Despite every attempt there were many customer complaints during the first week
of operation. Below is quality data obtained from customers during the opening
Comment
Time of
day
Comment
Time of
day
Parking a mess
Get better rides
Everything is OK
Double parking attendants
Lines too long
Too crowded
Food is good
No traffic control
Great
Need more snacks bars
Rides are boring
Parking is terrible
Bathrooms filthy
Well done
Unfriendly attendants
Expand parking lot
Hot dogs too expensive
Coffee cold
Took an hour to park
Prices too high
No complaints
10:00am
1:00pm
8:30am
10:25am
11:30am
12:00pm
11:00am
11:45am
3:30pm
1:00pm
8:30am
11:45am
1:35pm
9:15am
4:30pm
2:00pm
12:00pm
10:30am
12:30pm
8:30am
8:45am
Lines too long
Food is terrible / overpriced
Park is dirty
Park was nice and clean
Roller coaster broken
Parking was a nightmare
I won’t be back
Need more bathrooms
Nobody directing traffic
Very nice place
Food is gross
Need more shows
Not enough kiddie rides
Not worth the wait
Not worth the $
Great place. Will come back
No place to park
Bathrooms were a mess
Not enough shows
Rides are great
Parking was a piece of cake
2:00pm
2:15pm
3:15pm
8:45am
4:00pm
2:00pm
3:45pm
1:20pm
10:30am
9:00am
1:00pm
3:15pm
12:15pm
11:25am
8:45am
5:30pm
1:00pm
2:20pm
11:15am
10:00am
4:30pm
1) Use/create a histogram and a Pareto analysis to analyze this data
2) What are the next steps
3) What can be done to determine the root cause(s)
a. Create a proposal for specific actions supported by the data Include any general
thoughts on what impact those actions may have on scope, schedule, and/or budget.
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.
Type of complaint
Parking
Tr...
Completion Status:
100%
Review
Review
Anonymous
Really useful study material!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Cuyamaca College Artistic Work of Frederick Douglas Summary
Independent Project 2-5These instructions are compatible with both Microsoft Windows and Mac operating systems.San Diego S ...
Cuyamaca College Artistic Work of Frederick Douglas Summary
Independent Project 2-5These instructions are compatible with both Microsoft Windows and Mac operating systems.San Diego Sailing keeps data about its fleet of rental and charter boats. One of the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals. [Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7]File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.)Completed Project File Name: [your name]-SanDiegoSailing-02.xlsxSkills Covered in This ProjectCreate and copy formulas.Use formula auditing tools.Set mathematical order of operations.Use relative, mixed, and 3D cell references.Use COUNTIF and SUMIF functions.Build an IF formula.Insert the TODAY function. Open the SanDiegoSailing-02.xlsx workbook. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.Review a formula. Click the New Prices sheet tab and review theFormula bar. Click cell D5. The formula begins with 1+D4. Edit and copy a formula with mixed references. Edit the formula in cell D5 to show D$4instead of "D4." The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105). Figure 2-105 Mixed reference in the edited formula Copy the formula in cell D5 to cells D6:D19without formatting to preserve the border. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleetsheet ($H6) is adjusted to show the correct row. Build a formula with mixed references. Click cell F5 and type =(1+ to start the formula. Select cell F4 and make it an absolute reference to the row but not the column. Type )* for the closing parenthesis and multiplication. Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106). Figure 2-106 Mixed references in the new formula Copy the formula down column F without formatting to preserve the border. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19. Build an IF function formula. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people. Create an IF function in which the logical_test argument determines if there are 8 or more seats. Use Yes for the value_if_true argument. UseNo for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.) Copy the formula to cells G6:G19 without formatting and then center the data in column G. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).Create a division formula. Click the Bookings sheet tab and select cellF5. Calculate average revenue per passenger by dividing the fee by the number of passengers. Build the division formula. Copy the formula in cell F5 to cells F6:F19.Create and copy a COUNTIF function to count bookings by boat manufacturer. Select cell D27. Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group. Use cells $C$5:$C$19 as the Range argument. Set a Criteria argument that will select all boats in the “Beneteau” group. The criteria is ben*. If you type the formula, include quotation marks. Copy the formula in cell D27 to cells D28:D30. Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make. Create and copy a SUMIF function to calculate total revenue by boat make. Select cell E27. Start the SUMIF function with cells $C$5:$C$19 as the Range. Set the Criteria argument to ben*. Set the Sum_range argument to cells $E$5:$E$19. Copy the formula in cell E27 to cells E28:E30. Edit the criteria in each copied formula in cells E28:E30 as needed. Complete formatting. Apply the Currency format to all values that represent money. Format the labels in cells A1:A2 as 18 point. Select cells A1:F2 and click the Alignmentlauncher [Home tab, Alignment group]. Center the labels across the selection. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points. Bold and center the labels in rows 4 and 26. Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30. Center the page horizontally. Save and close the workbook (Figure 2-107). Upload and save your project file. Submit project for grading. Figure 2-107 Excel 2-5 completed
Written Assignment - Presenting Data
Your supervisor has asked you to provide a visual representation of the following data.
Florida Turnpike System ...
Written Assignment - Presenting Data
Your supervisor has asked you to provide a visual representation of the following data.
Florida Turnpike System - Road Ranger CallsType of CallYear 2013Year 2014No Assistance Required22,09131,223Disabled / Stranded Motorist32,67432,122Maintenance of Traffic During Accidents4,2842,040Debris Removal and Abandoned Vehicles41,83730,882How would this data be best presented? Consider different types of charts and graphs that would best depict the data.After
creating a visual representation, provide a short summary of the data.
Include any percentage of increase or decrease from year to year. Save your spreadsheet as a Microsoft Excel.
30 pages
Antonio.larkin Project Risk Management4
The project focuses on developing a marketing strategy. Marketing strategy is a component of a business plan that highligh ...
Antonio.larkin Project Risk Management4
The project focuses on developing a marketing strategy. Marketing strategy is a component of a business plan that highlights a game plan to get ...
University of the Cumberlands The Martian Project Management Concepts Paper
Project Management Concepts (250 Pt)The movie “The Martian” can be viewed through the framework of project management. ...
University of the Cumberlands The Martian Project Management Concepts Paper
Project Management Concepts (250 Pt)The movie “The Martian” can be viewed through the framework of project management. There are two different but simultaneous projects going on in The Martian. One is the survival project of Mark Watney and the other is the project aiming to save him. Watney has the right skills for his survival project: he’s a botanist, he knows how to repair a broken Pathfinder and the most important thing is he doesn’t panic even on his first day alone on Mars.On the other hand, he is not alone in this project. The members of the ‘remote’ team helping him are trying their best to achieve their goal. This is a good example for the importance of the communication between the team even if they are far away!QUESTIONSQuestion #1 (1 full page) (44 pt)The definition of a project: A project is a unique venture with a beginning and end, conducted by people to meet established goals within parameters of cost, schedule, and quality. A project can be considered to have any series of activities and tasks that:Have a specific objective to be completed within certain specificationsHave defined start and end datesHave funding limits, if applicableConsume human and nonhuman resources, such as money, people, equipmentAre multifunctional (i.e., cut across several functional lines)How does this definition fit the movie personalities and events versus just operations management?Question #2 (~3 pages or 1 page for each process) (132Pt)Select 3 of the project management processes below. For each of the 3 you mustProvide a brief description of each process,Describe how Mark Watney or one of the project teams manages this process, andProvide a specific example of the management of this process from the movie and why this is a good example.Stakeholder managementScope planningSchedule planningResource planningQuality planningCommunication planningRisk management planningProcurement managementQuestion #3 (1/2 to 1 full page) (44 Pt)Do you think Mark Watney is a champion? Why or why not?Requirements:Your paper should be Times New Roman, 12pt font and double spaced.Margins of the paper should be 1”. Do not allow your margins to be reduced by utilizing bullet point margins. This will lead to point deductions. Only your Watts textbook needs to be cited; do not worry about citing the movie.
NPU How Do Geographically Dispersed Teams Collaborate Effectively Paper
This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed team ...
NPU How Do Geographically Dispersed Teams Collaborate Effectively Paper
This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed teams, please answer the following questions:How do geographically dispersed teams collaborate effectively?Please find at least three tools on the market that teams can use to collaborate on a geographically dispersed team. Please note the pros and cons of each tool. Based on the research above, note which tool you would select if you were managing the geographically dispersed team and why. Be sure to use the UC Library for scholarly research. Google Scholar is also a great source for research. Please be sure that journal articles are peer-reviewed and are published within the last five years.The paper should meet the following requirements:3-5 pages in length (not including title page or references)APA guidelines must be followed. The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.A minimum of five peer-reviewed journal articles.The writing should be clear and concise. Headings should be used to transition thoughts. Don’t forget that the grade also includes the quality of writing.
American Graduate University Critical Thinking and Decision Analysis Paper
Critical Thinking and Decision AnalysisPlease see the attachments for Case Study and Questions17 (a,b,c,d,e)18 (a,b,c)
American Graduate University Critical Thinking and Decision Analysis Paper
Critical Thinking and Decision AnalysisPlease see the attachments for Case Study and Questions17 (a,b,c,d,e)18 (a,b,c)
Similar Content
business question needs an answer
A customer has
approached a local credit union for a $20,000 1-year loan at a 10% interest
rate. If the credit union...
Flow chats, management homework help
Purpose of Assignment The purpose of this assignment is for students to learn process flowcharting/improving a process and...
Digital Tools and How They Improve Goal Achievement Discussion
(How can digital tools help an organization achieve its goals and improve its performance? support your answer by coverin...
Case Study
Avoid plagiarismStudents are advised to make their work clear and well presented, marks may be reduced for poor presentati...
Management values: Arrange them in order of importance
Nine frequently
cited attributes are:
1. Low
prices
2. Choice
of national versus private labels
...
Research and Analyze
This assignment is designed to help students analyze and interpret primary and/or secondary data and research. First, stud...
Cost Management Class Notes_258049429-Strategic-Cost-Management-Chap007
uploads/services/161584/Cost Management Class Notes_258049429-Strategic-Cost-Management-Chap007.pdf...
Army S Ice Cream
Employees’ Competency in Army’s Ice Cream Human Resource EMPLOYEES’ COMPETENCY IN ARMY’S ICE CREAM HUMAN RESOURCE...
Integration Management Class Notes_52887505-Chapter-11-Class-Notes
uploads/services/161584/Integration Management Class Notes_52887505-Chapter-11-Class-Notes.pdf...
Related Tags
Book Guides
A Portrait of the Artist as a Young Man
by James Joyce
Ezperanza Rising
by Pam Muñoz Ryan
Pride and Prejudice
by Jane Austen
And Then There Were None
by Agatha Christie
The Scarlet Letter
by Nathaniel Hawthorne
My Brilliant Friend
by Elena Ferrante
The Dispossessed
by Ursula Kroeber Le Guin
Mrs Dalloway
by Virginia Woolf
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Cuyamaca College Artistic Work of Frederick Douglas Summary
Independent Project 2-5These instructions are compatible with both Microsoft Windows and Mac operating systems.San Diego S ...
Cuyamaca College Artistic Work of Frederick Douglas Summary
Independent Project 2-5These instructions are compatible with both Microsoft Windows and Mac operating systems.San Diego Sailing keeps data about its fleet of rental and charter boats. One of the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals. [Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7]File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.)Completed Project File Name: [your name]-SanDiegoSailing-02.xlsxSkills Covered in This ProjectCreate and copy formulas.Use formula auditing tools.Set mathematical order of operations.Use relative, mixed, and 3D cell references.Use COUNTIF and SUMIF functions.Build an IF formula.Insert the TODAY function. Open the SanDiegoSailing-02.xlsx workbook. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.Review a formula. Click the New Prices sheet tab and review theFormula bar. Click cell D5. The formula begins with 1+D4. Edit and copy a formula with mixed references. Edit the formula in cell D5 to show D$4instead of "D4." The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105). Figure 2-105 Mixed reference in the edited formula Copy the formula in cell D5 to cells D6:D19without formatting to preserve the border. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleetsheet ($H6) is adjusted to show the correct row. Build a formula with mixed references. Click cell F5 and type =(1+ to start the formula. Select cell F4 and make it an absolute reference to the row but not the column. Type )* for the closing parenthesis and multiplication. Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106). Figure 2-106 Mixed references in the new formula Copy the formula down column F without formatting to preserve the border. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19. Build an IF function formula. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people. Create an IF function in which the logical_test argument determines if there are 8 or more seats. Use Yes for the value_if_true argument. UseNo for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.) Copy the formula to cells G6:G19 without formatting and then center the data in column G. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).Create a division formula. Click the Bookings sheet tab and select cellF5. Calculate average revenue per passenger by dividing the fee by the number of passengers. Build the division formula. Copy the formula in cell F5 to cells F6:F19.Create and copy a COUNTIF function to count bookings by boat manufacturer. Select cell D27. Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group. Use cells $C$5:$C$19 as the Range argument. Set a Criteria argument that will select all boats in the “Beneteau” group. The criteria is ben*. If you type the formula, include quotation marks. Copy the formula in cell D27 to cells D28:D30. Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make. Create and copy a SUMIF function to calculate total revenue by boat make. Select cell E27. Start the SUMIF function with cells $C$5:$C$19 as the Range. Set the Criteria argument to ben*. Set the Sum_range argument to cells $E$5:$E$19. Copy the formula in cell E27 to cells E28:E30. Edit the criteria in each copied formula in cells E28:E30 as needed. Complete formatting. Apply the Currency format to all values that represent money. Format the labels in cells A1:A2 as 18 point. Select cells A1:F2 and click the Alignmentlauncher [Home tab, Alignment group]. Center the labels across the selection. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points. Bold and center the labels in rows 4 and 26. Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30. Center the page horizontally. Save and close the workbook (Figure 2-107). Upload and save your project file. Submit project for grading. Figure 2-107 Excel 2-5 completed
Written Assignment - Presenting Data
Your supervisor has asked you to provide a visual representation of the following data.
Florida Turnpike System ...
Written Assignment - Presenting Data
Your supervisor has asked you to provide a visual representation of the following data.
Florida Turnpike System - Road Ranger CallsType of CallYear 2013Year 2014No Assistance Required22,09131,223Disabled / Stranded Motorist32,67432,122Maintenance of Traffic During Accidents4,2842,040Debris Removal and Abandoned Vehicles41,83730,882How would this data be best presented? Consider different types of charts and graphs that would best depict the data.After
creating a visual representation, provide a short summary of the data.
Include any percentage of increase or decrease from year to year. Save your spreadsheet as a Microsoft Excel.
30 pages
Antonio.larkin Project Risk Management4
The project focuses on developing a marketing strategy. Marketing strategy is a component of a business plan that highligh ...
Antonio.larkin Project Risk Management4
The project focuses on developing a marketing strategy. Marketing strategy is a component of a business plan that highlights a game plan to get ...
University of the Cumberlands The Martian Project Management Concepts Paper
Project Management Concepts (250 Pt)The movie “The Martian” can be viewed through the framework of project management. ...
University of the Cumberlands The Martian Project Management Concepts Paper
Project Management Concepts (250 Pt)The movie “The Martian” can be viewed through the framework of project management. There are two different but simultaneous projects going on in The Martian. One is the survival project of Mark Watney and the other is the project aiming to save him. Watney has the right skills for his survival project: he’s a botanist, he knows how to repair a broken Pathfinder and the most important thing is he doesn’t panic even on his first day alone on Mars.On the other hand, he is not alone in this project. The members of the ‘remote’ team helping him are trying their best to achieve their goal. This is a good example for the importance of the communication between the team even if they are far away!QUESTIONSQuestion #1 (1 full page) (44 pt)The definition of a project: A project is a unique venture with a beginning and end, conducted by people to meet established goals within parameters of cost, schedule, and quality. A project can be considered to have any series of activities and tasks that:Have a specific objective to be completed within certain specificationsHave defined start and end datesHave funding limits, if applicableConsume human and nonhuman resources, such as money, people, equipmentAre multifunctional (i.e., cut across several functional lines)How does this definition fit the movie personalities and events versus just operations management?Question #2 (~3 pages or 1 page for each process) (132Pt)Select 3 of the project management processes below. For each of the 3 you mustProvide a brief description of each process,Describe how Mark Watney or one of the project teams manages this process, andProvide a specific example of the management of this process from the movie and why this is a good example.Stakeholder managementScope planningSchedule planningResource planningQuality planningCommunication planningRisk management planningProcurement managementQuestion #3 (1/2 to 1 full page) (44 Pt)Do you think Mark Watney is a champion? Why or why not?Requirements:Your paper should be Times New Roman, 12pt font and double spaced.Margins of the paper should be 1”. Do not allow your margins to be reduced by utilizing bullet point margins. This will lead to point deductions. Only your Watts textbook needs to be cited; do not worry about citing the movie.
NPU How Do Geographically Dispersed Teams Collaborate Effectively Paper
This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed team ...
NPU How Do Geographically Dispersed Teams Collaborate Effectively Paper
This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed teams, please answer the following questions:How do geographically dispersed teams collaborate effectively?Please find at least three tools on the market that teams can use to collaborate on a geographically dispersed team. Please note the pros and cons of each tool. Based on the research above, note which tool you would select if you were managing the geographically dispersed team and why. Be sure to use the UC Library for scholarly research. Google Scholar is also a great source for research. Please be sure that journal articles are peer-reviewed and are published within the last five years.The paper should meet the following requirements:3-5 pages in length (not including title page or references)APA guidelines must be followed. The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.A minimum of five peer-reviewed journal articles.The writing should be clear and concise. Headings should be used to transition thoughts. Don’t forget that the grade also includes the quality of writing.
American Graduate University Critical Thinking and Decision Analysis Paper
Critical Thinking and Decision AnalysisPlease see the attachments for Case Study and Questions17 (a,b,c,d,e)18 (a,b,c)
American Graduate University Critical Thinking and Decision Analysis Paper
Critical Thinking and Decision AnalysisPlease see the attachments for Case Study and Questions17 (a,b,c,d,e)18 (a,b,c)
Earn money selling
your Study Documents