Question
Must show Excel Calculations clearly (cell formulas). Otherwise, do not attempt to answer the question, please. You are an analyst for a pipe manufacturing corporation
Must show Excel Calculations clearly (cell formulas). Otherwise, do not attempt to answer the question, please.
You are an analyst for a pipe manufacturing corporation that is considering a new project which involves fabricating some custom pipe for a single customer. The project will take advantage of excess capacity in an existing plant. The plant has the capacity to produce 50,000 units of 18-inch pipe, but only 25,000 are being produced currently. Sales of 18-inch pipe are expected to increase by 10% a year. You want to use some of the remaining capacity to manufacture 20,000 units of custom 19.5-inch pipe for the next ten years (which will use up 40% of the total capacity), your customer will purchase this amount for the next ten years (no growth). An average unit of 18-inch pipe sells for $100 and costs $40 to make. The tax rate for the corporation is 40% and the discount rate is 10%. Is there an opportunity cost involved for producing the custom pipe? If so, how much is it?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started