Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This region sells all of the product lines, however the owners have asked for an analysis of two specific product lines: Backpacks and Computer Bags.

This region sells all of the product lines, however the owners have asked for an analysis of two specific product lines: Backpacks and Computer Bags. The managers of the Vancouver and Victoria operations provided the following information respecting sales and costs of these products. Dynamadics Vancouver Region Backpacks Computer Bags Total Sales by City as % of national sales Vancouver Victoria 37% 25% 62% 30% 8% 38% Total national sales 67% 33% 100% Cost as % of regional sales Variable production costs, 47% 47% Variable selling costs 13% 13% Fixed costs by product Traceable fixed cost Common fixed cost $74,000 $74,000 Remainder of total costs $148,000 The managers of these two operations identified Computer Bags as an area of concern for them specifically based on their experiences. They provided you with the following for the Computer Bag product line. Dynamadics Vancouver Region Computer-Bag Product Line Vancouver Victoria Total Sales Revenue $290,000 $92,800 $382,800 Costs as percentage of product sales Variable production costs 52% 31.38% Variable selling costs 12% 16% Traceable fixed cost $30,000 $44,000 $74,000 Requirement #1 (14 marks) 1. Prepare, in good form, an income statement segmented by product line for the regional operations, showing the corresponding company totals. (7 mark) 2. In the above income statement, report the segment margin % for each product and in total. [1 mark) 3. Prepare in good form, a segmented performance report for the computer-bag by city. (5 mark) 4. In the above income statement, report the segment margin % for each city and in total (1 mark) For both requirements Round your percentage answers to 2 decimal placed (ie., 0.1234 should be recorded as 12.34%) Round your answers to nearest dollar amount. Check figure: Common fixed cost for requirement #1 is $139,000. Be sure to show your work to support this check figure in your response

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Working Papers

Authors: John G. Helmkamp

2nd Edition

0471514292, 978-0471514299

More Books

Students also viewed these Accounting questions