2 Prepare a segment margin performance report Drizzdale Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year. Sales Variable Cost of Goods Sold Variable Operating Expenses Direct Fixed Manufacturing Overhead Direct Fixed Operating Expenses Common Fixed Expenses S 866,320 S 143,325 s 162,162 $96,300 $17,280 14140 Budgeted data for the same time period for the pharmaceutical segment are as follows 13 (all data are in millions): Budgeted sales in units 9,100 15 Variable Cost of Goods Sold per unit Variable Operating Expenses per unit Direct Fixed Manufacturing Overhead (in total) Direct Fixed Operating Expenses (in total) Common Fixed Expenses Allocated to the Pharmaceutical Segment 18 $ 90,000 $16,000 S 14,000 23 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 24 Always use cell references and formulas where appropriate to receive full credit. Prepare a segment margin performance report for the pharmaceutical segment. In this report, be sure to include lines for the contribution margin, the segment margin, and operating income. Calculate a variance and a variance 27 percentage for each line in the report