planning & control assignment final
DESCRIPTION
aTRANSCRIPT
![Page 1: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/1.jpg)
xYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
XYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
x
68 70 72 74 761600
1650
1700
1750
1800
1850
1900 1879
17201717
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
1032010299
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
![Page 2: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/2.jpg)
Year Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
0.8 1 1.2 1.4 1.6 1.8 20
0.2
0.4
0.6
0.8
1
1.21
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
![Page 3: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/3.jpg)
yOperating Expenses ($millions)
106241032010299
YSelling & Administrative Expense ($millions)
187917201717
y
68 70 72 74 761600
1650
1700
1750
1800
1850
1900 1879
17201717
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
1032010299
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
![Page 4: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/4.jpg)
Depreciation & Amortization Expense ($millions)158815271522
0.8 1 1.2 1.4 1.6 1.8 20
0.2
0.4
0.6
0.8
1
1.21
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
![Page 5: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/5.jpg)
![Page 6: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/6.jpg)
![Page 7: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/7.jpg)
![Page 8: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/8.jpg)
![Page 9: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/9.jpg)
![Page 10: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/10.jpg)
![Page 11: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/11.jpg)
![Page 12: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/12.jpg)
![Page 13: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/13.jpg)
ASSIGNMENT#1
Q.1 (A)x
Year Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
XYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
68 70 72 74 761600
1650
1700
1750
1800
1850
1900 1879
17201717
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
69 70 71 72 73 74 7510100
10200
10300
10400
10500
10600
10700 10624
1032010299
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
![Page 14: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/14.jpg)
xYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
Q.1 (B)x
Year Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
1032010299
f(x) = 80.302756425x + 4633.0702224441R² = 0.8041454314
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
68 70 72 74 761600
1650
1700
1750
1800
1850
1900 1879
17201717
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
0.8 1 1.2 1.4 1.6 1.8 20
0.2
0.4
0.6
0.8
1
1.21
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
![Page 15: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/15.jpg)
It includes the fixed cost of $4633.1 million and variable cost of $80.303 million.
xYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
The variable cost of $40.044 million and fixed cost is showing the negative value of $1110.9 million.
xYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
1032010299
f(x) = 80.302756425x + 4633.0702224441R² = 0.8041454314
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
69 70 71 72 73 74 751600
1650
1700
1750
1800
1850
1900 1879
17201717
f(x) = 40.0435244986x - 1110.8668070671R² = 0.7701326908
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
![Page 16: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/16.jpg)
It contains the fixed cost of $371.74 million whereas it has the variable cost of $16.306.
Q.1 (C)x
Year Passenger Cruise Days (millions)2013 74.0332011 69.971
Operating Expense is a mixed cost with $4700.6 million of fixed cost and $80.01 million of variable cost.
0.8 1 1.2 1.4 1.6 1.8 20
0.2
0.4
0.6
0.8
1
1.21
f(x) = + 1R² = 0
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
10299
f(x) = 80.0098473658x + 4700.6309699655R² = 1
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expense ($millions)
![Page 17: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/17.jpg)
xYear Passenger Cruise Days (millions)2013 74.0332011 69.971
xYear Passenger Cruise Days (millions)2013 74.0332011 69.971
The variable cost is $39.882 million and fixed cost shows the negative value of $1073.6 million which will decrease the total fixed cost.
69 70 71 72 73 74 751600
1650
1700
1750
1800
1850
1900 1879
1717
f(x) = 39.88183161x - 1073.5716395864R² = 1
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
69 70 71 72 73 74 751480
1500
1520
1540
1560
1580
1600 1588
1522
f(x) = 16.2481536189x + 385.1004431315R² = 1
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
![Page 18: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/18.jpg)
Q.2
xYear Passenger Cruise Days (millions)2013 74.0332012 71.9762011 69.971
Fixed Cost is $3893.9 million and variable cost is $136.65 million.
This model is 79.52% best fitted and explains the relationship among variables by 79.52%.
Depreciation & Amortization Expense is a mixed cost with $385.1 million of fixed cost and $16.248 million of variable cost.
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.513200
13400
13600
13800
14000
14200 14091
1356713538
f(x) = 136.6523726322x + 3893.9401862978R² = 0.7952142253
Total Cost to Passenger Cruise Days
Passenger Cruise Days (millions)
Total Cost ($millions)
![Page 19: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/19.jpg)
Carnival Corporation's
yOperating Expenses ($millions)
106241032010299
YSelling & Administrative Expense ($millions)
187917201717
68 70 72 74 761600
1650
1700
1750
1800
1850
1900 1879
17201717
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
69 70 71 72 73 74 7510100
10200
10300
10400
10500
10600
10700 10624
1032010299
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
![Page 20: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/20.jpg)
yDepreciation & Amortization Expense ($millions)
158815271522
yOperating Expenses ($millions)
106241032010299
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
1032010299
f(x) = 80.302756425x + 4633.0702224441R² = 0.8041454314
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
68 70 72 74 761600
1650
1700
1750
1800
1850
1900 1879
17201717
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
0.8 1 1.2 1.4 1.6 1.8 20
0.2
0.4
0.6
0.8
1
1.21
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
![Page 21: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/21.jpg)
It includes the fixed cost of $4633.1 million and variable cost of $80.303 million.
ySelling & Administrative Expense ($millions)
187917201717
The variable cost of $40.044 million and fixed cost is showing the negative value of $1110.9 million.
yDepreciation & Amortization Expense ($millions)
158815271522
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
1032010299
f(x) = 80.302756425x + 4633.0702224441R² = 0.8041454314
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expenses ($millions)
69 70 71 72 73 74 751600
1650
1700
1750
1800
1850
1900 1879
17201717
f(x) = 40.0435244986x - 1110.8668070671R² = 0.7701326908
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
![Page 22: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/22.jpg)
It contains the fixed cost of $371.74 million whereas it has the variable cost of $16.306.
yOperating Expenses ($millions)
1062410299
Operating Expense is a mixed cost with $4700.6 million of fixed cost and $80.01 million of variable cost.
0.8 1 1.2 1.4 1.6 1.8 20
0.2
0.4
0.6
0.8
1
1.21
f(x) = + 1R² = 0
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.510100
10200
10300
10400
10500
10600
10700 10624
10299
f(x) = 80.0098473658x + 4700.6309699655R² = 1
Operating Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Operating Expense ($millions)
![Page 23: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/23.jpg)
ySelling & Administrative Expense ($millions)
18791717
yDepreciation & Amortization Expense ($millions)
15881522
The variable cost is $39.882 million and fixed cost shows the negative value of $1073.6 million which will decrease
69 70 71 72 73 74 751600
1650
1700
1750
1800
1850
1900 1879
1717
f(x) = 39.88183161x - 1073.5716395864R² = 1
Selling & Administrative Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Selling & Administrative Expense ($millions)
69 70 71 72 73 74 751480
1500
1520
1540
1560
1580
1600 1588
1522
f(x) = 16.2481536189x + 385.1004431315R² = 1
Depreciation & Amortization Expense to Passenger Cruise Days
Passenger Cruise Days (millions)
Depreciation & Amortization Expense ($millions)
![Page 24: Planning & Control Assignment Final](https://reader034.vdocuments.us/reader034/viewer/2022042721/55cf8676550346484b97dd69/html5/thumbnails/24.jpg)
Q.2
yTotal Cost ($millions)
140911356713538
Fixed Cost is $3893.9 million and variable cost is $136.65 million.
This model is 79.52% best fitted and explains the relationship among variables by 79.52%.
Depreciation & Amortization Expense is a mixed cost with $385.1 million of fixed cost and $16.248 million of
69.5 70 70.5 71 71.5 72 72.5 73 73.5 74 74.513200
13400
13600
13800
14000
14200 14091
1356713538
f(x) = 136.6523726322x + 3893.9401862978R² = 0.7952142253
Total Cost to Passenger Cruise Days
Passenger Cruise Days (millions)
Total Cost ($millions)