Drisdale industries has gathered the following information about the actual sales revenues and expenses for its pharmaceutical segment for the most recent year.

D E Drizzdale Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year. 4 5 8 9 10 11 un 6 Sales $866,320 7 Variable Cost of Goods Sold $143,325 Variable Operating Expenses $162,162 Direct Fixed Manufacturing Overhead $ 96,300 Direct Fixed Operating Expenses $ 17,280 Common Fixed Expenses $ 14,140 12 Budgeted data for the same time period for the pharmaceutical segment are as 13 follows (all data are in millions): 14 15 Budgeted sales in units 9,100 16 Budgeted average selling price per unit $ 85 17 Variable Cost of Goods Sold per unit $ 15 18 Variable Operating Expenses per unit $ 18 19 Direct Fixed Manufacturing Overhead (in total) $ 90,000 Direct Fixed Operating Expenses (in total) $ 16,000 Common Fixed Expenses Allocated to the 21 Pharmaceutical Segment $ 14,000 22 23 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If Y 24 copy/paste from the Instructions tab you will be marked wrong. 25 26 Requirements Prepare a segment margin performance report for the pharmaceutical segment. In this re sure to include lines for the contribution margin, the segment margin, and operating inco 27 Calculate a variance and a variance percentag for each line in the report. 28 Check your spelling carefully and do not abbreviate. 29 b. Follow the format shown in Exhibit 10-4. 30 Use the ABS function when calculating variances, and use the drop-d 20 a. C. 31 1 (Use the ABS function when calculating variances, and use the drop-down selections for ForU when describing the variances.) 2 (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you v 3 4 5 6 Performance Report Drizzdale Industries - Pharmaceutical Segment For the Fiscal Year Ended December 31 (all figures in millions of dollars) Actual Budgeted Variance F/U Variance % F/U 7 8 9 10 11 12 13 14 15 16 17 18 19 Operating income (loss) 20 21 22 23 24 25 26 27 28 29 30