Use an Excel bar chart to show your data.
2) Assume that the data given in the table of the problem is last year, then changes in this year are given in the problem. Bottom line is to calculate Earnings per Share (use =formulas) for this year.
Income Analysis Eastern Office 2010 Estimates + Price Elasticity of Demand 4 Revenge Units Sold & Price per Un Total Revenue 10 11 Variable Expenses 12 Unita Produced (5% Surplux) 18 Material Cost per lait 14 Total Material Cost 15 Manufacturing Coult pore Llob 16 Total Manufacturing Cost 17 Total Variable Expenses 19 Fixed Expenses 20 Advertising 21 Administrative 22 Miscellaneous 23 Total Fixed Expenses 26 Total Rese 27 Total Expenses Net Income Income Statement. Optimal Price 315.02 8145,420.58 Optional Price Projected 14,000 111.95 $167,100.00 Projected 10,164 Onal Seek $62,475 $8. $51,450 Toy $111,925 By cherging cel: C30 Projected $15,000.00 $15,000.00 $10,000.00 $10,000.00 $5,000.00 $5,000.00 $30,000.00 $30,000.00 Projected Optimal Price 1167,300.00 $145,420.58 $143,925.00 $108,770.32 $21,175.00 $36,650.36 14,700 9,680 D Com-Valume Profit Analysis Expenses Units Sold 14,000 $167.300.00 3143,925.00 $29,375.00 D ($30,000.00) $0.00 $30,000.00 159.750.00 170.687.50 $119,500.00 1111,375.00 5,000 10,000 (110,937.50) 18,125.00 15,000 $179.250.00 1152,062.50 $27,187.50 20,000 $239,000.00 $192,750.00 $46,250.00 25,000 $298,750.00 $233,437.50 $65,312.50 30,000 1858,500.00 1274,125.00 384,375.00 Sales Price Sold $14.00 $16.00 $12.00 (130,000.00) ($30,000.00) ($30,000.00) (1667.50) 19,312.50 148,625.00 $19.00 (130,000.00) 5,000 (120,687.50 ($10,687.50) 10,000 (111,375.00) 18.425.00 828,625.00 15,000 ($2.062.50) $27,957.50 $57,937.50 20,000 $7,250.00 $47,250.00 $87,250.00 $127.250.00 25,000 $16,562.50 $66,562.50 1116,562.50 $166,562.50 30,000 $25,875.00 $95,875.00 $145,875.00 $205.875.00 587,937.50 Cancel Net Income Income Analysis Eastern Office 2010 Estimates + Price Elasticity of Demand 4 Revenge Units Sold & Price per Un Total Revenue 10 11 Variable Expenses 12 Unita Produced (5% Surplux) 18 Material Cost per lait 14 Total Material Cost 15 Manufacturing Coult pore Llob 16 Total Manufacturing Cost 17 Total Variable Expenses 19 Fixed Expenses 20 Advertising 21 Administrative 22 Miscellaneous 23 Total Fixed Expenses 26 Total Rese 27 Total Expenses Net Income Income Statement. Optimal Price 315.02 8145,420.58 Optional Price Projected 14,000 111.95 $167,100.00 Projected 10,164 Onal Seek $62,475 $8. $51,450 Toy $111,925 By cherging cel: C30 Projected $15,000.00 $15,000.00 $10,000.00 $10,000.00 $5,000.00 $5,000.00 $30,000.00 $30,000.00 Projected Optimal Price 1167,300.00 $145,420.58 $143,925.00 $108,770.32 $21,175.00 $36,650.36 14,700 9,680 D Com-Valume Profit Analysis Expenses Units Sold 14,000 $167.300.00 3143,925.00 $29,375.00 D ($30,000.00) $0.00 $30,000.00 159.750.00 170.687.50 $119,500.00 1111,375.00 5,000 10,000 (110,937.50) 18,125.00 15,000 $179.250.00 1152,062.50 $27,187.50 20,000 $239,000.00 $192,750.00 $46,250.00 25,000 $298,750.00 $233,437.50 $65,312.50 30,000 1858,500.00 1274,125.00 384,375.00 Sales Price Sold $14.00 $16.00 $12.00 (130,000.00) ($30,000.00) ($30,000.00) (1667.50) 19,312.50 148,625.00 $19.00 (130,000.00) 5,000 (120,687.50 ($10,687.50) 10,000 (111,375.00) 18.425.00 828,625.00 15,000 ($2.062.50) $27,957.50 $57,937.50 20,000 $7,250.00 $47,250.00 $87,250.00 $127.250.00 25,000 $16,562.50 $66,562.50 1116,562.50 $166,562.50 30,000 $25,875.00 $95,875.00 $145,875.00 $205.875.00 587,937.50 Cancel Net Income
