Cashback Offer (1st - 15th October 2020). Get Flat 10% Cashback credited in your account on a minimum transaction of $80. Post Your Question

Question DetailsNormal
$ 15.00

Test Bank for Practical Management Science 5th Edition by Winston

Question posted by
Online Tutor Profile
Online
request

Test Bank for Practical Management Science 5th Edition by Winston

 

 

1.            Which of the following is not one of the components of a mathematical model?

a.            Inputs

b.            Outputs

c.             Decision variables

d.            None of these options

ANSWER:

POINTS:               1

 

2.            Which of the following is not one of the features that can improve the readability of a spreadsheet model?

a.            Formatting features

b.            Data tables

c.             Cell comments

d.            Text Boxes ANSWER: POINTS:    1

 

3.            Which of the following is a useful tool for investigating what-if questions?

a.            Data tables

b.            VLOOKUP function

c.             Formula auditing

d.            SUMPRODUCT function

ANSWER:

POINTS:               1

 

4.            The Excel tool for solving one equation with one unknown is:

a.            Solver

b.            Goal Seek

c.             Trend function

d.            NPV function ANSWER: POINTS:               1

 

5.            Which of the following is a useful tool for understanding and troubleshooting a spreadsheet model?

a.            Data tables

b.            VLOOKUP function

c.             Formula auditing

d.            SUMPRODUCT function

ANSWER:

POINTS:               1

 

6.            Which of the following is not one of the required arguments for a VLOOKUP function?

 

a.            The lookup table range

b.            The value you want to compare to the values in the left column of the table

c.             The index of the column you want the returned value to come from

d.            TRUE (for an approximate match) or FALSE (for an exact match)

 

 

ANSWER:

POINTS:               1

 

7.            Estimating the relationships between variables in a spreadsheet model can be done using:

a.            data tables

b.            Goal Seek

c.             the VLOOKUP function

d.            curve fitting ANSWER: POINTS:  1

 

8.            Which of the following is not one of the types of curve fitting models available in Excel's Trendline tool?

a.            Exponential

b.            Linear

c.             Interpolation

d.            Power ANSWER: POINTS: 1

 

9.            An important property of the exponential function is that:

a.            if x changes by 1 unit, then y changes by a constant percentage that is approximately equal to the model constant b times 100%

b.            if x changes by 1 unit, then y changes by a constant percentage that is approximately equal to the model constant b%

c.             if x changes by 1%, then y changes by a constant percentage that is approximately equal to the model constant

b times 100%

d.            if x changes by 1%, then y changes by a constant percentage that is approximately equal to the model constant

b% ANSWER: POINTS:    1

 

10.          To evaluate which of a set of curves fits the data best, we can use:

a.            APE

b.            MAPE

c.             R2

d.            NPV ANSWER: POINTS: 1

 

11.          Much of the power of spreadsheet models derives from their flexibility.

a.            True

b.            False ANSWER:POINTS: 1

 

12.          A shortcut for establishing absolute references is pressing the F9 key.

 

 

a. True b. False ANSWER:

 

13.          A chart is typically much more informative to a business manager than the table of numbers it is based on.

a.            True

b.            False ANSWER:

14.          Many models are built for the purpose of permitting experimentation with various scenarios.

a.            True

b.            False ANSWER:POINTS: 1

 

15.          Goal Seek is a means for answering a large number of what-if questions quickly and easily.

a.            True

b.            False ANSWER: POINTS:                1

 

16.          In Excel terminology, the unknown value used in Goal Seek is called the input cell.

a.            True

b.            False ANSWER: POINTS:                1

 

17.          Trace Dependents and Trace Precedents are Formula Auditing commands.

a.            True

b.            False ANSWER:POINTS: 1

 

18.          The NPV function takes two arguments; the discount rate and the number of time periods in the model.

a.            True

b.            False ANSWER: POINTS:                1

 

19.          In general, any cash flow occurring at the beginning of the first time period must be placed outside the NPV function.

a.            True

b.            False

ANSWER:

 

 

POINTS:               1

 

20.          The HLOOKUP function works exactly the same as the VLOOKUP function, except the lookup table is arranged in columns instead of rows.

a. True b. False ANSWER: POINTS:            1

 

Exhibit 2-1

A t-shirt company is planning a production run for an event where the attendance (and thus demand for t-shirts) is uncertain. The event planners have indicated that they think the attendance will be 500, 750 or 1000, with probabilities of 30%, 50% and 20% respectively. The company must pre-order the blank t-shirts (cost=$5 per shirt) and it can sell finished shirts for $12 apiece. Any finished shirts that cannot be sold at the event can be sold for $2 apiece to a used clothing vendor.

21.          Refer to Exhibit 2-1. What Excel function is useful for calculating the expected value of demand for t-shirts? What is the expected demand?

ANSWER:

