Continuing from the previous question, please type the exact Excel functions you'd use for Supplier 5 in the space below. To be automatically graded by Canvas, you answer must 1) include the equal sign "=", 2) be in all CAPS, and 3) not contain any spaces.

• Supplier 5: With equal likelihood of these three scenarios: a) will be able to make delivery 4 days ahead of schedule, b) on time, or c) 2 days behind schedule.

Please only answer the above question not the below

GAC (General Appliance Corporation), an international appliance manufacturer, is working with a chain of five suppliers overseas to make one of its popular refrigerator models. Each supplier is responsible for making certain parts and delivering them to the next one within an allotted time, and the last one is responsible for assembling the final product. Below are the estimated delay/on-time/ahead-of-schedule status for each of them, taking into consideration factors such as weather, oil price, global economy, and political uncertainty. You are asked to write Excel functions to simulate their status where positive numbers mean delay, negative numbers mean ahead of schedule, and o means on time. Please type the exact Excel functions you'd use in the space below. To be automatically graded by Canvas, you answer must 1) include the equal sign "=", 2) be in all CAPS, and 3) not contain any spaces. Supplier 1: Will be one day late. Supplier 2: With 50-50 chance, will be able to make delivery either on time or 1 day behind schedule. Supplier 3: With 50-50 chance, will be able to make delivery either 5 days behind schedule or 1 day ahead of schedule. Supplier 4: Will be able to make delivery 2 days ahead of schedule or 3 days behind, or anywhere in between (decimal numbers included). Supplier 5: See the next