Module 1 – CaseASSUMED CERTAINTY: PIVOT TABLES AND MULTIATTRIBUTE DECISION
MAKINGPivot Tables and Pivot ChartsAssignment OverviewYou are the lead consultant for the Excellent Consulting
Group. It is midOctober. One of your top clients, Buddyâs Floor Barn, has just
closed the books for the first three quarters of the year (January through
September). Buddyâs Floor Barn requests that you analyze the sales performance
of its 5 product lines over this 3quarter period. From past consulting work
you have done for the company, you know that Buddyâs Floor Barn has 4 regions
and 18 total store locations.Each Regional Manager at the company has compiled the data
for his/her region. The raw data provided consists of the sales revenue for
each of the 5 premium flooring lines for all 4 regions and 18 locations for the
first three quarters of the current year.Case AssignmentThe data have been provided in list format. Generate a Pivot
Table Report with Charts. Use the Pivot Table and Charts to analyze the data.
Following your indepth analysis of the data, write a report to Buddyâs Floor
Barn in which you discuss and analyze the data, and make appropriate
recommendations relative to how Buddyâs Floor Barn should improve its sales
performance going forward.Assignment ExpectationsData: To begin, download the list data here: Data chart for
BUS520 Case 1Excel Analysis:Provide accurate and complete Excel analysis (Pivot Table
with Charts).Written report:Length requirement: 4â5 pages minimum (not including Cover
and Reference pages). NOTE: You must have 4â5 pages of written discussion and
analysis. This means you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Using the Pivot Table and Pivot Charts, discuss and analyze
the data, noting key highs and lows, trends, etc.Include charts from your Pivot Table to support your written
analysis. (Please do not use charts as âspace fillers.â Instead, use them
strategically to support your written analysis.)In a âRecommendationsâ section, give clear, specific, and
meaningful recommendations that Buddyâs Floor Barn should use to improve overall
company sales.Be sure to consider highs, lows, and trends in the data.
Which cities are the highest performers? Lowest? Which regions and quarter had
the highest sales? Lowest sales? Consider what may be driving the numbers: Poor
marketing? Outstanding marketing strategies? Inventory management? Seasonal
sales? Other? There are innumerable possibilities. Your role is to reflect on
the data, and ultimately, to use the data to give useful recommendations.Module 1 – SLPASSUMED CERTAINTY: PIVOT TABLES AND MULTIATTRIBUTE DECISION
MAKINGAssumed Certainty: MultiAttribute Decision Making (MADM)Scenario: You are the Vice President of Franchise Services
for the Happy Buns restaurant chain. You have been assigned the task of
evaluating the best location for a new Happy Buns restaurant. The CFO has
provided you with a template that includes 6 criteria (attributes) that you are
required to use in your evaluation of 5 recommended locations. Following are
the 6 criteria that you will use to evaluate this decision:Traffic counts (avg. thousands/day)âthe more traffic, the
more customers, and the greater the potential sales. Building lease and taxes (thousands $ per year)âthe lower
the building lease and taxes, the better.Size of building (square feet in thousands)âa larger
building is more preferable.Parking spaces (max number of customers parking)âmore
customer parking is preferable.Insurance costs (thousands $ per year)âlower insurance costs
are preferable.Ease of access (subjective evaluation from observation)âyou
will need to âcodeâ the subjective data. Use Excellent = 4, Good = 3, Fair = 2,
and Poor = 1.Now that you have collected the data from various sources
(your CFO and COO, local real estate listings, personal observation, etc.), you
have all the data you need to complete an analysis for choosing the best
location. Download the raw data for the 5 locations in this Word document:
BUS520 SLP1V1.docxAssignmentReview the information and data regarding the different
alternatives for a new restaurant location.Then do the following in Excel:Table 1: Develop an MADM table with the raw data.Table 2: Convert the raw data to utilities (scaled on 0 to
1). Show the utility weights in a second table.Table 3: Develop a third table with even weights (16.7%) for
each variable.Evaluate Table 3 for the best alternative.Table 4: Complete a sensitivity analysis by assigning
weights to each variable.In a Word document, do the following:Discuss the process used to put together Tables 1â4 above.Provide the rationale you used for choosing for each of the
weights you used in Table 4.Give your recommendation of which location the company
should choose (based on results of Table 4).SLP Assignment ExpectationsExcel AnalysisComplete Excel analysis using MADM (all four tables noted
above must be included).Accurate Excel analysis (Excel file includes working
formulas showing your calculations; all calculations and results must be
accurate). Written ReportLength requirements: 2â3 pages minimum (not including Cover
and Reference pages). NOTE: You must submit 2â3 pages of written discussion and
analysis. This means that you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Discuss the steps you used to compile the Excel analysis
(i.e., the four tables).Discuss the assumptions used to assign weights to each
variable of your sensitivity analysis (Table 4). That is, provide the rationale
for your choice of weights for each variable.Provide a complete and meaningful recommendation related to
the location that should be chosen as a new site.Upload both your Excel file and written Word report to the
SLP 1 Dropbox by the assignment due date.Module 2 – CaseRISK: FREQUENCY DISTRIBUTION, PROBABILITIES, AND EXPECTED
VALUERisk: Frequency Distribution, Probabilities, and Expected
ValueAssignment OverviewIn the Module 2 Case, you are again engaged on a consulting
basis by Buddyâs Floor Barn. This time, in order to get a better idea of what
might have motivated customersâ buying habits you are asked to analyze the ages
of the customers who have purchased oak flooring over the past 12 months. Past
research done by the Excellent Consulting Group has shown that different age
groups buy certain products for different reasons. Buddyâs Floor Barn has sent
a survey to 200 customers who have previously purchased oak premium flooring,
and 124 customers have responded. The survey includes age data of past
customers who purchased oak flooring in the past year. Case AssignmentUsing Excel, create a frequency distribution (histogram) of
the age data that was captured from the survey. You should consider the width
of the age categories (e.g., 5 years, 10 years, or other). That is, which age
category grouping provides the most useful information? Once you have created
this histogram, determine the mean, median, and mode.After you have reviewed the data, write a report to your
boss that briefly describes the results that you obtained. Make a
recommendation on how this data might be used for marketing purposes.Data: Download the Excelbased data file with the age data
of the 124 customers: Data chart for BUS520 Case 2. Use these data in Excel to
create your histogram.Assignment ExpectationsExcel AnalysisAccurate and complete analysis in Excel using the Histogram
function.Written ReportLength requirements: 4â5 pages minimum (not including Cover
and Reference pages). NOTE: You must submit 4â5 pages of written discussion and
analysis. This means that you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Provide a written analysis that supports your Histogram age
groups (bins). Based on your analysis of the histogram data, provide
complete and meaningful recommendations as the data relates to Buddyâs Floor
Barn marketing strategy.Module 2 – SLPRISK: FREQUENCY DISTRIBUTION, PROBABILITIES, AND EXPECTED
VALUERisk: Probabilities and Expected ValueScenario: You work for a private investment company that
currently has numerous business investments in real estate development,
restaurant franchises, and retail chains. Following an exhaustive search for
new investment opportunities, you have found three possible alternatives, each
of which will pay off in exactly 10 years from the date of initial investment.
Because you only have enough money to invest in one of the three options, you
recognize that you will need to complete a quantitative comparison of the three
alternatives:Option A: Real estate development.Option B: Investment in the retail franchise âJust Hats,â a
boutique that sells hats for men and women.Option C: Investment in âCupcakes and so forth,â a franchise
that sells a wide variety of cupcakes and a variety other desserts.Download the raw data for the three investments in this
Excel document: Raw data for BUS520 SLP 2AssignmentDevelop an analysis of these three investments in Excel. Use
expected value to determine which of the three alternatives you should choose.Write a report to your private investment company,
explaining your Excel analysis, giving your recommendation, and justifying your
decision.SLP Assignment ExpectationsExcel AnalysisUsing Excel, make an accurate and complete analysis of the
three investment alternatives.Written ReportLength requirements: 2â3 pages minimum (not including Cover
and Reference pages). NOTE: You must submit 2â3 pages of written discussion and
analysis. This means that you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Discuss the steps you used in completion of your Excel
analysis.Based on your Excel analysis, give your recommendation as to
which of the three investment alternatives should be pursued.Upload both your written report and Excel file to the SLP 2
Dropbox.Module 3 – CaseLINEAR REGRESSION FORECASTING AND DECISION TREESLinear Regression ForecastingAssignment OverviewScenario: You are a consultant who works for the Excellent
Consulting Group. Your client, the ABC Furniture Company, believes that there
may be a relationship between the number of customers who visit the store
during any given month (âcustomer trafficâ) and the total sales for that same
month. In other words, the greater the customer traffic, the greater the sales
for that month. To test this theory, the client has collected customer traffic
data over the past 12month period, and monthly sales for that same 12month
period (Year 1).Case AssignmentUsing the customer traffic data and matching sales for each
month of Year 1, create a Linear Regression (LR) equation in Excel. Use the
Excel template provided (see âModule 3 Case â LR âYear 1â spreadsheet tab), and
be sure to include your LR chart (with a trend line) where noted. Also, be sure
that you include the LR formula within your chart.After you have developed the LR equation above, you will use
the LR equation to forecast sales for Year 2 (see the second Excel spreadsheet
tab labeled âYear 2 Forecastâ). You will note that the customer has collected
customer traffic data for Year 2. Your role is to complete the sales forecast
using the LR equation from Step 1 above.After you have forecast Year 2 sales, your Professor will
provide you with 12 months of actual sales data for Year 2. You will compare
the sales forecast with the actual sales for Year 2, noting the monthly and
average (total) variances from forecast to actual sales.To complete the Module 3 Case, write a report for the client
that describes the process you used above, and that analyzes the results for
Year 2. (What is the difference between forecast vs. actual sales for Year 2âby
month and for the year as a whole?) Make a recommendation concerning how the LR
equation might be used by ABC Furniture Company to forecast future sales.Data: Download the Module 3 Case template here: Data chart
for BUS520 Case 3. Use this template to complete your Excel analysis.Assignment ExpectationsExcel AnalysisAccurate and complete Linear Regression analysis in Excel.Written ReportLength requirements: 4â5 pages minimum (not including Cover
and Reference pages). NOTE: You must submit 4â5 pages of written discussion and
analysis. This means that you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Your written (Word) analysis should discuss the logic and
rationale used to develop the LR equation and chart.Provide complete, meaningful, and accurate recommendation(s)
concerning how the ABC Furniture Company might use the LR equation to forecast
future sales. (For example, how reliable is the LR equation in predicting
future sales?) What other recommendations do you have for the client?Module 3 – SLPLINEAR REGRESSION FORECASTING AND DECISION TREESDecision TreesScenario: You are a consultant who works for the Excellent
Consulting Group. You have learned about three different investment
opportunities and need to decide which one is most lucrative. Following are the
three investment options and their probabilities:Option A: Real Estate development. This is a risky
opportunity with the possibility of a high payoff, but also with no payoff at
all. You have reviewed all of the possible data for the outcomes in the next 10
years and these are your estimates of the cash payoff and probabilities:Required initial investment: $0.75 millionHigh NPV: $5 million, Pr = 0.5Medium NPV: $2 million, Pr = 0.3Low NPV: $0, Pr = 0.2Option B: Retail franchise for Just Hats, a boutiquetype
store selling fashion hats for men and women. This also is a risky opportunity
but less so than Option A. It has the potential for less risk of failure, but
also a lower payoff. You have reviewed all of the possible data for the
outcomes in the next 10 years and these are your estimates of the payoffs and
probabilities:Required initial investment: $0.55 millionHigh NPV: $3 million, Pr = 0.75Medium NPV: $2 million, Pr = 0.15Low NPV: $1 million, Pr = 0.1Option C: High Yield Municipal Bonds. This option has low
risk and is assumed to be a Certainty. So there is only one outcome with
probability of 1.0:Required initial investment: $0.75 millionNPV: $1.5 million, Pr = 1.0AssignmentDevelop an analysis of these three investments, and
determine which of them you should choose. Be sure to account for cash paid for
each of the three alternatives. If you do not recall how to do this, review the
practice exercises in the Background page. Do your analysis in Excel using the
Decision Tree addin.Write a report to your private investment company and
explain your analysis and your recommendations. Provide a rationale for your
decision.Upload both your written report and Excel file with the
decision tree analysis to the SLP 3 Dropbox.SLP Assignment ExpectationsAnalysisAccurate and complete Excel analysis.Written ReportLength requirements: 2â3 pages minimum (not including Cover
and Reference pages)Provide a brief introduction to/background of the problem.Written analysis that supports Excel analysis and provides
thorough discussion of assumptions, rationale, and logic used.Complete, meaningful, and accurate recommendation(s).Module 4 – CaseRISK: EXPONENTIAL SMOOTHING FORECASTING AND VALUE OF
INFORMATIONRisk: Simple Exponential Smoothing (SES)Assignment OverviewScenario: You are a consultant for the Excellent Consulting
Group (ECG). You have completed the first assignment, developing and testing a
forecasting method that uses Linear Regression (LR) techniques (Module 3 Case).
However, the consulting manager at ECG wants to try a different forecasting
method as well. Now you decide to try Single Exponential Smoothing (SES) to
forecast sales.Case AssignmentUsing this Excel template: Data chart for BUS520 Case 4, do
the following:Calculate the MAPE for Year 2 Linear Regression forecast
(use the first spreadsheet tab labeled âYear 2 Forecast â MAPEâ).Calculate forecasted sales for Year 2 using SES (use the
second spreadsheet tab labeled âSES â MAPEâ). Use 0.15 and 0.90 alphas.Compare the MAPE calculated for the LR forecast (#1 above)
with the MAPEs calculated using SES.Then write a report to your boss in which you discuss the
results obtained above. Using calculated MAPE values, make a recommendation
concerning which method appears to be more accurate for the Year 2 data: SES or
Linear Regression.Assignment ExpectationsAnalysisAccurate and complete SES analysis in Excel.Written ReportLength requirements: 4â5 pages minimum (not including Cover
and Reference pages). NOTE: You must submit 4â5 pages of written discussion and
analysis. This means that you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Complete a written analysis that supports your Excel
analysis, discussing the assumptions, rationale, and logic used to complete
your SES forecast.Give complete, meaningful, and accurate recommendation(s)
relating to whether LR or SES is more accurate in predicting sales.Module 4 – SLPRISK: EXPONENTIAL SMOOTHING FORECASTING AND VALUE OF
INFORMATIONRisk: The Value of InformationScenario: Using the same situation from the Module 3 SLP,
recall that you are deciding among three investments. You have heard of an
expert who has a highly reliable âtrack recordâ in the correct identification
of favorable vs. unfavorable market conditions. You are now considering whether
to consult this âexpert.â Therefore, you need to determine whether it would be
worth paying the expertâs fee to get his prediction. You recognize that you
need to do further analysis to determine the value of the information that the
expert might provide.In order to simplify the analysis, you have decided to look
at two possible outcomes for each alternative (instead of three). You are
interested in whether the market will be Favorable or Unfavorable, so you have
collapsed the Medium and Low outcomes. Here are the three alternatives with
their respective payoffs and probabilities.Option A: Real estate development. This is a risky
opportunity with the possibility of a high payoff, but also with no payoff at
all. You have reviewed all of the possible data for the outcomes in the next 10
years and these are your estimates of the Net Present Value (NPV) of the
payoffs and probabilities:High/Favorable NPV: $7.5 million, Pr = 0.5Unfavorable NPV: $2.0 million, Pr = 0.5Option B: Retail franchise for Just Hats, a boutiquetype
store selling fashion hats for men and women. This also is a risky opportunity
but less so than Option A. It has the potential for less risk of failure, but
also a lower payoff. You have reviewed all of the possible data for the
outcomes in the next 10 years and these are your estimates of the NPV of the
payoffs and probabilities.High/Favorable NPV: $4.5 million, Pr = 0.75Unfavorable NPV: $2.5 million, Pr = 0.25Option C: High Yield Municipal Bonds. This option has low
risk and is assumed to be a Certainty. So there is only one outcome with
probability of 1.0:NPV: $2.25 million, Pr = 1.0You have contacted the expert and received a letter stating
his track record which you have checked out using several resources. Here is
his stated track record:True State of the MarketExpert PredictionFavorableUnfavorablePredicts âFavorableâ.9.3Predicts âUnfavorableâ.1.7You realize that this situation is a bit complicated since
it requires the expert to analyze and predict the state of two different
markets: the real estate market and the retail hat market. You think through
the issues of probabilities and how to calculate the joint probabilities of
both markets going up, both going down, or one up and the other down. Based on
your original estimates of success, here are your calculations of the single
probabilities and joint probabilities of the markets.ProbabilitiesFavorableUnfavorableA: Real Estate0.500.50B: Just Hats0.750.25Joint ProbabilitiesA Fav, B Fav (A+, B+)0.375A Unf, B Unf (A, B)0.125A Fav, B Unf (A+, B)0.125A Unf, B Fav (A, B+)0.375Finally, after a great deal of analysis and calculation, you
have determined the Posterior probabilities of Favorable and Unfavorable
Markets for the Real Estate business and the boutique hat business.Real EstateJust Hats FUFU0.45says “F/F”0.750.250.900.100.15says “F/U”0.750.250.300.700.30says “U/F”0.1250.8750.900.100.10says “U/U”0.1250.8750.300.70For example, this table says that there is 45% chance that
the expert will predict Favorable for both markets (F/F), and when he makes
this prediction, there is a 75% chance that the Real Estate market will be
favorable and 25% chance that it wonât, and also a 90% chance that the Hat
market will be Favorable and 10% chance it wonât.You have developed a Decision Tree showing the original
collapsed solution and also showing an expanded Decision Tree for evaluating
the value of the expertâs information. You need to enter the probabilities into
this tree to see if the expertâs information will increase the overall expected
value of your decision. Download the Excel file with the incomplete Decision
Tree: Decision Tree for BUS520 SLP 4AssignmentComplete the information in the Decision Tree in the Excel
file. Determine the Expected NPV of the decision if you were to consult the
Expert. Does use of the Expert increase the value of your analysis? If so, by
how much?Write a report to your private investment company and
explain your analysis and your recommendation. Provide clear rationale/
justification for your decision.Upload both your written report and Excel file with the
Decision Tree analysis to the SLP 4 Dropbox.SLP Assignment ExpectationsAnalysisAccurate and complete analysis in Excel.Required:Length requirements: 2â3 pages minimum (not including Cover
and Reference pages). NOTE: You must submit 2â3 pages of written discussion and
analysis. This means that you should avoid use of tables and charts as âspace
fillers.âProvide a brief introduction to/background of the problem.Written analysis that supports Excel analysis and provides
thorough discussion of assumptions, rationale, and logic used.Complete, meaningful, and accurate recommendation(s).Module 1 discussion Bounded Rationality Explain what Bounded Rationality is. Then discuss how this
concept can affect the decision situation in SLP 1. Also discuss how this
concept can affect the data analysis in Case 1. Explain your logic for both of
your arguments. Are there any similarities between these two situations?Week 1: Provide your initial discussion post to the
question. Be sure to include references to any resources you used. You should
use at least one resource to help you with your initial discussion.Week 2: Respond to at least two of your classmatesâ initial
posts. Your response should be substantive and further the discussion. It is OK
to be critical and use critical thinking. That means you can question what your
classmates say. Do they provide their own critical thinking and logic?Module 2 discussion Estimating Probabilities: Availability BiasOne of the biases that has been proposed by Kahneman and
Tversky and researched a great deal is the Availability bias. What is the
Availability bias? How might it play a role in the decision in SLP 2? Consider
that the estimated probabilities for both of the High NPV future states are
relatively high (0.50 and 0.75). How could the Availability bias be at work
here? How could using objective data analysis like frequency distributions
mitigate the effect of the Availability bias?Week 1: Provide your initial discussion post to the
question. Be sure to include references to any resources you used. You should
use at least one resource to help you with your initial discussion.Week 2: Respond to at least two of your classmatesâ initial
posts. Your response should be substantive and further the discussion. It is OK
to be critical and use critical thinking. That means you can question what your
classmates say. Do they provide their own critical thinking and logic?Module 3 discussion Anchoring BiasWhat is the Anchoring bias? How might is play a role in the
decision in SLP 2/SLP 3? In what way might this bias cause error in the
estimation of the probabilities? How could you mitigate the effect of this
bias?Week 1: Provide your initial discussion post to the
question. Be sure to include references to any resources you used. You should
use at least one resource to help you with your initial discussion.Week 2: Respond to at least two of your classmatesâ initial
posts. Your response should be substantive and further the discussion. It is OK
to be critical and use critical thinking. That means you can question what your
classmates say. Do they provide their own critical thinking and logic?Module 4 discussion HeuristicsWhat is the definition of a heuristic decision method? What
might be a heuristic method for hiring someone? Explain and justify your logic.Week 1: Provide your initial discussion post to the
question. Be sure to include references to any resources you used. You should
use at least one resource to help you with your initial discussion.Week 2: Respond to at least two of your classmatesâ initial
posts. Your response should be substantive and further the discussion. It is OK
to be critical and use critical thinking. That means you can question what your
classmates say. Do they provide their own critical thinking and logic?Module 4 Reflective discussion And Finally, We Reflect Back on the CourseAs you complete this course, reflect back and answer these
questions: What two concepts do you think are the most relevant to the
business and your MBA degree and why? Which one or two concepts do you think are the least
relevant to the business and your MBA degree and why? Which concepts did you find particularly difficult to learn
and why?
Our Service Charter

Excellent Quality / 100% PlagiarismFree
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarismfree. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers. 
Free Revisions
We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed. 
Confidentiality / 100% No Disclosure
We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service. 
Money Back Guarantee
If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 1430 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% moneyback in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit. 
24/7 Customer Support
We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.