Reference no: EM131111575
Your company has the opportunity to set up a SBU to manufacture solar panels. Your company's cash flow is very tight so you want to be sure that this endeavor will at least pay for itself. The SBU can lease an existing plant for one year only. There is an existing building on the site but you will need to convert the facility to manufacture the panels. Here are the specifics of the case (keep in mind I have simplified this scenario): Assumptions:
• Annual lease cost $75,000
• Plant Conversion cost $150,000
• Variable costs to produce each unit $50.00
• Local Value Added Tax 7.5%
• Royalty $3.50
• Projected Sales price $75.00 The royalty is paid on a per unit basis (regardless of sales price) to the original patent holder on the technology you need to manufacture these solar panels. The VAT is based on the margin between the revenue and variable production costs. For this exercise assume that the VAT is neither a variable or fixed cost, but it does need to be figured into the analysis in the final profit margin. Also for this exercise assume there are no income taxes. Please answer the following questions about this endeavor. You must use an Excel spreadsheet for this exercise and include it with your submission. Include all formulas in your answers.
1. If you could sell 10,000 units in this year of operations, would you undertake the project?
2. If you could sell 15,000 units in this year of operations, would you undertake the project?
3. What volume of units sold would you need to sell to breakeven on your cash flow for the year?
4. If you could sell only 6,000 units for the year but the market would allow you to raise your sales price; what is the average sales price you would need to breakeven on your cash flow?
5. If you could lease the building for 2 years instead of only 1 year, how would this impact your economics?
6. What volume would you need to sell annually to breakeven if this was a 2 year project?
How many volcanoes are reported on orange or red alert
: How many volcanoes are reported on Orange or Red alert? How many on Yellow? Where are these volcanoes located? Use the mute map of the World to mark the position of the volcanoes currently on high level of alert.
|
Concentration of benzene in the water
: A truck spills 1 gallon of benzene into an aquifer with an area = 50 ft2. Benzene has a solubility of 1750 ppm, and a specific gravity of 0.873. The aquifer has a porosity of 0.25, a hydraulic gradient of 0.004 and a hydraulic conductivity of 1000..
|
Approach for solving algebraic word problems
: Question: In your own words, describe a step-by-step approach for solving algebraic word problems.
|
Determine the future value that janet
: Determine the future value that Janet will have at the end of 10 years, given that end-of-period deposits are made and no interest is withdrawn, if (1) $300 is deposited annually and the credit union pays interest annually. (2) $150 is deposited semi..
|
Convert the facility to manufacture the panels
: If you could sell only 6,000 units for the year but the market would allow you to raise your sales price; what is the average sales price you would need to breakeven on your cash flow?
|
Confidence interval for the proportion of adults
: Construct a 90% confidence interval for the proportion of adults aged 18 or older who believe there is too little spending on national defense.
|
What is the maximum future value obtainable
: Compare your findings in part a, and use them to demonstrate the relationship between compounding frequency and future value. What is the maximum future value obtainable given the $15,000 deposit, the 2-year time period, and the 12% nominal annual ra..
|
Discuss the importance of a narrative hook
: Discuss the items that should be included in the abstract and introduction of a research proposal. In addition, discuss the importance of a narrative hook and why rhetorical questions should be avoided as a narrative hook.
|
Compute the minimum of these numbers
: Suppose that the array X consists of real numbers X[1], X[2], ..., X[N]. Write a pseudocode program to compute the minimum of these numbers.
|