### Archive

Posts Tagged ‘Forecasting’

## Alison Platform

Alison

via Alison.com Platform

03.06.2018

Online Educational Course “Forecasting – Winter’s Models, Goodness of forecast, Aggregate Planning, Tabular Method”

by G. Srinivasan

Learn how aggregate planning is used in many businesses to match supply and demand of output over the medium time range of up to approximately 12 months in the future by studying the course Applied Operations Management – Aggregate Planning.

Aggregate planning allows management to quantify materials and other resources that are to be procured so that the total cost of operations are kept to the minimum over a set period of time. The course begins by introducing the concept of aggregate planning and its use in medium term planning in businesses. You will be introduced to aggregate planning methodologies such as the tabular method and linear programming.

You will learn how a tabular approach uses spreadsheets and the values of different variables, such as production by regular workforce and inventory levels can be calculated by using the costs associated with production, overtime, subcontracting, hiring, inventory and back-orders. The tabular method is widely used because it is easy to understand and utilize. However, the generated solution may not be optimal and many trials and errors may be needed to find the optimal solution. The course also introduces the linear programming technique and a special type of linear programming known as the Transportation Model, which can be used to obtain aggregate plans that would allow balanced capacity and demand and the minimization of costs.

This course will be of great interest to all professionals working in the areas operations management or general management who would like to learn more about aggregate planning and the methods used in this important area of operations management. The course will also be of interest to all learners who are interested in operations management as a future career.

The key points from this module are:

Forecasting can be defined as the estimate of future demand.

Aggregate planning is carried out once information about future demand is obtained from forecasting.

A poor Aggregate Plan can result in the following:
– Lost sales and profits if unable to meet demand
– A large amount of excess inventory and capacity which increases costs

The question ‘What should the production capacity be such that the total production cost is minimized?’ is known as the aggregate planning problem.

The following costs are used to calculate the minimum production capacity production cost:
– Regular Time cost
– Overtime cost
– Inventory cost
– Shortage cost

The formula for Total Capacity is:
Total Capacity = Regular Time Capacity + Overtime Capacity

Regular time production is assumed to be less costlier than overtime production. Back order cost can be defined as the cost of back ordering per unit per month. Increasing or decreasing the number of production employees does not affect the regular time production capacity.

Linear Programming

R(t) – Regular Time production used in time t
O(t) – Overtime production used in time t
D(t) – Demand during time t
S(t) – Shortage at the end of period t
U(t) – Under utilization in period t
H(t) – Number of people hired in period t
W(t) – Number of people working in period t
L(t) – Number of people laid off in period t

In the linear programming formulation ‘I(t)’ (the inventory at the end of the previous period) has to be defined as a unrestricted variable which can take positive value or a negative value. Linear programming is a method to achieve the best outcome (such as maximum profit or lowest cost) in a mathematical model whose requirements are represented by linear relationships. In aggregate planning the planning horizon is often divided into Periods. The physical resources of the company are assumed to be fixed during the planning horizon of interest.

The following help a company cope with demand fluctuations:

– Changing the size of the work force by hiring and firing.
– Varying the production rate by introducing overtime.
– Accumulating seasonal inventories.
– Planning backorders.

The following costs are relevant to aggregate production planning:
– Basic production costs
– Costs associated with changes in the production rate
– Inventory related costs

In aggregate production planning the following are examples of basic production costs
– Material costs
– Direct labor costs

In aggregate production planning the following are costs associated with changes in the production rate:
– Hiring costs
– Training costs
– Laying off personnel costs

In the Aggregate Planning Problem the following are examples of constraints:
– Limits on overtime
– Limits on layoffs
– Limits on capital available
– Limits on stockouts and backlogs

Score

Categories: Online Courses