Question
Segmented Reporting and Variances Pittsburgh-Walsh Company (PWC) is a manufacturing company whose product line consists of lighting fixtures and electronic timing devices. The Lighting Fixtures
Segmented Reporting and Variances
Pittsburgh-Walsh Company (PWC) is a manufacturing company whose product line consists of lighting fixtures and electronic timing devices. The Lighting Fixtures Division assembles units for the upscale and mid-range markets. The Electronic Timing Devices Division manufactures instrument panels that allow electronic systems to be activated and deactivated at scheduled times for both efficiency and safety purposes. Both divisions operate out of the same manufacturing facilities and share production equipment.
PWCs budget for the year ending December 31, 20x1, follows and was prepared on a business segment basis under the following guidelines:
- Variable expenses are directly assigned to the incurring division.
- Fixed overhead expenses are directly assigned to the incurring division.
- The production plan is for 8,000 upscale fixtures, 22,000 mid-range fixtures, and 20,000 electronic timing devices. Production equals sales.
PWC established a bonus plan for division management that required meeting the budgets planned operating income by product line, with a bonus increment if the division exceeds the planned product line operating income by 10 percent or more.
PWC Budget | |||||||||||||||||
For the Year Ending December 31, 20x1 | |||||||||||||||||
(In Thousands of Dollars) | |||||||||||||||||
Lighting Fixtures | |||||||||||||||||
Upscale | Mid-Range | Electronic Timing Devices | Total | ||||||||||||||
Sales | $1,440 | $ 770 | $ 800 | $ 3,010 | |||||||||||||
Variable expenses: | |||||||||||||||||
Cost of goods sold | (720) | (439) | (320) | (1,479) | |||||||||||||
Selling and administrative | (170) | (60) | (60) | (290) | |||||||||||||
Contribution margin | $ 550 | $ 271 | $ 420 | $ 1,241 | |||||||||||||
Fixed overhead expenses | 140 | 80 | 80 | 300 | |||||||||||||
Segment margin | $ 410 | $ 191 | $ 340 | $ 941 |
Shortly before the year began, the CEO, Jack Parkow, suffered a heart attack and retired. After reviewing the 20x1 budget, the new CEO, Joe Kelly, decided to close the lighting fixtures mid-range product line by the end of the first quarter and use the available production capacity to grow the remaining two product lines. The marketing staff advised that electronic timing devices could grow by 40 percent with increased direct sales support. Increases above that level and increasing sales of upscale lighting fixtures would require expanded advertising expenditures to increase consumer awareness of PWC as an electronics and upscale lighting fixtures company. Kelly approved the increased sales support and advertising expenditures to achieve the revised plan. Kelly advised the divisions that for bonus purposes the original product-line operating income objectives must be met, but he did allow the Lighting Fixtures Division to combine the operating income objectives for both product lines for bonus purposes.
Prior to the close of the fiscal year, the division controllers were furnished with preliminary actual data for review and adjustment, as appropriate. These preliminary year-end data reflect the revised units of production amounting to 12,000 upscale fixtures, 4,000 mid-range fixtures, and 30,000 electronic timing devices and are presented as follows:
PWC Preliminary Actuals | |||||||||||||||||
For the Year Ending December 31, 20x1 | |||||||||||||||||
(In Thousands of Dollars) | |||||||||||||||||
Lighting Fixtures | |||||||||||||||||
Upscale | Mid-Range | Electronic Timing Devices | Total | ||||||||||||||
Sales | $ 2,160 | $140 | $1,200 | $ 3,500 | |||||||||||||
Variable expenses: | |||||||||||||||||
Cost of goods sold | (1,080) | (80) | (480) | (1,640) | |||||||||||||
Selling and administrative | (260) | (11) | (96) | (367) | |||||||||||||
Contribution margin | $ 820 | $ 49 | $ 624 | $ 1,493 | |||||||||||||
Fixed overhead expenses | 140 | 14 | 80 | 234 | |||||||||||||
Segment margin | $ 680 | $ 35 | $ 544 | $ 1,259 |
The controller of the Lighting Fixtures Division, anticipating a similar bonus plan for 20x2, is contemplating deferring some revenues to the next year on the pretext that the sales are not yet final and accruing in the current year expenditures that will be applicable to the first quarter of 20x2. The corporation would meet its annual plan, and the division would exceed the 10 percent incremental bonus plateau in 20x1 despite the deferred revenues and accrued expenses contemplated.
Required:
1. Calculate the contribution margin, contribution margin volume, and sales mix variances. Enter your answers in dollars, rather than in thousands of dollars For example, enter "750,000" rather than "750". If required, round calculations to the nearest cent.
Contribution margin variance | $ ????? | Favorable |
Contribution margin volume variance | $ ????? | Unfavorable |
Sales mix variance | $ ????? | Favorable |
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