Question
The most recent monthly contribution format income statement for Reston Company is given below Reston Company Income Statement For the Month Ended May 31 Sales
The most recent monthly contribution format income statement for Reston Company is given below
Reston Company Income Statement For the Month Ended May 31 | ||
Sales | $900,000 | 100% |
Variable Expenses | 408,000 | 45.3 |
Contribution margin | 492,000 | 54.7 |
Fixed expenses | 465,000 | 51.7 |
Net operating income | $27,000 | 3.0% |
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:
a. The company is divided into two sales territories-- Central and Eastern. The Central Territory recorded $400,000 in sales and $208,000 in variable expenses during May. The remaining sales and variable expenses were recorded in the Eastern Territory. Fixed expenses of $160,000 and $130,000 are traceable in the Central and Eastern Territories respectively. The rest of the fixed expenses are common to the two territories.
b. The company is the exclusive distributor for two products -- Awls and Pows. Sales of awls and Pows totaled $100,000 and $300,000 respectively, in the Central Territory during May. Variable expenses are 25% of the selling price for Awls and 61% for Pows. Cost records show that $60,000 of the Central Territory's fixed expenses are traceable to awls and $54,000 to Pows with the remainder common to the two products.
Required:
1. Prepare contribution format segmented income statements, first showing the total company broken down between sales territories and then showing the Central Territory broken down by product line. In addition, for the company as a whole and for each segment, show each item on the segmented income statement as a percent of sales.
2. Look at the statement you have prepared showing the total company segmented by sales territory. What points revealed by this statement should be brought to management's attention?
3. Look at the statement you have prepared showing the Central Territory segmented by product lines. What points revealed by this statement should be brought to management's attention?
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