Proble

m $3-10($Algo$)$

Tuff Wheels has forecast the demand and the cost project for a new product to be added to its small motorized vehicle line for children. The new product is called the Kiddy Dozer. It will look like a miniature bulldozer, complete with caterpillar tracks and a blade. Tuff Wheels has forecasted the demand and the cost to develop and produce the new Kiddy Dozer. The following table contains the relevant information for this project.

Development cost $$1,350,000$

Estimated development time $9$ months

Pilot testing $$200,000$

Ramp$-$up cost $$400,000$

Marketing and support cost $$150,000$ per year

Sales and production volume $60,000$ per year

Unit production cost $$100$

Unit price $$215$

Interest rate $8\%$

Tuff Wheels also has provided the project plan shown as follows. As can be seen in the project plan, the company thinks that the product life will be three years until a new product must be created.

The project schedule is $4$ years which is divided into $4$ quarters each. The data in the chart are as follows. Development: Q $1$ to Q $3$ of year $1.$ Pilot testing: Q $3$ and Q $4$ of year $1.$ Ramp$-$up: Q $3$ and Q $4$ of year $1.$ Marketing and support: Q $4$ of year $1$ and Q $1$ to Q $4$ of years $2,3,$ and $4.$ Production and sales: Q $1$ to Q $4$ of years $2,3,$ and $4.$

Assume all cash flows occur at the end of each period.

What are the yearly cash flows and their present value $($discounted at $8$ percent$)$ of this project? What is the net present value?

Note: Enter your answer in thousands of dollars. Perform all calculations using Excel. Do not round any intermediate calculations. Round your answer to the nearest thousand.

What is the impact on NPV for the Kiddy Dozer if the actual sales are $50,000$ per year? $70,000$ per year?

Note: Enter your answer in thousands of dollars. Perform all calculations using Excel. Do not round any intermediate calculations. Round your answer to the nearest thousand.

Based on the original sales level of $60,000,$ what is the effect on NPV caused by changing the discount rate to $9\%,10\%,$ or $11\%?$

Note: Enter your answer in thousands of dollars. Perform all calculations using Excel. Do not round any intermediate calculations. Round your answer to the nearest thousand.