Question: please answer 26-28 in excel with steps for explanation. once correct and complete I will rate with thumbs up. thanks! SCENARIO A team playing the

please answer 26-28 in excel with steps for explanation. once correct and complete I will rate with thumbs up. thanks!

SCENARIO A team playing the Customer Responsiveness simulation by Littlefield Technologies has the following data for a 10 day period. The coefficient of variation was 1 for both interarrival times and processing times. Average Average Number of Jobs Utilizatio Machines Completed n 0.76 3 99 Station 1 Station 2 Station 3 99 0.8 0.4 2 2 99 26 Use the data above to complete the following table. Estimate Ti Average Jobs in Processing Queue (queuing Time equation) Station 1 Station 2 Station 3 27 3.2 jobs per day There were 99 jobs completed in 10 days. The replenishment lead time is 7 days. The standard deviation of demand is The company wants a service level = 85% SO Z= 1.036 Calculate the reorder point ROP= #N/A 28 7% per year. Calculate the economic order quantity for the scenario above, if annual demand is 3,650 jobs The opportunity cost of money, r= 17% per year. The cost physically hold an item in inventory is The cost to the company of ALL the material for one job is $835 The cost to place an order is $155 EOQ= #N/A

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!

please answer 23-26 in excel with steps and explanation. once correct and fully complete I will rate with thumbs up. thanks! SCENARIO: The process of a firm is as follows. Flow units enter at the...

Please explain how to fins the Estimated Jobs in Queue with the information provided. I will rate with correct answer! A team playing the Customer Responsiveness simulation by Littlefield...

Case Study - Boutique Build Australia Boutique Build Australia Pty Ltd is a boutique building company based in Sydney that specialises in the design and build of high quality designer homes for the...

Contents Before you begin vii Topic 1: Review programs, systems and processes 1 1. 1A Establish strategies to monitor and evaluate key systems and processes 2 2. 1B Analyse supply chains and...

pls help solve it all Pre-Assessment Checklist: Task 3 - Project The purpose of this checklist The pre-assessment checklist helps students determine if they are ready for assessment. The...

Please answer the questions on M1 Rubric document 3 pgs and essay format about the document attached. Include excel about data listed in rubric. You don't have to read the whole document just skim...

ASSESSMENT Qualification: BSB51915 Diploma of Leadership and Management Unit of Competency: BSBMGT517 Manage operational plan Student Name: Thi My Tham Nguyen Student ID: 1439205 Assessment Due Date:...

Please help with the assigned discussion. The hyperlinks are attached. MY COMPANY IS WALMART Assigned Discussions: 1. Develop and explain a recommended corporate strategy for the selected company....

A flat square of side s0 at temperature T0 expands by Îs in both length and width when the temperature increases by ÎT. The original area is s02 = A0 and the final area is (s0 + Î...

Are you surprised by the number of people under community supervision in the US? What trends in Maruschak and Bonczars stat sheet were of particular interest or concern to you?

The fact that the manager generally has more information about the "true" financial position and results of operations of the entity than does the absented owner is called - ( Enter only one word per...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...