XLS data:

Find the scheduled utilization for each server, the throughput and define a target ship date to show whether the products are shipped on time or late. In a manufacturing plant we use two different types of materials: A and B$.$ The arrival orders and due

dates are given in the following table $($Use attached excel: HW$\_4.$xlsx

Download HW$\_4.$xIsx

Some products were left unfinished the day before the experiment started. Here is the table describing

their status.

The manufacturer uses $3$ machines $($servers$),$ Server$1,$ Server$2$ and Server $3$ to produce the products, all

routes are possible. The processing sequence and processing time for each material and server is

given in Table $2($Use attached excel$)$

Note, that you need to define that the ProcessTime column has hour units.

The plant operates from $7$:$00$ am to $7$:$00$ pm nonstop every day, including the weekends.

Model the above system and run an experiment from September $10,2020$ to October $10,2020.$

NOTE: I also attached excel data in screen shot. If not visible to you please share an email ID where I can share my question.

$*$Submit the SIMIO file plus a short report$*$