Job Scheduling Tool Generating Job Sequences for FCFS SPT & EDD Excel Task

Job Scheduling Tool Generating Job Sequences for FCFS SPT & EDD Excel Task

Order Custom written here

( https://homeworklance.com/job-scheduling-tool-generating-job-sequences-fcfs-spt-edd-excel-task/)

You will develop an Excel-based job scheduling tool that will generate job sequences and measures of performance for FCFS, SPT, and EDD dispatching rules, as well as Moore’s algorithm.

Project Requirements

Inputs: Your Excel tool must be able to accept the following data from the user:

  • Alistofjobnumbersthatindicatetheorderinwhichthejobarrived(e.g.,Job1arrivedfirst,Job2arrived second); the list may be of anylength
  • A processing time (in days) for each job in thelist
  • A due date (in terms of day number) for each job in thelist

Tasks: Your Excel tool must be able to automatically sequence the jobs according to all four of the following dispatching rules:

  • First-come, first-served(FCFS)
  • Shortest processing time (SPT)
  • Earliest due date(EDD)
  • Moore’salgorithm

Outputs: Your Excel tool must generate the following outputs:

  • Four sets of job sequences, according to each of the four dispatchingrules
  • Three plots for output metric comparison across the four dispatchingrules:
    • The mean job flow time for all four dispatchingrules
    • The mean job tardiness for all four dispatchingrules
    • The number of tardy jobs for all four dispatchingrules

Scheduling Tool Guidelines

your job scheduling tool should:

  • Be programmed using VBA macros in Excel
  • Produce correct job sequences and outputmetrics
  • Be easy to use andunderstand

 

Get 100% Original and Plagiarism Free Work

Get    Homework Help

Visit: How it Works?

Visit: Homework Lance

 

We write high-quality sample essays, term papers, research papers, thesis papers, dissertations, book reviews,nbook reports, speeches, assignments, business papers and custom web content

Ask Your Homework Question and Get Help from Our Qualified Tutors

ASK A QUESTION

Direct Email us at: Info.homeworklance@gmail.com

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *