Scribd
Upload
4 views18 pages

Profitability and Debt Analysis Report

The document presents a series of optimization problems involving multiple types of resources and constraints, focusing on profitability, labor, paint, and board requirements. It also includes a detailed analysis of debts in service, bad debts, and their respective percentages over multiple periods. Additionally, the document outlines various mathematical formulations and constraints related to resource allocation and financial management.

Uploaded by

Ishan Aggarwal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views18 pages

Profitability and Debt Analysis Report

The document presents a series of optimization problems involving multiple types of resources and constraints, focusing on profitability, labor, paint, and board requirements. It also includes a detailed analysis of debts in service, bad debts, and their respective percentages over multiple periods. Additionally, the document outlines various mathematical formulations and constraints related to resource allocation and financial management.

Uploaded by

Ishan Aggarwal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Type 1 Type 2 Type 3

x1 x2 x3 u1 v1 u2 v2
385.2941 197.0588 0 0 0 0 269.1176

Objective 1

Min u1 Profitability 1600 2200 24 1 -1


Min v2 Labor 1.5 3 2 1 -1
Min v3 Paint 3 2 3
Min v4 Board 2 2 4
u3 v3 u4 v4
0 0 435.2941 0

1050000 = 1050000
900 = 900
1 -1 1550 = 1550
1 -1 1600 = 1600
x1 x2 x3 u1 v1 u2 v2
150 0 337.5 0 0 0 0

Objective 1

Min u1 Profitability 1600 2200 2400 1 -1


Min v2 Labor 1.5 3 2 1 -1
Min v3 Paint 3 2 3
Min v4 Board 2 2 4

Additional Constraints
1
u3 v3 u4 v4
87.5 0 0 50

1050000 = 1050000
900 = 900
1 -1 1550 = 1550
1 -1 1600 = 1600

0= 0
x1 x2 x3 u1 v1 u2 v2
237.5 0 279.1667 0 0 0 14.58333

Objective

Min u1 Profitability 1600 2200 2400 1 -1


Min v2 Labor 1.5 3 2 1 -1
Min v3 Paint 3 2 3
Min v4 Board 2 2 4

Additional Constraints
1
1
u3 v3 u4 v4
0 0 8.333333 0

1 0

1050000 = 1050000
900 = 900
1 -1 1550 = 1550
1 -1 1600 = 1600

0= 0
0= 0
x1 x2 x3 u1 v1 u2 v2
150 0 337.5 0 0 0 0

Objective

Min u1 Profitability 1600 2200 2400 1 -1


Min v2 Labor 1.5 3 2 1 -1
Min v3 Paint 3 2 3
Min v4 Board 2 2 4

Additional Constraints
1
1
u3 v3 u4 v4
87.5 0 0 50

1 50

1050000 = 1050000
900 = 900
1 -1 1550 = 1550
1 -1 1600 = 1600

0= 0
0= 0
1 0= 0
in service without delay in service with delay Unserviced Debts
Debt in service without delay 80% 15% 5%
Debt in service with delay 10% 50% 40%
Unserviced Debts 0% 40% 0%
Bad Debt 0% 0% 0%

in service without delay in service with delay Unserviced Debts


Period 0 1 0 0
Period 1 0.80 0.15 0.05
Period 2 0.66 0.22 0.10
Period 3 0.55 0.25 0.12
Period 4 0.46 0.25 0.13
Period 5 0.39 0.25 0.12
Period 6 0.34 0.23 0.12
Period 7 0.29 0.21 0.11
Period 8 0.26 0.19 0.10
Period 9 0.23 0.18 0.09
Period 10 0.20 0.16 0.08
Period 11 0.17 0.14 0.07
Period 12 0.15 0.13 0.07
Period 13 0.14 0.11 0.06
Period 14 0.12 0.10 0.05
Period 15 0.11 0.09 0.05
Period 16 0.09 0.08 0.04
Period 17 0.08 0.07 0.04
Period 18 0.07 0.06 0.03
Period 19 0.06 0.05 0.03
Period 20 0.06 0.05 0.03
Period 21 0.05 0.04 0.02
Period 22 0.04 0.04 0.02
Period 23 0.04 0.03 0.02
Period 24 0.03 0.03 0.02
Period 25 0.03 0.03 0.01
Period 26 0.03 0.02 0.01
Period 27 0.02 0.02 0.01
Period 28 0.02 0.02 0.01
Period 29 0.02 0.02 0.01
0.02 0.01 0.01
0.01 0.01 0.01
0.01 0.01 0.01
0.01 0.01 0.01
0.01 0.01 0.00
0.01 0.01 0.00
0.01 0.01 0.00
0.01 0.01 0.00
0.01 0.01 0.00
0.01 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
Bad Debts
0%
0%
60%
100%
p1 p2 p3 p4
Bad Debts
0
0.00
0.03
0.09
0.16
0.24
0.31
0.38
0.45
0.51
0.56
0.61
0.66
0.69
0.73
0.76
0.79
0.81
0.83
0.85
0.87
0.88
0.90
0.91
0.92
0.93
0.94
0.94
0.95
0.96
0.96
0.97
0.97
0.97
0.98
0.98
0.98
0.98
0.99
0.99
0.99
0.99
0.99
0.99
0.99
0.99
0.99
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
x1 x2 x3 x4 x1^0.2 x2^0.4
1243.178 29250.87 57492.57 12013.38 4.158213 61.15832
10 8

1 1 1 1
x3^0.4 x4^0.3
80.13914 16.74556 1760.447
12 16

100000 <= 100000


x1 x2 x3 x4 x5 x6 x7 x8

1.5 0.8 1.3 0.6

1 -70
1 -50
1 -60
1 -40
>=

You might also like