with formulas in excel please show how to build consequences table

Part I. 1. When would a firm experience unsold units? (a) When demand is uncertain. (b) When demand exceeds the order amount. (c) When demand falls short of the order amount. (d) When demand is low. 2. The probability of experiencing unsold units for a firm can be 2.11. (a) True. (b) False. 3. Which of the following is not a component of the consequences table? (a) Decision (b) Uncertainty (c) Probability (d) Consequence 4. The maximax and minimax methods require estimation of probabilities. (a) True (b) False 5. The higher the probability of an event, the more likely it is that the event will occur. (a) True (b) False Part It. Consider a construction fem that is deciding to specialize in bunding high schools or elementary schocis over the long had. The firm as to ear as tigh profe as possin The submit a bit proposal, which costs money to prepare, and there are no guarantees that it will be awarded the contact the company ted on the high school and get the texts 162 000 T profit. However, if the company does not get the contract, it loses 11 500 TL. If the company bids on the elementary school and gets the contract, it wou 140 000 The get the contract, it will lose 5750 TL a) Baid the consequences table for the fum Conduct your analysis in the sheet name 'Part A" in the Excel "Qui b) The manager of the company believes that the best of the best is a reasonable policy for the company if this is the case, what should this company do? Conduct your in the host na P the Excel file "Quiz #7xx" Part II. Consider a construction firm that is deciding to specialize in building high schools or elementary schools over the long haul The firm aims to earn as high profits a peesble. The construction company must submit a bid proposal, which costs money to prepare, and there are no guarantees that it will be awarded the contract. If the company bids on the high school and gets the contract expects to make 162 000 T profit. However, if the company does not get the contract, it loses 11 500 TL. If the company bids on the elementary school and gets the contract it would met 140 000 11in profe. However, the company doesnt get the contract, it will lose 5750 TL a) Build the consequences table for the firm. Conduct your analysis in the sheet name "Part A" in the Excelle"Quiz #7xx" b) The manager of the company believes that the best of the best" is a reasonable policy for the company. If this is the case, what should this company do? Conduct yours in the sheet named "Part in the Excel file "Quiz #7.xlsx" 3. Which of the following is not a component of the consequences table? (a) Decision (b) Uncertainty (e) Probability (d) Consequence 4. The maximax and minimax methods require estimation of probabilities (a) True (b) False 5. The higher the probability of an event, the more likely it is that the event will occur. (a) True th) False Part II. Consider a construction fem that is deciding to specialize in building high schools or elementary schools over the long haul. The firm aims to earn as high profits as possible. The construction company must suberst a bid proposal, which costs money to prepare, and there are no guarantees that it will be awarded the contract. If the company bids on the high school and gets the contract, t expects to make 162 000 TL net profit. However, if the company does not get the contract, it loses 11.500 TL if the company bids on the elementary school and gets the contract, it would net 140 000 TL in profit. However, the company does not get the contract, it will lose 5750 TL 1) Build the consequences table for the fiem. Conduct your analysis in the sheet name "Part A' in the Excel file "Quiz #7xx" b) The manager of the company believes that the best of the best is a reasonable policy for the company. If this is the case, what should this company do? Conduct your analysis in the sheet named "Part B in the Excel file "Quiz #7xx