please make sure to read the requirements and explain the answers that you get

A B C D Performance Evaluation 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 $ 866,320 $ 143,325 $ 162,162 $ 96,300 $ 17,280 $ 14,140 Budgeted data for the same time period for the pharmaceutical segment are as follows (all data are in millions): . Budgeted sales in units Budgeted average selling price per unit 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 9,100 $ 85 $ 15 $ 18 $ 90,000 $ 16,000 $ 14,000 2 3. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Requirements 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 7 variance percentage for each line in the report. Check your spelling carefully and do not abbreviate Follow the format shown in Exhibit 10 4 30 . Use the ABS function when calculating variances, and use the drop down selections for F favorable) or U (unfavorable) when describing the variances b 2 Savinex Submittine Solution .00 0 Cell Styles A3 XV fx D H 1 G (Use the ABS function when calculating variances, and use the drop-down selections for For U 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 will be marked wrong.) 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 7 8 FU Variance % 9 F/U 10 12 13 15 16 17 18 19 Operating income (loss) 20 21 22 23 24 25 26