Problem 12-45 Prepare Segmented Income Statement; Contribution-Margin Format; Retail (LO 12-5) 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 Olentangy Store Scioto Store Downtown Store Individual Stores BUCKEYES DEPARTMENT STORIES, INC. Operating Data for 20x1 in thousanda) Columbus Division Olentangy Seloto Downtown Store Store Store 55,000 $2,400 $12,000 3,000 2,000 8,000 400 310 720 50 40 100 30 60 140 70 35 110 Cleveland Division (all store $ 25,000 11,000 1,900 200 320 250 Sales revenue Variable expenses Cont 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 250 140 70 40 60 40 35 160 50 100 40 50 60 25 20 230 50 130 95 230 100 90 430 90 500 290 160 480 200 170 920 210 I 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 $60,000 of computing costs, which are not allocated to individual stores The following fixed expenses are controllable only at the company level: depreciation--building property taxes, and supervisory salaries. In addition to these expenses, each division incurs costs for supervisory salaries of $150,000, which are not allocated to individual stores Buckeye Department Stores incurs common fixed expenses of $110,000, which are not allocated to the two divisions, Income tax expense for 20x1 is $2,950,000 Required: 1. Prepare a segmented income statement for Buckeye Department Stores, Inc. 2. How would the segmented income statement help the president of Buckeye Department Stores manage the company? Complete this question by entering your answers in the tabs below. Required 1 Required 2 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 Downtown Division Nor Scioto Store Division Store Store Allocated Stores, Inc. Variable operating expenses Total variable expenses Segment contribution margin Foxed expenses controllable by segment manager: $ $ OV's 0 $ 0 0 $ 0$ 0$ 0 $ 0 $ 0 $ $ $ 0$ 0 $ 0 0 0 $ Total Profit margin controllable by segment manager 0$ 0 $ 05 OS $ 0 $ 0 $ 0 05 0$ 0$ 0 $ OS OS 0 Check my work 0 $ 0 Total variable expenses Segment contribution margin Fixed expenses controllable by segment manager $ $ 0 S OS 05 0 $ OS 0$ 0$ 0$ 0 S 0 $ 05 0 $ Total Profit margin controllable by segment manager Fixed expenses, traceable to segment, but controllable by others: $ $ 0 $ 0$ 0 $ 0 $ 0$ 05 0$ 0$ 05 0 $ 0 O $ $ 0 $ 0 Total Profit margin traceable to segment 0 $ OS 0 $ 0$ 05 05 0 $ 0$ 0 $ 05 0 $ 0 $ 0 $ 0