solve in excel with proper working notes
this is a full question plz solve in excel with workinn notes
guestion 1 Following a strategy of product differentiation, Electronics Inc. makes a hand held calculator, 11300 . Electronics inc. Manufacturing conversion costs in each year depend on production capacity defined in terms of 11300 units that can produced. Selling and customer-service costs depend on the number of customers that the customer and service functions are designed to support. Neither conversion costs or customer-senvice costs are affected by changes in actual volume. Electronics Inc. has 23 customers in year 1 and 25 customers in year 2 . The industry market size for hand held prices. Your boss has come to you to create a report that includes all of the information below and to explain the results of the calculations for the following items. a. What is the operating income for Year 1 ? b. What is the operating income in Year 2 ? c. What is the change in operating income from Year 1 to Year 2 ? d. What amount is the revenue effect of the growth component? c. What amount is the cost effect of the growth component? f. What is the net effect on operating income as a result of the growth component? g. What amount is the revenue effect of the price-recovery component? h. What amount is the cost effect of the price-recovery component? i. What is the net change in operating income as a result of the price-recovery component? j. What is the net effect on operating income as a result of the productivity component? k. The change in operating income from cost leadership. The change in operating income due to industry wide effects. n. The effect of product differentiation on operating income and a summarization of the change in operating income etween Year 1 to Year 2. auestion 1 Following a strategy of product differentiation, Electronics Inc. makes a hand held calculator, 11300 . Electronics inc. Manufacturing conversion costs in each year depend on production capacity defined in terms of 1300 units that can produced. Selling and customer-service costs depend on the number of customers that the customer and service functions are designed to support. Neither conversion costs or customer-service costs are affected by changes in actual volume. Electronics inc. has 23 customers in year 1 and 25 customers in year 2 . The industry market size for hand held prices. Your boss has come to you to create a report that includes all of the information below and to explain the results of the calculations for the following items. a. What is the operating income for Year 1 ? b. What is the operating income in Year 2? c. What is the change in operating income from Year 1 to Year 2 ? d. What amount is the revenue effect of the growth component? e. What amount is the cost effect of the growth component? f. What is the net effect on operating income as a result of the growth component? g. What amount is the revenue effect of the price-recovery component? h. What amount is the cost effect of the price-recovery component? i. What is the net change in operating income as a result of the price-recovery component? j. What is the net effect on operating income as a result of the productivity component? k. The change in operating income from cost leadership. The change in operating income due to industry wide effects. n. The effect of product differentiation on operating income and a summarization of the change in operating income etween Year 1 to Year 2. guestion 1 Following a strategy of product differentiation, Electronics Inc. makes a hand held calculator, 11300 . Electronics inc. Manufacturing conversion costs in each year depend on production capacity defined in terms of 11300 units that can produced. Selling and customer-service costs depend on the number of customers that the customer and service functions are designed to support. Neither conversion costs or customer-senvice costs are affected by changes in actual volume. Electronics Inc. has 23 customers in year 1 and 25 customers in year 2 . The industry market size for hand held prices. Your boss has come to you to create a report that includes all of the information below and to explain the results of the calculations for the following items. a. What is the operating income for Year 1 ? b. What is the operating income in Year 2 ? c. What is the change in operating income from Year 1 to Year 2 ? d. What amount is the revenue effect of the growth component? c. What amount is the cost effect of the growth component? f. What is the net effect on operating income as a result of the growth component? g. What amount is the revenue effect of the price-recovery component? h. What amount is the cost effect of the price-recovery component? i. What is the net change in operating income as a result of the price-recovery component? j. What is the net effect on operating income as a result of the productivity component? k. The change in operating income from cost leadership. The change in operating income due to industry wide effects. n. The effect of product differentiation on operating income and a summarization of the change in operating income etween Year 1 to Year 2. auestion 1 Following a strategy of product differentiation, Electronics Inc. makes a hand held calculator, 11300 . Electronics inc. Manufacturing conversion costs in each year depend on production capacity defined in terms of 1300 units that can produced. Selling and customer-service costs depend on the number of customers that the customer and service functions are designed to support. Neither conversion costs or customer-service costs are affected by changes in actual volume. Electronics inc. has 23 customers in year 1 and 25 customers in year 2 . The industry market size for hand held prices. Your boss has come to you to create a report that includes all of the information below and to explain the results of the calculations for the following items. a. What is the operating income for Year 1 ? b. What is the operating income in Year 2? c. What is the change in operating income from Year 1 to Year 2 ? d. What amount is the revenue effect of the growth component? e. What amount is the cost effect of the growth component? f. What is the net effect on operating income as a result of the growth component? g. What amount is the revenue effect of the price-recovery component? h. What amount is the cost effect of the price-recovery component? i. What is the net change in operating income as a result of the price-recovery component? j. What is the net effect on operating income as a result of the productivity component? k. The change in operating income from cost leadership. The change in operating income due to industry wide effects. n. The effect of product differentiation on operating income and a summarization of the change in operating income etween Year 1 to Year 2
