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 | $ | 960,000 | 100.0 | % |
| Variable expenses | 400,000 | 41.7 | ||
| Contribution margin | 560,000 | 58.3 | ||
| Fixed expenses | 495,000 | 51.6 |
| |
| Net operating income | $ | 65,000 | 6.7 | % |
| | | | | |
Management is disappointed with the companys 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 territoriesCentral and Eastern. The Central Territory recorded $400,000 in sales and $176,000 in variable expenses during May. The remaining sales and variable expenses were recorded in the Eastern Territory. Fixed expenses of $192,000 and $117,600 are traceable to 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 productsAwls and Pows. Sales of Awls and Pows totaled $100,000 and $300,000, respectively, in the Central Territory during May. Variable expenses are 20% of the selling price for Awls and 52% for Pows. Cost records show that $40,000 of the Central Territorys fixed expenses are traceable to Awls and $60,000 to Pows, with the remainder common to the two products. |
| Required: |
| 1a. | Prepare contribution format segmented income statements for the total company broken down between sales territories. (Input all amounts as positive values except losses which should be indicated by a minus sign. Round your percentage answers to 1 decimal place. Omit the "$" and "%" signs in your response.) |
Sales Territory | ||||||
| Total Company | Central | Eastern | ||||
| Amount | % | Amount | % | Amount | % | |
| Sales | $ | $ | $ | |||
| Variable Expenses | ||||||
| Contribution Margin |
|
|
|
|
|
|
| Traceable Fixed Expenses | ||||||
| Territorial Segment Margin | $ | $ | ||||
| | | | | |||
| Common Fixed Expenses | ||||||
| Net Operating Income(loss) | $ | |||||
| | | |||||
| 1b. | Prepare contribution format segmented income statements for the Central Territory broken down by product line. (Input all amounts as positive values except losses which should be indicated by a minus sign. Round your percentage answers to 1 decimal place. Omit the "$" and "%" signs in your response.) |
Product Line | ||||||
| Central Territory | Awls | Pows | ||||
| Amount | % | Amount | % | Amount | % | |
| Sales | $ | $ | $ | |||
| Variable Expenses | ||||||
| Contribution Margin | ||||||
| Traceable Fixed Expenses | ||||||
| Product Line Segment | $ | $ | ||||
| | | | | |||
| Common Fixed Expenses | ||||||
| Sales Territory Segment Margin<--? | $ | |||||
| | | |||||
I have done as much as I can do. Everything is correct so far just need more input..Obviously.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
