Help please

4 Buckeye Department Stores, Inc., operates a chain of department stores in Ohio. The company's organization chart appears below. Operating data for 20x1 follow. Buckeye Department Stores Columbus Division Cleveland Division Olentang Share Scioto Store Downtown Store Individual Stores Cleveland Division (all stores) $25,000 500 Sales revenue Variable expenses Cost of merchandise sold Sales personnel salaries Sales commissions Utilities Other Fixed expenses: Depreciation buildings Depreciation-furnishings Computing and billing Warehouse Insurance Property taxes Supervisory salaries Security BUCKEYE DEPARTMENT STORES, INC. Operating Data for 20x1 in thousands Columbus Division Olentangy Scioto Downtown Stare Store Store $6,000 $2,900 $16,000 5,000 2,500 6,000 350 730 60 40 90 80 60 160 70 45 130 100 90 240 50 40 150 50 30 85 50 60 5a 35 90 45 30 80 150 140 420 30 30 80 16,000 1,400 250 320 300 210 490 340 210 470 250 220 910 260 The following fixed expenses are controllable at the divisional level depreciation-furnishings, computing and billing, warehouse, Insurance, and security. In addition to these expenses, each division annually incurs $40,000 of computing costs, which are not allocated to individual stores. The following fixed expenses are controllable only at the company levet depreciation-building property taxes, and supervisory Salaries. In addition to these expenses, each division incurs costs for supervisory salaries of $160,000, which are not allocated to Individual stores Buckeye Department Stores incurs common fixed expenses of $170,000, which are not allocated to the two divisions. Income-tax expense for 20xt is $3.000.000 00000 (95) Prepare a segmented income statement for Buckeye Department Stores, Inc. (Enter your answers in thousands) Segments of Company Segments of Columbus Division Buckeye Department Cleveland Columbus Olentangy Scioto Downtown Not Stores, Inc. Division Division Store Store Store Allocated Sales revenue $ 49.900 $ 25,000$ 24,900 $ 6.000 $ 2.000$ 16,000 Variable operating expenses Cost of merchandise sold $ 29.500$ 16,000$ 13.500 $ 5,000 $2.500$ 8.000 Sales personnelles 2.900 1,400 1.580 500 350 730 Sales commission 440 250 190 60 40 90 Us 620 320 300 80 60 160 Other 545 300 245 70 45 130 Total variable expenses $ 34.065 $18.270 $ 15.815 $ 5.710 $ 2.995 $ 7,110 $ 0 Segment contribution margin S 15.815 $ 6.730 $ 9.085 $ 290 $ Fred expenses controllable by segment 8.800 $ 0 manager Depreciation Furnishings s 590S 340$ 2505 sos 403 Computing and billing 210 165 50 30 85 Warehouse 790 470 320 50 60 210 Insurance 425 250 175 50 35 00 Security 400 260 140 30 30 00 5 2.205 $ 1.530 S 1050 $ 240 $ 105 $ 615 S 0 Profit margin controlable by segment manager $ 13610 $ 5.200 S 8,035 S SO Fored expenses raceable to segment but $ 2003 $ 8.275 $ 0 controllable by other Depreciation building 900s 490 4303 100 $ 90S 240 Property taxes 375 220 155 45 30 10 Supervisory 1.6203 9103 7103 150 140 420 TO $ 2015 $ 7.620 s 1.295 295 $ 200 $ 740 $ 0 Profit marginalo segment $ 10.095 $ 3.500 $ 0,740 S (245) 3 (550) $ 7.535 $ 0 Common fired expenses Income before 10.000 Income expense Not income 10.695 150 OOOO OOO 16,000 Required 2 >