Please use Excel, and if you can, send me the link/download of the Excel sheet (not just photo of it) TIA! :)

Mid-Atlantic Bus Lines was founded by a group of manag In Table 7.9 was collected over several weeks and represents ers from Trailways when that company was acquired by a typical day's operation. Greyhound. They launched a first-class, express bus service Questions operating between the major coastal cities from Philadel- phia, Pennsylvania, to Jacksonville, Florida. By hiring laid-off 1. Use DEA to identify efficient and inefficient terminal opera- Trailways drivers and leasing buses, they established fran- tions. Formulate the problem as a linear programming chises in each city with local entrepreneurs, who were given model, and solve using computer software such as Excel the right to operate a Mid-Atlantic bus terminal. A percentage Solver that permits input file editing between runs. of the passenger ticket sales and freight sales would be kept 2. Using the appropriate reference set of efficient terminals, by the terminal operator to cover his or her costs and profit. make recommendations for changes in resource inputs for After several months of operation, some franchisees each inefficient terminal. complained about inadequate profits and threatened to 3. What recommendations would you have for the one seri- close their terminals. Because other franchisees were ously inefficient terminal in regard to increasing its outputs? pleased with their experiences, however, a study of all termi 4. Discuss any shortcomings in the application of DEA to Mid- nal operations in the system was undertaken. The information Atlantic Bus Lines. TABLE 7.9 Outputs and Inputs for Mid-Atlantic Bus Lines Bus Depot 1 2 Freight Sales 300 600 700 600 Facility Dollars 500 500 400 City Served Philadelphia, PA Baltimore, MD Washington, DC Richmond, VA Raleigh, NC Charleston, SC Savannah, GA Jacksonville, FL 4 Ticket Sales 700 300 200 400 500 500 800 300 Labor-Hours 40 50 50 50 40 000 UI WN 500 400 400 500 50 500 40 600 500 200 30 400 Mid-Atlantic Bus Lines was founded by a group of manag In Table 7.9 was collected over several weeks and represents ers from Trailways when that company was acquired by a typical day's operation. Greyhound. They launched a first-class, express bus service Questions operating between the major coastal cities from Philadel- phia, Pennsylvania, to Jacksonville, Florida. By hiring laid-off 1. Use DEA to identify efficient and inefficient terminal opera- Trailways drivers and leasing buses, they established fran- tions. Formulate the problem as a linear programming chises in each city with local entrepreneurs, who were given model, and solve using computer software such as Excel the right to operate a Mid-Atlantic bus terminal. A percentage Solver that permits input file editing between runs. of the passenger ticket sales and freight sales would be kept 2. Using the appropriate reference set of efficient terminals, by the terminal operator to cover his or her costs and profit. make recommendations for changes in resource inputs for After several months of operation, some franchisees each inefficient terminal. complained about inadequate profits and threatened to 3. What recommendations would you have for the one seri- close their terminals. Because other franchisees were ously inefficient terminal in regard to increasing its outputs? pleased with their experiences, however, a study of all termi 4. Discuss any shortcomings in the application of DEA to Mid- nal operations in the system was undertaken. The information Atlantic Bus Lines. TABLE 7.9 Outputs and Inputs for Mid-Atlantic Bus Lines Bus Depot 1 2 Freight Sales 300 600 700 600 Facility Dollars 500 500 400 City Served Philadelphia, PA Baltimore, MD Washington, DC Richmond, VA Raleigh, NC Charleston, SC Savannah, GA Jacksonville, FL 4 Ticket Sales 700 300 200 400 500 500 800 300 Labor-Hours 40 50 50 50 40 000 UI WN 500 400 400 500 50 500 40 600 500 200 30 400