22.          Refer to Exhibit 2-1. What Excel function is useful for calculating revenue? Explain why it is useful.

ANSWER: POINTS:           1

 

23.          Refer to Exhibit 2-1. What are the two possible cases for the amount of t-shirts that will be sold to the used clothing vendor? How would you calculate this amount in a spreadsheet model?

ANSWER: POINTS:           1

 

24.          Refer to Exhibit 2-1. Suppose that blank t-shirts can only be ordered from the wholesale vendor in batches of 100? How many t-shirts should the company order?

ANSWER: POINTS:           1

 

25.          Refer to Exhibit 2-1. Suppose now that blank t-shirts can only be ordered from the wholesale vendor in batches of 50? How many t-shirts should the company order?

ANSWER: POINTS:           1

 

Exhibit 2-2

A small sporting goods company is considering investing $2000 in a project at the start of year 1 that will produce volleyballs over the next five years. The company plans to produce and sell 200 volleyballs in the first year, and expects that volume to grow by 10% each year thereafter. The unit selling price forecast the company has developed is $20 in year 1, $22 in year 2, $25 in year 3, $28 in year 4, and $31.50 in year 5. Variable costs are forecast to be $15 per unit produced, and there will be a fixed overhead cost in each year of $500.  (Unless otherwise indicated, assume that all cash flows occur at the end of the year.)

26.          Refer to Exhibit 2-2. Use the above information to develop a simple cash flow proforma sheet, and then apply Excel's NPV function to calculate the project value assuming a 10% discount rate. What is your answer?

ANSWER: POINTS:           1

 

27.          Refer to Exhibit 2-2. Suppose the company thinks it may be able to produce and sell more than currently planned. What growth rate of production would produce an NPV of $10,000?

ANSWER: POINTS:           1

 

28.          Refer to Exhibit 2-2. Suppose instead that the company thinks it can reduce its variable cost rate. What rate would produce an NPV of $10,000?

ANSWER: POINTS:           1

 

29.          [Part 1] Refer to Exhibit 2-2. Use the graphing function in Excel to construct a scatterplot of forecasted price versus time, and fit a linear trendline to the data. What are the coefficients of the linear model, and what is the MAPE of a linear model forecast, compared to the company's forecast?

ANSWER: POINTS:           1

 

30.          [Part 2] Refer to Exhibit 2-2. Use the same scatterplot constructed for the previous question, fit an exponential trendline to the data. What are the coefficients of the exponential model, and what is the MAPE of an exponential model forecast, compared to the company's forecast?

ANSWER: POINTS:           1

 

 

Available Answer
$ 15.00

[Solved] Test Bank for Practical Management Science 5th Edition by Winston

  • This solution is not purchased yet.
  • Submitted On 05 Oct, 2019 01:46:12
Answer posted by
Online Tutor Profile
Online
solution
Test Bank for Practical Management Science 5th Edition by Winston 1. Which of the following is not one of the components of a mathematical model? a. Inputs b. Outputs c. Decision variables d. None of these options ANSWER: d POINTS: 1 2...
Buy now to view the complete solution
Other Similar Questions
User Profile
Tutor...

Test Bank CHAPTER 24 FULL DISCLOSURE IN FINANCIAL REPORTING

Test Bank CHAPTER 24 FULL DISCLOSURE IN FINANCIAL REPORTING d 21. Disclosure of significant accounting policies. c 22. Disclosure of inventory accounting policy. c 23. Definition of errors and irregularities. d S24. Fu...
User Profile
Tutor...

Test Bank CHAPTER 23 STATEMENT OF CASH FLOWS

Test Bank CHAPTER 23 STATEMENT OF CASH FLOWS c 21. Objective of the statement of cash flows. c 22. Primary purpose of the statement of cash flows. c S23. Answers provided by the statement of cash flows. b S24. First st...
User Profile
Tutor...

Test Bank CHAPTER 22 ACCOUNTING CHANGES AND ERROR ANALYSIS

Test Bank CHAPTER 22 ACCOUNTING CHANGES AND ERROR ANALYSIS b 21. Accounting changes and consistency concept. b 22. Identify changes in accounting principle. c 23. Identify a non-retrospective change. d 24. Identify a c...
User Profile
Tutor...

Test Bank Chapter 21 Accounting for Leases.

Test Bank Chapter 21 Accounting for Leases. d 21. Advantages of leasing. d 22. Advantages of leasing. b 23. Basic principle of lease accounting. c 24. Conceptual support for treating all leases as a sale/purchase. a ...
User Profile
Tutor...

Test Bank Chapter 20 Accounting for Pensions and Postretirement Benefits.

Test Bank Chapter 20 Accounting for Pensions and Postretirement Benefits. d 21. Factors considered by actuaries. c 22. Process of funding a pension plan. d 23. Accounting problems in pension plans. c 24. Nature of a d...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35