Please just get me started. I'm not asking for the whole sheet to be completed.

Drugs 'R Us Variance Analysis (Dollar Amounts in Millions, Unit Dollar Rates in Dollars) Price % of 2012 at 2011 Mix of 2012 at 2011 Efficiency of 2012 at 2011 2012 Actual Variance 2011 Prices Variance 2011 Rates Variance budget Volume Volume Total of Variance budget 2011 Actual Variance badget $ $ $ $ Statistics: Total units sold in millions) Feel So Good percentage of total sales Dump the Pounds percentage of total sales Feel So Good - selling price per unit Dump the Pounds - selling price per unit Liters per unit of raw materials - Feel so Good Liters per unit of raw materials - Dump the Pounds Price per liter of raw materials - Feel so Good Price per liter of raw materials - Dump the Pounds Production labor hours per unit - Feel so Good Production labor hours perunit - Dump the Pounds Production labor personnel costs per hour Production equipment depreciation rate per labor hour Production utility rate per labor hour Material handling, storage, shipping - cost per unit Material handling, storage, shipping breakpoint Material handling breakpoints Material handling cost per breakpoint (in millions of 5) Units per production supervisor Production supervisors Production supervisor annual personnel costs The following costs are all stated in millions of dollars Administration Administrative utilities Marketing and promotion - Feel So Good Marketing and promotion - Dump the Pounds Research and Development Administrative depreciation 165 40.0% 60.0% $ 47.89 $ 17.99 0.75 0.55 $ 23.95 $ 9.99 0.69 0.12 $ 23.95 $ 2.25 $ 13.15 $ 0.82 70 3 $ 31 1.200,000 165 $ 86,234 165 40.0% 60.0% $ 49.95 $ 18.25 0.75 0.55 $ 22.50 $ 9.25 0.69 0.12 $ 21.15 $ 2.25 $ 12.40 S 0.78 70 3 $ 30 1.200.000 165 $ 83.352 HER 165 45.0% 55.0% $ 49.95 $ 18.25 0.75 0.55 $ 22.50 $ 9.25 0.69 0.12 $ 21.15 $ 2.25 $ 12.40 $ 0.78 70 3 $ 30 1,200,000 165 $ 83,352 139 45.0% 55.0% 49.95 18.25 0.80 0.60 22.50 9.25 0.71 0.13 21.15 2.25 12.40 0.78 70 165 45.0% 55.0% $ 49.95 S 18.25 0.80 0.60 $ 22.50 S 9.25 0.71 0.13 $ 21.15 S 2.25 $ 12.40 $ 0.78 70 3 $ 30 1,000,000 165 $ 83.352 $ $ $ $ $ 30 1,000,000 139 $ 83.352 $ $ $ $ $ $ 57 41 60 30 256 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ Revenues Feel So Good Dump the Pounds Total revenues 3,161 1,781 4,942 3.124 1.395 4.520 Cost of Goods Sold Raw materials - Feel So Good Raw materials - Dump the Pounds Production labor - Feel so Good Production labor - Dump the Pounds Production equipment depreciation - Feel So Good Production equipment depreciation - Dump the Pounds Production utilities - Feel So Good Production utilities - Dump the Pounds Material handling, storage, shipping - per unit Material handling, storage, shipping - per breakpoint Supervisor personnel costs Cost of Goods Sold Gross Profit Selling. General, and Administrative Expenses Administration Administrative utilities Marketing and promotion - Feel So Good Marketing and promotion - Dump the Pounds Research and Development Administrative depreciation Total Selling, General, and Admin Expenses Operating Income 1,186 544 1,091 285 102 27 599 156 135 93 12 4.229 713 1.126 424 939 210 100 22 551 123 108 60 12 3,676 844 57 41 60 30 256 156 600 113 55 39 77 36 301 156 664 180 $ Drugs 'R Us Variance Analysis (Dollar Amounts in Millions, Unit Dollar Rates in Dollars) Price % of 2012 at 2011 Mix of 2012 at 2011 Efficiency of 2012 at 2011 2012 Actual Variance 2011 Prices Variance 2011 Rates Variance budget Volume Volume Total of Variance budget 2011 Actual Variance badget $ $ $ $ Statistics: Total units sold in millions) Feel So Good percentage of total sales Dump the Pounds percentage of total sales Feel So Good - selling price per unit Dump the Pounds - selling price per unit Liters per unit of raw materials - Feel so Good Liters per unit of raw materials - Dump the Pounds Price per liter of raw materials - Feel so Good Price per liter of raw materials - Dump the Pounds Production labor hours per unit - Feel so Good Production labor hours perunit - Dump the Pounds Production labor personnel costs per hour Production equipment depreciation rate per labor hour Production utility rate per labor hour Material handling, storage, shipping - cost per unit Material handling, storage, shipping breakpoint Material handling breakpoints Material handling cost per breakpoint (in millions of 5) Units per production supervisor Production supervisors Production supervisor annual personnel costs The following costs are all stated in millions of dollars Administration Administrative utilities Marketing and promotion - Feel So Good Marketing and promotion - Dump the Pounds Research and Development Administrative depreciation 165 40.0% 60.0% $ 47.89 $ 17.99 0.75 0.55 $ 23.95 $ 9.99 0.69 0.12 $ 23.95 $ 2.25 $ 13.15 $ 0.82 70 3 $ 31 1.200,000 165 $ 86,234 165 40.0% 60.0% $ 49.95 $ 18.25 0.75 0.55 $ 22.50 $ 9.25 0.69 0.12 $ 21.15 $ 2.25 $ 12.40 S 0.78 70 3 $ 30 1.200.000 165 $ 83.352 HER 165 45.0% 55.0% $ 49.95 $ 18.25 0.75 0.55 $ 22.50 $ 9.25 0.69 0.12 $ 21.15 $ 2.25 $ 12.40 $ 0.78 70 3 $ 30 1,200,000 165 $ 83,352 139 45.0% 55.0% 49.95 18.25 0.80 0.60 22.50 9.25 0.71 0.13 21.15 2.25 12.40 0.78 70 165 45.0% 55.0% $ 49.95 S 18.25 0.80 0.60 $ 22.50 S 9.25 0.71 0.13 $ 21.15 S 2.25 $ 12.40 $ 0.78 70 3 $ 30 1,000,000 165 $ 83.352 $ $ $ $ $ 30 1,000,000 139 $ 83.352 $ $ $ $ $ $ 57 41 60 30 256 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ $ $ $ $ 55 39 77 36 301 156 $ $ Revenues Feel So Good Dump the Pounds Total revenues 3,161 1,781 4,942 3.124 1.395 4.520 Cost of Goods Sold Raw materials - Feel So Good Raw materials - Dump the Pounds Production labor - Feel so Good Production labor - Dump the Pounds Production equipment depreciation - Feel So Good Production equipment depreciation - Dump the Pounds Production utilities - Feel So Good Production utilities - Dump the Pounds Material handling, storage, shipping - per unit Material handling, storage, shipping - per breakpoint Supervisor personnel costs Cost of Goods Sold Gross Profit Selling. General, and Administrative Expenses Administration Administrative utilities Marketing and promotion - Feel So Good Marketing and promotion - Dump the Pounds Research and Development Administrative depreciation Total Selling, General, and Admin Expenses Operating Income 1,186 544 1,091 285 102 27 599 156 135 93 12 4.229 713 1.126 424 939 210 100 22 551 123 108 60 12 3,676 844 57 41 60 30 256 156 600 113 55 39 77 36 301 156 664 180 $