Final excel for mid term.xlsx - Formula Expected value...

This preview shows page 1 - 3 out of 12 pages.

FormulaExpected valuep(x)xEV0.1510000150000000Productivityoutput/inputoutput1000Input980Productivity1.02Yield(total input)(%good) + (total input)(1-%good) (%reworked)Yield264I%G%R3000.80.4Product Cost(Direct manufacturing cost per unit * input + rework cost perDirect manufacturig cost per unit$70Product costInput300rework cost per unit25rework units14yield264Product cost$80.87QPRgood quality units/((input units) (unit processing cost) + (rew∑24_(𝒊=𝟏)^𝒏▒?(𝒙𝒊)(𝒙𝒊)
Good Quality units665Input units700Unit processing cost$30rework units17.5rework cost$15QPR3.13Quality Index Numbers(Total Quality cost/Base)*100Total Quality cost$810,400Base4360000Quality Index$18.59p-chart UCLpbar + z * sigma pLCLpbar - z * sigma pSigma pSQRT(pbar (1 - pbar)/npbartotal defect/total sample observationTotal defect341Toal sample observation2000pbar0.1705Sample size (n)1000.043.00UCL0.28LCL0.06c-ChartUCLcbar + z * sigma cLCLcbar - z * sigma ccbartotal defect/total sample observationTotal defect190Total Sample observation15cbar12.67z3.00Sample size10UCL23.34Standard deviation of

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture