Question: PLEASE ANSWER IN EXCEL Q2. (60 points) A machine shop would like to predict the processing time for the jobs that they expect to receive

PLEASE ANSWER IN EXCEL

PLEASE ANSWER IN EXCEL Q2. (60 points) A machine

Q2. (60 points) A machine shop would like to predict the processing time for the jobs that they expect to receive Annual Demand and Processing time per unit varies. The probability distributions for both are indicated in the table below. a. Use Random numbers to generate Annual Demand and Processing Time for 20 weeks and determine Annual Processing Time b. Determine the Frequency and Percentage of the Anuual Demand for the three possible levls. Note. A template is provided for you to use Demand Random Number Simulated for Demand Annual Demand Random Number for Processing Time Simulated Annual Processing Time per unit Processing Time Lower range Higher Range Demand (units/year) Probability 3000 0.1 3500 0.6 4200 0.3 Week 1 2 3 4 5 6 7 Processing Time Lower range Higher Range Processing Time (hr/unit) Probability 10 0.35 20 0.45 30 0.2 8 9 10 11 Frequency Percentage Cumulative Demand 3000 3500 4200 Totals gnuBHBgv899 12 13 14 15 16 17 18 19 20

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!

Amachine shop would like to predict the processing time for the jobs that they expect to receive Annual Demand and Processing time per unit varies. The probability distributions for both are...

Q2. (60 points) For the given operations process charts of two products below, a. (20 pts.) Calculate the quantity of the Part Q, W, E, R, and T to be ordered from the suppliers to fulfill the demand...

BUS309: Excel AutoSave OFF ... MidTerm 2 Part 2 Questions ~ Q OP Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me Comments Share Calibri (Body) 11 A A Conditional...

Need help Please with the following.. Calculate the following ratios using Microsoft Excel : Current Ratio Quick Ratio Debt Equity Ratio Inventory Turnover Ratio Receivables Turnover Ratio Total...

\ This case was developed solely for the purpose of classroom discussion. Some details of the case have been disguised. This case is not intended to serve as endorsements, sources of academic or...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

6 | Consumer Choices Figure 6.1 Investment Choices Higher education is generally viewed as a good investment, if one can afford it, regardless of the state of the economy. (Credit: modification of...

Find attached Ingredients: Water, MCC, Salt, Nicotine, pH regulator, sweeteners and flavours I am wondering why the decision to go with LYFT. I understand migrating to LYFT would be easier from sells...

Discuss the six tools of the operating manager: measurement systems, technology, organizational structure, people, leadership signals, and culture. Be prepared to discuss each in relation to the...

Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By 2010, discussions began about whether "cash hoarding" by firms was...

Using historical records, the personnel manager of a plant has determined the probability distribution of X, the number of employees absent per day. It is a. Find the following probabilities. P12 X ...

What are the advantages of an RTK survey over a PPK survey?

No asset of liability is recognized at the inception of a purchase commitment because the contract is "executory" in nature. Group of answer choices True False

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....