Carvell Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year.

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%).

Data Table

Sales. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .	$1,446,900
Variable Cost of Goods Sold. . . . . . . . . . . .	$216,216
Variable Operating Expenses. . . . . . . . . . .	$262,080
Direct Fixed Manufacturing Overhead. . . .	$87,720
Direct Fixed Operating Expenses. . . . . . . .	$32,100
Common Fixed Expenses. . . . . . . . . . . . . .	$15,450

Budgeted data for the same time period for the pharmaceutical segment are as follows (all data is in millions): Data Table

Budgeted sales in units. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .	9,100
Budgeted average selling price per unit. . . . . . . . . . . . . . . . . . . . . . . .	$150
Variable Cost of Goods Sold per unit. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .	$22
Variable Operating Expenses per unit. . . . . . . . . . . . . . . . . . . . . . . . . . . . .	$30
Direct Fixed Manufacturing Overhead (in total). . . . . . . . . . . . . . . . . . . . .	$86,000
Direct Fixed Operating Expenses (in total). . . . . . . . . . . . . . . . . . . . . .	$30,000
Common Fixed Expenses Allocated to the Pharmaceutical Segment. . . .	$15,00

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.

PLEASE FOLLOW ALL REQUIREMENTS AND FORMAT AS SHOWN:

Carvell 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) Budgeted data for the same time period for the pharmaceutical segment are as folaws (all data is in milians) (Click the icon to view the budgeted 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%). Begin by preparing the perfomance 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, XXX%) Performance Report Carvell - Pharmaceutical Segment For Fiscal Year Ending December 31 Variance % Actual Bugeted Vanance Sales Less Variable Expenses Var able Cost of Goods Sold Variable Operating Expenses Contribution Margin Choose from any list or enter any number in the input fields and then click Check