Question
Requirements : 1. Using the transaction list provided, prepare a perpetual inventory record for Steel Breeze, Inc., for the month of December. Steel Breeze, Inc.,
Requirements :
1. | Using the transaction list provided, prepare a perpetual inventory record for Steel Breeze, Inc., for the month of December. Steel Breeze, Inc., uses the FIFO inventory costing method. (Steel Breeze records inventory in the perpetual inventory record net of any discounts, as it is company policy to take advantage of all purchase discounts.) | |
2. | Four-column general ledger accounts, along with their balances from the November 30 trial balance as applicable, have been opened for you. Record each transaction in the general journal utilizing the "net" method for purchases and sales. Explanations are not required. Post the journal entries to the general ledger. Omit posting references. Calculate the new account balances. | |
3. | Prepare an unadjusted trial balance as of December 31, 2018. | |
4. | Journalize and post the adjusting journal entries based on the following information: | |
Depreciation expense on office equipment, $1,300 | ||
Supplies on hand, $290 | ||
Accrued salary expense for the office receptionist, $800 | ||
Estimated refund liability, $1,750 | ||
Cost of estimated inventory returns, $875 | ||
5. | Prepare an adjusted trial balance as of December 31, 2018. Use the adjusted trial balance to prepare Steel Breeze, Inc.'s multistep income statement and statement of retained earnings for the year ending December 31, 2018. Also, prepare the balance sheet at December 31, 2018. | |
6. | Journalize and post the closing entries. | |
7. | Prepare a post-closing trial balance at December 31, 2018. |
Will you please help me with all the requirements?
Steel Breeze, Inc., wholesales a line of custom road bikes. Steel Breeze's inventory as of November 30, 2018, consisted of 23 mountain bikes costing $1,200 each. Steel Breeze's trial balance as of November 30 appears as follows: (Click the icon to view the November 30 trial balance.) During the month of December 2018, Steel Breeze, Inc., had the following transactions: i (Click the icon to view the December transactions.) Read the requirements. Requirement 1. Using the transaction list provided, prepare a perpetual inventory record for Steel Breeze, Inc., for the month of December. Steel Breeze, Inc., uses the FIFO inventory costing method. (Steel Breeze records inventory in the perpetual inventory record net of any discounts, as it is company policy to take advantage of all purchase discounts.) Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period. (Round all currency amounts to the nearest cent, X.XX. Enter the oldest inventory layers first.) Perpetual Inventory Record: FIFO Purchases Cost of goods sold Unit Total Inventory on hand Unit Total Unit Total Date Qty Cost Cost Qty Cost Cost Dec 1 Qty Cost Cost 23 $ 1,200.00 $ 27,600.00 23 1,200 27,600 Dec 41 19 1000 19,000 19 1000 19000 Steel Breeze, Inc. Trial Balance November 30, 2018 Account Debit Credit Cash 9,400 Accounts receivable 12,600 27,600 700 7,800 Inventory Supplies Office equipment Accumulated depreciation, office equipment Accounts payable Note payable, long-term 2,600 1,600 2,500 Common stock 7,000 Retained earnings 1,410 Dividends 5,000 Sales revenue 154,000 Cost of goods sold 78,900 Accounts receivable 12,600 Inventory 27,600 700 7,800 Supplies Office equipment Accumulated depreciation, office equipment Accounts payable Note payable, long-term $ 2,6001 1,600 2,500 Common stock 7,000 Retained earnings 1,410 Dividends 5,000 Sales revenue 154,000 Cost of goods sold 78,900 Sales commissions expense 11,900 Office salaries expense 7,550 Office rent expense 5,060 2,600 Shipping expense $ 169,110 $ 169, 110 Total Dec 4 6 8 10 12 14 Purchased 19 bikes for $1,000 each from The Handle Bar, Co., on account. Terms, 3/15, n/45, FOB destination. Sold 22 bikes for $2,200 each on account to Wheel Wizzard, Inc. Terms, 1/10, n/30, FOB destination. Paid $125 freight charges to deliver goods to Wheel Wizzard, Inc. Received $6,900 from Camp Rock as payment on a November 17 sale. Terms were n/30. Purchased $700 of supplies on account from Office Express. Terms, 3/10, n/30, FOB destination. Received payment in full from Wheel Wizzard, Inc., for the December 6 sale. Purchased 21 bikes for $1,100 each from The Handle Bar, Co., on account. Terms, 3/15, n/45, FOB destination. Paid The Handle Bar, Co., the amount due from the December 4 purchase in full. Sold 20 bikes for $2,400 each on account to Trickster, Inc. Terms, 3/15, n/45, FOB shipping point. Paid for the supplies purchased on December 12. Paid sales commissions, $2,200. Paid current month's rent, $460. Paid The Handle Bar, Co., the amount due from the December 16 purchase in full. 16 18 19 20 22 30 31 Steel Breeze, Inc., wholesales a line of custom road bikes. Steel Breeze's inventory as of November 30, 2018, consisted of 23 mountain bikes costing $1,200 each. Steel Breeze's trial balance as of November 30 appears as follows: (Click the icon to view the November 30 trial balance.) During the month of December 2018, Steel Breeze, Inc., had the following transactions: i (Click the icon to view the December transactions.) Read the requirements. Requirement 1. Using the transaction list provided, prepare a perpetual inventory record for Steel Breeze, Inc., for the month of December. Steel Breeze, Inc., uses the FIFO inventory costing method. (Steel Breeze records inventory in the perpetual inventory record net of any discounts, as it is company policy to take advantage of all purchase discounts.) Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period. (Round all currency amounts to the nearest cent, X.XX. Enter the oldest inventory layers first.) Perpetual Inventory Record: FIFO Purchases Cost of goods sold Unit Total Inventory on hand Unit Total Unit Total Date Qty Cost Cost Qty Cost Cost Dec 1 Qty Cost Cost 23 $ 1,200.00 $ 27,600.00 23 1,200 27,600 Dec 41 19 1000 19,000 19 1000 19000 Steel Breeze, Inc. Trial Balance November 30, 2018 Account Debit Credit Cash 9,400 Accounts receivable 12,600 27,600 700 7,800 Inventory Supplies Office equipment Accumulated depreciation, office equipment Accounts payable Note payable, long-term 2,600 1,600 2,500 Common stock 7,000 Retained earnings 1,410 Dividends 5,000 Sales revenue 154,000 Cost of goods sold 78,900 Accounts receivable 12,600 Inventory 27,600 700 7,800 Supplies Office equipment Accumulated depreciation, office equipment Accounts payable Note payable, long-term $ 2,6001 1,600 2,500 Common stock 7,000 Retained earnings 1,410 Dividends 5,000 Sales revenue 154,000 Cost of goods sold 78,900 Sales commissions expense 11,900 Office salaries expense 7,550 Office rent expense 5,060 2,600 Shipping expense $ 169,110 $ 169, 110 Total Dec 4 6 8 10 12 14 Purchased 19 bikes for $1,000 each from The Handle Bar, Co., on account. Terms, 3/15, n/45, FOB destination. Sold 22 bikes for $2,200 each on account to Wheel Wizzard, Inc. Terms, 1/10, n/30, FOB destination. Paid $125 freight charges to deliver goods to Wheel Wizzard, Inc. Received $6,900 from Camp Rock as payment on a November 17 sale. Terms were n/30. Purchased $700 of supplies on account from Office Express. Terms, 3/10, n/30, FOB destination. Received payment in full from Wheel Wizzard, Inc., for the December 6 sale. Purchased 21 bikes for $1,100 each from The Handle Bar, Co., on account. Terms, 3/15, n/45, FOB destination. Paid The Handle Bar, Co., the amount due from the December 4 purchase in full. Sold 20 bikes for $2,400 each on account to Trickster, Inc. Terms, 3/15, n/45, FOB shipping point. Paid for the supplies purchased on December 12. Paid sales commissions, $2,200. Paid current month's rent, $460. Paid The Handle Bar, Co., the amount due from the December 16 purchase in full. 16 18 19 20 22 30 31
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