Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a column entitled Net Income/Loss. This column will represent Revenue minus Expenses. Make a pivot table representing Each Segment and Subdivision by Revenue, Expenses,

Create a column entitled "Net Income/Loss." This column will represent Revenue minus Expenses.

Make a pivot table representing Each Segment and Subdivision by Revenue, Expenses, and Net Income. Use row headers and column headers.

Table
Subdivision Group Segment Revenue Expenses
Bigger Medium 8249.328 594.8782
Bigger Medium 6557.873 83.33939
Pretty Small Small 6180.036 551.2668
Bigger Medium 9915.454 336.8577
Very Small Small 4047.669 481.0083
Pretty Small Small 4797.088 962.3551
Pretty Small Small 6537.8 931.9697
Not as Big Medium 3151.423 848.2135
Not Real Big Big 9504.782 827.5632
Not as Big Medium 9378.14 566.7977
Not Real Big Big 6772.133 436.88
Pretty Small Small 1854.632 930.5483
More than 500 Big 8303.943 680.7504
Pretty Small Small 6741.46 418.0317
Very Small Small 4151.44 336.4056
Pretty Small Small 7972.302 917.1406
Not Real Big Big 10331.58 440.4744
Pretty Small Small 3695.193 217.6563
Pretty Small Small 7904.294 764.5839
Bigger Medium 849.2599 94.51704
More than 500 Big 7157.628 915.9245
Bigger Medium 3712.565 432.5486
Very Small Small 7596.44 134.8226
Very Small Small 2198.658 1037.294
Not Real Big Big 4723.996 463.2899
Bigger Medium 1331.265 959.2307
Not as Big Medium 2743.803 222.9193
More than 500 Big 5038.307 306.9577
Very Small Small 10458.27 692.7631
Pretty Small Small 7567.035 720.3191
More than 500 Big 7688.434 851.8513
Pretty Small Small 4023.227 166.4942
Not as Big Medium 4551.604 701.0457
Not as Big Medium 2665.114 654.9797
Very Small Small 6589.125 278.1884
Not as Big Medium 5220.427 589.1738
Not as Big Medium 7282.189 387.5496
Pretty Small Small 6444.584 258.5027
Very Small Small 10299.03 287.8049
Pretty Small Small 9841.23 824.4757
Very Small Small 8237.848 48.29594
Bigger Medium 6221.249 414.8821
Bigger Medium 5401.242 877.9679
Very Small Small 10013.81 807.8508
More than 500 Big 8466.7 450.5697
Pretty Small Small 8382.214 958.2512
Very Small Small 8105.417 647.6468
Very Small Small 10051.26 1003.73
Pretty Small Small 3667.201 680.7147
Pretty Small Small 7822.062 924.3563
Very Small Small 4575.527 657.6493
Pretty Small Small 3178.197 756.208
Pretty Small Small 1734.412 864.1464
Bigger Medium 8601.066 666.9246
Bigger Medium 8328.446 898.7092
Not as Big Medium 9715.27 536.2619
Bigger Medium 4722.773 837.7133
Not as Big Medium 3434.694 574.1249
Very Small Small 8696.756 581.4445
Not as Big Medium 9195.08 1000.673
Not Real Big Big 4168.872 650.9037
Not Real Big Big 885.2432 323.9769
Bigger Medium 3222.211 760.2841
Pretty Small Small 3185.182 455.4647
Pretty Small Small 5050.976 618.326
Very Small Small 306.0781 275.3065
Pretty Small Small 9598.977 613.2912
Very Small Small 10338.8 979.852
Bigger Medium 7350.612 271.9879
Very Small Small 7506.473 408.0083
Very Small Small 1939.781 413.9418
More than 500 Big 7692.217 1015.874
Not Real Big Big 1060.487 607.3437
Bigger Medium 738.5082 431.4749
Very Small Small 8174.839 206.6453
Very Small Small 4368.806 203.3753
Pretty Small Small 1292.52 123.1056
More than 500 Big 2210.749 465.5262
Not Real Big Big 4240.745 737.0689
Very Small Small 5927.042 501.2388
Very Small Small 2597.354 489.987
Very Small Small 9549.487 835.0237
Pretty Small Small 3931.334 191.4213
Pretty Small Small 8578.804 670.2412
More than 500 Big 1946.137 273.5117
Not as Big Medium 9021.016 402.0587
Not as Big Medium 5575.672 148.334
More than 500 Big 1193.066 148.1347
Very Small Small 10340.53 250.0847
Very Small Small 5512.768 542.6187
Not as Big Medium 2555.999 824.1295
Pretty Small Small 10157.81 508.1698
Bigger Medium 8921.522 259.3319
More than 500 Big 10494.44 565.4319
Bigger Medium 7007.768 765.6917
Not as Big Medium 4811.038 193.1749
Pretty Small Small 8657.827 171.6024
Bigger Medium 8204.321 278.7478
Pretty Small Small 4246.883 644.5165

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Development Finance Innovations For Sustainable Growth

Authors: Nicholas Biekpe, Danny Cassimon, Andrew William Mullineux

1st Edition

331954165X, 978-3319541655

More Books

Students also viewed these Finance questions