Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started