subject
Business, 19.02.2020 23:02 wildfire771003

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.

ansver
Answers: 2

Other questions on the subject: Business

image
Business, 21.06.2019 14:00, asialuv
Proportion of us adults who own a cell phone. in a survey of 1006 us adults in 2014, 90% said they had a cell phone.1
Answers: 2
image
Business, 21.06.2019 20:50, josephvcarter
Last year, western corporation had sales of $5 million, cost of goods sold of $3 million, operating expenses of $175,000 and depreciation of $125,000. the firm received $40,000 in dividend income and paid $200,000 in interest on loans. also, western sold stock during the year, receiving a $40,000 gain on stock owned 6 years, but losing $60,000 on stock owned 4 years. what is the firm's tax liability?
Answers: 2
image
Business, 22.06.2019 11:40, rmcarde4432
Fanning company is considering the addition of a new product to its cosmetics line. the company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. relevant information and budgeted annual income statements for each of the products follow. skin cream bath oil color gel budgeted sales in units (a) 110,000 190,000 70,000 expected sales price (b) $8 $4 $11 variable costs per unit (c) $2 $2 $7 income statements sales revenue (a × b) $880,000 $760,000 $770,000 variable costs (a × c) (220,000) (380,000) (490,000) contribution margin 660,000 380,000 280,000 fixed costs (432,000) (240,000) (76,000) net income $228,000 $140,000 $204,000 required: (a) determine the margin of safety as a percentage for each product. (b) prepare revised income statements for each product, assuming a 20 percent increase in the budgeted sales volume. (c) for each product, determine the percentage change in net income that results from the 20 percent increase in sales. (d) assuming that management is pessimistic and risk averse, which product should the company add to its cosmetics line? (e) assuming that management is optimistic and risk aggressive, which product should the company add to its cosmetics line?
Answers: 1
image
Business, 22.06.2019 17:30, chilanka
Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding
Answers: 2
You know the right answer?
Perform a goal seek analysis to find a packing weight that will bring the shipping weight of the ret...

Questions in other subjects:

Konu
English, 30.08.2019 20:00
Konu
Mathematics, 30.08.2019 20:00