Instructions: Using Excel individually develop a report showing transaction by transaction under which expense or income account is posted. On another page develop the Income Statement Report for the following transactions. This problem has a value of 20 points. Expense and Income Transactions:

1. A sale of 200 computer units is made for $ 300 each.

2. The 10 computer assembly line employees who earn $ 12 / hour for 40 hours worked are paid.

3. $ 80 supplies are paid for each computer sold. 4. A robotics kit was purchased for $ 15,000 and with a life of 10 years.

5. The supervisor was paid for $ 2000.

6. The warehouse labor of $ 1200 was paid

7. The manager was paid for $ 3000.

8. The quality inspector was paid $ 1800.

9. We were billed for $ 20 worth of packaging materials by computer.

10. She bought office supplies for $ 450. 11.Bought 2 robot response pieces for $ 70 each.

12. $ 50 worth of tape was purchased to pack the computer cases sold.

13. The electricity bill was paid for $ 350.

14. $ 120 water bill paid.

15. $ 500 internet and phone bill paid.

16. The transportation of the computer materials was paid for $ 600.

17. The external accountant for the merchant certification was paid for $ 1,000.

18. The salary of 2 employees in charge of packing the computers was paid at $ 10 / hour for the 40 hours worked. Indicate retained or lost earnings on the income statement.

USING EXCEL PLS ASAP!!