ANSWER ALL PARTS ( FOR A POSITIVE RATING

no more info required friend solved it as is.

3. A company has a warehouse with 7 loading docks available for delivery of goods. Trucks arrive at the warehouse approximately once every 5 minutes. Currently, each dock is staffed by a single worker who unloads a truck in an average of 30 minutes. Each worker carns S20 per hour in salary and benefits. The goodwill cost of a delivery truck being in the system (warehouse) is $80 per hour. Suppose that you have been hired by the company to cvaluate the following options: 1) Hire a second worker for cach loading dock, reducing the average time to unload a truck to 20 minutes at each loading dock (cach new worker will also carn $20 per hour in salary and benefits). 2) Rent an electric forklift for each loading dock at S10 per forklift per hour and the forklift can reduce the time for each loading dock to unload a truck to an average of 24 minutes (ie., one worker and one forklift for each loading dock). 3) Build 3 more loading docks (accounting for capital costs and other costs, cach new dock will cost the company S5 per hour of operation) (hint: cach loading dock is staffed by one worker and each worker cams S20 per hour in salary and benefits). 4) Implement both option (1) and option (3) (1.c., to build 3 new docks and cach dock is staffed by two workers (each new worker will also earn $20 per hour in salary and benefits). 5) Implement both option (2) and option (3) (.e., to build 3 new docks and cach dock will have one worker with an electric forklift). Hint: similar to Group project 3, the number of servers for each option is the number of loading docks, not the number of workers. (14) (a) Complete the following table of calculating the hourly costs (note that the values for the average time cach truck stays in the system (W) needs to be calculated from the Excel worksheet): AT rule Service s To Tool And Toc Tould poodwill of aber dock TOTAL (3) (b) What is your recommendation (.e., which option will you recommend to the company)? What will be the benefits to the company if your recommendation is implemented? 3. A company has a warehouse with 7 loading docks available for delivery of goods. Trucks arrive at the warehouse approximately once every 5 minutes. Currently, each dock is staffed by a single worker who unloads a truck in an average of 30 minutes. Each worker carns S20 per hour in salary and benefits. The goodwill cost of a delivery truck being in the system (warehouse) is $80 per hour. Suppose that you have been hired by the company to cvaluate the following options: 1) Hire a second worker for cach loading dock, reducing the average time to unload a truck to 20 minutes at each loading dock (cach new worker will also carn $20 per hour in salary and benefits). 2) Rent an electric forklift for each loading dock at S10 per forklift per hour and the forklift can reduce the time for each loading dock to unload a truck to an average of 24 minutes (ie., one worker and one forklift for each loading dock). 3) Build 3 more loading docks (accounting for capital costs and other costs, cach new dock will cost the company S5 per hour of operation) (hint: cach loading dock is staffed by one worker and each worker cams S20 per hour in salary and benefits). 4) Implement both option (1) and option (3) (1.c., to build 3 new docks and cach dock is staffed by two workers (each new worker will also earn $20 per hour in salary and benefits). 5) Implement both option (2) and option (3) (.e., to build 3 new docks and cach dock will have one worker with an electric forklift). Hint: similar to Group project 3, the number of servers for each option is the number of loading docks, not the number of workers. (14) (a) Complete the following table of calculating the hourly costs (note that the values for the average time cach truck stays in the system (W) needs to be calculated from the Excel worksheet): AT rule Service s To Tool And Toc Tould poodwill of aber dock TOTAL (3) (b) What is your recommendation (.e., which option will you recommend to the company)? What will be the benefits to the company if your recommendation is implemented