Question: Hathaway Products, Inc., produces an innovative lighting system used in restaurants and high-end retail stores to provide a pleasing, warm atmosphere. Hathaway produces two versions
Hathaway Products, Inc., produces an innovative lighting system used in restaurants and high-end retail stores to provide a pleasing, warm atmosphere. Hathaway produces two versions of the product, called Starlight and Moonlight. Sales management at Hathaway wants to complete a sales performance analysis and has collected the following information for the first quarter (Qtr. 1) and the second quarter (Qtr. 2) of the current fiscal year.
.png)
Required
1. Calculate a flexible budget contribution income statement for Qtr. 2, showing the Qtr. 2 results, the Qtr. 1 results, and the flexible budget. Use Exhibit 16.15 as a guide.
2. Calculate the volume variances for each product based both on sales dollars and contribution margin.
3. Determine the sales volume variance, the sales mix variance, and the sales quantity variance for each product, based on contribution margin
Otr. 2 Otr. 1 Sales units Sales mix for each product 12,000 10,000 Starlight Moonlight 20% 80% 25% 75% Price Starlight Moonlight $35.00 $85.00 $35.00 $90.00 Variable cost per unit Starlight Moonlight $22.00 $48.00 $150,000 S22.00 S48.00 $150,000 Fixed cost
Step by Step Solution
3.27 Rating (159 Votes )
There are 3 Steps involved in it
Given Data Actual Budget Qtr 2 Qtr 1 Sales units 12000 10000 Sales mix for each product Starlight 20 25 Moonlight 80 75 Price Starlight 3500 3500 Moon... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
1153-B-M-A-C-M(2811).xlsx
300 KBs Excel File
