We have to take the information from the first post and put it into the chart and reference cells not just type in the number that is within a cell. I am puzzled as to what goes in the first column on the left.This comes from a managerial accounting class. Thanks!

1 Performance Evaluation 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 4 for the most recent year Sales Variable Cost of Goods Sold Variable Operating Expenses Direct Fied Manufacturghead Direct Fised Operating Espenses Common Fised Expenses $ 866,320 $ 143.325 $ 162,162 96,300 $17,280 14,140 Budgeted data for the same time period for the pharmaceutical 13 segment are asfollows (all data are in millions): 14 Budgeted sales in units Budgeted average selling price per unit $ Variable Cost of Goods Sold per unit Variable Operating Expenses peru Direct Fied Manufacturgheadin 90,000 Direct Fixed Operating Expenses (in total16,000 Common Fied Expenses Allocated to the Pharmaceutical Seqment 9,100 85 15 18 nit$ 14,000 23 Use the blue shaded areas on the ENTERANSWERS tab for inputs 24 Alays use cell references and formulas where appropriate to receive full credit 26 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 27 operating income. Calculate a variance and a variance percentage for each line in the Check your spelling carefuly and do not abbreviate