] Perform a goal seek analysis to determine what the sales price in column B needs to be if you wanted the operating income in column B to be $3,500. Accept the solution. Sort & Filter Data Tools Forecast B3 & I A B D Goal Seek ? G H 1 Official College Swed shirts 2 Set cell: Flexible Budget Analysis 3 STATIC BUDGET Te yale 4 Fixed Cost $17,450 By shaping cell SD$12 5 Variable Cost per unit $15 OK Cancel 6 Unit Output 750 7 Sales Price $10 8 9 Sales Revenue $30,000 10 LESS: Expenses $28,700 11 Operating Income $1,300 12 13 FLEXIBLE BUDGET 14 Varying Unit Output 450 600 750 900 1050 1200 15 Sales Revenue $18,000.00 $ 24,000.00 $30,000.00 $ 36,000.00 $ 42,000.00 $48,000.00 16 Expenses $24,200.00 $ 26,450.00 $ 28,700.00 $30,950.00 $33,200.00 $35,450.00 17 Operating Income $ (6,200.00 $ (2,450.00 $ 1,300.00 $ 5,050.00 $ 8,800.00 $12,550.00 Unit Output 18 19 20 21 22 23 Varying Unit Output and Shiles Price Operating Income $35.00 $37.50 Sales Price $40.00 $42.50 $45.00 Budget Analysis Named Ranges 450 -$8,450 -$7,325 -$6,200 -$5,075 -$3,950 600 -$5,450 -$3,950 -$2,450 -$950 $550 Unit Output 750 900 -$2,450 $550 -$575 $2,800 $1,300 $5,050 $3,175 $7,300 $5,050 $9,550 1050 $3,550 $6,175 $8,800 $11,425 $14,050 1200 $6,550 $9,550 $12,550 $15,550 $18,550 25 ] Perform a goal seek analysis to determine what the sales price in column B needs to be if you wanted the operating income in column B to be $3,500. Accept the solution. Sort & Filter Data Tools Forecast B3 & I A B D Goal Seek ? G H 1 Official College Swed shirts 2 Set cell: Flexible Budget Analysis 3 STATIC BUDGET Te yale 4 Fixed Cost $17,450 By shaping cell SD$12 5 Variable Cost per unit $15 OK Cancel 6 Unit Output 750 7 Sales Price $10 8 9 Sales Revenue $30,000 10 LESS: Expenses $28,700 11 Operating Income $1,300 12 13 FLEXIBLE BUDGET 14 Varying Unit Output 450 600 750 900 1050 1200 15 Sales Revenue $18,000.00 $ 24,000.00 $30,000.00 $ 36,000.00 $ 42,000.00 $48,000.00 16 Expenses $24,200.00 $ 26,450.00 $ 28,700.00 $30,950.00 $33,200.00 $35,450.00 17 Operating Income $ (6,200.00 $ (2,450.00 $ 1,300.00 $ 5,050.00 $ 8,800.00 $12,550.00 Unit Output 18 19 20 21 22 23 Varying Unit Output and Shiles Price Operating Income $35.00 $37.50 Sales Price $40.00 $42.50 $45.00 Budget Analysis Named Ranges 450 -$8,450 -$7,325 -$6,200 -$5,075 -$3,950 600 -$5,450 -$3,950 -$2,450 -$950 $550 Unit Output 750 900 -$2,450 $550 -$575 $2,800 $1,300 $5,050 $3,175 $7,300 $5,050 $9,550 1050 $3,550 $6,175 $8,800 $11,425 $14,050 1200 $6,550 $9,550 $12,550 $15,550 $18,550 25
