Plan Agregado de Producción con Fuerza de Trabajo Mínima y Subcontratación en Excel

Production Planning Using Minimum Workforce and Outsourcing

Introduction to Production Planning

• The video introduces the concept of industrial engineering, focusing on production planning, management, research, optimization, and problem-solving within companies.

• It discusses developing a production plan using a minimum workforce strategy combined with outsourcing to meet production demands without maintaining inventory.

Key Concepts in Workforce Management

• The planning horizon is set for six months, requiring identification of working days and monthly demand based on historical sales or market studies.

• Important parameters include average production per worker, initial workforce size, daily labor costs, hiring and firing costs, subcontracting unit costs, initial inventory (set to zero), and work hours per day (eight hours).

Calculating Labor Requirements

• Total working days are calculated alongside total demand over the six-month period (17,000 units).

• Monthly output per worker varies based on the number of working days; for January, it’s determined by multiplying 23 days by an average output of 15 units per worker.

Determining Minimum Workforce Needs

• The method emphasizes using the minimum number of workers required during the month with the lowest demand; this figure will be constant throughout the planning period.

• A formula is used to calculate required workers by dividing monthly demand by units produced per worker. This helps identify that April has the lowest requirement at approximately 7.94 workers.

Adjusting Workforce Numbers

• The minimum number of workers is rounded up to eight for practical purposes across all months.

• Current workforce numbers are established before implementing changes; if required workers exceed current staff levels, new hires are made accordingly.

Managing Hires and Dismissals

• Conditional statements determine whether additional hires or dismissals are necessary based on comparisons between current and required workforce numbers.

• For February's calculations: if more workers are needed than currently available (12), four will be dismissed as part of adjusting operational needs.

This structured approach provides a comprehensive overview of how to effectively manage labor resources in production planning while adapting to fluctuating demands through strategic outsourcing.

Production Planning Using Minimum Force Method

Overview of Inventory and Production Units

• The method discussed assumes inventories are effectively zero, meaning produced units equal available units. A formula is introduced: available units = produced units + initial inventory (which is 0).

• A conditional calculation for inventory is presented: if available units exceed demand, then inventory exists as the difference between available units and demand; otherwise, it remains zero.

Calculating Shortages and Available Units

• Another conditional statement calculates shortages: if demand exceeds available units, the shortage equals demand minus available units; otherwise, it’s zero. For January, there are 40 units to subcontract due to this difference.

• Moving into February, the calculation for available units again reflects that they equal produced units plus previous month's inventory (still 0).

Cost Calculation Breakdown

• The speaker begins calculating costs associated with the production plan. Costs for hiring workers are calculated based on the number of hired operatives multiplied by their cost ($300).

• Costs for layoffs are similarly calculated using a formula based on laid-off operatives and their respective costs.

Labor and Storage Costs

• Labor costs are determined by multiplying utilized operatives by working days in a month (23 days at $95 per day).

• Although storage costs would be $0 due to no inventory, a formula is still provided: inventory multiplied by storage cost per unit ($18).

Total Cost Analysis Across Months

• The total costs for each detail are summed up. For example, hiring costs amount to $0 while layoff costs reach $2,000. Subcontracting totals around $11,200.

• An analysis reveals April as the cheapest month with total costs of $16,320 due to having no subcontracted units that month.

Relationships Between Variables

• A relationship between monthly costs and utilized operatives shows that while operative numbers remain constant, monthly costs fluctuate significantly.

• Another relationship highlights how utilized operatives correlate with produced units; February sees the lowest production compared to higher outputs in January and March.

Conclusion and Resources

• The video concludes with an invitation for questions or suggestions from viewers. It also mentions that a free template can be obtained via a link in the video description for users to fill out blank cells which will auto-generate results.