Manufacturer : User Solutions, Inc
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 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.
It is easy to do what-if analysis with the RUNOUT
model. To illustrate, Brookshire management wants to schedule overtime to get run-out
time up to 1 week of stock for every item. How many hours of stock production are
needed? Increase cell F4 until you get run-out time of 1 week. A total of 46
hours are required.Operations Manager
Learning curves (LEARN)
The learning curve is a widely-used model that predicts a reduction in direct labor hours or costs per unit as cumulative production increases.
For over 12 years User Solutions, Inc. has been the easy choice for thousands of companies worldwide.
Please note that Operations Manager - Saver Package contains many business Excel spreadsheets: production planning, inventory management, job scheduling, quality control, analysis of waiting lines, and more.
Additional Information: Operations Manager
|Require Excel 97 or
30-day money back guarantee.
|FULL Business Operations Manager||$129.00|
To manage all organization resources, please see Resource Manager for Excel
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Contact Management Document Management Sales Management
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Cash Flow Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment IRR Management Marketing NPV Planners Project Management Quality Control Schedulers )
MS Excel Add-ins, Spreadsheets, Templates