Q: Joseph used the spreadsheet below to check the sensitivity of Innovative Speakers profit to increases in prices of components by suppliers next year. First he raised the cost of cabinets by 20% in cell B12, then noted the profit change in B6. Next he raised the cost of diaphragms in C12 by 20%, then noted the profit change. He…
-
-
In the model below, Amy used sensitivity analysis in a cashflow projection to check how her assumptions affect her need to finance operations through credit or loans during the coming year. This question has two parts. First, think about which one outcome variable is most clearly related to the need to plan for financing operations. Then identify which assumption she should make sure she has estimated correctly, since the outcome variable is most sensitive to changes in that assumption. The range B4:F6 show current best assumptions. Range B8:F18 show 10% changes in the three assumptions. Provide as your answer the assumption variable you’ve identified.
Q: In the model below, Amy used sensitivity analysis in a cashflow projection to check how her assumptions affect her need to finance operations through credit or loans during the coming year. This question has two parts. First, think about which one outcome variable is most clearly related to the need to plan for financing operations. Then identify which assumption…
-
The primary limitation of deterministic models is that:
Q: The primary limitation of deterministic models is that: or Q: The following is the main drawback of deterministic models: Their forecasts aren’t situated in historical data All of these They can’t model exponential growth or decline They are often inaccurate representations of the variance in the real world Explanation: This is the key limitation of deterministic models. These models…
-
The story of Bricklin and Frankston and the emergence of personal computers provides evidence suggesting that
Q: The story of Bricklin and Frankston and the emergence of personal computers provides evidence suggesting that or Q: The development of personal computers and the tale of Bricklin and Frankston offer proof that Spreadsheets were not originally used for accounting applications Hardware sells software The personal computer existed before Apple All of these are true Software sells hardware Explanation:…
-
Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply.
Q: Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply. or Q: In the spreadsheet below, which of the following formulae will produce a circular reference error? Choose all that apply. All of these will result in a circular reference error Formula in cell C14=C10*C4-C10*C2 Formula in cell…
-
In the cashflow spreadsheet below, which of the following cell addresses contains a potentially important output function for the cashflow model? Select all that apply.
Q: In the cashflow spreadsheet below, which of the following cell addresses contains a potentially important output function for the cashflow model? Select all that apply. or Q: Which of the following cell addresses in the cashflow spreadsheet below houses a potentially significant cashflow model output function? Choose all that apply. B8 B7 B13 B12 B6 Explanation: Likely contains an…
-
In this analysis of historical sales, which cell formula tells you the level of variation in the spread of sales numbers from low performing months to high performing months?
Q: In this analysis of historical sales, which cell formula tells you the level of variation in the spread of sales numbers from low performing months to high performing months? or Q: Which cell formula in this historical sales analysis indicates the degree of fluctuation in the sales statistics’ distribution from underperforming to high-performing months? C9 C11 C8 C10 None…
-
The term array is closest in meaning in Excel to:
Q: The term array is closest in meaning in Excel to: or Q: In Excel, the term “array” is most closely related to: Cell Standard Deviation Spreadsheet Range Sumproduct Explanation: An array refers to a collection of values or cells that Excel treats as a single entity when performing certain functions. A range in Excel is a set of multiple…
-
Consider the following spending allocation of the advertising budget: ASI = 60, ASC = 20, AEI = 0, AEC = 115. What is the total net sales increase (in $ millions) corresponding to this budget allocation? Choose the closest value among the ones presented below.
Q: Consider the following spending allocation of the advertising budget: ASI = 60, ASC = 20, AEI = 0, AEC = 115. What is the total net sales increase (in $ millions) corresponding to this budget allocation? Choose the closest value among the ones presented below. or Q: Examine the advertising budget’s expenditure distribution as follows: ASC = 20, AEI…
-
Ignore the settings of Q3 and Q4 and consider the original problem formulation. Suppose that the company decides to change the requirement on the minimum net sales increase in China from the current value of $4 million to $3 million. The other constraints remain unchanged. What is the new value of the optimal total net sales increase, in $ millions? Choose the closest value among the ones below.
Q: Ignore the settings of Q3 and Q4 and consider the original problem formulation. Suppose that the company decides to change the requirement on the minimum net sales increase in China from the current value of $4 million to $3 million. The other constraints remain unchanged. What is the new value of the optimal total net sales increase, in $…
