Please answer all questions on a Microsoft Excel spreadsheet ONLY.

E 15-5 Apply threshold tests 1. Coy Corporation and its divisions are engaged solely in manufacturing operations. The following data (consistent with prior years' data) pertain to the industries in which operations were conducted for the year ended December 31, 2011 (in thousands): Total Operating Assets at Industry Revenue Profit December 31, 2011 A $10,000 $1,750 $20,000 B 8,000 1,400 17.500 6,000 1.200 12,500 D 3,000 550 7.500 E 4,250 675 7.000 F 1,500 225 3.000 $32,750 $5,800 $67,500 In its segment information for 2011, how many reportable segments does Coy have? a Three b Four C Five d Six 2. Hen Corporation's revenues for the year ended December 31, 2011, are as follows (in thousands): Consolidated revenue per income statement Intersegment sales Intersegment transfers Combined revenues of all segments $1,200 180 60 $1,440 Hen has a reportable segment if that segment's revenues exceed: a $6 b$24 c$120 d $144 3. The following information pertains to Ari Corporation and its divisions for the year ended December 31, 2011 (in thousands): $4,000 Sales to unaffiliated customers Intersegment sales of products similar to those sold to unaffiliated customers Interest earned on loans to other industry segments 1,200 80 The intersegment interest is not reported by the divisions on internal reports reviewed by the chief operating officer. Ari and all of its divisions are engaged solely in manufacturing operations. Ari has a reportable segment if that segment's revenue exceeds: a $528 b $520 C $408 d $400 4. The following information pertains to revenue earned by Wig Company's operating segments for the year ended December 31, 2011: Sales to Unaffiliated Intersegment Total Segment Customers Sales Revenues Ames $10,000 $6,000 $16,000 Beck 16,000 8,000 24.000 Cyns 8,000 8,000 DG 86,000 32,000 118,000 Combined 120,000 46,000 166,000 Elimination (46.000) (46,000) Consolidated $120,000 $120,000 In conformity with the revenue test, Wig reportable segments were: a Only DG b Beck and DG Ames, Beck, and DG d Ames, Beck, Cyns, and DG Use the following information in answering questions 5 and 6: Gum Corporation, a publicly owned corporation, is subject to the requirements for segment reporting. In its in- come statement for the year ended December 31, 2011, Gum reported revenues of $50,000,000, operating expenses of $47,000,000, and net payroll costs of $15,000,000. Gum's combined identifiable assets of all industry segments at December 31, 2011, were $40,000,000. 5. In its 2011 financial statements, Gum should disclose major customer data if sales to any single customer amount to at least: a $300,000 b $1,500,000 C$4,000,000 d $5,000,000 6. In its 2011 financial statements, if Gum is organized on an industry basis, it should disclose foreign operations data on a specific country if revenues from that country's operations are at least: a $5,000,000 b $4,700,000 C$4,000,000 d$1,500,000 7. Selected data for a segment of a business enterprise are to be separately reported in accordance with GAAP when the revenues of the segment exceed 10 percent of the: a Combined net income of all segments reporting profits bTotal revenues obtained in transactions with outsiders c Total revenues of all the enterprise's operating segments d Total combined revenues for all segments reporting profits 8. In financial reporting of segment data, which of the following items is used in determining a segment's operating income? a Income tax expense b Sales to other segments c General corporate expense d Gain or loss on discontinued operations