OMGT Test 1 Keller Study Guide | Operations Management Review, Key Concepts & Practice
Questions
If cost increases then profit - ANS ✔✔Must decrease
If break even is 100 units, when price is 15 and Variable cost is 10, then fixed costs are? - ANS
✔✔Between 250 and 750
if profit is more than 1000 when fixed costs are 5000 when producing 100 units, then variable
costs are? - ANS ✔✔Not enough information
If profit = 1500 and revenue = 1000. then what is cost - ANS ✔✔-500
If the break-even point is 2000 units when fixed cost is $2000 and the variable cost is $10, then
the price is? - ANS ✔✔11
If price is $50, variable cost is $25, and fixed cost is $1000, then what is Profit for a production
quantity of 1000 units? - ANS ✔✔24000
If the break-even point is 1000 units when fixed cost is $1,000 and the variable cost is $5, then
the price is? - ANS ✔✔More than $4 but less than $24.
If fixed costs decrease then the break-even point ... - ANS ✔✔Must decrease
If Profit = 1000 and Cost = 500, then what is Profit? - ANS ✔✔1000
If price is $40, variable cost is $20, and fixed cost is $1500, then what is Profit if the quantity
sold is 50 units? - ANS ✔✔Between -$1000 and +$1000
, What is the break-even point when fixed costs are $2000, price is $20 and variable costs are
$10? - ANS ✔✔Less than 250 units
If Profit = 500 and Revenue = 1000, then what is Revenue? - ANS ✔✔1000
If the EXCEL formula =A3+B2 is copied from one cell to another cell located 3 rows down and
two columns to the right, the resulting formula will be ... - ANS ✔✔= c6+d5
What is the result from the EXCEL formula =COUNT(Location)? - ANS ✔✔0
What is the result from the EXCEL formula =COUNTA(Y)? - ANS ✔✔none of the other answers
In EXCEL, if cell A3 contains the value 50, then the calculated result for the EXCEL formula
=IF(A3>=50,) is ... - ANS ✔✔0
In EXCEL, if cell A3 contains the value 50 and B3 contains the value 60, then the calculated result
for the EXCEL formula =IF(A3>50,IF(A3<60,1,0),IF(B3>60,1,0)) is ... - ANS ✔✔0
The EXCEL function to find the second smallest value in a data range is ... - ANS
✔✔=SMALL(data range, 2)
The mathematical result of -2^2+2 is ... - ANS ✔✔-2
The result of entering the formula = -4^2+1 in Excel is ... - ANS ✔✔17
What is the result from the EXCEL formula =SUMIF(X,">5",Y)? - ANS ✔✔Less than 5
Questions
If cost increases then profit - ANS ✔✔Must decrease
If break even is 100 units, when price is 15 and Variable cost is 10, then fixed costs are? - ANS
✔✔Between 250 and 750
if profit is more than 1000 when fixed costs are 5000 when producing 100 units, then variable
costs are? - ANS ✔✔Not enough information
If profit = 1500 and revenue = 1000. then what is cost - ANS ✔✔-500
If the break-even point is 2000 units when fixed cost is $2000 and the variable cost is $10, then
the price is? - ANS ✔✔11
If price is $50, variable cost is $25, and fixed cost is $1000, then what is Profit for a production
quantity of 1000 units? - ANS ✔✔24000
If the break-even point is 1000 units when fixed cost is $1,000 and the variable cost is $5, then
the price is? - ANS ✔✔More than $4 but less than $24.
If fixed costs decrease then the break-even point ... - ANS ✔✔Must decrease
If Profit = 1000 and Cost = 500, then what is Profit? - ANS ✔✔1000
If price is $40, variable cost is $20, and fixed cost is $1500, then what is Profit if the quantity
sold is 50 units? - ANS ✔✔Between -$1000 and +$1000
, What is the break-even point when fixed costs are $2000, price is $20 and variable costs are
$10? - ANS ✔✔Less than 250 units
If Profit = 500 and Revenue = 1000, then what is Revenue? - ANS ✔✔1000
If the EXCEL formula =A3+B2 is copied from one cell to another cell located 3 rows down and
two columns to the right, the resulting formula will be ... - ANS ✔✔= c6+d5
What is the result from the EXCEL formula =COUNT(Location)? - ANS ✔✔0
What is the result from the EXCEL formula =COUNTA(Y)? - ANS ✔✔none of the other answers
In EXCEL, if cell A3 contains the value 50, then the calculated result for the EXCEL formula
=IF(A3>=50,) is ... - ANS ✔✔0
In EXCEL, if cell A3 contains the value 50 and B3 contains the value 60, then the calculated result
for the EXCEL formula =IF(A3>50,IF(A3<60,1,0),IF(B3>60,1,0)) is ... - ANS ✔✔0
The EXCEL function to find the second smallest value in a data range is ... - ANS
✔✔=SMALL(data range, 2)
The mathematical result of -2^2+2 is ... - ANS ✔✔-2
The result of entering the formula = -4^2+1 in Excel is ... - ANS ✔✔17
What is the result from the EXCEL formula =SUMIF(X,">5",Y)? - ANS ✔✔Less than 5
