Supply chain management

profileRust99
ESCENARIOSPYG.xlsx

Hoja1

A) INCREASE 10% SALES
SALES 220 SALES 242
COST OF MATERIALS 120 55% COST OF MATERIALS 133.1 55%
OTHER VARIABLE COSTS 22 10% OTHER VARIABLE COSTS 24.2 10%
FIX COSTS 55 25% FIX COSTS 55 23%
PROFIT AND LOSS 23 10% PROFIT AND LOSS 29.7 12%
C) INCREASE 10% PRICES D) DECREASE 10% MAT. COSTS
SALES 242 SALES 220
COST OF MATERIALS 120 50% COST OF MATERIALS 108.9 50%
OTHER VARIABLE COSTS 24.2 10% OTHER VARIABLE COSTS 22 10%
FIX COSTS 55 23% FIX COSTS 55 25%
PROFIT AND LOSS 42.8 18% PROFIT AND LOSS 34.1 16%

Hoja2

Hoja3