[HELP! PLEASE ANSWER WITH SOLUTION]

PROBLEM #1

GCQ Company

GCQ Company operates in different geographic areas since 2X14. The following pertains to GCQ Company's operation for 2X17.

Geographical Segment	Identifiable Assets	Revenue (Internal)	Revenue (External)	Total	Profit or Loss
A	P 10,000,000	P 25,000,000	P 5,000,000	P 30,000,000	P 8,000,000
B	4,000,000	8,000,000	2,000,000	10,000,000	(3,000,000)
C	4,000,000	6,000,000	1,000,000	7,000,000	1,000,000
D	20,000,000	5,000,000	8,000,000	13,000,000	(4,000,000)
E	11,000,000	22,000,000	4,000,000	26,000,000	11,000,000

REQUIRED:

a. Total assets of all segments

b. Total revenues of all segments

c. Combined profits of all segments operating at a profit

d. Combined profits of all segment operating at a loss

PROBLEM #2

Bobcat Company

Bobcat Company discloses supplementary operating segment information for its two (2) reportable segments. Data for 2X21 are as follows:

	Segment E	Segment W
Sales	P 750,000	P 250,000
Traceable operating expenses	325,000	130,000

Additional 2X21 expenses are as follows:

Indirect operating expenses

P 120,000

Appropriately selected common indirect operating expenses are allocated to two (2) segments based on each segment's sales ratio to total sales.

REQUIRED:

a. Operating profit of Segment E

b. Operating profit of Segment W

GCQ Company GCQ Company operates in different geographic areas since 2X14. The following pertains to GCQ Company's operation for 2X17. Geographical Identifiable Revenue Revenue Total Profit or Se - ment Assets Internal External Loss P10, 000, 000 P25,000,000 P5,000,000 P30,000,000 P8,000,000 4,000,000 8,000,000 2,000,000 10,000,000 (3,000,000) 4,000,000 6,000,000 1,000,000 7,000,000 1,000,000 __ 20,000,000 5,000,000 8,000,000 13,000,000 4,000,000 _- 11,000,000 22,000,000 4,000,000 26,000,000 11,000,000 Procedure: 1. Open MS Excel and start a new worksheet. Then, compute for the following: A. Total assets of all segments B. Total revenues of all segments C. Combined prots of all segments operating at a prot D. Combined losses of all segments operating at a loss Bobcat Company Bobcat Company discloses supplementary operating segment information for its two (2) reportable segments. Data for 2X21 are as follows: Segment E Segment W Sales P750,000 P250,000 Traceable operating expenses 325,000 130,000 Additional 2X21 expenses are as follows: Indirect operating expenses P120,000 Appropriately selected common indirect operating expenses are allocated to two (2) segments based on each segment's sales ratio to total sales. Procedure: 1. Open MS Excel and start a new worksheet. Then, compute for the following: A. Operating profit of Segment E B. Operating profit of Segment W