Perform a goal seek analysis to find a packing weight that will bring the shipping weight of the retro fit clothing set down to 39.75 lbs. use cell i9 as the cell to set, 39.75 as the target value, and cell f5 as the changing cell. keep the values generated by the goal seek analysis as the value for cells f5, i9, and i10.

P8-4b dropping unfavorable division based on the following analysis of last year's operations of groves, inc., a financial vice president of the company believes that the firm's total net income could be increased by $160,000 if its design division were discontinued. (amounts are given in the thousands of dollars.) required provide answers for each of the following independent situations: a. assuming that total fixed costs and expenses would not be affected by discontinuing the design division, prepare an analysis showing why you agree or disagree with the vice president. b. assume that the discontinuance of the design division will enable the company to avoid 30% of the fixed portion of cost of services and 40% of the fixed operating expenses allocated to the design division. calculate the resulting effect on net income. c. assume that in addition to the cost avoidance in requirement (b), the capacity released by discontinuance of the design division can be used to provide 6,000 new services that would have a variable cost per service of $60 and would require additional fixed costs totaling $68,000. at what unit price must the new service be sold if groves is to increase its total net income by $180,000?