50.1K

Verified Solution

Link Copied!

Below is the contribution format income statement for Hawkins Industries, segmented by Sales Territory. Sales Territory Total Company Central Eastern Sales $900,000 100.0% $400,000 100.0% $500,000 100.0% Variable expenses 408,000 45.3% 208,000 52.0% 200,000 40.0% Contribution margin 492,000 54.7% 192,000 48.0% 300,000 60.0% Traceable fixed expenses 290,000 32.2% 160,000 40.0% 130,000 26.0% Territorial segment margin 202,000 22.4% $32,000 8.0% $170,000 34.0% Common fixed expenses 175,000 19.4% Net operating income $27,000 3.0% Hawkins Industries would like a report for the Central Territory further segmented by Product Line. Here is the information for the the two products sold in the Central Territory: Awls sales $100,000 Pows sales $300,000 Awls variable expenses 25% of sales Pows variable expenses 61% of sales Awls traceable fixed expenses $60,000 Pows traceable fixed expenses $54,000 Enter a formula or cell reference in every yellow cell. Use the segment report above as your guide. Product Line Central Territory Awls Pows Sales Variable expenses Contribution margin Traceable fixed expenses Product line segment margin Common fixed expenses Net operating income Hint: the Net operating income for the Central Territory should be $32,000. Rubric: Each yellow cell is worth 1/2 point. You must use a formula or cell reference for every yellow cell. If you just type in your answer, you will get zero points. Please let me know if you need some help with the formulas

Answer & Explanation Solved by verified expert

See Answer