"geneva's manager would like to see some additional information to help make sales decisions. enter a formula in cell j4 using the if function to it whether or not the item beaded earrings should go on sale. it will go on sale if its current sales rank (in cell g4) is 8th or lower. (hint: if the cell value is greater than or equal to 8, it will go on sale.)

a. if this condition is true, the item will go on sale. (hunt: the if_true value should be "yes".)

b. if this condition is false, the item doesn't need to go on sale. (hint: the if false value should be "-".)

c. copy the formula created in cell j4 to the range j5:j14."

Shelby company produces three products: product x, product y, and product z. data concerning the three products follow (per unit): product x product y product z selling price $ 85 $ 65 $ 75 variable expenses: direct materials 25.50 19.50 5.25 labor and overhead 25.50 29.25 47.25 total variable expenses 51.00 48.75 52.50 contribution margin $ 34.00 $ 16.25 $ 22.50 contribution margin ratio 40 % 25 % 30 % demand for the company’s products is very strong, with far more orders each month than the company can produce with the available raw materials. the same material is used in each product. the material costs $8 per pound, with a maximum of 4,400 pounds available each month. required: a. compute contribution margin per pound of materials used. (round your intermediate calculations and final answers to 2 decimal places.) contribution margin per pound product x $ product y $ product z $ b. which orders would you advise the company to accept first, those for product x, for product y, or for product z? which orders second? third? product x product y product z

Which of the following is likely not a benefit of requiring a grand jury to listen to and examine all of the evidence against a person suspected of committing a serious crime and then independently deciding whether or not to hand down an indictment? 1.the grand jury system provides the accused another safeguard against being sent to trial and facing conviction based on flawed evidence. 2.the members of the grand jury are drawn from the community and are empowered to render independent decisions about whether or not the government has collected enough evidence to bring an individual to trial. 3.the grand jury’s decision can provide prosecutors insight into what is necessary to build a sufficient case if a similar crime is presented later. 4.the grand jury is impaneled to rubber-stamp prosecutors’ cases, which makes it possible for more cases to reach trial.

Over the past several years, joyce chen has been able to save regularly. as a result, today she has $54,188 in savings and investments. she wants to establish her own business in 5 years and feels she will need $100,000 to do so. a. if she can earn 6% on her money, how much will her $54,188 in savings/investments be worth in 5 years? will joyce have the $100,000 she needs? if not, how much more money will she need? b. given your answer to part a, how much will joyce have to save each year over the next 5 years to accumulate the additional money? assume she can earn interest at a rate of 6%. c. if joyce can afford to save only $4,000 a year then, given your answer to part a, will she have the $100,000 she needs to start her own business in 5 years?