Question: Data Table: Sales. . . . . . . . . . . . . . . . . . . . . . .

 Data Table: Sales. . . . . . . . .

Data Table:

Sales. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .$1,354,080

Variable Cost of Goods Sold. . . . . . . . . . . . .$98,580

Variable Operating Expenses. . . . . . . . . . . .$125,550

Direct Fixed Manufacturing Overhead. . . . .$112,270

Direct Fixed Operating Expenses. . . . . . . . .$16,160

Common Fixed Expenses. . . . . . . . . . . . . . .$23,760

Budgeted Data:

Budgeted sales in units. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

9,300

Budgeted average selling price per unit. . . . . . . . . . . . . . . . . . . . . . . . .

$130

Variable Cost of Goods Sold per unit. . . . . . . . . . . . . . . . . . . . . . . . . . . .

$10

Variable Operating Expenses per unit. . . . . . . . . . . . . . . . . . . . . . . . . . .

$15

Direct Fixed Manufacturing Overhead (in total). . . . . . . . . . . . . . . . . . .

$103,000

Direct Fixed Operating Expenses (in total). . . . . . . . . . . . . . . . . . . . . . .

$16,000

Common Fixed Expenses Allocated to the Pharmaceutical Segment

$22,000

Carling Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year. (Click the icon to view the actual data.) Prepare a segment margin performance report for the pharmaceutical segment. Calculate a variance and a variance percentage for each line in the report. Round to the nearest hundredth for the variance percentages (for example, if your answer is 16.2384%, round it to 16.24%). Budgeted data for the same time period for the pharmaceutical segment are as follows (all data are in millions): (Click the icon to view the budgeted data.) Begin by preparing the performance report through the contribution margin line. Next, complete the report through the segment margin line, and then, finally, complete the report through the operating income line. (Enter the variances as positive numbers. Round the variance percentages to the nearest hundredth percent, X.XX%.) Performance Report Carling - Pharmaceutical Segment For Fiscal Year Ending December 31 Actual Bugeted Variance Variance % % Sales Less Variable Expenses: % % % Variable Cost of Goods Sold Variable Operating Expenses Contribution Margin Less Direct Fixed Expenses: Fixed Manufacturing Overhead Fixed Operating Expenses Segment Margin Less Common Fixed Expenses allocated to the profit center: Operating Income %6 % %6 %6 %6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!