Architecting Oracle Cloud Infrastructure Solutions Ed 2, This course provides learners with advanced technical knowledge and skills to enable them to architect cloud infrastructure solutions using Oracle Cloud Infrastructure services. Oracle Capacity Planning And Sizing Spreadsheets Free Download Spreadsheets contributed us the prospective to input, transform, and calculate anything we wanted and store it digitally for again. You may construct anything from simple spreadsheet to Oracle Capacity Planning And Sizing Spreadsheets Free Download that feed off of massive data sets—the possibilities seemed endless.
Excel template resource capacity planning
This article provides details of Excel template resource capacity planning that you can download now.
Microsoft Excel software under a Windows environment is required to use this template
These Excel templates resource capacity planning work on all versions of Excel since 2007.
Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information.
To be able to use these models correctly, you must first activate the macros at startup.
The file to download presents tow Excel template resource capacity planning
- Template resource planning worksheet
Definition:
This template can be used throught the project life. From Origination to Execution
In the Origination Phase the PM can use it to get an order of magnitute need for resources.
In the Initiation phase you can use the template to work with putting assigned resources to the phases of the plan and percentage of utilization.
In the other phases of the project you can use it to do 'WHAT IF' scenerios when looking at new or changed resources prior to changing the Microsoft Project.
Usage:
Origination:
When starting the template you can put generic resources in the spreadsheet. i.e. Developer, tester, Project Mananger.
The rate for US resources is $65.00. Also, you can put any other hardware costs and consulting costs as best as you know them.
In the origination phase you should not really have to worry about when the resources will be within the phases of the plan or if they will be used more in April then June.
Initiation:
Go ahead and put names to the generic resources and work with percentages of hours needed.
Add any consultants in the template with the hourly costs as best the PM know it.
Hardware and Software Costs can now be further defined.
Execution:
As you need to make changes to your resources, whether hardware,software,or human resources you can do 'What if' scenerios and put the resources hours where you believe the resource is needed. This will help to start your change requests prior to putting the changes in Microsoft Project.
- Excel template for Capacity Analysis Report)
Instructions:
In the blue-shaded cell below, please identify the scenario or reason for the CAR submission. If unsure, then contact STA site engineer.
Capacity Planning
The 4 sheets identified below are required or suggested when submitting a pdf, hard-copy or facsimile of this CAR file to an agent of Ford Motor Company.
Sheets Required or Suggested for Submission
Capacity Planning
Shared Loading Plan - only if the manufacturing process is being used to make more than one part Historical Mfg Performance (if used for shared loading OEE)
Supplier Declarations and Notes
What is Capacity Planning?
Capacity planning refers to determining what kind of labour and equipment capacities are required and when they are required. Capacity is usually planned on the basis of labour or machine hours available within the plant. Thus, capacity planning is planning for quantity or scale of output.
There are four major considerations in capacity planning:
- Level of demand
- Cost of production
- Availability of funds
- Management policy.
Production has no meaning unless its products can be sold at a remunerative price. Generally, the capacity of plant is limited by the level of current demand. Stable demand makes the task of capacity planning simple while fluctuations in demand create problems concerning the acquisition of resources and matching them up with demand levels. Estimation of demand is, therefore, the first step in capacity planning. Size of the market depends upon the sales potential rather than on the geographical areas.
Demand Forecasts
Demand forecasting is fundamental to effective capacity and sales planning. A demand forecast establishes link between the internal management of the firm and its external environment. Before making a demand forecast, the period of forecast should be decided and an appropriate method of forecasting should be selected.
The nature of product to be sold, the size and characteristics of population, the disposable income, degree of competition, fashion, trends, political conditions, import, export policy of Government, etc., should be taken into consideration. In case of multiple products, product line forecast is useful in deciding the priority of different products in the allocation of limited resources. For example, Delhi Cotton Mills Ltd., may like to know whether to produce more of sugar or textiles.
The demand for new product can be forecast by making consumer surveys, test marketing, product life cycle analysis etc. The annual demand forecast is broken into monthly or weekly forecasts for production scheduling.
Capacity planning is an integral part of the overall production planning for an enterprise. Capacity planning and control is the process of establishing, measuring, monitoring and adjusting the levels of capacity in order to execute all manufacturing plans and schedules in the best possible manner.
Capacity planning involves the following questions.
- What type of capacity is required?
- How much capacity is required?
- When the capacity is required?
The type of capacity required depends upon the products and services which the enterprise intends to produce or provide. The quantity and timing of capacity is related to the quantity and timing of demand for the product or service. The nature of demand (stable or fluctuating) is another important consideration.
Capacity planning is an important element of production management. Decision concerning capacity are one of the most basics decisions of production. Location, layout, and production technology can be determined only after the capacity is decided. For example, Western
Electronics Ltd., can decide the number and type of machines, workers, materials and other inputs only after deciding the number of TV sets to be manufactured by it.
Importance of Capacity Planning
Capacity planning is important due to the following reasons:
- Capacity limits the rate of output. Therefore, capacity planning determines the ability of an enterprise to meet future demand for its products and services.
- Capacity influences the operating costs. Capacity is determined on the basis of estimated demand. Actual demand is often different from estimated demand. As a result, there arises excess capacity or under capacity. Excess or idle capacity increases the cost per unit of output.
Whereas under capacity results in the loss of sales.
- Capacity decisions leave a direct impact on the amount of fixed investment made initially.
- Capacity decisions result in long-term commitment of funds. Such long-term decisions cannot be reversed except at major costs.
The following concepts of capacity are involved in capacity planning:
- Design Capacity: It refers to the maximum output that can possibly be produced in a given period of time. It is the ideal situation.
- Effective Capacity: Refers to the maximum possible output, given the changes in product mix, machine maintenance, scheduling and operating problems, labour problems, etc. It is usually less than the design capacity.
- Actual Output: It is the rate of output actually achieved. It cannot exceed effective capacity due to machine breakdowns, labour absenteeism, irregular supply of raw materials, unusual delay in supply of equipment, power breakdown, etc.
The effectiveness of a production system (system effectiveness) can be measured in two ways:
- Efficiency which is the rate of actual output to effective output, and
1.2.Utilization which implies the rate of actual output to the design capacity.
Symbolically:
Efficiency = Actual Output / Effective Capacity
Oracle Capacity Planning And Sizing Spreadsheets Free Download Windows 10
Utilization = Actual Output / Design Capacity
Every operating manager should try to increase capacity utilization by increasing effective capacity.
Procedure for Capacity Planning
- Assessment of Existing Capacity
Capacity of a unit can be measured in terms of output or inputs. Output measure is appropriate in case of manufacturing concerns, e.g., automobile plant (number of cars), iron and steel plant (tons of steel), brewery (barrels of bear), cannery (tons of food), power company, (megawatts of electricity), etc. Service concerns like hospitals (number of beds), airlines (number of seats), theatres (number of seats), restaurants (number of tables), university (number of students), warehouse (cubic feet of space), etc., can measure capacity in terms of inputs.
- Forecasting Future Capacity Needs
Short term capacity requirements can be estimated by forecasting product demand at different stages of the product life cycle. It is more difficult to anticipate long-term capacity requirements due to uncertainties of market and technology. Capacity forecast helps to determine the gap between the existing capacity and estimated capacity so that necessary adjustments may be made. For example, a company engaged in manufacturing two products may find that one product has a low demand in summer (e.g. coffee or tea) while another product has low demand in winter (e.g. cold drink).
- Identifying Alternative ways of Modifying Capacity
In case where the existing capacity is inadequate to meet the forecast demand capacity, the expansion is required to meet the shortage.
Additional shifts may be employed to expand the capacity. Expansion will provide economies of scale and help in meeting the forecast demand. But it involves additional investment and danger of fall in forecast demand in future.
When the existing capacity exceeds forecast capacity, there is a need for reduction of excess capacity. Developing new products, selling of existing facilities, layout of workers or getting work from other firms are the methods of overcoming it.
- Evaluation of Alternatives
Various alternatives for capacity expansion or reduction are evaluated from economic, technical and other viewpoints. Reactions of employees and local community should also be considered. Cost Benefit analysis,
Decision theory and Queuing theory are the main techniques of evaluating alternatives.
- Choice of Suitable Course of Action
After performing the cost-benefit analysis of various alternatives to expand or reduce the capacity, the most appropriate alternative is selected.
Determinants of Effective Capacity
- Facilities
The design of production facilities is the most important determinant of effective capacity. Design includes the size and also the provision for expansion of the facilities. Design facilities should be such that the employees should feel comfortable at their work place. Location factors such as distance from the market, supply of labour, transport costs, energy sources are also important. Layout of the work area determines how smoothly the work can be performed.
Environmental factors such as lighting, ventilation, etc., influence the effectiveness with which employees can perform the assigned work.
- Products or Services
Design of the company’s products or services exerts a significant influence on capacity utilization. When more uniform is the output, greater can be the standardization of materials and methods and greater can be the utilization of capacity. For instance, a restaurant that offers a limited menu, can prepare and serve meals at a faster rate. Product mix should also be considered because different products have different rates of output.
- Process
Quantity capacity of a process is the obvious determinant of effective capacity. But if quantity of output does not meet the quality standards, the rate of output is reduced due to the need for inspection and rework activities.
- Human factors
Job design (tasks that comprise a job), nature of the job (variety of activities involved), training and experience required to perform the job, employee motivation, manager’s leadership style, rate of absenteeism and labour turnoverare the main human factors influencing the rate of output.
- Operational Factors
Materials management, scheduling, quality assurance, maintenance policies and equipment breakdowns are important determinants of effective capacity. Late delivery and low acceptability of materials will reduce effective capacity. Inventory problems are a major hurdle in a capacity utilization. Similarly, when the alternative equipment have different capabilities there may be scheduling problems.
- External Factors
Product standards (minimum quality and performance standards), pollution control regulations, safety requirements and trade union attributes exercise tremendous influence on effective capacity.
Generally, the external factors act as constraints in capacity utilization.
Workshop Crystal balls aren't really good for IT administration. Database administrators (DBAs) like certainty and clarity, and that extends to how much strain their databases will be under in the future. Capacity planning is a way to figure that out.
The concept behind capacity planning is simple, but the mechanics are harder. Capacity planning acknowledges that the business requirements on the system may increase, and forecasts how much resource must be added to the database system to ensure that the user experience continues uninterrupted.
Typically, the resources you'll add may be CPU power, memory, storage, or network capacity, or more likely a combination of these, depending on how demands are predicted to grow.
This makes capacity planning different to performance tuning, because the latter is a reactive process. You tweak the system's parameters to ensure that it does not dip below pre-set levels based on current performance requirements. You plan capacity to ensure that it does not fall below performance levels in the future.
There is no silver bullet for capacity planning. There are several tools and steps available, but to be done well, this requires a little forethought and hard work.
One tool that you can use to help plan your Oracle capacity is Quest’s Space Manager with LiveReorg. This lets you rejig your files to reclaim space on your physical media, while keeping the database up and running. It displays current space use in visual form, while also using database metrics to analyse future growth in databases that share storage resources. This extends to using 'what if' analysis, so that you can tell what happens if the order rate rises by 10 per cent, say.
What's your goal?
The easiest part will be to define your goal. A conversation with business managers will hopefully help, here. Asking them what they expect key metrics in their business to do over the next few months will help you to craft an agreement with them, so that you can plan things more effectively at your end.
Talk to the business about its metrics. It may be most interested in the number of concurrent ecommerce customer sessions it expects to see on the web site. Perhaps the number of orders per month is expected to grow by 15 per cent, or the number of customer records accessed by the call centre will grow by a specific amount during a new product upgrade.
What's your configuration?
You have to understand your database inside out before you can plan capacity, especially if you're trying to predict multiple resources. But not just the database; collecting operations statistics on your entire system will help you to determine how it is performing, and plan for the next step.
Do it when there aren't any performance crunches or unexpected spikes in demand, so that you get a reliable picture of what the system normally does. You should collect statistics on the following:
Oracle Capacity Planning And Sizing Spreadsheets Free Downloads
- Oracle Database This will naturally be the most important piece of the puzzle for a DBA. The Automatic Workload Repository (AWR) can be a good way to find some of the data on Oracle database performance, as it takes regular snapshots of key performance metrics. You can look at these metrics in a web-based viewer.
- The application Profiling the application that the database serves will help you to see if any bottlenecks exist there. The profiling tool that you use here will depend on the application framework that you're using. .NET and Java each have a variety of solutions available, for example.
- The operating system Check to see how your operating system is performing when the database is running at normal levels. Again, the tools for this will depend on the specific platform (Sysinternals can help with Windows).
- The underlying infrastructure CPU usage, network bandwidth, and storage usage, are all relevant parts of the puzzle. Collecting this data during your snapshot is an important element in the process.
Gathering this data regularly and storing it will help you to track the increased use of data resources over time. The more historical data sets that you have here, the more accurate you'll be able to get in your predictions. You can store this data either in the AWR itself for smaller systems, or for larger, enterprise systems, in a dedicated Capacity Management Information System (CMIS).
If storing your statistical data in the AWR, you can use the AWR baseline to compare multiple snapshots of data over time. Ideally, you'll want enough of these snapshots to highlight times of peak load and normal operation. You can use then use Enterprise Manager to chart that historical data.
Get your statistics textbook and spreadsheet out
You need to find the average of these data points over time. One way to do that is to find the mean average (the sum of all the values, divided by the number of values). This will take units of peak load and poor performance into account. If you'd rather ignore that extreme data, you can use a median, in which you order the data (from lowest to highest, say) and take the median of the middle two values. This will remove the data that doesn't represent the norm.
If you're going after specific goals or questions (e.g.: 'how many more orders a day can I process with the current CPU resource?') then statistical analysis can be useful. Details are beyond the scope of this document, but you can use functions such as correlations to find out how much an increase in one metric relates to the increase in another.
You might find that CPU usage is likely to be affected by the number of updates in a particular table column, for example. This could then help you to calculate the rough number of updates to that particular column permitted by a certain number of CPUs, at a specific CPU usage rate.
Excel spreadsheets are a common way to calculate these results, and there is a variety of pre-baked Oracle capacity planning spreadsheets available for sale online.
Oracle Capacity Planning And Sizing Spreadsheets Free Download 64-bit
Set your thresholds
Your thresholds are levels of system usage beyond which you don't want to move. Thresholds can be set on all kinds of metrics in Oracle, such as cumulative user logins, for example.
These thresholds will help you to monitor when your resource capacity is starting to fall behind. As the number of critical alerts increases, it'll be a good sign that your capacity planning model needs to be revised, and new resource potentially added.
Capacity planning isn't the easiest of tasks for Oracle DBAs, and statistical modelling is never a completely sure thing. The further out you try to plan, the less accurate your details may become, which is why regular revision of your statistical data and recalculation of capacity baselines is a good idea.
Oracle Capacity Planning And Sizing Spreadsheets Free Download Free
This technical know-how, complemented by regular communication with business users to see what new demands are coming down the pipe, will help to keep your database ready for the challenges that a healthy business will inevitably throw at it.
Most importantly, it will keep you in control of your systems. This is a far better place to be than the alternative. No one wants to be thrown into reactive mode as they scurry to fix performance problems that were months in the making - if only they had the foresight to spot them. ®
The Register is running a series of Oracle DBA workshop articles in association with Dell Software.