Homework 1a Multiple Choice Identify the choice that best completes the statement or answers the question. B 1. The essence of decision analysis is: |a. |breaking down complex situations into manageable elements. | |b. |choosing the best course of action among alternatives. | |c. |finding the root cause of why something has gone wrong. | |d. |thinking ahead to avoid negative consequences. | C 2. Why would someone wish to use a spreadsheet model? |a. |To …show more content…
|Neither i nor ii | C 10. Variables are termed independent when they satisfy which of the following? |a. |The function value depends upon their values. | |b. |The decision maker has no control over them. | |c. |The variables have no relationship to one another. | |d. |The variable is described as an output of the spreadsheet model. | C 11. Consider the spreadsheet model shown in the figure. This is a | |A |B |C | |1 | | | | |2 | | | | |3 |Purchase price |$32,500 | | |4 |less: | | | |5 | Down payment |$ 6,500 | | |6 | Trade-in |$ 4,000
What: 43 million records which include usernames, hashed passwords, email addresses and also ad-related data of users were hacked
6. Although you are basically satisfied with the analysis thus far, you are concerned about the
Build an Excel spreadsheet to estimate how much a prospective customer is worth, depending on whether that customer is offered a rebate. What do you learn from the updated spreadsheet? Explain the logic behind your findings and
4. Based on your analysis in (1) – (3) above, what is your overall conclusion regarding the
b. Dependent Variable: the variable that I am measuring (it depends on the independent variable)
24) The number of hours spent studying appears to be highly correlated with the grade students earn in a class. Which variable would be the dependent
d) independent: a person’s height has nothing to do with the whether or not they can do math and vice versa
4. Ben believes that the appropriate analysis is to calculate the future value of each option. How would you evaluate this statement?
A. The table below lists each category and states whether the cost is relevant, if it is an implicit or explicit cost, and if the cost has been properly calculated (note: company is currently operating at 65% capacity).
Question 3: Identify all costs associated with this venture. Categorize these costs as fixed or variable.
3. For each of the individual overhead accounts at Bridgeton, do you believe the given cost is variable, fixed, or something else? Why? (Use information or evidence from the case to support your evaluation, if possible. For most of these costs, there is no single right answer from the case information, so the goal is to come up with a reasonable estimate.)
-Who is the decision maker? (Remember: in analyzing a case you have to put yourself in the position of the decision maker and try to figure out what YOU would do in his/her position).
In the Illustrated Excel Module 1 SAM project, Katherine is deciding which one of her two fast food restaurants to invest in. Students determine which restaurant is the most profitable through calculating the total profit from each type of sandwich and burger, along with the difference in profits between both restaurants. To work through the problem, students utilize function-based equations, formatting tools, and display settings. From this project, they learn how to determine what factors should be considered when investing in a company or product and what influences total profit.
Apply a simple decision making technique to evaluate options to arrive at the best solution (24 marks)
Let us talk about the first spreadsheet for each option. Each sheet is setup in a five year period and broken down into three main parts each. The first part is called the revenue this breaks down the money coming labeled as sales and the