70.2K

Verified Solution

Link Copied!

Please answer!

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. There is a sale of 200 units of computers 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 $ 3000. 8. The quality inspector was paid $ 1800. 9. We were billed for $ 20 worth of packaging materials by computer. 10. 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. Paid to outside accountant for merchant certification 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

Answer & Explanation Solved by verified expert

See Answer