msis 3223 final- ali bagheri questions
and answers
/. Which of the following is necessary to calculate the variable cost of production for the
company to develop a profit model?
O unit sale price
O quantity of item sold
O quantity of item produced
O fixed cost of production - Answer-✅quantity of item produced
/.in which af the fallowing ways does demand influence profit?
O it directly influences the fixed cost of production.
O it helps in reducing the variable cost of production.
O it reduces the unit cost of production.
O it predicts how many units will be sold. - Answer-✅it predicts how many units will be
sold.
/.Which of the following formulas would be used to calculate the net income value using
only the data values in the spreadsheet above?
O =SUM(B5:B11)
O =SUM(B5:B10)-B11
O =B5-SUM(B6:B11)
O =B5-SUM(B6:B10)+B11 - Answer-✅=SUM(B5:B10)-B11
/.Which of the fellewing formulas would be used to calculate the operating expenses
using only the data values in the spreadsheet above?
O =SUM(B7:B10)
O =SUM(B7:20)-B11
O =SUM(B7:B9)
O =SUM(B7:B9)-B6 - Answer-✅=SUM(B7:B10)
/.Which of the following would be used to calculate the gross profit using only the data
values in the spreadsheet above?
0 =B5-B6+(B11-B10)
0 =B5-(B6-B11)
O =B5-B6
O =SUM(B7:B11)-B6 - Answer-✅=B5-B6
/.Which of the following formulas would be used to calculate the net operating income
using only the model values in the spreadsheet above?
0 =B15-B16+B6
, O =SUM(B6:B10)-B11
O =B15-B16
0 =B15-B5 - Answer-✅=B15-B16
/.Which of the following formulas would be used to calculate earnings before taxes
using both the data and model values in the spreadsheet above?
=B15-B16
=B17-B10
=B15-B5
=B15-B16+B6 - Answer-✅=B15-B16+B6
/.Which of the following formulas would be used to calculate the net income value using
both the data and model sections in the spreadsheet above?
0 =B15-B16-B17+B10
0 =B6-B15
0 =B18-B11
0 =B5-B17 - Answer-✅=B15-B16-B17+B10
/.When will a company use a predictive decision model?
O when it wishes to deterine the best product pricing to maximize revenue
O when it wishes to know sales patterns to plan inventory levels
O when it wishes to ensure that a specified level of customer service is achieved
O when it wishes to know how best to use advertising strategies to infilience sales -
Answer-✅when it wishes to know sales patterns to plan inventory levels
/.Which dension model incorporates the uncertainty element?
O normative
O prescriptive
O descriptive
O predictive - Answer-✅predictive
/.Which one is NOT a what-if analysis tool in excel?
Data Validation
Scenario Manager
Goal Seek
Data tables - Answer-✅Data Validation
/.which statement is NOT true about Data Tables?
O A 2 -way data table can evaluate more than one output variable
O A two way data table can consider a range of values for two input variables
O A tue way data table can consider a range of values for only one input variable
O A one way data table can evaluate more than one output variable - Answer-✅A 2 -
way data table can evaluate more than one output variable
/.Which af the following best defines decision variables in an optimization model?
and answers
/. Which of the following is necessary to calculate the variable cost of production for the
company to develop a profit model?
O unit sale price
O quantity of item sold
O quantity of item produced
O fixed cost of production - Answer-✅quantity of item produced
/.in which af the fallowing ways does demand influence profit?
O it directly influences the fixed cost of production.
O it helps in reducing the variable cost of production.
O it reduces the unit cost of production.
O it predicts how many units will be sold. - Answer-✅it predicts how many units will be
sold.
/.Which of the following formulas would be used to calculate the net income value using
only the data values in the spreadsheet above?
O =SUM(B5:B11)
O =SUM(B5:B10)-B11
O =B5-SUM(B6:B11)
O =B5-SUM(B6:B10)+B11 - Answer-✅=SUM(B5:B10)-B11
/.Which of the fellewing formulas would be used to calculate the operating expenses
using only the data values in the spreadsheet above?
O =SUM(B7:B10)
O =SUM(B7:20)-B11
O =SUM(B7:B9)
O =SUM(B7:B9)-B6 - Answer-✅=SUM(B7:B10)
/.Which of the following would be used to calculate the gross profit using only the data
values in the spreadsheet above?
0 =B5-B6+(B11-B10)
0 =B5-(B6-B11)
O =B5-B6
O =SUM(B7:B11)-B6 - Answer-✅=B5-B6
/.Which of the following formulas would be used to calculate the net operating income
using only the model values in the spreadsheet above?
0 =B15-B16+B6
, O =SUM(B6:B10)-B11
O =B15-B16
0 =B15-B5 - Answer-✅=B15-B16
/.Which of the following formulas would be used to calculate earnings before taxes
using both the data and model values in the spreadsheet above?
=B15-B16
=B17-B10
=B15-B5
=B15-B16+B6 - Answer-✅=B15-B16+B6
/.Which of the following formulas would be used to calculate the net income value using
both the data and model sections in the spreadsheet above?
0 =B15-B16-B17+B10
0 =B6-B15
0 =B18-B11
0 =B5-B17 - Answer-✅=B15-B16-B17+B10
/.When will a company use a predictive decision model?
O when it wishes to deterine the best product pricing to maximize revenue
O when it wishes to know sales patterns to plan inventory levels
O when it wishes to ensure that a specified level of customer service is achieved
O when it wishes to know how best to use advertising strategies to infilience sales -
Answer-✅when it wishes to know sales patterns to plan inventory levels
/.Which dension model incorporates the uncertainty element?
O normative
O prescriptive
O descriptive
O predictive - Answer-✅predictive
/.Which one is NOT a what-if analysis tool in excel?
Data Validation
Scenario Manager
Goal Seek
Data tables - Answer-✅Data Validation
/.which statement is NOT true about Data Tables?
O A 2 -way data table can evaluate more than one output variable
O A two way data table can consider a range of values for two input variables
O A tue way data table can consider a range of values for only one input variable
O A one way data table can evaluate more than one output variable - Answer-✅A 2 -
way data table can evaluate more than one output variable
/.Which af the following best defines decision variables in an optimization model?
