# Complete the listed excercises by date

Assignment 2: Problems

Exercises

From your textbook, Statistics for Management and Economics,
complete the following exercises:

“Decision Analysis”: Exercises 22.2 and 22.11

Write your answers in a Microsoft Excel workbook, with each
problem on a separate worksheet. Label each tab in the workbook with the
exercise number. Highlight the answers in yellow and provide an interpretation
in a text box.

Name your Microsoft Excel workbook
SU_MBA5008_W6_A2_LastName_FirstInitial.xls.

Submit your workbook to this W6: Assignment 2 Dropbox
by Wednesday, March 30, 2016.

Cite any sources using the APA format on a separate page.

·
22.1 Set up the opportunity loss table from the following
payoff table:

 a1 a2 s1 55 26 s2 43 38 s3 29 43 s4 15 51

·
22.2 Draw the decision tree for Exercise 22.1.

·
22.11 The owner of a clothing store must decide how many men’s
shirts to order for the new season. For a particular type of shirt, she must
order in quantities of 100 shirts. If she orders 100 shirts, her cost is \$10
per shirt; if she orders 200 shirts, her cost is \$9 per shirt; and if she
orders 300 or more shirts, her cost is \$8.50 per shirt. Her selling price for
the shirt is \$12, but any shirts that remain unsold at the end of the season
are sold at her famous “halfprice, end-of-season sale.” For the sake of
simplicity, she is willing to assume that the demand for this type of shirt
will be 100, 150, 200, or 250 shirts. Of course, she cannot sell more shirts
than she stocks. She is also willing to assume that she will suffer no loss of
goodwill among her customers if she understocks and the customers cannot buy
all the shirts they want. Furthermore, she must place her order today for the
entire season; she cannot wait to see how the demand is running for this type
of shirt.

o  a. Construct the
payoff table to help the owner decide how many shirts to order.

o  b. Set up the
opportunity loss table.

o  c. Draw the
decision tree.

Assignment 3: Final Project

In the previous weeks, you used the
sample dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing
area so as to conduct various analyses. This is similar to providing business
analytics support on an ongoing basis and entails answering (by means of
analysis) many different questions.

Summarize your findings and draw
conclusions. Create a final report document containing the following:

• Executive summary: This section should be a 1-page
summary of the most important findings presented in the context of the
recommended course of action.
• Data and methodology: In this section, describe the
characteristics of the data and the specific methodologies used in the
analysis.
• Analytic details: This section should contain
supporting evidence for the findings and conclusions presented in the
executive summary section.

Create your report in a 3- to 4-page
Microsoft Word document.