Question: I need help with the third macro. I have finished the other two before it, I just dont know how to start the third one.
I need help with the third macro. I have finished the other two before it, I just dont know how to start the third one.

Develop a Microsoft Excel workbook that is designed to evaluate a solution to a single- machine (without preemption), job sequencing problem of any size The workbook must accept an integer input for the number of jobs. A VBA macro (executed via a command button) must create a table where the user provides the following integer inputs for each job: ready time, processing time, due date, and weight. The macro must also create an input area for the user to provide a proposed job sequence Using a second VBA macro (executed via a command button), the workbook must verify the feasibility of the job sequence provided by the user and then output for the proposed job sequence: the start time for each job, the completion time for each job, the lateness for each job, the tardiness for each job, the makespan, the total idle time, the total completion time the maximum lateness, the total tardiness, the total weighted completion time, and the total weighted tardiness Using a third VBA macro (executed via a command button), the workbook must output the makespan, the total idle time, the total completion time, the maximum lateness, the total tardiness, the total weighted completion time, and the total weighted tardiness resulting from application of each of the following dispatching rules: FCFS, SPT, WSPT, EDD
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
