On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates!
Check price for your assignment

Barlett Company

ATC 1-6 Spreadsheet Assignment Using Excel
The following transactions pertain to 2014, the first year of operations of the Barlett Company. All inventory was started and completed during 2014. Assume that all transactions are cash transactions.
1. Acquired $2.000 cash by issuing common stock.
2. Paid $400 for materials used to produce inventory.
3. Paid $600 t production workers.
4. Pair $200 rental fee for production equipment.
5. Paid $160 to administration employees.
6. Paid $80 rental fee for administrative office equipment.
7. Produced 300 units of inventory of which 200 units were sold at a price of $7.00 each.
Required:
Construct a spreadsheet that includes the income statement and balance sheet.

ATC 1-6 Spreadsheet Assignment Using Excel
The following transactions pertain to 2014, the first year of operations of the Barlett Company. All inventory was started and completed during 2014. Assume that all transactions are cash transactions.
1. Acquired $2.000 cash by issuing common stock.
2. Paid $400 for materials used to produce inventory.
3. Paid $600 t production workers.
4.