West End Hospital is pursuing a sixty-two-bed expansion and would like to determine how many beds should be allocated to cardiac surgical patients versus oncology patients to maximize revenues. The average length of stay for cardiac surgical patients is 4.7 days whereas the average length of stay for oncology patients is seven days. Assume the hospital is open 365 days a year. The average revenue generated from from an oncology patient is $9,500 and the average revenue generated from a cardiac surgical patient is $10,750. The hospital currently has four hundred beds, and its laboratories, radiology department, and operating rooms have excess capacity and would be able to handle the increased demand from the expansion with existing staff. the laboratories could process up to an additional ten thousand tests annually. the average cardiac surgical patient requires 2.5 lab tests whereas the average oncology patient requires two lab tests. the radiology department can process up to an additonal five thousand imaging requests annually. the average cardiac surgical patient requires two imaging services whereas the oncology patient requires four. Last, fifteen hundred additional surgeries could be accommodated in the hospital's existing operating rooms.

a. Formulate this as a linear programming problem.

b. Solve the problem using Excel Solver.

c. What is the optimal allocation of beds to cardiac surgical versus oncology patients?

Please show answers using Excel!

You are valuing a company that will experience two stages. During the first stage, the revenues and expenses will grow quickly. During the second stage, the revenues and the expenses will grow at slower rates. The revenues will be received annually and the expenses will be paid annually. The discount rate is 12% per year. For this problem, you may find it useful to consult the two-stage valuation diagram (“red and blue”) that was handed out in class.

Stage 1. Revenues at t = 1 will equal $1 million. The revenues will grow at 10% per year until t = 7. That is, the last revenue collected during the first stage is at t = 7. The expenses at t = 1 will equal $0.8 million. The expenses will grow at 12% per year until t = 7. That is, the last expenses paid during the first stage are at t = 7. Hint: Revenues in Stage 1 are a growing annuity. Expenses in Stage 1 are another growing annuity.

[2 points] What is the present value, at t = 0, of all revenues collected during Stage 1?

[2 points] What is the present value, at t =0, of all expenses paid during Stage 1?

[1 point] What is the net value of Stage 1 (at t = 0)?

Stage 2. Remember that the last payment in Stage 1 is payment at t = 7. Immediately after this payment the second stage begins. The second stage lasts forever. The revenues will grow at 3% per year in the second stage. The expenses in the second stage will grow at 2% per year.

[2 points] What is the present value, at t = 0, of all revenues collected during stage 2?

[2 points] What is the present value, at t = 0, of all expenses paid during stage 2?

[1 point] What is the net value of Stage 2 (at t = 0)?

[2 points] Value of the business. You have now computed the present value of revenues in stage 1, expenses in stage 1, revenues in stage 2, and expenses in stage 2. What is the total value of the business today (at t = 0)?

The following income statements illustrate different cost structures for two competing companies: Income Statements Company Name Munoz Jordan Number of customers (a) 85 85 Sales revenue (a × $230) $ 19,550 $ 19,550 Variable cost (a × $180) N/A (15,300 ) Variable cost (a × $0) 0 N/A Contribution margin 19,550 4,250 Fixed cost (15,300 ) 0 Net income $ 4,250 $ 4,250 Required Reconstruct Munoz’s income statement, assuming that it serves 170 customers when it lures 85 customers away from Jordan by lowering the sales price to $130 per customer. Reconstruct Jordan’s income statement, assuming that it serves 170 customers when it lures 85 customers away from Munoz by lowering the sales price to $130 per customer.

5. Now cross two of the heterozygous F1 offspring from question #2.

What is the genotypic ratio of the offspring in Question 5?
25%(YY):50%Yy:25%(yy)
What is the phenotypic ratio of the offspring in Question 5?
3(Yellow):1(Green)

6. Consider the resulting ratio of crossing the two heterozygous pea plants in question #5. We will use this ratio in a short activity exploring probability. Keep in mind that crossing two individuals that are heterozygous for a certain trait is similar to flipping two coins. Each coin has two sides (we might think of each side as an “allele”) and the chances of flipping heads/heads, heads/tails or tails/tails should be similar to the ratio we see when crossing two heterozygotes.

For this simple activity, you will need two coins (pennies, nickels, dimes, quarters, or a mix of any of those). Alternatively, you may google a coin-flipper simulator that will allow you to flip two coins at once. You will also need a piece of scratch paper and a pen or pencil.

