• Option Two: You are a chief operating officer at a for-profit insurance company. A board of directors has requested that you prepare a summary of the issues involved with a potential 40%                reduction in U. S. medical insurance reimbursement. Prepare a report for the board of directors on how to address the proposed funding cuts while remaining sensitive to the needs and health of the community and your patients. In your report, reflect on the key course objectives as well as the financial, legal, and alternative health care models. In addition, reinforce your knowledge of strategic planning and capital budgeting. by using an electronic spreadsheet to display the financials.

·  create a small financial table in the MSWord document and list the numbers and then analyzed those according to the choice made
·   Must be 6-8  double-spaced pages in length (excluding title and reference pages) and
·  8 references from scholarly scources

Question 1 (10 points)

If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, the optimal production mix of air conditioners and fans is __________. (The first number is for air conditioners and the second for fans.)Question 1 options:(50,30)(20,80)(40,60)(26.67,80)

Question 2 (10 points)

In the optimal solution for the above question (Question 1), the slack for the four constrains — Total hours of wiring, Total hours of drilling, Number of air conditioners, Number of fans are __________, respectively. (Hint: A negative number shows that the constraint is binding downward, i.e. it sets a lower rather than an upper limit. You may take the negative sign out when interpreting the results.)Question 2 options:0, 0, 20, 200, 0, 10, 200, 0, 20, 1010, 10, 10, 10

Question 3 (5 points)

Question 3 options:If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, the optimal production of air conditioners isand the optimal production of fans is. (Please only enter an integer and include no units.)

Question 4 (5 points)

In the optimal solution for the above question (Question 3), the slack for the four constrains — Total hours of wiring, Total hours of drilling, Number of air conditioners, Number of fans are __________, respectively. (Hint: A negative number shows that the constraint is binding downward, i.e. it sets a lower rather than an upper limit. You may take the negative sign out when interpreting the results.)Question 4 options:0, 0, 15, 105, 0, 15, 00, 5, 15, 00, 0, 10, 15

Part 2

The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources: its carpenters (labor force) and a supply of redwood for use in the furniture. During the next production cycle, 1,200 hours of labor are available under a union agreement. The firm also has a stock of 3,500 feet of good-quality redwood. Each bench that Outdoor Furniture produces requires 4 labor hours and 10 feet of redwood; each picnic table takes 6 labor hours and 35 feet of redwood. Completed benches will yield a profit of $9 each, and tables will result in a profit of $20 each.

Question 5 (10 points)

Question 5 options:The optimal production of benches isand the optimal production of tables is. (Please only enter an integer and include no units. Hint: Because of the resource constraints, you may not be able to produce 4 tables even if the solution is 3.8; you may have to just produce 3 tables.)

Part 3

A winner of the Texas Lotto has decided to invest $50,000 per year in the stock market. Under consideration are stocks for a petrochemical firm and a public utility. Although a long-range goal is to get the highest possible return, some consideration is given to the risk involved with the stocks. A risk index on a scale of 1–10 (with 10 being the most risky) is assigned to each of the two stocks. The total risk of the portfolio is found by multiplying the risk of each stock by the dollars invested in that stock. The attached table provides a summary of the return and risk. The investor would like to maximize the return on the investment, but the average risk index of the investment should not be higher than 6.

Question 6 (10 points)

The optimal dollar amount invested in Petrochemical stock is _________ dollars, and the optimal dollar amount invested in Utility stock is ___________ dollars. (Please only enter an integer and include no units. Hint: The total risk on each stock is the risk index times the investment in dollars. When you use Excel QM, you need to end the total risk in the right hand side of the constraint not simply the risk index.)Question 6 options:20,000, 30,00030,000, 20,00010,000, 15,00015,000, 10,000

Question 7 (10 points)

Question 7 options:The average risk index (not in dollar amount) for the optimal investment is, and the estimated best/maximum return for this investment is. (Please only enter an integer and include no units.)

Part 4

This part of the question is based on the following information.
The Heinlein and Krampf Brokerage firm has just been instructed by one of its clients to invest $250,000 of her money obtained recently through the sale of land holdings in Ohio. The client has a good deal of trust in the investment house, but she also has her own ideas about the distribution of the funds being invested. In particular, she requests that the firm select whatever stocks and bonds they believe are well rated, but within the following guidelines:
(a) Municipal bonds should constitute at least 20% of the investment.
(b) At least 40% of the funds should be placed in a combination of electronic firms, aerospace firms, and drug manufacturers.
(c) No more than 50% of the amount invested in municipal bonds should be placed in a high-risk, high-yield nursing home stock.
Subject to these restraints, the client’s goal is to maximize projected return on investments. The analysts at Heinlein and Krampf, aware of these guidelines, prepare the attached list of high-quality stocks and bonds and their corresponding rates of return.
Hint: You will need to rearrange one of the constraints in this problem so that all variables will be at the left hand side of the constraint and the right hand side of the constraint will be zero. You may adjust he sign of the constraint accordingly. For example, rearranging x < y + 2 to x – y < 2.

Question 8 (10 points)

The optimal money invested in the five stocks and bonds — Municipal bonds, Electronics, Aerospace, Drugs, and Nursing homes are __________ dollars, respectively.Question 8 options:50,000, 50,000, 50,000, 50,000, 50,00050,000, 0, 0, 175,000, 25,000
25,000, 0, 0, 175,000, 50,00050,000, 25,000, 25,000, 125,000, 25,000

Part 5

Mt. Sinai Hospital in New Orleans is a large, private, 600-bed facility, complete with laboratories, operating rooms, and x-ray equipment. In seeking to increase revenues, Mt. Sinai’s administration has decided to make a 90-bed addition on a portion of adjacent land currently used for staff parking. The administrators feel that the labs, operating rooms, and x-ray department are not being fully utilized at present and do not need to be expanded to handle additional patients. The addition of 90 beds, however, involves deciding how many beds should be allocated to the medical staff for medical patients and how many to the surgical staff for surgical patients.
The hospital’s accounting and medical records departments have provided the following pertinent information. The average hospital stay for a medical patient is 8 days, and the average medical patient generates $2,280 in revenues. The average surgical patient is in the hospital 5 days and receives a $1,515 bill. The laboratory is capable of handling 15,000 tests per year more than it was handling. The average medical patient requires 3.1 lab tests and the average surgical patient takes 2.6 lab tests. Furthermore, the average medical patient uses one x-ray, whereas the average surgical patient requires two x-rays. If the hospital was expanded by 90 beds, the x-ray department could handle up to 7,000 x-rays without significant additional cost. Finally, the administration estimates that up to 2,800 additional operations could be performed in existing operating room facilities. Medical patients, of course, do not require surgery, whereas each surgical patient generally has one surgery performed.
Assume that the hospital is open 365 days a year. Round off your answers to the nearest integer.

Question 9 (10 points)

Question 9 options:The optimal number of medical patients per year is, and optimal number of surgical patients per year is. The maximum annual profit isdollars. (Please round to the closest integer and include no units.)

Question 10 (10 points)

Among the 90 additional beds, _______ beds should be used for medical patients and _______ beds used for surgical patients.Question 10 options:45, 4560, 3061, 2929, 61

Question 11 (10 points)

Question 11 options:At the optimal, there areempty beds,lab tests of unused capacity,x-rays of unused capacity, andunused operation rooms available. (Please round to the closest integer and include no units.)