4 Open the Products form in Form view. Add a new product (Access will automatically add the Product ID): Coffee-Arabica Premium. The Description is 24/Case, Pre-Ground 1.75 Oz Bags, the Cost is $13 (just type 13, no $), the Markup Percent is 100%, the Brand is Premium, and the Year Introduced is 2017. Save the new record and close the form. 12

Trey morgan is an employee who is paid monthly. for the month of january of the current year, he earned a total of $4,538. the fica tax for social security is 6.2% of the first $118,500 earned each calendar year, and the fica tax rate for medicare is 1.45% of all earnings for both the employee and the employer. the amount of federal income tax withheld from his earnings was $680.70. his net pay for the month is .

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

Russell's is considering purchasing $697,400 of equipment for a four-year project. the equipment falls in the five-year macrs class with annual percentages of .2, .32, .192, .1152, .1152, and .0576 for years 1 to 6, respectively. at the end of the project the equipment can be sold for an estimated $135,000. the required return is 13.2 percent and the tax rate is 23 percent. what is the amount of the aftertax salvage value of the equipment assuming no bonus depreciation is taken