Question: A small plant assembles two components together into a finished product. These components are Part# 3467 and Part# 9225 as seen in the following figure.

A small plant assembles two components together into a finished product. These components are Part# 3467 and Part# 9225 as seen in the following figure. An assembly worker picks up these parts from their boxes for the assembly. Due to supplier quality problems these parts come in slightly different sizes. The assembly requires that Part# 3467 should have a smaller diameter size than that of Part# 9225 to fit. A simulation analysis is needed to figure out the percent of unfit assemblies in 20 assemblies. Unfit assemblies are those assemblies where the diameter of Part# 3467 is greater than the diameter of the Part# 9225 Create a simulation model in Excel using the tables below. Fill out the spaces in the tables with the right formulas. Submit your Excel sheet back to Canvas. No submission is needed here for this question Freq. PART# 3467 Cmi.Freq. 0 ses 0.15 0.25 0.35 0.15 0.10 Diameter 300 320 340 360 400 Freq PART# 9225 CmlFreq. o 015 0.25 0.35 0.15 0.10 Diameter 340 350 360 370 380

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

(Im Sorry the numbers are difficult to see) Draw Page Layout ibri (Body)11 General A small plant assembles two components together into a finished product. These components are Part# 3467 and Part#...

How many balancing mounts should be made each month ensuring demand is met and costs are optimized within the constraints described in the case? Under the new production plan, how many employees...

What is the standard cost of an assembled balancing mount according to the new plan? Need calculation with formula also? What is the conclusion for this case? SAGE SAGE Business Cases Craig Seidelson...

Responsibility Center Presentation Imagine you have been selected by your manager to present a training session to a group of new employees. The new hires do not have accounting backgrounds and have...

Ken Wilkens arrives early in the morning to his plant, Riverside Fashions, Inc. in Norris, SC. It is a medium sized apparel manufacturer, employing around 500. Ken currently produces garments for six...

Summarize the following chapter in your words: (Basic elements of organizing) The Organizing Process organization.2 As you will see in this chapter, managing the basic frameworks that organizations...

Summarize the following chapter: (Basic elements of organizing) The Organizing Process organization.2 As you will see in this chapter, managing the basic frameworks that organizations use to get...

Columbus Custom Carpentry - Active Employees First N Last NaSexAge EEO FT/PT Anthony Chad Jeffrey Molly Daniel Brook James Brian Scott Ronnie Terry Stephen Benny Don Roger Christop Raven Brian Nikki...

Indicate the effects of the following errors on the balance sheet and the income statement in the current year and succeeding years. (a) The cost of a depreciable asset is incorrectly recorded as an...

Organizations are increasing their use of personality tests to screen job applicants. What are some of the advantages and disadvantages of this approach? What can managers do to avoid some of the...

In pairs, look at the following sentences and discuss what is implied rather than stated explicitly. Write a sentence for each one, explaining how the writer uses implicit meaning and the effect it...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...