The events of 9/11 and the subsequent implementation of a number of unilateral and joint border security policies have resulted in an increase in cost of cross border trade between Canada and the US. These costs are mainly due to delays at border crossings and direct costs associated with compliance to the new security policies. Before 9/11, the average time it took a truck to cross a specific Canada - US border was 5 minutes. All trucks were treated alike and no company/truck had preferential treatment over another.
The new security policies implemented by both the US and Canadian border security agencies have resulted in a classification system for trucks crossing the Canada - US border. One class is for trucks with shipments that the carrier, shipper, and other parties with custody or ownership of the shipment have been certified by Customs as compliant with the signature certification program Free and Secure Trade (FAST). Trucks that have FAST certification have an easier time crossing the border as they have been pre-cleared and have less paperwork to complete at the border crossings. Trucks that do not have this certification have a longer processing time at the border. From here on, trucks that have the FAST certification will be called FAST trucks and the trucks that do not have the certification will be called Non-FAST trucks.
Some data from a specific land border crossing is provided to you in a file called "border crossing.xlsx". Students were employed to collect data from a border crossing. They used stop watches for data collection and set the time at which they started data collection as time zero and then noted down the arrival time and inspection time of 6000 FAST and 6000 non FAST trucks on 10 different weeks. There is one worksheet called "Arrival times FAST trucks", one worksheet called "Arrival times Non FAST trucks", one worksheet called "FAST truck inspection times" and another called "Non FAST truck inspection times". Detailed instructions on what data should be used by each group are given in the Appendix under the heading "Data Usage Details". Carry out the following tasks. Support your answers by printing out the appropriate report from input analyzer. Submit the answer to this part in a table. The template for the table is given in the appendix.
a. Determine the inter-arrival time distribution of FAST trucks.
b. Determine the inter-arrival time distribution of Non-FAST trucks.
c. Determine the primary inspection time distribution FAST trucks.
d. Determine the primary inspection time distribution for Non-FAST trucks.