What is the minimum number of cans

Reference no: EM131956255

Question: The Coka company is a soft drink company. Until today the company bought empty cans from an outside supplier that charges Coka $0.20 per can. In addition the transportation cost is $1,000 per truck that transports 10,000 cans. The Coka company is considering whether to start manufacturing cans in its plant. The cost of a can machine is $1 million and its life span is 12 years. The terminal value of the machine is $160,000. Maintenance and repair costs will be $150,000 for every 3-year period. The additional space for the new operation will cost the company $100,000 annually. The cost of producing a can in the factory is $0.17. The cost of capital of Coka is 11% and the corporate tax rate is 40%.

a. What is the minimum number of cans that the company has to sell annually to justify self-production of cans? (Hint: start by guessing that annual production is 3 million cans and then use Solver to correct the guess by making the NPV equal to 0. Note the NPV here should be the differential cash flows between own production and outside supply.)

b. Advanced: Use data table functionality to show the NPV and IRR of the project as a function of the number of cans.?

Reference no: EM131956255

Questions Cloud

What are the basic units of life for trees : What are the basic units of life for trees? And how do they work to keep trees alive and not dead or dying daily?

How many units must the company sell next year to earn : During the past year a company had total fixed costs of $70,000. Its product sold for $9 per. How many units must the company sell next year to earn $1,000,000?

What is the minimum price pearl should accept : During the past year, Pearl McGill planted a new vineyard on 150 acres of land that she leases for $30650 a year. What is the minimum price Pearl should accept?

Calculate cobalt net operating profits after taxes : Cobalt Industries had sales of 158 comma 500 158,500 units at a price of $ 9.68 $9.68 per unit. It faced fixed operating costs of $ 245 comma 000 $245,000.

What is the minimum number of cans : What is the minimum number of cans that the company has to sell annually to justify self-production of cans? (Hint: start by guessing that annual production).

What is the entropy changes : What is the entropy changes, delta S (in units of J/K) when Argon gas (Ar), at 1.00 atm in a 0.5 L container is allowed to expand to 1 L

Impactful topic of managing growth : Discuss and reflect 2 the interesting and impactful topic of managing growth and what are comment on lessons of good and bad growth

Find what annual rate did the buyer earn on purchase : A coin that was featured in a famous novel sold at auction in 2014 for $6,581,000. The coin had a face value of $10 when it was issued in 1791.

What is the expected capacity variance : Patton Corp. uses a standard cost system to account for the costs of its one products. What is the expected (planned) capacity variance?

User Account

All Pages