Home > Excel Business Solutions > Operations and Management > Manufacturing and Engineering > Production Planning Share

Production Planning

Excel production planning for manufacturing and engineering

Excel Production Planning

Rate this solution:
(3.2/5 from 6 votes)
Production Planning screenshot
Excel Templates for Production Planning include: Aggregate production planning, Run-out time production planning, and Learning curves.

Aggregate production planning is the process of determining (1) the timing and quantity of production, (2) the level of inventories, (3) the number of workers employed, and (4) the amount of overtime used for up to 12 months ahead. Production and inventories are stated in overall or aggregate quantities, such as number of automobiles without regard to model or color or number of pairs of shoes without regard to style or size. Cost minimization is rarely the only goal in aggregate planning. Other considerations, such as stability of the workforce and maintenance of adequate inventory levels, are usually just as important.

The aim of the Run-out time production planning template is to give each inventory item the same run-out time, defined as the number of weeks the inventory will last at current demand rates. Of course, the demand forecasts change weekly, so run-out time is updated weekly. Management controls the model by specifying the number of hours to be worked next week on stock production. Other inputs include the item description, the production hours required to produce 1 unit, the inventory on-hand in units, and the demand forecast for the next week in units.

The learning curve is a widely-used model that predicts a reduction in direct labor hours or costs per unit as cumulative production increases.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2018-06-01)

Related Excel Solutions for Production Planning

Inventory ManagementSupply Chain and Inventory  Material Requirements PlanningSupply Chain and Inventory  Economic Order Quantity (EOQ) TemplateSupply Chain and Inventory  Six Sigma TemplatesProcess Management  Continuous Process ImprovementProcess Management  Resource ManagementManufacturing and Engineering

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.