Directions: Flip the two coins simultaneously at least 50 times. For each flip of the pair of coins, you will record the results on a piece of scratch paper. You might set up a table like the one below to record your results. Once you have flipped the coins at least 50 times, enter the number of heads/heads, heads/tails and tails/tails in Table 1 below.

Now determine the ratio for your results. You will do this by dividing the number for each result by the total number of flips, and then multiply by 100.

(Example: If the number of heads/heads is 9 then 9/50 = .18, .18x100 = 18%), Repeat this mathematical procedure for heads/tails and tails/tails)

Compare the resulting ratio from the question #5 cross of two heterozygous parents to the ratio from the coin flipping exercise. Are there similarities? If so, what are they?


What might be done to make the ratio from the coin flipping exercise become more similar to the ratio from question #5? (Hint: Consider that more data equals better accuracy.)

In this question, you are going to implement a human vs. human version of Notakto.

Notakto is a tic-tac-toe variant. It is played across three 3 x 3 boards: Board A, board B and board C. When you start the game you should output the boards as follows.

A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 1:
There are two players: Player 1 and player 2. Player 1 always starts. Both players play the same piece: X. E.g., let player 1 choose location 6 on board A, i.e., the user will enter A6. The output of the program should be as follows (bold font represents user input).

A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 1: A6
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X 7 8 6 7 8 6 7 8
Player 2:
Each player takes turn placing an X on the board in a vacant space (a space not already occupied by an X).

A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 1: A6
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X 7 8 6 7 8 6 7 8
Player 2: A7
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X X 8 6 7 8 6 7 8
Player 1:
If a board has three X in a row, column, or diagonal, the board is dead and it cannot be played anymore. It should not be displayed anymore. E.g., in the following, board A becomes dead and is not displayed anymore.

A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 1: A6
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X 7 8 6 7 8 6 7 8
Player 2: A7
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X X 8 6 7 8 6 7 8
Player 1: A8
B C
0 1 2 0 1 2
3 4 5 3 4 5
6 7 8 6 7 8
Player 2:
The game ends when all the boards contain three X in a row, column, or diagonal, at which point the player to have made the last move loses the game. Unlike tic-tac-toe, there will always be a player who wins any game of Notakto.

A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 1: A6
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X 7 8 6 7 8 6 7 8
Player 2: A7
A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
X X 8 6 7 8 6 7 8
Player 1: A8
B C
0 1 2 0 1 2
3 4 5 3 4 5
6 7 8 6 7 8
Player 2: B0
B C
X 1 2 0 1 2
3 4 5 3 4 5
6 7 8 6 7 8
Player 1: B4
B C
X 1 2 0 1 2
3 X 5 3 4 5
6 7 8 6 7 8
Player 2: C0
B C
X 1 2 X 1 2
3 X 5 3 4 5
6 7 8 6 7 8
Player 1: C4
B C
X 1 2 X 1 2
3 X 5 3 X 5
6 7 8 6 7 8
Player 2: C8
B
X 1 2
3 X 5
6 7 8
Player 1: B8
Player 2 wins game
Note that you should check for legal moves. If the users enters something illegal you should prompt them again. Let's play a new game to illustrate this.

A B C
0 1 2 0 1 2 0 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 1: C0
A B C
0 1 2 0 1 2 X 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 6 7 8
Player 2: B9
Invalid move, please input again
Player 2: fds
Invalid move, please input again
Player 2: C0
Invalid move, please input again
Player 2: C6
A B C
0 1 2 0 1 2 X 1 2
3 4 5 3 4 5 3 4 5
6 7 8 6 7 8 X 7 8
Player 1: C6
Invalid move, please input again
Player 1: C3
A B
0 1 2 0 1 2
3 4 5 3 4 5
6 7 8 6 7 8
Player 2: C2
Invalid move, please input again
Player 2:
Implement the game and try to pass all test cases. The list of test cases is not complete. We may add more test cases when marking after the deadline.

Yo

I want the answer in python

Your boss has asked for your assistance regarding the company’s investments. One of their current investments has $10 million invested in long-term corporate bonds. This bond portfolio's expected annual rate of return is 9%, and the annual standard deviation is 10%.

An external firm was contacted to see if the company could improve their return. Their recommendation has the company invested in an index fund that closely tracks the Standard & Poor's 500 Index. The index has an expected return of 14%, and its standard deviation is 16%.

