Study guide
7.3 Break-Even Analysis, Payback Period & EOQ Inventory Models
PRC Mechanical Engineer Licensure Examination MELE
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Licensing Overview, Law & Professional Ethics
1.1 MELE Facts, RA 8495 & Board Organization 1.2 Code of Ethics for Mechanical Engineers & Professional Practice 1.3 Philippine Mechanical Engineering Code (PME Code) Governance & Legal Mandates
2 Chapter 2: Advanced Mathematics & Engineering Statistics
2.1 Differential & Integral Calculus in Engineering Applications 2.2 Differential Equations & Mathematical Modeling 2.3 Applied Engineering Statistics & Quality Control Probability
3 Chapter 3: Engineering Thermodynamics
3.1 Thermodynamic State Postulate, Properties & P-V-T Equations of State 3.2 First Law Analysis for Open & Closed Thermal Systems 3.3 Second Law, Entropy, Exergy & Reversibility Analysis
4 Chapter 4: Fluid Mechanics & Hydraulic Engineering
4.1 Fluid Statics, Manometry, Hydrostatic Force & Buoyancy 4.2 Fluid Kinematics, Dynamics & Bernoulli Equation 4.3 Pipe Flow, Friction Losses & Piping Network Analysis
5 Chapter 5: Heat Transfer & Thermal Systems
5.1 Conduction Heat Transfer & Thermal Insulation Design 5.2 Natural & Forced Convection Heat Transfer Correlations 5.3 Thermal Radiation & Industrial Heat Exchanger Design
6 Chapter 6: Mechanics & Strength of Materials
6.1 Statics & Dynamics of Rigid Bodies & Engineering Linkages 6.2 Normal, Shear & Triaxial Stress-Strain Relationships 6.3 Bending Stresses, Torsion & Column Buckling Analysis
7 Chapter 7: Engineering Economics & Financial Analysis
7.1 Time Value of Money & Cash Flow Equivalence Formulas 7.2 Asset Depreciation, Taxation & Economic Evaluation Methods 7.3 Break-Even Analysis, Payback Period & EOQ Inventory Models
8 Chapter 8: Engineering Materials & Metallurgy
8.1 Ferrous & Non-Ferrous Metals, Alloys & Polymers 8.2 Phase Diagrams, Iron-Carbon System & Heat Treatment 8.3 Mechanical Testing, Fatigue Failure & Fracture Mechanics
9 Chapter 9: Machine Elements & Stress Analysis
9.1 Failure Theories, Static & Fluctuating Stress Design 9.2 Power Transmission Shafts, Keys & Rigid/Flexible Couplings 9.3 Spur, Helical, Bevel & Worm Gear Design Calculations
10 Chapter 10: Power Transmission Components
10.1 Belts, V-Belts, Chains, Wire Ropes & Flywheels 10.2 Rolling Element & Hydrodynamic Journal Bearings 10.3 Mechanical Springs, Clutches & Industrial Brakes
11 Chapter 11: Manufacturing, Fasteners & GD&T
11.1 Threaded Fasteners, Rivets & Welded Joint Analysis 11.2 Manufacturing Processes, Machine Tools & Machining Calculations 11.3 Engineering Drawing, Limits, Fits, Tolerances & GD&T
12 Chapter 12: Power Plants, Boilers & Thermal Power Cycles
12.1 Steam Power Plants & Rankine Cycles 12.2 Steam Generators, Boilers & Combustion Engineering 12.3 Internal Combustion Engines: SI & CI Cycles 12.4 Gas Turbine Power Plants & Combined Cycles
13 Chapter 13: Renewable Energy, Fluid Machinery & Plant Systems
13.1 Hydroelectric, Geothermal & Renewable Energy Power Plants 13.2 Pumps & Hydraulic Machinery 13.3 Air Compressors, Fans & Blowers
14 Chapter 14: Refrigeration, HVAC & Building Mechanical Systems
14.1 Refrigeration Systems, Cycles & Refrigerants 14.2 Psychrometrics & Air Conditioning Systems 14.3 Piping/Ductwork Design, PME Code & Industrial Safety Management
7.3 Break-Even Analysis, Payback Period & EOQ Inventory Models
Key Takeaways Explain This Topic AI
Break-even quantity Q_BE = FC / (P - VC) identifies the production volume where total sales revenue equals total operating costs.
Margin of Safety measures the percentage drop in sales volume that a company can withstand before reaching its break-even point and incurring operating losses.
Discounted payback period incorporates the time value of money, yielding a longer, more accurate capital recovery horizon than simple payback.
Economic Order Quantity (EOQ = sqrt(2DS/H)) optimizes inventory management by balancing annual ordering costs against annual holding costs.
Reorder Point (ROP = D × L + SS) establishes the minimum inventory threshold for placing purchase orders to prevent stockouts.
Last updated: July 2026
7.3 Break-Even Analysis, Payback Period & EOQ Inventory Models
Industrial mechanical engineers frequently manage factory operations, equipment selection, production scheduling, and supply chain inventory. Evaluating the operational feasibility of manufacturing processes requires quantitative techniques to establish cost structures, determine profit thresholds, evaluate capital recovery speeds, and optimize inventory holding vs. ordering expenses.
Cost-Volume-Profit (CVP) & Break-Even Analysis
Production operations divide operating costs into two primary categories based on behavior relative to output volume Q Q Q :
Fixed Costs ( F C FC FC ): Overhead expenses that remain constant regardless of production output within the relevant range (e.g., factory rent, building insurance, administrative salaries, equipment depreciation).
Variable Costs ( V C VC V C ): Expenses that vary directly in proportion to production volume Q Q Q (e.g., raw materials, direct shop labor, consumable tooling, electric power for machinery). Total variable cost is V C ( Q ) = v ⋅ Q VC(Q) = v \cdot Q V C ( Q ) = v ⋅ Q , where v v v is the unit variable cost.
Total Cost Function ( T C TC TC ): T C ( Q ) = F C + v ⋅ Q TC(Q) = FC + v \cdot Q TC ( Q ) = FC + v ⋅ Q
Total Revenue Function ( T R TR TR ): T R ( Q ) = P ⋅ Q TR(Q) = P \cdot Q TR ( Q ) = P ⋅ Q where P P P is the unit selling price.
Profit Function ( Π \Pi Π ): Π ( Q ) = T R ( Q ) − T C ( Q ) = P ⋅ Q − ( F C + v ⋅ Q ) = ( P − v ) Q − F C \Pi(Q) = TR(Q) - TC(Q) = P \cdot Q - (FC + v \cdot Q) = (P - v) Q - FC Π ( Q ) = TR ( Q ) − TC ( Q ) = P ⋅ Q − ( FC + v ⋅ Q ) = ( P − v ) Q − FC
1. Break-Even Quantity ( Q B E Q_{BE} Q BE )
The break-even point occurs at the production volume Q B E Q_{BE} Q BE where total revenue equals total cost, yielding zero operating profit ( Π = 0 \Pi = 0 Π = 0 ): Q B E = F C P − v Q_{BE} = \frac{FC}{P - v} Q BE = P − v FC
where ( P − v ) (P - v) ( P − v ) is known as the Unit Contribution Margin ( C M CM CM ) .
2. Contribution Margin Ratio ( C M R CMR CMR ) & Break-Even Revenue ( R B E R_{BE} R BE ) C M R = P − v P CMR = \frac{P - v}{P} CMR = P P − v R B E = Q B E ⋅ P = F C C M R R_{BE} = Q_{BE} \cdot P = \frac{FC}{CMR} R BE = Q BE ⋅ P = CMR FC
3. Margin of Safety ( M S MS MS )
Margin of Safety measures how far expected or actual sales volume Q a c t u a l Q_{actual} Q a c t u a l exceeds the break-even volume Q B E Q_{BE} Q BE : M S = Q a c t u a l − Q B E Q a c t u a l × 100 % MS = \frac{Q_{actual} - Q_{BE}}{Q_{actual}} \times 100\% MS = Q a c t u a l Q a c t u a l − Q BE × 100%
Payback Period Analysis
Payback period measures the time required for net cash inflows from an investment project to fully recover the initial capital outlay ( C 0 C_0 C 0 ).
1. Simple Payback Period ( S P P SPP SPP )
Simple payback ignores the time value of money. For uniform annual net cash inflow A A A : S P P = C 0 A SPP = \frac{C_0}{A} SPP = A C 0
For non-uniform annual cash flows, S P P SPP SPP is the year n n n where cumulative net cash flow turns non-negative.
Limitations: Simple payback ignores interest rates and completely neglects all cash flows occurring after the payback horizon.
2. Discounted Payback Period ( D P P DPP D PP )
Discounted payback incorporates interest rate i i i by discounting future cash flows back to t = 0 t=0 t = 0 . D P P DPP D PP is the smallest number of periods n n n satisfying: ∑ t = 1 n C F t ( 1 + i ) t ≥ C 0 \sum_{t=1}^n \frac{CF_t}{(1+i)^t} \ge C_0 t = 1 ∑ n ( 1 + i ) t C F t ≥ C 0
Inventory Control & Economic Order Quantity (EOQ)
Manufacturing plants maintain inventories of raw materials, spare parts, and components. Inventory management balances two opposing cost forces:
Annual Ordering Cost ( A O C AOC A OC ): Decreases as order quantity Q Q Q increases (fewer purchase orders placed per year). A O C ( Q ) = D Q ⋅ S AOC(Q) = \frac{D}{Q} \cdot S A OC ( Q ) = Q D ⋅ S where D D D = annual demand (units/year) and S S S = fixed cost per purchase order (₱/order).
Annual Holding / Carrying Cost ( A H C AHC A H C ): Increases as order quantity Q Q Q increases (higher average inventory held in warehouse). A H C ( Q ) = Q 2 ⋅ H AHC(Q) = \frac{Q}{2} \cdot H A H C ( Q ) = 2 Q ⋅ H where H H H = annual holding cost per unit (₱/unit-year). If holding cost is given as a percentage rate I h I_h I h , then H = I h × C u n i t H = I_h \times C_{unit} H = I h × C u ni t .
Total Inventory Cost ( T I C TIC T I C ) Function T I C ( Q ) = D Q S + Q 2 H + D ⋅ C u n i t TIC(Q) = \frac{D}{Q} S + \frac{Q}{2} H + D \cdot C_{unit} T I C ( Q ) = Q D S + 2 Q H + D ⋅ C u ni t
Derivation of Economic Order Quantity ( E O Q EOQ EOQ )
Taking the first derivative of T I C ( Q ) TIC(Q) T I C ( Q ) with respect to Q Q Q and setting it to zero: d ( T I C ) d Q = − D S Q 2 + H 2 = 0 ⟹ D S Q 2 = H 2 ⟹ Q 2 = 2 D S H \frac{d(TIC)}{dQ} = -\frac{D S}{Q^2} + \frac{H}{2} = 0 \implies \frac{D S}{Q^2} = \frac{H}{2} \implies Q^2 = \frac{2 D S}{H} d Q d ( T I C ) = − Q 2 D S + 2 H = 0 ⟹ Q 2 D S = 2 H ⟹ Q 2 = H 2 D S E O Q = 2 D S H EOQ = \sqrt{\frac{2 D S}{H}} EOQ = H 2 D S
At the optimal E O Q EOQ EOQ , annual ordering cost exactly equals annual holding cost ( A O C = A H C AOC = AHC A OC = A H C ). The minimum total annual inventory cost is: T I C m i n = 2 D S H + D ⋅ C u n i t TIC_{min} = \sqrt{2 D S H} + D \cdot C_{unit} T I C min = 2 D S H + D ⋅ C u ni t
Reorder Point ( R O P ROP ROP ) & Safety Stock ( S S SS SS )
The Reorder Point ( R O P ROP ROP ) defines the inventory level at which a new order of size E O Q EOQ EOQ must be placed to replenish stock before depletion during lead time L L L : R O P = d d a i l y × L + S S ROP = d_{daily} \times L + SS ROP = d d ai l y × L + SS
where:
d d a i l y d_{daily} d d ai l y = daily demand rate ( d d a i l y = D / operating days per year d_{daily} = D / \text{operating days per year} d d ai l y = D / operating days per year )
- L L L = replenishment lead time (days)
- S S SS SS = buffer safety stock retained to guard against demand spikes or delivery delays
- Worked Industrial Engineering Problem: Valve Production & Inventory
- Problem Statement
An industrial valve factory produces heavy stainless-steel control valves. The plant operations involve the following financial and manufacturing specifications:
- Part A: CVP & Payback Analysis
- Fixed Costs ( F C FC FC ): PHP 4 , 500 , 000 \text{PHP }4,500,000 PHP 4 , 500 , 000 /year
- Unit Variable Cost ( v v v ): PHP 1 , 200 \text{PHP }1,200 PHP 1 , 200 /valve
- Unit Selling Price ( P P P ): PHP 2 , 700 \text{PHP }2,700 PHP 2 , 700 /valve
- Maximum Plant Capacity: 4 , 500 valves/year 4,500 \text{ valves/year} 4 , 500 valves/year
An automation machine costing C 0 = PHP 6 , 000 , 000 C_0 = \text{PHP }6,000,000 C 0 = PHP 6 , 000 , 000 yields net annual cash flow A = PHP 1 , 500 , 000 A = \text{PHP }1,500,000 A = PHP 1 , 500 , 000 at interest rate i = 10 % i = 10\% i = 10% .
Part B: Inventory Optimization (EOQ)
Annual Demand ( D D D ): 12 , 000 electric motor actuators/year 12,000 \text{ electric motor actuators/year} 12 , 000 electric motor actuators/year
- Order Placement Cost ( S S S ): PHP 1 , 500 \text{PHP }1,500 PHP 1 , 500 /order
- Holding Cost ( H H H ): PHP 100 \text{PHP }100 PHP 100 /unit-year
- Delivery Lead Time ( L L L ): 6 working days 6 \text{ working days} 6 working days
- Operating Days per Year: 300 days/year 300 \text{ days/year} 300 days/year
- Safety Stock ( S S SS SS ): 100 units 100 \text{ units} 100 units
Perform the following calculations:
Compute the break-even quantity ( Q B E Q_{BE} Q BE ) and annual operating profit at full capacity (4,500 valves).
Compute the Margin of Safety ( M S MS MS ) at full capacity.
Compute the Simple Payback Period ( S P P SPP SPP ) and Discounted Payback Period ( D P P DPP D PP ) for the automation machine.
Compute the Economic Order Quantity ( E O Q EOQ EOQ ), number of orders per year, and Reorder Point ( R O P ROP ROP ) for motor actuators.
Step-by-Step Solution
Step 1: Break-Even Quantity & Operating Profit Q B E = F C P − v = 4 , 500 , 000 2 , 700 − 1 , 200 = 4 , 500 , 000 1 , 500 = 3 , 000 valves/year Q_{BE} = \frac{FC}{P - v} = \frac{4,500,000}{2,700 - 1,200} = \frac{4,500,000}{1,500} = 3,000 \text{ valves/year} Q BE = P − v FC = 2 , 700 − 1 , 200 4 , 500 , 000 = 1 , 500 4 , 500 , 000 = 3 , 000 valves/year
At full capacity Q a c t u a l = 4 , 500 Q_{actual} = 4,500 Q a c t u a l = 4 , 500 valves: Π = ( P − v ) Q − F C = ( 1 , 500 × 4 , 500 ) − 4 , 500 , 000 = 6 , 750 , 000 − 4 , 500 , 000 = PHP 2 , 250 , 000 \Pi = (P - v) Q - FC = (1,500 \times 4,500) - 4,500,000 = 6,750,000 - 4,500,000 = \text{PHP }2,250,000 Π = ( P − v ) Q − FC = ( 1 , 500 × 4 , 500 ) − 4 , 500 , 000 = 6 , 750 , 000 − 4 , 500 , 000 = PHP 2 , 250 , 000
Step 2: Margin of Safety ( M S MS MS ) M S = 4 , 500 − 3 , 000 4 , 500 × 100 % = 1 , 500 4 , 500 × 100 % = 33.33 % MS = \frac{4,500 - 3,000}{4,500} \times 100\% = \frac{1,500}{4,500} \times 100\% = 33.33\% MS = 4 , 500 4 , 500 − 3 , 000 × 100% = 4 , 500 1 , 500 × 100% = 33.33%
Step 3: Simple & Discounted Payback Period For simple payback: S P P = C 0 A = 6 , 000 , 000 1 , 500 , 000 = 4.00 years SPP = \frac{C_0}{A} = \frac{6,000,000}{1,500,000} = 4.00 \text{ years} SPP = A C 0 = 1 , 500 , 000 6 , 000 , 000 = 4.00 years
For discounted payback at i = 10 % i = 10\% i = 10% :
Year 1 discounted cash flow: 1 , 500 , 000 / 1.10 = PHP 1 , 363 , 636 1,500,000 / 1.10 = \text{PHP }1,363,636 1 , 500 , 000/1.10 = PHP 1 , 363 , 636 (Cumulative = PHP 1 , 363 , 636 \text{PHP }1,363,636 PHP 1 , 363 , 636 )
Year 2 discounted cash flow: 1 , 500 , 000 / ( 1.10 ) 2 = PHP 1 , 239 , 669 1,500,000 / (1.10)^2 = \text{PHP }1,239,669 1 , 500 , 000/ ( 1.10 ) 2 = PHP 1 , 239 , 669 (Cumulative = PHP 2 , 603 , 305 \text{PHP }2,603,305 PHP 2 , 603 , 305 )
Year 3 discounted cash flow: 1 , 500 , 000 / ( 1.10 ) 3 = PHP 1 , 126 , 972 1,500,000 / (1.10)^3 = \text{PHP }1,126,972 1 , 500 , 000/ ( 1.10 ) 3 = PHP 1 , 126 , 972 (Cumulative = PHP 3 , 730 , 277 \text{PHP }3,730,277 PHP 3 , 730 , 277 )
Year 4 discounted cash flow: 1 , 500 , 000 / ( 1.10 ) 4 = PHP 1 , 024 , 520 1,500,000 / (1.10)^4 = \text{PHP }1,024,520 1 , 500 , 000/ ( 1.10 ) 4 = PHP 1 , 024 , 520 (Cumulative = PHP 4 , 754 , 797 \text{PHP }4,754,797 PHP 4 , 754 , 797 )
Year 5 discounted cash flow: 1 , 500 , 000 / ( 1.10 ) 5 = PHP 931 , 382 1,500,000 / (1.10)^5 = \text{PHP }931,382 1 , 500 , 000/ ( 1.10 ) 5 = PHP 931 , 382 (Cumulative = PHP 5 , 686 , 179 \text{PHP }5,686,179 PHP 5 , 686 , 179 )
Year 6 discounted cash flow: 1 , 500 , 000 / ( 1.10 ) 6 = PHP 846 , 711 1,500,000 / (1.10)^6 = \text{PHP }846,711 1 , 500 , 000/ ( 1.10 ) 6 = PHP 846 , 711 (Cumulative = PHP 6 , 532 , 890 \text{PHP }6,532,890 PHP 6 , 532 , 890 )
At the end of Year 5, unrecovered capital is 6 , 000 , 000 − 5 , 686 , 179 = PHP 313 , 821 6,000,000 - 5,686,179 = \text{PHP }313,821 6 , 000 , 000 − 5 , 686 , 179 = PHP 313 , 821 . D P P = 5 + 313 , 821 846 , 711 = 5 + 0.3706 = 5.37 years DPP = 5 + \frac{313,821}{846,711} = 5 + 0.3706 = 5.37 \text{ years} D PP = 5 + 846 , 711 313 , 821 = 5 + 0.3706 = 5.37 years
Step 4: Inventory EOQ & Reorder Point E O Q = 2 × 12 , 000 × 1 , 500 100 = 36 , 000 , 000 100 = 360 , 000 = 600 units/order EOQ = \sqrt{\frac{2 \times 12,000 \times 1,500}{100}} = \sqrt{\frac{36,000,000}{100}} = \sqrt{360,000} = 600 \text{ units/order} EOQ = 100 2 × 12 , 000 × 1 , 500 = 100 36 , 000 , 000 = 360 , 000 = 600 units/order Orders per year = D E O Q = 12 , 000 600 = 20 orders/year \text{Orders per year} = \frac{D}{EOQ} = \frac{12,000}{600} = 20 \text{ orders/year} Orders per year = EOQ D = 600 12 , 000 = 20 orders/year
Daily demand rate d d a i l y = 12 , 000 300 = 40 units/day d_{daily} = \frac{12,000}{300} = 40 \text{ units/day} d d ai l y = 300 12 , 000 = 40 units/day . R O P = d d a i l y × L + S S = ( 40 × 6 ) + 100 = 240 + 100 = 340 units ROP = d_{daily} \times L + SS = (40 \times 6) + 100 = 240 + 100 = 340 \text{ units} ROP = d d ai l y × L + SS = ( 40 × 6 ) + 100 = 240 + 100 = 340 units
Conclusion: The factory achieves break-even at 3,000 valves/year with a 33.33% margin of safety. Automation capital is recovered in 4.0 years simple (5.37 years discounted). Actuator orders should be placed in batch sizes of 600 units whenever inventory drops to 340 units.