Business
Business, 19.03.2021 18:00, brittsterrr

Car Inventory You have been tasked with creating an Excel workbook that will allow sales persons the ability to search existing inventory by VIN. They must also be able to define any combination of search criteria that returns a list of results and summary data pertaining to that result set. They have also asked that you create a separate sheet to help them calculate how large of loan they can afford and an amortization schedule for the loan.
Populate Calculated Fields
You need to calculate the number of days each vehicle has been on the lot and if there are any special notes that need to be added to each vehicle. Any vehicle that has been on the lot for more than 200 days is eligible for a special employee bonus if they are able to sell that vehicle. Any vehicle that has been on the lot between 125 and 200 days will earn the seller one raffle ticket in the end of the month $1000 bonus.
a. Open exam2_data and save as Exam2_LastFirst.
b. On the Inventory worksheet, insert a function in H7:H206 to calculate the number of days each vehicle has been on the lot using 1/1/2018 as today’s date.
c. Insert a function in I7:I206 that will display "Bonus Eligible" for cars that have been on the lot more than 200 days, "Raffle Eligible" for cars that have been on the lot between 125 and 200 days, and nothing for the remaining vehicles.

answer
Answers: 1

Other questions on the subject: Business

image
Business, 21.06.2019 18:20, shelbyhood8329
Write two goals for yourself that will aid you in pursuing your post-secondary education or training. with this
Answers: 1
image
Business, 22.06.2019 07:50, sis212
Connors academy reported inventory in the 2017 year-end balance sheet, using the fifo method, as $154,000. in 2018, the company decided to change its inventory method to lifo. if the company had used the lifo method in 2017, the company estimates that ending inventory would have been in the range $130,000-$135,000. what adjustment would connors make for this change in inventory method?
Answers: 1
image
Business, 22.06.2019 11:40, sabrinabowers4308
Vendors provide restaurants with what? o a. cooked items ob. raw materials oc. furniture od. menu recipes
Answers: 1
image
Business, 22.06.2019 16:10, safiyyahrahman6907
From what part of income should someone take savings?
Answers: 2
Do you know the correct answer?
Car Inventory You have been tasked with creating an Excel workbook that will allow sales persons th...

Questions in other subjects:

Konu
Chemistry, 13.01.2021 01:40
Konu
Biology, 13.01.2021 01:40
Konu
Mathematics, 13.01.2021 01:40
Konu
Mathematics, 13.01.2021 01:40