i need help with this problem by using cell reference formulas

Step Instructions 1 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 percentage for each line in the report. (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) a. Check your spelling carefully and do not abbreviate. b. Follow the format shown in Exhibit 10-4. c. Use the ABS function when calculating variances, and use the drop-down selections for For when describing the variances, Total Dinth D 2. Prepare a segment margin performance report 14 Deladale Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most 4 recent year 5 Sales 586620 7 Variable Cost of Goods Sold 5143,125 Variable Operating Expenses $162, 162 Directed Manufacturing Othead $ 96,300 10 Direct Pared Operating Expenses 5 17.250 11 Common Fed Expenses S14,160 13 Budgeted data for the same time period for the pharmaceuticals follows (all data are in millions 14 15 16 17 18 20 Budgeted sales in units 5,100 Budgeted average selling price per unit 5 Variable Cost of Goods Sold per unit S 15 Variable Operating Experises per unit 18 Directed Manufacturing Overhead (in totaly $90,000 Directed Operating Expenses (in total $ 16,000 Common Fixed Expenses Allocated to the Pharmaceutical Sement 5 14,000 Use the blue shaded areas on the ENTERANSWERS tab for houts Always use coll references and formulas where appropriate to receive full credit you ny/paste from the Instructions tab you will be marked wrong 21 Requirements Prepare a setmanin performance report for the pharmaceutical segment. In this report be sve to include lines for the contribution in the spent main, and operating income calculate a variance and a variance percentage for each in the report Check your spelling catelully and do not abbreviate Follow the format shown in Exhibit 104 Use the function when calculatie vacances and use the dio down selections for wo) Dantsvotte) when describing the variances 23 311 + (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 will be marked wrong.) 3 4 5 Performance Report Driadale Industries - Pharmaceutical Segment For the Fiscal Year Ended December 31 (all figures in millions of dollars) Actual Budgeted Variance / Variance % F/U 7 0 10 11 12 15 16 17 18 19 Operating income (loss) 20 21 22 23 24 25 26 27 20 29 30 31 34 33 36 37 30 ag