I really dont care about the writing of the letter, I just need the info to put into it!

In 2004 David Lee started Lee Manufacturing, a company dedicated to manufacturing simple yet efficient gas barbecues. The barbecues are made of aluminum and stainless steel and are priced at the middle of the market. Davids goal has always been to make a barbecue that cooks great food. This means, good quality parts, simple construction, even heat, no hot or cold spots, and a barbecue that will hold temperature from the lowest setting to the highest setting. Davids motto is high quality for a fair price. The company offers four basic grill sizes (models) and several options and accessories that can be added on to each model. Lees barbecues have been well received. Revenue and profits have grown steadily.

Based on the recommendation from his sales and marketing department Mr. Lee is considering broadening his product line by adding a new product line of Lee charcoal barbecues. These barbecues would be ideal for those cooks that like that distinct charcoal flavor or the nostalgia of barbecuing the old fashioned way. Mr. Lee has asked his sales and marketing team to come up with a sales forecast for units and pricing. He has also asked his manufacturing team to come up with alternatives for the production of the charcoal barbecues including what equipment is needed and what the projected costs would be.

The sales and marketing team hired Advanced Marketing Consultants to conduct a market survey. The total cost for this consulting was $37,500. The initial model would be a mid-sized kettle barbecue. Eventually, two more models would be added, a smaller version ideal for camping or apartment patios and a larger model for the serious cooks.

Based on the survey and their own experience the sales and marketing team has provided a sales forecast. The suggested price of the initial barbecue is $46.90 per barbecue. They would be sold to retailers with a suggested retail price of $69.95. This would provide retailers with a target margin of 33%. The barbecues would be sold by the companys existing sales force to its existing customer base. Unit sales are forecast at 2,500 in year 1, 5,000 in year 2, 6,500 in year 3, 8,000 in year 4, and then increasing by 1,000 each year thereafter. Sales and marketing expenses are expected to be 10% of total revenue.

The production team forecasts that the fixed costs needed for the charcoal barbecue production line will be $65,000 per year. Variable costs for materials (sheet aluminum, grills, handles wheels, etc.) is expected to be $15.50 per unit. The variable labor costs will vary based on what equipment will be purchased.

There are two brands of equipment that could be purchased to manufacture the lids and bowls of the barbecue. The first is made by the Strong Metal Equipment company. The second is made by the Precision Industrial company.

The Strong brand is more expensive, but higher quality and more efficient. It will cost $125,000 plus an additional $9,000 for shipping and installation. The equipment would be depreciated to zero over 5 years using straight line depreciation. It is expected that the equipment would last for 8 years at which time it would be sold then for $27,500. Maintenance of the Strong equipment would cost $5,000 per year. Since the Strong equipment is more efficient the variable labor cost would be $9.00 per barbecue.

The Precision brand is less expensive. It will cost $95,000 plus an additional $8,000 for shipping and installation. The equipment would be depreciated to zero over 5 years using straight line depreciation. It is expected that the equipment would last for 8 years and would then be sold for $22,000. Maintenance of the Precision equipment would cost $8,000 per year. The variable labor cost with the Precision brand equipment would be $9.75 per barbecue.

The increase in working capital (accounts receivable and inventory) is expected to be $35,000 at the beginning of the project and will be the same for both machines. The companys cost of capital is 14% and its tax rate is 40%. Since Mr. Lees production team believes that both brands of equipment will last for eight years David wants this analyzed as an eight year project.

David has always believed in buying quality so he is leaning towards the Strong brand equipment. But after hearing that you have learned about capital budgeting in your Finance class at UVU he wants to take advantage of your expertise. David has asked you to analyze his choices and give him some advice on which option would provide the best financial outcome for Lee Manufacturing.

Prepare an analysis and professional report for Mr. Lee. The report should be professionally written and include a two to three-page letter (double spaced), plus attached schedules. The letter should explain what analytical techniques you are using, why you are using those techniques, what the results show, what you would recommend to Mr. Lee and why. Make sure that the letter is well organized and professionally written. Also make sure that the letter includes the following:

1. The cash flows associated with the different equipment brands for each year of the project.

2. The PB period, Discounted PB, IRR, and NPV for the two alternatives.

3. Your recommendation of which brand of equipment should be purchased.

4. Attach to your letter schedules that show your analysis and your work.

It is okay to submit two files. A Word file with your letter and an Excel file with your analysis.