Question
Instructions: Using Excel individually develop a report showing transaction by transaction under which expense or income account is posted. On another page develop the Results
Instructions: Using Excel individually develop a report showing transaction by transaction under which expense or income account is posted. On another page develop the Results 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 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 in the income statement.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started