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 business tool includes
1 Downloadable Excel Workbook
Nancy S. Sato Misawa offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Cost Benefit Excel TemplateCost-Benefit Template in Excel to work out your various costs, savings, and revenues.businessrevenuescostsexcelspreadsheetssavingscost benefittotal costsrecurring costs1,969 remove_red_eye
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&lrevenuesaccountingexpensescostsincomeprofit and loss statement174 remove_red_eyefreeby KAAS
Modelling Volume - Spark Financial ModelLearn how to model volume and volume drivers within the Spark Financial Model.revenuerevenuescostsassumptionsfinancial modelingrevenue modelvolumehow tostep by step30 remove_red_eyefreeby David Liu
2017 Round 1: Go With the FlowExcel training/competition model from the 2017 Financial Modeling World Championshipsrevenuescostsexcel modelexcel skillsfinancial modeling skillsexcel trainingexcel modeling training24 remove_red_eyefreeby MODELOFF
Frameworks for Selected Engineering Project Management ReportsE-Book sample providing frameworks for a range of engineering project management reports.managementstructuresampleebookreportingengineering79 remove_red_eye
How to Prepare a Cost of Goods Manufactured StatementVideo on how to prepare a statement for cost of goods manufactured.cogscostsvideohow toyoutubecost of goods manufactured117 remove_red_eyefreeby David Burrell
How to Conduct a Retail Rate Analysis of Batteries and SolarThis is an efficient tool for performing an evaluation of the market structure of electricity and battery prices.marketanalysiscostschartssolarelectricitybatteriesirradiationretail rate160 remove_red_eye
E-commerce Excel Model TemplateE-commerce Model in Excel that enables you to estimate the value of the e-commerce depending on KPIsprofitlosssalesrevenuebusiness modelfinancial modelcostskpise-commerce2,077 remove_red_eye$5.00by Asen Gyczew
13 Strategies to Improve the Loyalty of Existing Connections on LinkedInHow to STOP Adding New Connections Every Day on LinkedIn AND Get Better Results in Messaging and Creating Conversationspersonal brandinglinkedinnetworkingjob searchengineeringcareerjobs100 remove_red_eyefreeby Nader Mowlaee
Fluid Flow Excel WorkbookExcel Workbook aligning with Chapter 4: 'Fluid Flow' in the textbook "Rules of Thumb for Chemical Engineers."vbaengineeringfunction subroutinesworkbookrules of thumb for engineers76 remove_red_eyefreeby Stephen Hall
Any questions on Excel Workbook For Calculating Revenues & Costs Of Water Fabrication?
The user community and author are here to help. Go ahead!