After consideration, you suggest the company puts all these funds into a combination evenly split between the index fund and corporate fund. Your boss likes the suggestion but wants to see proof that your return is better than the outside organization. She all wants to make certain that you considered risk when making your suggestion.

How do you determine the correlation coefficient?

What is the rate of return for a 50/50 mix of the two portfolios?

What is the standard deviation for a 50/50 mix of the two portfolios?

An important feature of the financial statements of state and local governments is the two-layer reporting system. In addition to the traditional fund financial statements, the Governmental Accounting Standard Board (GASB) issued Statement No. 34 to add a new layer of reporting, the government-wide financial statements. The government-wide statements are presented using the full accrual basis of accounting and with the economic resources’ measurement focus. Combined with the fund level statements, the financial overview of the governmentwide financial statements provides a comprehensive evaluation of the overall financial condition and operating results of a government. City of Sugar Land in Texas is selected as a good example to illustrate the two-layer financial reporting system. Most students in our school are familiar with the city and its services, facilities, and infrastructures. It serves as an interesting case for students in learning its activities and accounting system. The city has a population of about 90,000, and its 2014-2015 budget is $181.59 million. It is a full-service municipality engaging in both governmental activities (i.e., police and fire protection, curbside recycling, parks and recreation, public works, planning / zoning) and business-type activities (i.e. water / wastewater utilities, solid waste collection, a regional airport). But the city does not have fiduciary activities. During the past years, the city has seen continuous economic growth, and has been named one of the top 50 best places to live in the US. The most recent CAFR can be obtained from the city’s website. After going over the general structure of the reports, the students are asked to focus on the financial section, including the management discussion and analyses (MD&A), government-wide financial statements and the governmental funds financial statements. Then, a written summary from each student is required to address the following questions.

1) What are the programs/functions reported in the Government-wide Statement of Activities? By how much has the city’s Net Position increased from the last fiscal year?

2) Why is fund accounting used in governmental accounting? Which types of governmental funds and enterprise funds does the city have?

3) What are the major revenues for the city’s governmental funds? What are the three major revenue sources for the city? How is sales tax collected by the city? What is franchise tax?

4) What is the revenue recognition policy for the city’s governmental funds? How is the policy different from revenue recognition in for-profit companies?

5) In which situation will the city issue bond? What sources can the city rely upon to make payments for the premium and interest related to the bond?

6) What is restricted fund? What are the examples of restricted fund in the city?

7) How does the city balance its budget, especially when the projected expenditures exceed the projected revenues?

8) What is an interfund transfer? Why are interfund transfers closely monitored by the government?

9) Why is reconciliation needed between the fund financial statements and governmentwide financial statements? Please give one or two example (s).

Imagine the following scenario where you need to decide which MUTUALLY-EXCLUSIVE project to pursue: You are given $50,000 to invest in one of the following two projects (you CANNOT invest in both). 200-500 words

Project A: A highly respectable local entrepreneur reaches out to you for a short-term loan of $10,000 guaranteeing a return of $16,000 in 15 days ($6,000 of profit). The situation is unusual as her customers lost their financing source and will need about 2 weeks to wire her the money. Everything is insured and guaranteed so there is ZERO risk of losing your money if you decide to give her the loan.

Project B: A large local utility company sells community bonds with a minimum of $50,000 and promising 15% interest at the end of one year. Calculate the annualized return for project A. Which project (A or B) would you invest in? Why?

A software company is creating a scheduling plan for a nine-month project,. The company has 30 of its own full-time employees and can assign them to the project. For any shortage of personnel, the company will hire short-term contract employees. Company employees earn $5,500 per month, while short-term contract employees make $8,000/month. Contract employees can be assigned to the project beginning in any month, and their contract period is two months. The number of workers required for the project by month is shown below:

a) Determine the optimal staffing plan for the project. (25 pts)

b) The project manager is evaluating options to complete the project early so that the company can earn a bonus. He has determined that the project schedule can be compressed into a seven-month schedule, with the same total number of worker-months. In that case, the staffing requirements are as shown below.

Develop an optimal staffing plan for the project under the accelerated schedule. (10 pts)

c) Suppose the bonus for completing the project two months early is $225,000. What would be the net bonus to the company, after adjusting for any difference in personnel costs under the accelerated schedule? (5 pts)

I am not very familiar with staff optimization. So please elaborate as much as possible. A step by step from excel would be greatly appreciated.