Please answer the following questions to complete your job application:
1. A company owns a truck fleet – we sold one truck that we owned for 3 years. The truck was acquired in April 2017 and sold in April 2020. Please advise how to prepare the entry recording the sale of the truck if we bought it for $55K and sold it for $23K.
Required
2. One of our large customers took 2% discount beyond terms. Without creating a credit memo advise how can your book the remittance. Remittance amount $100K customer took $2K credit.
Required
3. Please write a formula looking up invoice 202004567 in table of 5 columns where column 1 is the invoice # and column 4 is the delivery date. We are looking for the delivery date.
Required
4. Please write a formula summing up salaries for department 1000 in table of 5 columns where department # is in column 1 column 2 is gross payroll – column 3 if fed deductions column 4 is state deductions and column 5 is net pay.
Required