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

User Generated

RyvnfTunarz

Business Finance

Description

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.

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hey this is the best that i would help you considering the time constrains but hope you appreciate the work thank you

cherry
price
profit contribution
monthy sales
time production5.2 hrs
discount rate
unit requirements
lumber req
4.9ft

mahogany
$155
$20
500
8hrs
$2.70
$3.50
$12.74
$14.00
4.0 ft
$85
$37
800

12.74c+14m= 5000
4.9c+4m=2500
after to solve the equation the upper equation wil b...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags