Business and Finance Homework

Need Finance Homework Help? Ask an Expert

Ask an Expert,
Get an Answer ASAP!

Business and Finance Homework
This answer was rated:

Your boss wants to know the limits of expected variation.

Objective: We want you to...

Objective: We want you to determine baseline sigma for both the current defect level and the new target defect level. (approximate is okay) You will need to refer to the tab below entitled "The Project" for this deliverable. Instructions for you: Calculate baseline sigma. Sigma Levels 6 sigma 3.4 dissatisfied customer experiences per million (DPMO) 5 sigma 233 DPMO 4 sigma 6,210 DPMO 3 sigma 66,807 DPMO 2 sigma 308,538 DPMO 1 sigma 691,462 DPMO Lovell Levelers, Inc. is a major provider of specialized parts for the automotive industry. LLI’s biggest customer, Specific Motors was not a delighted customer this month. In fact, last Monday, the executive vice president of Specific Motors headquarters, Phyllis Kendall was diverted from a return trip from Singapore to drop in unexpectedly at the LLI plant. There was nothing routine about this visit. She made it explicitly clear that Specific Motors was disappointed with the level of quality relative to the leveler plates. In particular, she was disappointed with the current average of rejects at the rate of 1,350 defects per million opportunities (DPMO) at a cost of poor quality of just over $256,000 per quarter. She said the industry standard is less than 50 DPMO and if we do not get the level of quality to the industry standard (as a minimum) within the next six months, LLI should not expect to keep the business next year.

Show More
Show Less
Ask Your Own Business and Finance Homework Question
Answered in 18 hours by:
9/3/2013
Angela--Mod
Category: Business and Finance Homework
Satisfied Customers: 8
Verified

Hello, I'm a moderator for this topic. I've been working hard to find a professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. Please let me know and I will assist further. Thank you!

 

Best,

Angela

Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago


I figured out the answer to that question can I ask another question instead. This is for my six sigma business project. Thanks

Hello. Please post your request details here and I will update the information for you.
Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago



































































Objective:
Your boss wants to know the limits of expected variation. You know there is another shipment
coming in next week and based upon this week's run, you can calculate/predict the limits
of expected variation by calculating the mean and standard deviation.
need to use excell 2007
The Mean and StDev in Excel 2007
Expected variation
Instructions for you:
1. Calculate the average for length, width and thickness.
2. Calculate the standard deviation for each.
3. From these calculations, determine the expected variation. ( Use + or - 3 sigma)
You may complete this assignment by hand, as taught in the lecture. You may use Excel, or you
may use a calculator or other software. We explain the fundamentals of the calculations, so that
you learn the mechanics and the meaning of standard deviation. This basic approach gives you an
understanding of standard deviation, which then allows you to be flexible in the tools that you use.


















































































































































































































Data:
DataLengthWidthThickness
10.677.510.551
10.747.570.546
10.687.550.546
10.727.530.554
10.667.530.546
10.697.560.542
10.707.520.545
10.727.580.538
10.697.550.552
10.687.530.547
10.727.560.546
10.707.580.545
10.707.550.546
10.737.550.548
10.757.540.546
10.737.570.543
10.697.540.548
10.687.550.545
10.707.550.553
10.777.560.539
10.727.540.549
10.697.560.541
10.667.560.543
10.697.550.545
10.637.540.549
10.687.550.546
10.737.560.545
10.747.570.540
10.657.540.541
10.697.550.545
10.707.540.547
10.727.550.543
10.757.530.545
10.717.540.546
10.727.550.547
Upper Spec117.660.56
Lower Spec10.57.450.54
Target10.757.550.55

 















































































































































Project: Manufacturing
Deliverable: Expected variation
Student last name:Your last name here
REPORT ALL OF THE RESULTS TO AT LEAST 4 DECIMAL PLACES!
Mean for LENGTH:::
Standard deviation for LENGTH:::
What is the lowest point of expected variation?
What is the upper point of expected variation?
Mean for WIDTH:::
Standard deviation for WIDTH:::
What is the lowest point of expected variation?
What is the upper point of expected variation?
Mean for THICKNESS:::
Standard deviation for THICKNESS:::
What is the lowest point of expected variation?
What is the upper point of expected variation?

Thank you for your patience while we continue to search for a professional to assist you.
Ask Your Own Business and Finance Homework Question
Josie-Mod
Category: Business and Finance Homework
Satisfied Customers: 5
Verified
Hello again :)

We are still working with our professionals to find you the best possible match. But I wanted to touch base to see if you were still needing our professionals' assistance.

Please let me know if you would like to continue to wait or if you would like to cancel your question at this time. We sincerely XXXXX XXXXX the extended wait time.

Thank you,

Josie~Moderator
Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago
I will wait. Thanks
Thank you for your reply. Your question is open to all professionals and marked high priority. You'll receive an email notification if a professional replies. We appreciate your patience.
Ask Your Own Business and Finance Homework Question
mesosphereman
Category: Business and Finance Homework
Satisfied Customers: 781
Verified
Hello! I'm looking at your question, and will get back to you shortly. Thanks
Ask Your Own Business and Finance Homework Question
Here is your answer:

Word doc

Please let me know if you need any clarification. When you are happy with my response, please make sure to "accept" and rate my answer. Thanks!
mesosphereman
Category: Business and Finance Homework
Satisfied Customers: 781
Verified
mesosphereman and 87 other Business and Finance Homework Specialists are ready to help you
Ask your own question now
Customer reply replied 4 years ago

 


You have received partial credit for the assignment.

Please recalculate the means, std dev and the resulting expected variation.

this is what I got back from my teacher. Thank you. I don't mind giving a bonus but i need to make sure it is correct for my project. I have more for you to. Thanks again.

Hello!

I've reviewed the work, and found that the means, standard deviations, and +/- 3 sigma points are indeed correct in the Word document that I provided. If possible, please ask your instructor for clarification on this. Here is the Excel file I used to generate these numbers --> Excel file.

I appreciate you letting me know about this. I want to understand the issues and do the best possible for you. And of course I'd be very happy to answer more questions if you have any. Thanks!

Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago

Attachment: 2013-09-09_201936_rounding_errors.docx

I don't know if this helps but this was one other part that was in the assignment.

Decimal places in Excel
Excel STORES the full decimal value of a number in its cells.
But, you can adjust how many decimal values
are VISIBLE in your spreadsheet. For example,
if your average/mean was 2.4557643, Excel
could display that number. Or, you can set your spreadsheet
number to display the value to 4 decimal places, 2.4558.
Following are the instructions for re-setting the number of
decimal places that are visible in Excel for both Excel 2003 and
Excel 2007. NOTE: Try to not use 'rounded' data during your
calculations. In your final result, you may round to one
more decimal place than your raw data.

Do you happen to have to work on how you did it? I don't know what the problem is but I will ask my instructor now.

Yes, this Excel file is how I did it.

The answers are correct to the number of decimals in the input data. Using more digits is easy enough (Format --> Cell --> Number --> Decimal Places), but the extra digits are really meaningless in light of the limited precision of the input data.

It is true that Excel displays some number of digits for each cell, while storing it with high precision (about 12-15 digits). Subsequent calculations involving a cell use its stored, high precision value.
Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago


I will get with my instructor and ask him to relook it I appreciate your patients and don't worry you will get paid.

Thanks. No worries. Just happy to help. :)
Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago


No later than wednesday I will post for two more assignments do I post both of them for martin?

Yes please!
Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago

 


Martin for some reason everytime I try to do another question $80 keeps coming up. I don't click on the 80 it says $40 if satisified and I do not check the $80 block but it shows up as that. Can you help?


 

Customer reply replied 4 years ago

Are you using ALL of the available digits during the calculations (format to at least 8 decimal places) and rounding only when reporting the results



This is what my instructor sent back. I tried it but came up with same answer do you understand what he is saying Martin?

Yes is the answer to his question. I'll be back with more detail shortly.
Ask Your Own Business and Finance Homework Question
OK, here is the same spreadsheet, but with the answers calculated to many more digits. You can see that the original answers are correct to the level of precision of the input data. This should satisfy your crazed instructor. :)
Ask Your Own Business and Finance Homework Question
Customer reply replied 4 years ago

Thanks Martin

No problem!
Ask Your Own Business and Finance Homework Question
Ask mesosphereman Your Own Question
mesosphereman
mesosphereman
mesosphereman
Category: Business and Finance Homework
Satisfied Customers: 781
781 Satisfied Customers

mesosphereman is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

linda_us

linda_us

Master's Degree

852 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

F. Naz

Bachelor's Degree

540 satisfied customers

Have completed B.COM and CA Finalist

Bizhelp

Bizhelp

Accountant

260 satisfied customers

BA degree and Certified Public Accountant

214 satisfied customers

dasdasd

Mr. Gregory White

Mr. Gregory White

Master's Degree

211 satisfied customers

M.A., M.S. Education / Educational Administration

Brittany

Brittany

Professional

30 satisfied customers

