Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calibri 11 B Gee tements H price 12.90 1333 12.90 18 415 57.99 123 D customer number Region date of sale item brand cocon description

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Calibri 11 B Gee tements H price 12.90 1333 12.90 18 415 57.99 123 D customer number Region date of sale item brand cocon description 478406 Central 2017.07.10 2015-12 lements 1281 CCM 480402 Central 2017-03 OSAS OPC Jeffrey Alexander Hayworth CC 479491 South 2016-06-19 2115-128BAC Elements Undos 120 CM 479471 Central 2018-01-02 885 Wey leader worth 478157 South 2015-08-12 115BNDOL tements Lindes Kob 479491 South 2017-10-26885305PC Jey Ander Hayworth 35 put 479491 South 2017-06-01 SON Jefrey Alexander Hayworth 479564 Central 2015-12-18 855-C Jeffrey Al Mayworth CC 479529 Central 2017-06-03 2115-1250BC Cements indos 13 CCP 4795LR South 2018-12-23 385-3055 Jeffrey leander Kayworth 5 mm CCP 479529 Centre 2017.10 26 2115-125MC tements Lindos 125 CC 479535 South 2017-07-06 2115-1200 123 479518 South 2018-03-10 2115-SN Lindos CH 150137 Central 20150222 STRE Clements report Kob 478782 Central 2017-04-10 2155-1285 Elements Lindes 125CC 478782 Central 2016-09-26 2115-1285N Elements Lindos 125CC 477402 South 2016-03-11 15-224SN frey Alexander Haworth 224 mm CC 450137 Central 2016-02-01 &TAE Kingsport knob 475406 Central 2011 01-18 2115 BAC ents Lidos 96 CCM 479529 Central 2017-10-30 2315-9Cements Udos %" CC Bul 474471 Central 2015-11-0185-105 Very Alexander Hayworth NOSCU 479566 Central 2018-05-19 886-224PC Alexander Hayworth 220 cp 479529 Central 2018 OS 32115 128PC Elements 128 OCA 40137 Central 2017-02-15 STEAE Clements port Kob 479491 South 2015-07-03 885 96 Jeffrey Alender Hayworth 96CC 7991 South 2015-070) 885-96SN Jeffrey Aleander Hayworth 95CPU 2015-02-05 87 40117 Central Elements Knob port 476614 South 2018 OL-25 25-30SSN Jeffrey Alender Hayworth SO5 mm 12 52.99 12.90 12.98 437 320 Unders 1 Cost told le vent variable cost contribution map 12 VOTS 298436 2.517.405 1,46746 345 5.172025 1.39435 1.447.56 379 355 1.30 55.67RSS 212.65 2.95 2165 2.0726 51.93320 S LOSLO 2.52 103 70335 455 275.41 361 470 5 27.255.30 16,467.00 $ 10.28830 1035 11985 26115 57055 759 5 10:496.97 $17.51 S 1,149.45 999 5 12.967.02S 15 11 315 5 1266.85 $ 11,020.355 54360 5615 7,2015 4,6SOUS 22631.05 2685 3.478.64 52.367253 1211.36 329 3325 340LS 2.95 1.409.36 27 8465 2,7145 1.920025 20 8.08 101 $ OS 2412.085 1.4740 808 1615 2.0 78 5 1-330385 TO 3422 098 5 170120 $295.56 $ 7,105 4 222 612 5 2013 4 5 24 $ 6202 31 5665 2.756.425 2.754605 1001 11 125 1.684685 205 534 11 1325 7,65465 4.7305 2.88940 2465 6.002.405 3.857215 2.14512 46 035 RM45 5.230.58 2015.95 227 502 1.641 20 5 137 22 5 51103 15 2013 225 1691 815 156 3 2.572 38 5 115 1.050 90 2:27 4375 152 215 1105.495 64 3755 30$ 1739.705 112550 $ E120 - 12.5 244 320 482 437 579 244 128 Lindos 133 3.29 57.99 Red 2 R3 Reg4 esta found cost dat segment margin H 1 M 520 CC 224 mm po 1293 264 8.08 1422 222 21 21 361 1568 7.101.64 03424 1012 96 CCM 96 CCM 305 mm 224 mm 128 CC 487 57.99 29.40 12.90 223 or 478782 Central 477407 South 430137 Central 478405 Central 479529 Central 479471 Central 479566 Central 479529 Central 40137 Central 479491 South 479491 South 480137 Central 476614 South 479471 Central 47301 Central 478782 Central 479529 Central 479491 South 479471 Central 478103 Central 479529 Central c 0 w 2016-05-26 2115 128SN Elements 2016-03-11 585-2745N frey Alender Haworth 2016-02-01 BAE Benti Report 2018-01-18 2115 96DBAC Eements Lindos 2017-11-30 2115-96DBAC Elements Undos 2015-11-01 305PC Jeffrey Alexandet Hayworth 2018-05-19 215-224PC Jeffrey Aleander Hayworth 2018-05-02 2115-178PC Clements Untos 2017-02-15 87RAE Dements Kingsport 2015-01 03 BSSON Mettre de ander Hayworth 2015-07-01 BS MSN Here Alexander Hayworth 2015-02-05 878AE Clements Deport 2018-04-25 885-BOSSN effrey Alexander Hayworth 2015-01 30 685-305PC Jeffrey Alexander Hayworth 2011-02-25 211590MC teman Lindos 2016-05 20 2115-1281 Elements Undos 2018-02-03 885 3SPC Neffrey Alexander Hayworth 2016-07-07 885965N Jeffrey Alexander Hayworth 2016-11-13 585-224N Neffrey Aleander Hayworth 2016-01-16 2115-128PC Elements Undos 2015-12-11 2115-96NSOL Elements Lindos 2015 5110 110955 500 CCM Cpu 1615 2.0 1.100 698 $ 17,011.20 $9.925 54 5 6125 2011 485 1.139.24 5665 2.755.675 1.154405 3875 1. 5 1.19.05 1335 765468 S 40205 2465 6.0030 SYS 6235 046.54 5.27058 5015 1602051117275 2075 2.2.31 $ 1691.265 1865 2.5725 1.521485 45 160223 1.105.495 305 1739.70 $ 12. SOS 6585 37.574 $23.573105 65 3.063) S 1949.90 5 212252,817185 846 5 45.0 56 5 0 0 5 1915 2.64153 $ 1.56238 $ 1315 3.195.40 $ 2.052.77 $ 943 5 12.240.34 $ 7,977-78 5 8965 402262 $ 2.510 16 S 6130 1412 13 3.0 57.99 579 487 129 57.99 13.23 244 33 305CC 305 CM 95 cc pul 128 C 305 56 un CCD 226CC 125CC 96 CCP 21 23 37.55 63 31 8.45 361 18 15.69 845 3.16 10116 1184 1.02.15 1143 63 1412.5 14 1 Segment Margin Report 2 For Year of 2018 3 D E G H 1 1 Central East Coast International Midwest Northeast Northwest South West Total of all gone 4 Sales revenue 5 Less variable expenses 6 Contribution margin 7 Less direct foued expenses # Segment margin 9 less common fixed costs allocated to regions 10 Operating income foss) 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Central B E G H 1 Fixed cost data 2 For year of 2018 3 Central East Coast International Midwest Northeast Northwest South West 4 Directed expenses $ 5,278,312 $7,513,545 S 690,587 S 9,874,330 $ 3,965,187 $ 4,968,774 $ 6,849,541 $ 9,065,478 5 Common allocated costs $ 1.219,464 5 1,589.821 $ 217,290 2,018.055 814,835 $ 1,075,209 $ 980,076 S 1.665,250 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 Calibri 11 B Gee tements H price 12.90 1333 12.90 18 415 57.99 123 D customer number Region date of sale item brand cocon description 478406 Central 2017.07.10 2015-12 lements 1281 CCM 480402 Central 2017-03 OSAS OPC Jeffrey Alexander Hayworth CC 479491 South 2016-06-19 2115-128BAC Elements Undos 120 CM 479471 Central 2018-01-02 885 Wey leader worth 478157 South 2015-08-12 115BNDOL tements Lindes Kob 479491 South 2017-10-26885305PC Jey Ander Hayworth 35 put 479491 South 2017-06-01 SON Jefrey Alexander Hayworth 479564 Central 2015-12-18 855-C Jeffrey Al Mayworth CC 479529 Central 2017-06-03 2115-1250BC Cements indos 13 CCP 4795LR South 2018-12-23 385-3055 Jeffrey leander Kayworth 5 mm CCP 479529 Centre 2017.10 26 2115-125MC tements Lindos 125 CC 479535 South 2017-07-06 2115-1200 123 479518 South 2018-03-10 2115-SN Lindos CH 150137 Central 20150222 STRE Clements report Kob 478782 Central 2017-04-10 2155-1285 Elements Lindes 125CC 478782 Central 2016-09-26 2115-1285N Elements Lindos 125CC 477402 South 2016-03-11 15-224SN frey Alexander Haworth 224 mm CC 450137 Central 2016-02-01 &TAE Kingsport knob 475406 Central 2011 01-18 2115 BAC ents Lidos 96 CCM 479529 Central 2017-10-30 2315-9Cements Udos %" CC Bul 474471 Central 2015-11-0185-105 Very Alexander Hayworth NOSCU 479566 Central 2018-05-19 886-224PC Alexander Hayworth 220 cp 479529 Central 2018 OS 32115 128PC Elements 128 OCA 40137 Central 2017-02-15 STEAE Clements port Kob 479491 South 2015-07-03 885 96 Jeffrey Alender Hayworth 96CC 7991 South 2015-070) 885-96SN Jeffrey Aleander Hayworth 95CPU 2015-02-05 87 40117 Central Elements Knob port 476614 South 2018 OL-25 25-30SSN Jeffrey Alender Hayworth SO5 mm 12 52.99 12.90 12.98 437 320 Unders 1 Cost told le vent variable cost contribution map 12 VOTS 298436 2.517.405 1,46746 345 5.172025 1.39435 1.447.56 379 355 1.30 55.67RSS 212.65 2.95 2165 2.0726 51.93320 S LOSLO 2.52 103 70335 455 275.41 361 470 5 27.255.30 16,467.00 $ 10.28830 1035 11985 26115 57055 759 5 10:496.97 $17.51 S 1,149.45 999 5 12.967.02S 15 11 315 5 1266.85 $ 11,020.355 54360 5615 7,2015 4,6SOUS 22631.05 2685 3.478.64 52.367253 1211.36 329 3325 340LS 2.95 1.409.36 27 8465 2,7145 1.920025 20 8.08 101 $ OS 2412.085 1.4740 808 1615 2.0 78 5 1-330385 TO 3422 098 5 170120 $295.56 $ 7,105 4 222 612 5 2013 4 5 24 $ 6202 31 5665 2.756.425 2.754605 1001 11 125 1.684685 205 534 11 1325 7,65465 4.7305 2.88940 2465 6.002.405 3.857215 2.14512 46 035 RM45 5.230.58 2015.95 227 502 1.641 20 5 137 22 5 51103 15 2013 225 1691 815 156 3 2.572 38 5 115 1.050 90 2:27 4375 152 215 1105.495 64 3755 30$ 1739.705 112550 $ E120 - 12.5 244 320 482 437 579 244 128 Lindos 133 3.29 57.99 Red 2 R3 Reg4 esta found cost dat segment margin H 1 M 520 CC 224 mm po 1293 264 8.08 1422 222 21 21 361 1568 7.101.64 03424 1012 96 CCM 96 CCM 305 mm 224 mm 128 CC 487 57.99 29.40 12.90 223 or 478782 Central 477407 South 430137 Central 478405 Central 479529 Central 479471 Central 479566 Central 479529 Central 40137 Central 479491 South 479491 South 480137 Central 476614 South 479471 Central 47301 Central 478782 Central 479529 Central 479491 South 479471 Central 478103 Central 479529 Central c 0 w 2016-05-26 2115 128SN Elements 2016-03-11 585-2745N frey Alender Haworth 2016-02-01 BAE Benti Report 2018-01-18 2115 96DBAC Eements Lindos 2017-11-30 2115-96DBAC Elements Undos 2015-11-01 305PC Jeffrey Alexandet Hayworth 2018-05-19 215-224PC Jeffrey Aleander Hayworth 2018-05-02 2115-178PC Clements Untos 2017-02-15 87RAE Dements Kingsport 2015-01 03 BSSON Mettre de ander Hayworth 2015-07-01 BS MSN Here Alexander Hayworth 2015-02-05 878AE Clements Deport 2018-04-25 885-BOSSN effrey Alexander Hayworth 2015-01 30 685-305PC Jeffrey Alexander Hayworth 2011-02-25 211590MC teman Lindos 2016-05 20 2115-1281 Elements Undos 2018-02-03 885 3SPC Neffrey Alexander Hayworth 2016-07-07 885965N Jeffrey Alexander Hayworth 2016-11-13 585-224N Neffrey Aleander Hayworth 2016-01-16 2115-128PC Elements Undos 2015-12-11 2115-96NSOL Elements Lindos 2015 5110 110955 500 CCM Cpu 1615 2.0 1.100 698 $ 17,011.20 $9.925 54 5 6125 2011 485 1.139.24 5665 2.755.675 1.154405 3875 1. 5 1.19.05 1335 765468 S 40205 2465 6.0030 SYS 6235 046.54 5.27058 5015 1602051117275 2075 2.2.31 $ 1691.265 1865 2.5725 1.521485 45 160223 1.105.495 305 1739.70 $ 12. SOS 6585 37.574 $23.573105 65 3.063) S 1949.90 5 212252,817185 846 5 45.0 56 5 0 0 5 1915 2.64153 $ 1.56238 $ 1315 3.195.40 $ 2.052.77 $ 943 5 12.240.34 $ 7,977-78 5 8965 402262 $ 2.510 16 S 6130 1412 13 3.0 57.99 579 487 129 57.99 13.23 244 33 305CC 305 CM 95 cc pul 128 C 305 56 un CCD 226CC 125CC 96 CCP 21 23 37.55 63 31 8.45 361 18 15.69 845 3.16 10116 1184 1.02.15 1143 63 1412.5 14 1 Segment Margin Report 2 For Year of 2018 3 D E G H 1 1 Central East Coast International Midwest Northeast Northwest South West Total of all gone 4 Sales revenue 5 Less variable expenses 6 Contribution margin 7 Less direct foued expenses # Segment margin 9 less common fixed costs allocated to regions 10 Operating income foss) 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Central B E G H 1 Fixed cost data 2 For year of 2018 3 Central East Coast International Midwest Northeast Northwest South West 4 Directed expenses $ 5,278,312 $7,513,545 S 690,587 S 9,874,330 $ 3,965,187 $ 4,968,774 $ 6,849,541 $ 9,065,478 5 Common allocated costs $ 1.219,464 5 1,589.821 $ 217,290 2,018.055 814,835 $ 1,075,209 $ 980,076 S 1.665,250 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30

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

Financial Accounting And Reporting

Authors: Mr Barry Elliott, Jamie Elliott

16th Edition

027377817X, 978-0273778172

More Books

Students also viewed these Accounting questions