The segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016 Total Company Product A Produc...
The segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016
Total Company Product A Product B Product C
Sales $ 610,000 $ 305,000 $ 118,000 $ 187,000
Vari. expenses 273,000 146,000 53,000 74,000
Cont. margin $ 337,000 $ 159,000 $ 65,000 $ 113,000
Fixed expenses 283,000 164,000 49,000 70,000
Oper. income $ 54,000 $ (5,000 ) $ 16,000 $ 43,000
The company is concerned about the performance of product A, and you have been asked to analyze the situation and recommend to the president whether to continue or discontinue the product. During your investigation, you discover that certain fixed expenses are traceable directly to each product line as indicated here:
Total Company Product A Product B Product C
Direct fixed expenses $102,000 $75,000 $10,000 $17,000
The remaining fixed expenses are considered to be corporate-wide expenses that have been allocated to each product line based on sales revenue.
Required: a. What will be the effect of the decision to discontinue product A on operating income?
b. Assume that product A is discontinued. Prepare a segmented income statement for the remaining products. Allocate corporate-wide fixed expenses as described. (Round intermediate calculations to 2 decimal places.)
c. Starting with the segmented income statement, use the information you discovered during your investigation to present a more appropriately designed segmented income statement.
Homework Answers
a. Effect of Decision to discontinue product a-
Fixed cost burden (164,000-75,000) = 89,000
Less: Saving of Product A loss =5,000
Operating Income will decrease by 84,000
b)
| XYZ COMPANY | |||
| Segmented Income Statement | |||
| For the Year Ended December 31, 2016 | |||
| Total | Product B | Product C | |
| Sales | $ 305,000.00 | $ 118,000.00 | $ 187,000.00 |
| Variable Expenses | $ 127,000.00 | $ 53,000.00 | $ 74,000.00 |
| Contribution Margin | $ 178,000.00 | $ 65,000.00 | $ 113,000.00 |
| Direct Fixed Expenses | $ 27,000.00 | $ 10,000.00 | $ 17,000.00 |
| Common Fixed Expenses | $ 181,000.00 | $ 70,026.23 | $ 110,973.77 |
| Operating Income/loss | $ (30,000.00) | $ (15,026.23) | $ (14,973.77) |
c)
| XYZ COMPANY | ||||
| Segmented Income Statement | ||||
| For the Year Ended December 31, 2016 | ||||
| Total | Product A | Product B | Product C | |
| Sales | $ 610,000.00 | $ 305,000.00 | $ 118,000.00 | $ 187,000.00 |
| Variable Expenses | $ 273,000.00 | $ 146,000.00 | $ 53,000.00 | $ 74,000.00 |
| Contribution Margin | $ 337,000.00 | $ 159,000.00 | $ 65,000.00 | $ 113,000.00 |
| Direct Fixed Expenses | $ 102,000.00 | $ 75,000.00 | $ 10,000.00 | $ 17,000.00 |
| Segment margin | $ 235,000.00 | $ 84,000.00 | $ 55,000.00 | $ 96,000.00 |
| Common Fixed Expense | $ 181,000.00 | |||
| Operating Income/loss | $ 54,000.00 | |||
Add Answer to:
The segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016 Total Company Product A Produc...
The segmented income statement for XYZ Company for the year ended December 31, 2016, tollows: XYZ...
The segmented income statement for XYZ Company for the year ended December 31, 2016, tollows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31. 2016 Total CompenyProduct A $ 305,000 146,000 Product B $ 118,000 51.000 Product C 182.000 6,000 Sales Variable axpenses Contribution margin Fixed expenses $ 605,000 273,000 332 159.0 280.000 $ 52.000 159.000 44,000 23,000 7.000 $ 29,000 Operaing income The company is concerned about the performance of product A, and you have been asked...
woolcorp condensed income statement WoolCorp Condensed Income Statement For the Year Ended December 31, 2018 Raw...
woolcorp condensed income statement
WoolCorp Condensed Income Statement For the Year Ended December 31, 2018 Raw Wool Wool Yarn Rug Yarn Total Company Sales $200,000 $155,000 $187,000 $542,000 Costs of goods sold: Variable costs $(48,000) $(18,600) $(37,180) $(103,780) Fixed costs (32,000) (12.400) (24,790) (69,190) Total cost of goods sold $(80,000) $(31,000) ${61,970) $(172.970) Gross profit $120,000 $124,000 $125,030 $309.030 Operating expenses: Variable expenses $(5,000) $(7,750) $(53,110) $(65,860) Foxed expenses (89,000) (77,000) (106,200) (272,200) Total operating expenses $(94,000) $(84,750) $(159,310) $(338,060)...
21.The income statement for Pierre Paul Company for the year ended December 31, 2016 is as...
21.The income statement for Pierre Paul Company for the year ended December 31, 2016 is as follows: onoo sw notosane o ntne obo n T0832 idva PIERRE PAUL COMPANY Income Statement For the Year Ended December 31, 2016 Revenues m $53,000 4,000 $57,000 Sales revenue Interest revenue Total revenues Expenses 30,000 18,000 1,500 Cost of goods sold. Salaries and wages expense Interest expense. Total expenses 49,500 $ 7.500 Net income.... Prepare the entries to close the revenue and expense accounts...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016 ($ in 000s): Net sales $ 15,000 Interest income Interest expense $27,000 Cost of goods sold 290 Selling and administrative expenses 530 Restructuring costs 3,400 1,700 In addition, during the year the company completed the disposal of its plastics business and incurred a loss from operations of $2.5 million and a gain on disposal of the component's assets of $3.8 million. 600,000 shares of...
In its income statement for the year ended December 31, 2017, Pharoah Company reported the following...
In its income statement for the year ended December 31, 2017, Pharoah Company reported the following condensed data. Salaries and wages expenses Cost of goods sold Interest expense Interest revenue Depreciation expense $465,000 Loss on disposal of plant assets 1,243,000 Sales revenue 66,000 Income tax expense 127,900 Sales discounts 305,000 Utilities expense $83,500 2,410,000 25,000 150,000 110,000 Prepare a multiple-step income statement. (List other revenues before other expenses.) PHAROAH COMPANY Income Statement PHAROAH COMPANY Income Statement
3) The Income Statement for XYZ Company for 2016 and 2017 is as follows: 2017 2016...
3) The Income Statement for XYZ Company for 2016 and 2017 is as follows: 2017 2016 Sales $4,000,000 $3,500,000 Cost of Goods Sold 2,500,000 2,400,000 Gross Profit 1,500,000 1,100,000 Selling Expense 600,000 700,000 Administrative Expense 200,000 150,000 Total Operating Expense 800,000 850,000 Income from Operations 700,000 250,000 Income Tax Expense 50,000 20,000 Net Income 650,000 230,000 Instructions: Using the above comparative income statement, prepare a horizontal analysis for ABC Company. (10 points)
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For...
Vulcan Company’s contribution format income statement for June
is as follows:
Vulcan Company
Income Statement
For the Month Ended June 30
Sales $750,000
Variable expenses 336,000
Contribution margin 414,000
Fixed expenses 378,000
Net operating income $36,000
Management is disappointed with the company’s performance and
is wondering what can be done to improve profits. By examining
sales and cost records, you have determined the following:
The company is divided into two sales territories—Northern and
Southern. The Northern territory recorded $300,000 in...
Chapter 24 & 25 Mastery (Mastery) Calculator For the Year Ended December 31, 2048 Raw Wool...
Chapter 24 & 25 Mastery (Mastery) Calculator For the Year Ended December 31, 2048 Raw Wool Wool Yarn Rug Yarn $200,000 $155,000 $187,000 Total Company $542,000 Sales Costs of goods sold: Variable costs $(18,600) (12,400) $(103,800) (69,200) Fixed costs $(48,000) (32,000) $(80,000) $120,000 $(37,200) (24,800) $(62,000) $125,000 Total cost of goods sold $(31,000) $(173,000) $369,000 Gross profit $124,000 Operating expenses: Variable expenses $(53,100) $(65,850) Fixed expenses $(5,000) (89,000) $(94,000) $26,000 $(7,750) (77,000) $(84,750) $39,250 (106,200) $(159,300) Total operating expenses Operating...
ABC Company, LLC Income Statement For the Year Ended December 31, 2016 (Actual Dollars) SALES $...
ABC Company, LLC Income Statement For the Year Ended December 31, 2016 (Actual Dollars) SALES $ 3,315,938 COST OF SALES GROSS PROFIT 640,652 OPERATING EXPENSES: Advertising Auto and Truck Expenses Bank Service Charges Credit Card Fees Depreciation Insurance Legal and Accounting Miscellaneous Payroll Taxes Rent Repairs and Maintenance Supplies Travel Utilities Wages Total Operating Expenses 5.264 3,686 3,158 16.621 8.436 24,511 15.943 10.963 29,931 36,000 34,370 35,748 7,071 28.338 199.537 $ OPERATING INCOME (LOSS) INTEREST EXPENSE 6,237 NET INCOME BEFORE...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For...
Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales $ 900,000 Variable expenses 408,000 Contribution margin 492,000 Fixed expenses 465,000 Net operating income $ 27,000 Management is disappointed with the company’s performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: The company is divided into two sales territories—Northern and Southern. The Northern Territory recorded...
The segmented income statement for XYZ Company for the year ended December 31, 2016, tollows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31. 2016 Total CompenyProduct A $ 305,000 146,000 Product B $ 118,000 51.000 Product C 182.000 6,000 Sales Variable axpenses Contribution margin Fixed expenses $ 605,000 273,000 332 159.0 280.000 $ 52.000 159.000 44,000 23,000 7.000 $ 29,000 Operaing income The company is concerned about the performance of product A, and you have been asked...
woolcorp condensed income statement
WoolCorp Condensed Income Statement For the Year Ended December 31, 2018 Raw Wool Wool Yarn Rug Yarn Total Company Sales $200,000 $155,000 $187,000 $542,000 Costs of goods sold: Variable costs $(48,000) $(18,600) $(37,180) $(103,780) Fixed costs (32,000) (12.400) (24,790) (69,190) Total cost of goods sold $(80,000) $(31,000) ${61,970) $(172.970) Gross profit $120,000 $124,000 $125,030 $309.030 Operating expenses: Variable expenses $(5,000) $(7,750) $(53,110) $(65,860) Foxed expenses (89,000) (77,000) (106,200) (272,200) Total operating expenses $(94,000) $(84,750) $(159,310) $(338,060)...
21.The income statement for Pierre Paul Company for the year ended December 31, 2016 is as follows: onoo sw notosane o ntne obo n T0832 idva PIERRE PAUL COMPANY Income Statement For the Year Ended December 31, 2016 Revenues m $53,000 4,000 $57,000 Sales revenue Interest revenue Total revenues Expenses 30,000 18,000 1,500 Cost of goods sold. Salaries and wages expense Interest expense. Total expenses 49,500 $ 7.500 Net income.... Prepare the entries to close the revenue and expense accounts...
Rembrandt Paint Company had the following income statement items for the year ended December 31, 2016 ($ in 000s): Net sales $ 15,000 Interest income Interest expense $27,000 Cost of goods sold 290 Selling and administrative expenses 530 Restructuring costs 3,400 1,700 In addition, during the year the company completed the disposal of its plastics business and incurred a loss from operations of $2.5 million and a gain on disposal of the component's assets of $3.8 million. 600,000 shares of...
In its income statement for the year ended December 31, 2017, Pharoah Company reported the following condensed data. Salaries and wages expenses Cost of goods sold Interest expense Interest revenue Depreciation expense $465,000 Loss on disposal of plant assets 1,243,000 Sales revenue 66,000 Income tax expense 127,900 Sales discounts 305,000 Utilities expense $83,500 2,410,000 25,000 150,000 110,000 Prepare a multiple-step income statement. (List other revenues before other expenses.) PHAROAH COMPANY Income Statement PHAROAH COMPANY Income Statement
Vulcan Company’s contribution format income statement for June
is as follows:
Vulcan Company
Income Statement
For the Month Ended June 30
Sales $750,000
Variable expenses 336,000
Contribution margin 414,000
Fixed expenses 378,000
Net operating income $36,000
Management is disappointed with the company’s performance and
is wondering what can be done to improve profits. By examining
sales and cost records, you have determined the following:
The company is divided into two sales territories—Northern and
Southern. The Northern territory recorded $300,000 in...
Chapter 24 & 25 Mastery (Mastery) Calculator For the Year Ended December 31, 2048 Raw Wool Wool Yarn Rug Yarn $200,000 $155,000 $187,000 Total Company $542,000 Sales Costs of goods sold: Variable costs $(18,600) (12,400) $(103,800) (69,200) Fixed costs $(48,000) (32,000) $(80,000) $120,000 $(37,200) (24,800) $(62,000) $125,000 Total cost of goods sold $(31,000) $(173,000) $369,000 Gross profit $124,000 Operating expenses: Variable expenses $(53,100) $(65,850) Fixed expenses $(5,000) (89,000) $(94,000) $26,000 $(7,750) (77,000) $(84,750) $39,250 (106,200) $(159,300) Total operating expenses Operating...
ABC Company, LLC Income Statement For the Year Ended December 31, 2016 (Actual Dollars) SALES $ 3,315,938 COST OF SALES GROSS PROFIT 640,652 OPERATING EXPENSES: Advertising Auto and Truck Expenses Bank Service Charges Credit Card Fees Depreciation Insurance Legal and Accounting Miscellaneous Payroll Taxes Rent Repairs and Maintenance Supplies Travel Utilities Wages Total Operating Expenses 5.264 3,686 3,158 16.621 8.436 24,511 15.943 10.963 29,931 36,000 34,370 35,748 7,071 28.338 199.537 $ OPERATING INCOME (LOSS) INTEREST EXPENSE 6,237 NET INCOME BEFORE...
Most questions answered within 3 hours.
-
A 0.500-kg object, suspended from an ideal spring of spring
constant 30.2 N/m, is oscillating vertically....
asked 1 minute ago -
Please help and show work. I keep getting the wrong answers for
these problems
1. Cell...
asked 1 minute from now -
If there is a SNP in the read with respect to the
reference genome, how would a...
asked 1 minute ago -
Early black-and-white television sets used an electron beam to
draw a picture on the screen. The...
asked 3 minutes ago -
What is the standard error of M (denoted as
σM ) ?
Options:
The mean of...
asked 27 minutes ago -
Explain the role of n, the sample size, in determining the size
of a generated confidence...
asked 16 minutes ago -
Kelsey Drums, Inc., is a well-established supplier of fine
percussion instruments to orchestras all over the...
asked 30 minutes ago -
In a criminal case, the state must not prove its case beyond a
reasonable doubt. T/F
asked 35 minutes ago -
5.6 dm^3 of gaseous HCl (as measured in normal conditions) is
dissolved in 100 cm^3 of...
asked 44 minutes ago -
The hammer throw is a track-and-field event in which a 7.2-kg
ball (the ''hammer''), starting from...
asked 1 hour ago -
Evaluate a specific listening situation using the Sapir-Whorf
and Bernstein hypothesis. What was thecontext? What was...
asked 1 hour ago -
Recall that if X is a Student’s t random variable with n df,
then by definition...
asked 1 hour ago