Question: please provide excel formulas 1. The Pohl Pool Company has seven jobs waiting to be processed through its liner department. Each job's estimated processing times

please provide excel formulas

1. The Pohl Pool Company has seven jobs waiting to be processed through its liner department. Each job's estimated processing times and due dates are as follows: Job Processing Time (Days) Due Date (Days from Now) A 4 4 8 B 13 37 3 8 C 6 D 3 7 E 11 39 F 9 9 21 G 8 16 a. Using the shortest processing time scheduling rule, in what order would the jobs be completed? Processing can start immediately. b. What is the average completion time (in days) of the sequence calculated in part a? c. What is the average job lateness (in days) of the sequence calculated in part 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!

The Fara Littlebear Society is an NFPO funded by government grants and private donations. It was established in Year 5 by the friends of Fara Littlebear to encourage and promote the work of Native...

1. The Pohl Pool Company has seven jobs waiting to be processed through its liner department. Each jobs estimated processing times and due dates are as follows: a. Using the shortest processing time...

1. The Pohl Pool Company has seven jobs waiting to be processed through its liner department. Each jobs estimated processing times and due dates are as follows: Processing Due Date Job Time (Days)...

Please fill out all 3 charts and provide excel formulas! :) The answer key is givin! Just need the charts filled out Scenario 1 - Aggregate planning Consider the following 12-month forecast for...

Hi! How would you allocate cost using cycle time in lean manufacturing? What alternatives would you suggest to allocate their conversion costs? ISSN 1940-204X Aero Gear, Inc.: Performance...

PRO-FORMS, INC. J.B. Bryson (-Br to everyone who knew her). General Manager of Pro-Forms. Inc., read the invitation with interest: You are invited to attend a retirement party for Iris David...." Was...

CHAP TER 1 The Role of Human Resources HUMAN RESOURCE MANAGEMENT DAY TO DAY You have just been hired to work in the human resource department of a small company. You heard about the job through a...

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

CASE 03 Whole Foods Market in 2014: Vision, Core Values, and Strategy Arthur A. Thompson The University of Alabama ounded in 1980, Whole Foods Market had evolved from a local supermarket for natural...

This assignment is very urgent! Be as Accurate as possible providing explanations to each answer. Chapter 1 1.Managerial Accounting and Financial Accounting differ in the following way: A. Financial...

Assume the same information as BEA-13 except that the discount rate is 12% instead of 10%. In this case, how much can Hanna expect to receive from the sale of these bonds? Data From BEA-13 Hanna...

Let f(x) = . Bn = 3 x 0 Compute the Fourier sine coefficients for f(x). Give values for the Fourier sine series S(x) = - Bu situ ( 1 2). Bn 4 n-1 S(4) = 0 S(-2) = 1,0 S(7) = for 0

Foreign equities as a proportion of U . S . investors' portfolio wealth rose from about 1 percent in the early 1 9 8 0 s to about _ _ _ _ _ _ _ _ _ by 2 0 2 1 . Question 5 5 options: a ) 1 0 percent...

What is an example of constructive feedback? provide reference