You are ceo of a facility and Aetna has offered you a contract . Develop the...

You are ceo of a facility and Aetna has offered you a contract . Develop the P&L statement for the following assumptions between 0 and 55,000 procedures in increments of 2,500 :

•Health way is offering you a contract that will pay you a flat fee of $2,750,000 across all ranges of volume

•Supply costs = $42.50 per procedure

•You incur a hazardous disposal fee of $2.50 per procedure

•Fixed costs = $1,200,000

•You will need to hire an additional salaried employee with volumes of 35,000 or more at an annual cost of $47,000.

please put into an excel sheet so i can see total costs, total variable cost, total fixed cost, breakeven point, etc

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

You are the ceo of a facility and Aetna has offered you a contract. Develop the...

You are the ceo of a facility and Aetna has offered you a contract. Develop the P&L statement for the following assumptions between 0 and 65,000 procedures in increments of 2,500: •Aetna is offering you a contract that will pay you $55 per procedure •Variable costs per procedure = $37.00 •Fixed costs = $1,000,000 •You will need to hire an additional salaried employee with volumes of 40,000 or more at an annual cost of $50,000 please show excel sheet so...

anaylsis You are the ceo of a facility and Aetna has offered you a contract. Develop...

anaylsis You are the ceo of a facility and Aetna has offered you a contract. Develop the P&L statement for the following assumptions between and 65,000 procedures in increments of 2,500: • Aetna is offering you a contract that will pay you $55 per procedure • Variable costs per procedure = $37.00 • Fixed costs = $1,000,000 •You will need to hire an additional salaried employee with volumes of 40,000 or more at an annual cost of $50,000 questions what...

You are ceo of a facility and Aetna has offered you a contract. Develop the P&L...

You are ceo of a facility and Aetna has offered you a contract. Develop the P&L statement for the following assumptions between and 55,000 procedures in increments of 2,500: -Aetna is offering you a contract that will pay you a flat fee of $2,750,000 across all ranges of volume -Supply costs = $42.50 per procedure. -You get a hazardous disposal fee of $2.50 per procedure -Fixed costs = $1,200,000 -You will need to hire an additional salaried employee with volumes...

You are offered the opportunity to develop a 400,000 sf warehouse facility for General Foods in...

You are offered the opportunity to develop a 400,000 sf warehouse facility for General Foods in suburban Philadelphia. Attracted by your expertise as a local warehouse developer, General Foods has offered to sign a triple net lease for seven years at a rent for $2 million per year. They also insist that at the end of the lease term they have the option to purchase the property at $22 million. Their final major condition is that the project be completed...

It is budget time and the CEO has asked you to develop a presentation on cost...

It is budget time and the CEO has asked you to develop a presentation on cost concepts and how it is used in decision making. As the Director of Budgeting and Finance, you have been tasked to present the presentation to all directors, supervisors and physicians. The CFO has ask you to address the following: How and why do we classify cost? Discuss the four major categories of direct and indirect cost and explain each. Give examples of each. What...

Your factory has been offered a contract to produce a part for a new printer. The...

Your factory has been offered a contract to produce a part for a new printer. The contract would last for three years, and your cash flows from the contract would be $5.01 million per year. Your upfront setup costs to be ready to produce the part would be $8.05 million. Your discount rate for this contract is 8.1%. a. What is the IRR? b. The NPV is $4.84 million, which is positive so the NPV rule says to accept the...

Your factory has been offered a contract to produce a part for a new printer. The...

Your factory has been offered a contract to produce a part for a new printer. The contract would last for three years, and your cash flows from the contract would be 5.08 million per year. Your upfront setup costs to be ready to produce the part would be $8.09 million. Your discount rate for this contract is 7.8% . a. What is the IRR? b. The NPV is $5.05 million, which is positive so the NPV rule says to accept...

Your factory has been offered a contract to produce a part for a new printer. The...

Your factory has been offered a contract to produce a part for a new printer. The contract would last for 3 years and your cash flows from the contract would be $5.11 million per year. Your upfront setup costs to be ready to produce the part would be $8.12 million. Your discount rate for this contract is 7.9%. a. What does the NPV rule say you should do? b. If you take the contract, what will be the change in...

In public school there has been a new contract system that is being offered to teachers,...

In public school there has been a new contract system that is being offered to teachers, they now have the choice to give up life contracts in exchange for increased pay, in this new system they get short term contracts that are renewed by employees based on performance. What asymmetric information problem can occur if only some school distrcts implement this program and others don’t. Use charts if needed

Company A has been offered a 5 years contract to supply IT services for a customer....

Company A has been offered a 5 years contract to supply IT services for a customer. If they finally accept to enter that project, they'll have to afford the following expenses: Cost of equipment: 300,000€; Working capital required: 30,000€; Upgrading of equipment after 3 years: 100,000€ and, at the end, the residual value of the equipment will be of 30,000€ In case they decide to enter that project, the annual cash inflow will be 150,000€. The working capital will be...

Subjects