70.2K

Verified Solution

Link Copied!

Week 8 Cho Segment Report - Excel Search AutoSave Off Data Formulas Review View Help File Home Insert Draw Page Layout K30 H G B E C D 4 Below is the contribution format income statement for Hawkins Industries, segmented by 5 Sales Territory 6 Sales Territory 7 Total Company Central Eastern 8 Sales $900,000 100.0% $400,000 100.0% $500,000 100.0% 9 Variable expenses 408,000 45.3% 208,000 52.0% 200,000 40.0% 10 Contribution margin 492,000 54.7% 192,000 48.095 300,000 60.0% 11 Traceable fixed expenses 290,000 32.2% 160,000 40.0% 130,000 26.096 12 Territorial segment margin 202,000 22.4% $32,000 8.0% $170,000 34.0% 13 Common fixed expenses 175,000 19.4% 14 Net operating income $27,000 3.0% 15 16 Hawkins Industries would like a report for the Central Territory further segmented by Product Line. 17 Here is the information for the the two products sold in the Central Territory: 18 19 Awls sales $100,000 20 Pows sales $300,000 21 Awls variable expenses 25% of sales 22 Pows variable expenses 61% of sales 23 Awis traceable fixed expense $60,000 24 Pows traceable fixed expens $54,000 25 26 Enter a formula or cell reference in every yellow cell. Use the segment report above as your guide. 27 28 Product Line 29 Central Territory Awls Pows 30 Sales Sheet1 Enter File Home Insert Draw Page Layout K30 F G E H D B 15 16 Hawkins Industries would like a report for the Central Territory further segmented by Product Line. 17 Here is the information for the the two products sold in the Central Territory: 18 19 Awls sales $100,000 20 Pows sales $300,000 21 Awls variable expenses 25% of sales 22 Pows variable expenses 61% of sales 23 Awls traceable fixed expense $60,000 24 Pows traceable fixed expens $54,000 25 26 Enter a formula or cell reference in every yellow cell. Use the segment report above as your guide. 27 28 Product Line 29 Central Territory Awls Pows 30 Sales 31 Variable expenses 32 Contribution margin 33 Traceable fixed expenses 34 Product line segment margin 35 Common fixed expenses 36 Net operating income 37 38 39 Hint: the Net operating income for the Central Territory should be $32,000. 40 41 Sheet1 Enter

Answer & Explanation Solved by verified expert

See Answer