In this portion of an Excel spreadsheet, the user has given values for selling prion, the costs, and a sample volume. G E Bmak-wan calculation Saling prion par unit 10 Costs Fbconst 8400 Variable onst per unit 12 Bmok-man volume 13 14 Sample calculation Volume 2000 16 Thiad revenue 17 Third onst 18 Profit (Joss] What is the total cost? Select one Q R. 20000 O b. 37800 0 C. 17400 0 0. 84000Which of the methods for decision making best protects the decision maker from undesirable results? Select one: O a. the optimistic approach O b. the conservative approach O c. minimum regret O d. minimax regretLet M be the number of units to make and B be the number of units to buy. If it costs $2 to make a unit and $3 to buy a unit and 4000 units are needed, the objective function is Select one: O a. Max 2M + 3B O b. Min 4000 (M + B) O c. Max 8000M + 12000B O d. Min 2M + 3BA section of output from a software package is shown here. Variable Lower Current Upper Limit Value Limit 60 100 120 What will happen to the solution if the objective function coefficient for variable 1 decreases by 20? Select one: O a. Nothing. The values of the decision variables, the dual prices, and the objective function will all remain the same. O b. The values of the decision variables and the dual prices will remain the same but the value of the objective function will change. O C. The same decision variables will be positive, but their values, the objective function value, and the dual prices will change. O d. The problem will need to be resolved to find the new optimal solution and dual price.A manager uses the following equation to predict monthly receipts: Y = 40,000 + 150t. What is the forecast for July if t = 0 in April of this year? Select one: O a. 40,450 O b. 40,600 O C. 42, 100 O d. 42,250 O e. 42,400Gradual shifting of a time series to relatively higher or lower values over a long period of time is called Select one: O a. periodicity O b. cycles O c. seasonality O d. trend