URGENT!! Who can help with excel exam 20 min from now?

i have a now at 8:00 am (eastern time) on 6/12. its based on excel, i will have 3 questions and i want you to solve it and send it to me within 50 min.(within 50 min).I’m going to provide a previous exam for clarification.Hello, now I am gonna send you the exam at 8:00 am(Eastern time) and I want you to solve it immediately and send it to me within an hour maximum, please make sure to do it the best way possible and send it to me.Best regards.
q3.xls

q1.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
URGENT!! Who can help with excel exam 20 min from now?
Just from $13/Page
Order Essay

q_1.xlsx

q_1_2.xlsx

q2.xlsx

Unformatted Attachment Preview

Terminal
Warehouse
St. Louis Atlanta
New York
Charlotte
1800
2100
1600
Memphis
1000
700
900
Louisville
1400
800
2200
Number of Trucks to assign 11.11111 7.777778
10
11
7
10
Demand
Cost
Total Cost
Ordering COST
Ordering cost for 200 quantities
Price
Total cost
Total Cost for 1000
1000
$50
$50,000
$12.50
$2,500.00
$48.50
$12,200.00
$62,500
The Compnay Should Order the 200 impellers and get the 3% discount
You have just inherited a small amount and would like to invest it. Your choices are stocks, bonds or money market. You can o
The returns for each type of investment relative to the state of the economy are:
Investment
Strong Economy
Average Economy
Weak Economy
Stocks
12%
6%
-10%
Bonds
7%
4%
1%
Money Market
4%
3%
2%
Assuming you can only pick one investment option, which investment would you choose based on the following crite
a) Maximax
b) Maximin
c) Equally Likely
d) Hurwicz with an alpha value of 0.5
e) Minimax Regret
Maximax
Under this approach, we will find the maximum payoff for each investment. Then we will select maximum of maximum payo
2%). The optimum decision according to maximax criteria is investing in Stocks and the payoff of the decision is 12%
Maximin
Under this approach, we will find the minimum payoff for each investment. Then we will select maximum of minimum payof
10%). The optimum decision according to maximin criteria is investing in Stocks and the payoff of the decision is 4%
Equally like criteria
We will calculate the weighted payoff using the following formula:Weighted payoff =
Payoff (stocks)/3 + Payoff (Bonds)/3 + Payoff (Money market)/3
Investment
Stocks
Bonds
Money Market
Strong Economy
12%
7%
4%
Average Economy
6%
4%
3%
Weak Economy
-10%
1%
2%
Now we will select maximum of weighted payoffs i.e. Bonds
Investing in bonds is the best decision according to equal likelihood criteria
Minimax Regret
Weighted
3%
4%
3%
Investment
Stocks
Bonds
Money Market
8%
12%
9%
As per Minimax Regret approach, Investment should be made in Bonds.
s or money market. You can only invest in one. The return on your investment will depend on the performance of the economy.
e based on the following criteria (7 pts each):
maximum of maximum payoff percentage (12%, 6%,
f the decision is 12%
maximum of minimum payoff percentage (4%, 3%, of the decision is 4%
of the economy.
You have just inherited a small amount and would like to invest it. Your choices are stocks, bonds or money market. You can o
The returns for each type of investment relative to the state of the economy are:
Investment
Strong Economy
Average Economy
Weak Economy
Stocks
12%
6%
-10%
Bonds
7%
4%
1%
Money Market
4%
3%
2%
Assuming you can only pick one investment option, which investment would you choose based on the following crite
a) Maximax
b) Maximin
c) Equally Likely
d) Hurwicz with an alpha value of 0.5
e) Minimax Regret
Maximax
Under this approach, we will find the maximum payoff for each investment. Then we will select maximum of maximum payo
2%). The optimum decision according to maximax criteria is investing in Stocks and the payoff of the decision is 12%
Maximin
Under this approach, we will find the minimum payoff for each investment. Then we will select maximum of minimum payof
10%). The optimum decision according to maximin criteria is investing in Stocks and the payoff of the decision is 4%
Equally like criteria
We will calculate the weighted payoff using the following formula:Weighted payoff =
Payoff (stocks)/3 + Payoff (Bonds)/3 + Payoff (Money market)/3
Investment
Stocks
Bonds
Money Market
Strong Economy
12%
7%
4%
Average Economy
6%
4%
3%
Weak Economy
-10%
1%
2%
Now we will select maximum of weighted payoffs i.e. Bonds
Investing in bonds is the best decision according to equal likelihood criteria
Minimax Regret
Weighted
3%
4%
3%
Investment
Stocks
Bonds
Money Market
8%
12%
9%
As per Minimax Regret approach, Investment should be made in Bonds.
s or money market. You can only invest in one. The return on your investment will depend on the performance of the economy.
e based on the following criteria (7 pts each):
maximum of maximum payoff percentage (12%, 6%,
f the decision is 12%
maximum of minimum payoff percentage (4%, 3%, of the decision is 4%
of the economy.
Brand
Buying Price
Selling Price
Maximum Demand
Number of Brands to Maximize Profit
Vodel
Shutz
Creekwater
$
1.50 $
0.90 $
0.50
$
3.00 $
2.50 $
1.75
400
500
300
3
3
2.25
2
0.75
1

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP