How do you draw a risk free line on an efficient frontier graph?

please do it in excel BETTER PRODUCTS COMPANY has decided to start manufacturing four new products in three plants that currently have excess production capacity. The products require comparable production effort per unit, so the available production capacity in the plants is measured by the number of units of any product that can be manufactured per day. a)Formulate this problem as a transportation problem by constructing the appropriate parameter table. Note:One image is of the data and the other image is option 1 to solve the exercise.

Scenario One: An 86-year widow comes in monthly to have her blood drawn and monitored ever since her heart attack 2 years ago. Her husband has recently passed away and she has no family nearby to help her. She has Medicare but does not have supplemental insurance to cover office visits. When leaving the office today, she starts to cry and tell you that she can no longer afford her blood pressure medications, cholesterol medications, blood work, and office visits each month. She will not be able to get her medications refilled unless she sees the doctor and has blood work each month. She currently owes $180 on her account today. Scenario 2: A 19-year-old mother of 3 children, all under the age of 5, brings in all of the kids today for their recommended check-ups and vaccinations. She does not have insurance for any of the children as she was denied Medicaid based on a previous fraud. She has been diligent paying for the children’s healthcare, with assistance from a grandmother, but she…

Emerson Electric is considering the purchase of equipment that will allow the company to manufacture a new line of wireless devices for home appliance control. The first cost will be $80,000 and the life estimated is 6 years with a salvage value of $10,000. Three different salespeople have provided estimates regarding the added revenue the equipment will generate. Salespersons 1,2, and 3 have made estimates of $10,000 , $16,000 , and $18,000 per year respectively if the Companys MARR is 8% per year find the PW of each salespersons estimates.

1.  Kirsten is trying to decide where to go for her well-earned vacation. She would like to camp, but if the weather is bad, she will have to go to a motel. Given the costs and probabilities of bad weather given below, which destination should she choose?   Camping cost Motel cost Probability of bad weather Nevada $21.2 $80.9 0.2 Oregon $15.9 $84.6 0.4 California $30 $95 0.1   a. California, because its EMV = $33.14 b. Nevada, because its EMV = $33.14 c. California, because its EMV = $36.5 d. Any of the 3 choices. e. Oregon, because its EMV = $43.38 f. Nevada, because its EMV = $43.38 g. None of the 3 choices. h. Oregon, because its EMV is $36.50.

A flood control reservoir project and channel improvement project are proposed for reducing flood damages along a stream in an urban area. Estimated costs are as follows: Dam and reservoir project Channel improvement project Initial investment $1,500,000 $1,200,000 Annual maintenance $10,000/yr $5,000/yr Hydrologic, hydraulic and economic studies have been conducted to develop the following relationships for the river reach and flood plain: (a) annual exceedance probability versus peak discharge with and without the reservoir, (b) discharge versus stage with and without the channel improvement, and (c) stage versus damage Annual Peak discharge Stage (ft) exceedance (cfs) probability Without With Discharge reservoir reservoir (cfs) Without With Stage Damage project project (ft) million) 0.50 3,000 2,700 0 0 0 9 0.0 0.20 5,400 0.10 7,600 4,200 3,500 5,000 10. 7 10 0.2 10,000 15° 11 15 1.1 0.05 10,400 5,500 15,000 20 14 20 2.2 0.02 0.01 19,000 0.005 24,000 20,000 15,000 8,600 20,000 23 17…

As the newly named president and CEO of Tourism Banff, the Destination Management Organization for the world famous iconic tourism community locatin in Banff National Park (BNP), Canada’s first and most famous national park, you have been asked to formulate a tourism development and promotion policy which balances the needs of residents of the small community of 6,700 permanent residents and the over 5 million annual visitors to BNP. In formulating the requested policy, keep in mind that the town of Banff is located in a National Park, how would you balance the rights and responsibilities of: a. Permanent residents of the community b. Visitors living in the nearby city of Calgary and c. Visitors from the rest of Canada How would you decide which kind of tourism activities you would both allow and encourage within the National Park? In formulating a vision for the future of the National Park community/destination, whom would you involve in the visioning process?

Please answer the question as quickly as possible A toy company has developed two new toys for possible inclusion in its product line for the upcoming Christmas season. Setting up the production facilities to begin production would cost $50,000 for toy 1 and $80,000 for toy 2. Once these costs are covered, the toys would generate a unit profit of $10 for toy 1 and $15 for toy 2. The company has two factories that are capable of producing these toys. However, to avoid doubling the start-up costs, just one factory would be used, where the choice would be based on maximizing profit. For administrative reasons, the same factory would be used for both new toys if both are produced. Toy 1 can be produced at the rate of 50 per hour in factory 1 and 40 per hour in factory 2. Toy 2 can be produced at the rate of 40 per hour in factory 1 and 25 per hour in factory 2. Factories 1 and 2, respectively, have 500 hours and 700 hours of production time available before Christmas that could…

Build New plant option=

Answer the following homework question