Question

A company has five business units that may be reportable as business segments. Data for these entities is as follows:

	A	($000) B	C	D	E
Sales	$621	$853	$1,237	$2,832	$4,720
Profit	103	(218)	832	1.337	(583)
Assets	1,200	2,780	2,324	4,280	8,321

Submission Requirements:

• Using the ACT470_Mod06-Option01.xlsx Excel spreadsheet in the Module 6 folder, identify the threshold base for each category above and signify (yes/no) if each business segment is reportable by category.
• Review the grading rubric following this assignment, to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.

ACT470-Module 6-Option 1
	Segment Test:						Quantitative Thresholds
	($1,000s)	A	B	C	D	E		Profit	Loss
	Sales
	Profit
	Assets

Answer 1

	A	b	C	D	E	Total	Profit	Loss
Reportable segments	Yes	Yes	Yes	Yes	Yes
Sales	$621	$853	$1,237	$2,832	$4,720	$10,263
% to total	6.1	8.3	12.1	27.6	46.0	%
Profit	103	-218	832	1.337	-583		936.337	-801
% of total profit for profits and for loss total losses	11.0	27.2	88.9	0.1	72.8	%
Assets	1,200	2,780	2,324	4,280	8,321	$18,905
% to total	6.3	14.7	12.3	22.6	44.0	%
All are reportable segments
I think 1.337 is $1337 may be tyo error
	A	b	C	D	E	Total	Profit	Loss
Reportable segments	No	Yes	Yes	Yes	Yes
Sales	$621	$853	$1,237	$2,832	$4,720	$10,263
% to total	6.1	8.3	12.1	27.6	46.0	%
Profit	103	-218	832	1337	-583		2272	-801
% of total profit for profits and for loss total losses	4.5	27.2	36.6	58.8	72.8	%
Assets	1,200	2,780	2,324	4,280	8,321	$18,905
% to total	6.3	14.7	12.3	22.6	44.0	%
Revenue,profit or loss ,assets are 10% or more of its total values respectively
are operating segments