AA/Accounting BS/Business

Dimitry K., Esq.

Dimitry K., Esq.

Doctoral Degree

19 satisfied customers

JD/MBA, Business Attorney

< Previous | Next >

Related Business and Finance Homework Questions
Locate a recent annual report for a public company that
Locate a recent annual report for a public company that includes a disclosure note that describes an investment in a trading security. Explain why this company would report their investment as a tradi… read more
Expert
Expert
214 satisfied customers
Could you do variance analysis>? I have an assigment due on
on Variance analysis I need to provide notes on each line item… read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
This morning, the hair dryer of one of the students in this
This morning, the hair dryer of one of the students in this class broke. The student, Jane, discussed the problem with her older brother Dick.Dick: Hi, Jane. What happened to your hair dryer? Jane: It… read more
Expert
Expert
214 satisfied customers
This question is do today by 4pm. I am able to pay an
This question is do today by 4pm. I am able to pay an additional charge to get it completed asap. I have attached the questions below and the grading rubric. Please follow the directions closely. This… read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
For writer F. Naz. This assignment is due saturday 1/13 by
For writer F. Naz. This assignment is due saturday 1/13 by 6pm. I have attached the assignment page and grading rubric. Please read the directions and follow them closely. This is for a healthcare fin… read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
Complete assignment as follows: Record the transactions for
Complete assignment as follows: Record the transactions for May 1 through May 31 in a general Journal using the account names listed in the chart of accounts (red tab). Post the entries to general led… read more
Expert
Expert
214 satisfied customers
Business Law - Answer each of the following questions in a
Business Law - Answer each of the following questions in a composition of 10 to 20 sentences:1. Discuss the difference between larceny, embezzlement, and robbery and give an example of each that would… read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
I will need to take the Ashworth College Semester Exam which
I will need to take the Ashworth College Semester Exam which is a series of 50 q's in 3hrs. Accounting. Can i get some help? … read more
Expert
Expert
214 satisfied customers
Is there a charge? I just want the answers to the final exam
is there a charge? JA: You just pay a $5 deposit now and the rest only when you get a reply from the Tutor. All of this is 100% satisfaction guaranteed, so you can get a refund if you're not happy for… read more
GLENN
GLENN
Master of Mathematics
340 satisfied customers
Use all of the three methods you have learned in class and
Use all of the three methods you have learned in class and take a weighted average of the three methods. Weights are subjective. (CAPM, DCF, bond-yield-plus-risk-premium) FOR TOYOTA MOTORS … read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
How much will it cost it is due at midnight. Compose a 4-6
Compose a 4-6 page report, double-spaced, on the following topic: If the Fed decides to raise interest rates next year, what effect would rising rates have upon the following: (1) Consumer financing for big-ticket items such as autos and homes; (2) the present and future values of annuities; (3) the NPV calculation; (4) the WACC; (5) corporate earnings ? … read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
What is the answer Marshall, Inc., produces three products
what is the answer Marshall, Inc., produces three products but weekly demand for the three products exceed the available amount of machine time. Following is information about each product: Product A … read more
Carter McBride
Carter McBride
LLM
239 satisfied customers
It is an accounting questio (usa taX) need help with this
it is an accounting questio (usa taX) need help with this due by tomorrow . pls write answer question in separate document… read more
Expert
Expert
214 satisfied customers
Assignment 1. Plot in Excel the risky asset opportunity set
Assignment 1. Plot in Excel the risky asset opportunity set for Portfolios A & B. Hint: create the following table in excel assuming weights of portfolio A & B in 10 percentage point increments. Then … read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
Manal, I see that you have previously helped someone answer
Hi Manal,I see that you have previously helped someone answer a tax return problem that is very similar to the one I am having trouble with. It is so similar that actually all of the same numbers, the… read more
Expert
Expert
214 satisfied customers
Cassius Clay operates a bituminous coal home heating and
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Centre counties. He must have a supply of bituminous coal on hand so customers may get the coal they need to he… read more
F. Naz
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
Tax Return Problem 5 -Individual Tax Instructions: Please
Tax Return Problem 5 -Individual Tax Instructions: Please complete the 2016 federal income tax return for Joseph and Diana Cohen. You may complete the tax return using Tax Act or paper forms. The link… read more
PDtax
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
I'm enrolled at Portland Community College and for my
I'm enrolled at Portland Community College and for my Entrepreneurship class we are developing a workplace harassment app that would possible partner with BOLI and EEOC. What kind of information would… read more
Dr. Donna Kakonge
Dr. Donna Kakonge
Doctor of Education
201 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x