27 Jun Question Lee Manufacturing Capital Budgeting Analysis
Question
Lee Manufacturing
Capital Budgeting Analysis
In 2004David 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. David’s 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. David’s 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. Lee’s 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 thosecooks 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 company’s 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 company’s cost of capital is 14% and its tax rate is 40%. Since Mr. Lee’s 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 equipmentshouldbe 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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.