Oracle Capacity Planning And Sizing Spreadsheets Free Download

Posted : admin On 1/26/2022

The Oracle DBA Capacity planning Spreadsheet Utilities package contains Excel spreadsheets for use in Oracle capacity planning. Included in the package are: Oracle table sizing spreadsheet – This can be used to predict table sizes before a table is created or to predict future growth. Unix and Solaris Capacity Planning. The server monitoring and capacity planning abilities help plan virtualization efforts with capability to monitor CPU, memory, disk, network traffic, etc. It also helps understand how resource usage varies across time. Oracle Capacity Planning. Connect to almost any database, drag and drop to create visualizations, and share with a click. May 7, 2010 - Execution Plan. Because as Oracle is scanning the table, it simply ignores the first row. This is a dynamic list of unpredictable size that will constantly be. It does not speak to whether or not that person has the capacity to learn.

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:

  1. Level of demand
  2. Cost of production
  3. Availability of funds
  4. 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.

  1. What type of capacity is required?
  2. How much capacity is required?
  3. 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:

  1. Capacity limits the rate of output. Therefore, capacity planning determines the ability of an enterprise to meet future demand for its products and services.
  2. 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.

  1. Capacity decisions leave a direct impact on the amount of fixed investment made initially.
  2. 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:

  1. Design Capacity: It refers to the maximum output that can possibly be produced in a given period of time. It is the ideal situation.
  2. 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.
  3. 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:

  1. 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

Utilization = Actual Output / Design Capacity

And

Every operating manager should try to increase capacity utilization by increasing effective capacity.

Procedure for Capacity Planning

  1. 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.

  1. 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).

  1. 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.

  1. 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.

  1. 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

  1. Facilities

Oracle Capacity Planning And Sizing Spreadsheets Free Download Windows 10

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.

  1. 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.

  1. 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.

Oracle Capacity Planning And Sizing Spreadsheets Free Download 64-bit

  1. 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.

  1. 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.

  1. 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.