21 st Century Schools

Assignment Help Services

  • Home
  • About Us
  • Returning Client
  • Order Form
  • Contact Us
  • Blog

ASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKING

March 18, 2016 By George Leave a Comment

Scenario: You are the VP of Franchise services for the Happy Buns Restaurant. You have been assigned the task of evaluation the best location for the next HB that a prospective franchisee has suggested in the Columbus, Ohio, area. You are using the standard template that provides for which criteria (attributes) you should evaluate. But the specific weights for these are open to adjustment depending on the specific area. These are the six criteria that you will use to evaluate this decision.

Close to drive through traffic – traffic counts (avg. thousands/day)
Property cost/investment and taxes = NPV of investment ($$)
Size of building (square feet in thousands)
Size of parking (max number of customers parking)
Insurance costs (thousands $ per year)
Ease of access from streets (subjective evaluation from observation)
There are five possible locations. You have collected the data from various sources including your VP Finance, Real estate agents, etc. This document summarizes the raw data for each of the five locations: Abberton, Bellview, Casstown, Denton, and Eddington, all suburbs of Columbus. See Data Below.

Assignment

Review the information and data regarding the different alternatives for restaurant location. Develop a MADM table with the raw data. Convert the raw data to utilities (scaled on 0 to 1). Determine the relative weights of each criteria. Evaluate the Decision Table for the best alternative. Do a sensitivity analysis.

Write a report to your boss, Executive VP. Explain your analysis and your recommendation. Provide a rationale for your decision including the logic you used to determine your weights.

Data

Download this Word doc with the data: Happy Buns Raw Data.docx
Upload both your written report and Excel file to the SLP 1 Dropbox.

SLP Assignment Expectations
Analysis

Accurate, complete analysis (in Excel and Word) using the MADM model and theory.
Written Report

Length requirements = 2–3 pages minimum (not including Cover and Reference pages)
Provide a brief introduction/ background of the problem.
Complete and accurate Excel analysis.
Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.
Complete, meaningful, and accurate recommendation(s).
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!

Order Now

Related Posts

  • ASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKINGASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKING
  • Topic: BUS520-SLP1Topic: BUS520-SLP1
  • Topic: BUS520-SLP1Topic: BUS520-SLP1
  • ASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKINGASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKING
  • ASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKINGASSUMED CERTAINTY: PIVOT TABLES AND MULTI-ATTRIBUTE DECISION MAKING
  • Topic: BUS520-SLP1Topic: BUS520-SLP1

Filed Under: Uncategorized

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Payment System

Payment System

Order Process

Order Process

Disclaimer

The Company offers custom writing and research services to its customers for limited use only as provided in its Terms and Conditions. It does give consent or authority to the client to copy or reproduce any portion of the term paper, research paper, thesis paper, essay, dissertation or other products of the Company without proper reference. In addition, the Company will not be responsible to third parties for the unauthorized use of its product

Copyright © 2019 · Log in