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.

Advanced enterprises reports year-end information from 2018 as follows: sales (160,250 units) $968,000 cost of goods sold 641,000 gross margin 327,000 operating expenses 263,000 operating income $64,000 advanced is developing the 2019 budget. in 2019 the company would like to increase selling prices by 14.5%, and as a result expects a decrease in sales volume of 9%. all other operating expenses are expected to remain constant. assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. should advanced increase the selling price in 2019?