Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved 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 Results

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISE Managerial Accounting Creating Value In A Dynamic Business Environment

Authors: Ronald W. Hilton, David Platt

13th Edition

1265046794, 9781265046798

More Books

Students also viewed these Accounting questions

Question

Enumerate the items most commonly classified as current assets.

Answered: 1 week ago