Publication number: ELQ-91116-1
View all versions & Certificate
Excel Workbook for Calculating Revenues & Costs of Water Fabrication
This Excel Workbook provides models to help you calculate revenues and costs of water fabrication.
This workbook presents spreadsheet models in excel that you can use to calculate revenues and the costs of water fabrication. The intention here is to provide an engineering analyst with the tools to evaluate the impact economically of process and equipment changes, process/equipment installation timing changes, changes in the time it takes to ramp up die yield, and manufacturing cycle time changes. Cash flows are computed for both cash flows for expenditures and revenues from fabrication.
Currently, the models make the assumption that the fabrication line operates a single process technology that will consist of up to 300 major process steps using max. 50 major kinds of process equipment. The user is able to compute revenues and costs for 1 out of 2 basic cases:
1. Wafer start volumes being pre-specified over a period of time
2. Equipment counts are pre-specified over a period of time
In the first case, reduced process times or higher equipment efficiencies will result in decreased investment in facilities and equipment to accommodate the wafer starts that have been pre-specified. Higher yields in this case will result in decreased investment costs as well as revenues that are higher for given wafer start volumes. In the second case, reduced process times or higher equipment efficiencies will result in higher wafer throughput for the given equipment set, and therefore both lower costs and higher revenues per wafer. Higher yields here will therefore result in a higher die throughput for the given equipment set and both lower costs and higher revenues per wafer.
An enhanced version of SEMATECH's Cost-resource Model is used to calculate the fab expenses. The model accounts for expenses generated by fab construction and operation. To compute die costs and wafer, all die and wafers produced throughout the technology's life, are all burdened with capital expenses equally. The main differences in comparison to CRM are:
1. Staffing costs are computed for various levels of fab automation
2. Rather than average throughput rates and availability, equipment performance is defined by the user in terms of theoretical throughput rates and CEE.
When you calculate the fab revenues, it will account for a user-specified reduction in die prices over time. Delays for fab construction, equipment installation and qualification, process development and qualification, manufacturing cycle time, and yield ramp all depress revenues that are obtained from the process technology over the period of its life. The Delay Cost Model presents a die cost equivalent which results from delays for qualification and development, equipment installation and qualification, time to ramp die yield, factory construction, and manufacturing cycle time.
This workbook includes seven spreadsheets:
1. The Introduction
2. The Input Data
3. The Process Data
4. The Expense Cost Calculation
5. The Total Cost Spreadsheet
6. The Number of Tools Spreadsheet
7. The Personnel Requirements Spreadsheet
8. The Phased Capacity Spreadsheet
*Originally shared on industrial-ebooks.com*
This Best Practice includes
1 Downloadable Excel Workbook
Nancy S. Sato Misawa offers you this Best Practice for free!
download for free
Add to bookmarks
- Rate this Downloadable Best Practice
Write a review
- Zlo Bog(last updated: 11/10/2019 12:08)
People using this Best Practice also downloaded
2017 Round 1: Go With the FlowExcel training/competition model from the 2017 Financial Modeling World Championshipsrevenuescostsexcel modelexcel skillsfinancial modeling skills250add_shopping_cart
Cost Benefit Excel TemplateCost-Benefit Template in Excel to work out your various costs, savings, and revenues.businessrevenuescostsexcelspreadsheets4,863add_shopping_cart
Profit & Loss Statement Template in ExcelP & L statement template in excel for a month or a year including a column for the previous year and budgeted figures.profitlossincome statementp&lrevenues513add_shopping_cartfreeby KAAS
Modelling Volume - Spark Financial ModelLearn how to model volume and volume drivers within the Spark Financial Model.revenuerevenuescostsassumptionsfinancial modeling77freeby David Liu
Costing Spreadsheet - Calculate Profit per Product or ServiceA video on how to create a costing spreadsheet for a product or a service.profitproductpricingcostsspreadsheet3,545
Binary Number Converter Download SpreadsheetThis tool simulates a Binary Coded Decimal (BCD) to 7 segment display driver circuit.converterengineeringbinarydisplay driver circuit237add_shopping_cart
PID Loop Simulator SpreadsheetThis spreadsheet simulates a control loop using a PID controller.engineeringpid loopsimulatorpid controller1,412add_shopping_cart
Frameworks for Selected Engineering Project Management ReportsE-Book sample providing frameworks for a range of engineering project management reports.managementstructuresampleebookreporting243add_shopping_cartfreeby Dr. Johan Gouws
How to Prepare a Cost of Goods Manufactured StatementVideo on how to prepare a statement for cost of goods manufactured.cogscostsvideohow toyoutube526freeby David Burrell
Collection of Useful Excel Sheets for EngineersCollection of 28 sheets in one excel file made exclusively for engineers to make their lives easier.excelengineeringspreadsheetsusefulcalculators388add_shopping_cartfreeby Norman May
Any questions on Excel Workbook For Calculating Revenues & Costs Of Water Fabrication?
The user community and author are here to help. Go ahead!