Please fill in the yellow highlighted areas. See attachment.

Buckeye Department Stores, Inc. operates a chain of department stores in Ohio. The company's organization chart BUCKEY Op Sales revenue Variable expenses: Cost of merchandise sold Sales personnelsalaries Sales commissions Utilities Other Fixed expenses: Depreciationbuildings Depreciationfurnishings Computing and billing Warehouse Insurance Property taxes Supervisory salaries Security Olentangy Store Scioto Store 5,000 2,700 3,000 400 50 70 60 2,300 330 30 50 55 110 70 60 60 60 55 140 40 100 40 40 50 45 40 110 40 The following fixed expenses are controllable at the divisional level: depreciationfurnishings, computing and billing The following fixed expenses are controllable only at the company level: depreciationbuilding, property taxes, and Buckeye Department Stores incurs common fixed expenses of $140,000, which are not allocated to the two division 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 manag Prepare a segmented income statement for Buckeye Department Stores, Inc. (Enter your answers in thousands. Sementts of Company 1. Prepare a segmented income statement for BuckeyBuckeye Department Stores,INC Cleveland Divison Sales revenue 41,700 22,000 Variable operating expense Cost of merchandise sold 26,300 14,000 Sales personnelsalaries 3,170 1,700 Sales commissions 440 260 Utilities 590 300 Others 565 310 Total variable expenses 31,065 16,570 Segment contribution margin 10,635 5,430 Fixed expenses controllable by segment manager Depreciationfurnishings 620 350 Computing and billing Warehouse 860 510 Insurance 465 260 Security 440 270 Total 2385 1390 Profit margin controllable by segment manager 8,250 4,040 Fixed expenses, traceable to segment, but controllable by others Depreciationbuildings 1030 530 Property taxes 415 230 Supervisory salaries Total 1445 760 Profit margin traceable to segment 6,805 Less: Common fixed expenses 140 Income before taxes 6,665 Less: Income tax expense 1300 Net income 5,365 any's organization chart appears below. Operating data for 20x1 follow. BUCKEYE DEPARTMENT STORES, INC. Operating Data for 20x1 (in thousands) Columbus Division Cleveland Division (total for all Downtown Store stores) 12,000 22,000 7,000 740 100 170 140 14,000 1,700 260 300 310 290 160 65 240 100 90 460 90 530 350 220 510 260 230 930 270 gs, computing and billing, warehouse, insurance, and security. In addition to these expenses, each division annually incurs $80 ding, property taxes, and supervisory salaries. In addition to these expenses, each division incurs costs for supervisory salaries ocated to the two divisions. Income-tax expense for 20x1 is $1,300,000. epartment Stores manage the company? r answers in thousands.) Segments of Columbus Division Columbus Division Olentangy Store Scioto Store Downtown Store Not allocated 5,000 2,700 12,000 19,700 12,300 1,470 180 290 255 14,495 5,205 3,000 400 2,300 330 7,000 740 50 70 60 3,580 1,420 30 50 55 2,765 -65 100 170 140 8,150 3,850 270 70 60 60 60 40 290 1,130 40 40 50 45 40 215 -280 160 65 240 100 90 655 3,195 110 55 140 305 100 40 110 250 290 90 460 840 350 205 170 995 4,210 500 185 685 Cleveland Division (total for all stores) $ h division annually incurs $80,000 of computing costs, which are not allocated to individual stores. costs for supervisory salaries of $120,000, which are not allocated to individual stores. Countywide Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data for these s Service revenue Variable expenses Controllable fixed expenses Fixed expenses controllable by others In addition to the expenses listed above, the company has $95,000 of common fixed expenses. Income-tax expense Common fixed expense income tax expense Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc. Service revenue Variable expenses Segment contribution margin Less: Fixed expenses controllable by segment manager Profit margin controlleable by segment manager Less: Fixed expenses, traceable to segment, but controllable by others Profit margin traceable to segment Common fixed expense Icome before taxes income tax expense Net Income ents: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro 1,050,000 170,000 380,000 200,000 suburban 850,000 120,000 300,000 170,000 outlaying 450,000 70,000 130,000 60,000 5,000 of common fixed expenses. Income-tax expense for the year is $295,000. $95,000 $295,000 ntywide Cable Services, Inc. Segmented income statements: Countrywide Cable Services, INC. Segments of Company Countrywide cable services 2,350,000 360,000 1,990,000 810,000 1,180,000 430,000 Metro Suburban 1,050,000 850,000 170,000 120,000 880,000 380,000 500,000 200,000 $95,000 $335,000 $295,000 $40,000 730,000 300,000 430,000 170,000 Outlying 450,000 70,000 380,000 130,000 250,000 60,000 Data Screen Corporation is a highly automated manufacturing firm. The vice president of finance has decided that traditional standards are inappropriate for performance measures in an automated environment. Labor is insignificant in terms of the total cost of production and tends to be fixed, material quality is considered more important than minimizing material cost, and customer satisfaction is the number one priority. As a result, production and delivery performance measures have been chosen to evaluate performance. The following information is considered typical of the time involved to complete and ship orders. Waiting time: From order being placed to start of production 9 From start of production to completion 8 8 2 4 3 2 4 3 26 17 Inspection time Processing time Move time total 1. Calculate the manufacturing cycle efficiency=processing time/(processing time+ inspection+move t 2.delivery cycle= processing + inpection+waiting time+move time Required: 1. Calculate the manufacturing cycle efficiency. (Round your percentage answer to 1 decimal place 2. Calculate the delivery cycle time. (Round your answer to nearest whole number.) 1.Manufacturing Cycle efficiency 2. Delivery Cycle time % days ing time+ inspection+move time+from strat to complete) e answer to 1 decimal place. (i.e., 0.123 should be entered as 12.3)) ole number.) notes Manufacturing Cycle Efficiency: Delivering the goods at the right time requires that the said goods must be produced on time. It is a measure which defines how well a company's manufacturing capabilities use time resources. Timelines of the production process is assessed using the various operations performance measures. It is a measure of internal business process performance. Production time or throughput time required per unit is called manufacturing cycle time