Question Details

(solution) Advanced Excel. Related with Goal Seek & Tree-Diagram Needs to be


Advanced Excel. 

Related with Goal Seek & Tree-Diagram

Needs to be detailed


ITM 501: Decision Analysis

 

Homework Assignment 1

 

Instructions:

 

- The assignment must be submitted through Blackboard.

 

- Submit one spreadsheet file named according to the following format:

 

<first name>_<last name>#1.xlsx (e.g. amir_gandomi #1.xlsx)

 

- Create one worksheet for each question which clearly shows your analysis. Use the question number

 

as the title of the worksheet.

 

- Create one separate titled ?Answers? that summarizes all the answers in one single table.

 

- Submissions that do not conform to these guidelines are subject to penalty.

 

- Late submission penalty: 0.0694% per minute! Questions:

 

ABC Enterprise Solutions is the provider of hosted solutions for Small to Medium Enterprises (SMEs).

 

The headquarters are in Mississauga, ON, and they have clients across the globe. Currently, they are

 

charging a $95 weekly fee for their CRM services that they offer to 400 of their clients. They have

 

recently been contacted by their software vendor, and been told that, with an $180,000 upgrade on their

 

hardware and CRM software platform, they can substantially improve their direct marketing offerings.

 

The new system will cost them nothing beyond the initial cost, but they will have to increase the

 

number of their maintenance and support staff from 11 to 14 to be able to comply with their service

 

level agreements. The maintenance staff is paid $800 weekly.

 

Using the Goal Seek analysis feature of MS Excel, answer the following question:

 

1. The management thinks the upgrade will cause the demand (# of clients) to grow uniformly

 

(same percentage every week). What level of weekly demand increase (percentage) would

 

justify the investment if ABC wants to break even (reach the status quo profit levels) after 2

 

years (104 weeks)?

 

ABC has learnt that there are talks about a bill in the US that will change the regulation on trans-border

 

data flow. Since a good portion of their clients are in the US, this concerns ABC. The new regulation:

 

a. May be stricter than the current one and cause ABC to lose 25% of their clientele (with a

 

linear weekly decline, i.e. same amount every week) in a year until the demand stabilizes at

 

that level (unfavorable situation: UF); (Hint: Demand in Week 0 is 400, it declines to 300 in

 

Week 52 and remains 300 until the end of week 156).

 

b. May not impact ABC at all (Neither favorable nor unfavorable situation: N); ITM501 Amir Gandomi, Ph.D. Page 1 of 2 c. May actually be advantageous and let the company increase the size of their clientele by

 

30% in 2 years (with a linear weekly growth), and after that the demand stays at that level

 

(favorable situation: F).

 

Note that ABC currently has 400 clients whom are being charged $95 weekly. ABC also believes that

 

this bill is the only foreseeable event that will affect their future demand (i.e. ignore the analysis you

 

did in Question 1). Due to changing demand, their estimated annual operating expenses are $500,000,

 

$600,000, and $800,000 respectively for the UF, N, and F situations.

 

Meanwhile, a larger company impressed by ABC?s continued success has approached them and offered

 

$1,300,000 a year to acquire their CRM business.

 

ABC does not have the luxury to wait until the bill passes the congress to make a decision on whether

 

to sell their business or not. Therefore, they need to analyze their options and act before the bill is voted

 

on. Your task is to help ABC analyze the problem. Use the profits for the next 3 years as the pay-off.

 

2. Construct the payoff table.

 

3. If ABC wants to be pessimistic, what decision-making method should they use? Why?

 

According to the method(s) chosen, what alternative (i.e., do nothing or sell the CRM business)

 

would they decide on?

 

4. If ABC wants to be risk neutral, what decision-making method should they use? Why?

 

According to the method(s) chosen, what alternative would they decide on?

 

5. If ABC wants to be optimistic, what decision-making method should they use? Why? According

 

to the method(s) chosen, what alternative would they decide on?

 

6. If the probabilities for the three different scenarios are: Pr(UF)=0.5, Pr(N)=0.4, and Pr(F)=0.1,

 

what should ABC do? Why? (Create a decision tree using TreePlan to answer this question)

 

7. According to the scenario in question 6, what is value of perfect information (to disclose in

 

certain terms what the bill would be like) for ABC? ITM501 Amir Gandomi, Ph.D. Page 2 of 2

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001001287.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now