Question
1. Which best explains spreadsheet models as what-if models? Group of answer choices The impacts of changes in one cell to all functions. Logic-based models.
1.
Which best explains spreadsheet models as what-if models?
Group of answer choices
The impacts of changes in one cell to all functions.
Logic-based models.
They are mathematical models.
None of the answers is correct.
2.
Identify which of the following are the uncontrollable inputs of spreadsheet model.
Group of answer choices
Fixed costs
Variable cost per unit
Total Cost
Savings
3.
Which of the following does not belong to the group?
Group of answer choices
Use What-if analysis to find the output of an input.
Separate the parameters from the model.
Format the model.
Use simple formulas and formats.
4.
What do you think is the significance of using color in a spreadsheet model?
Group of answer choices
To draw attention.
To give emphasis on the decision variable.
To identify the model inputs.
All answers are correct.
5.
Which best describe one-way data table?
Group of answer choices
Summarizes one input's impact on an output.
Summarizes two or more input's impact on the output.
Summarizes the output over inputs.
Generate values of inputs to determine output values.
6.
Match sales to income using what-if analysis one data table on below data.
| Labor cost of 10 workers | 500 per head |
| Raw materials | 30,000 |
| Rent | 50,000 |
| Quantity to produce | 10,000 |
| Sales | 100,000 |
1. 0 _______
2. 300,000 _______
3. 400,000 _______
4. 450,000 _______
5. 200,000 _______
6. 250,000 _______
7. 150,000 _______
8. 500,000 _______
Group of answer choices to 1 -8
200,000
215,000
-85,000
115,000
365,000
315,000
415,000
165,000
150,000
95,000
300,000
400,000
100,000
65,000
7.
With 20 workers, how much income ABC Company will generate using the data below:
| Labor cost per worker | 500 |
| Raw materials | 30,000 |
| Rent | 50,000 |
| Sales | 100,000 |
| Quantity | 10,000 |
1. 450,000 _______
2. 200,000 _______
3. 150,000 _______
4. 500,000 _______
5. 350,000 _______
6. 300,000 _______
7. 400,000 _______
8. 0 _______
9. 250,000 _______
Group of answer choices to 1 -9
260,000
360,000
60,000
500,000
400,000
-9,000
100,000
110,000
310,000
410,000
160,000
300,000
200,000
210,000
8.
Find at how much sales ABC Company can earn P100,000, using data table below.
| Labor costs (10 workers) | 500 |
| Raw materials | 30,000 |
| Rent | 50,000 |
| Sales | 100,000 |
Group of answer choices
185,000
190,000
195,000
200,000
9.
What are the components of VLOOKUP function?
Group of answer choices
range
index
value
table
10.
Match the right concept to the following terms.
Parameters _______
Data table _______
Goal-Seek _______
Decision variable _______
Labor cost _______
Group of answer choices
A collection of inputs and outputs
Fixed Cost
Variable Cost
Uncontrollable model input
Determining the value of an input cell which will caused the value of related output cell.
An input that decision maker can control.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing and Assurance Services
Authors: Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws
6th edition
978-1259197109, 77632281, 77862341, 1259197107, 9780077632281, 978-0077862343
