1. _{You should use Excel to complete your assignment. 1. Enter all starting balances in the GL and subledgers. You will need to calculate your raw materials inventory value (about $30,000) based on your assigned variables. Adjust retained earnings to balance the opening trial balance. Round all totals to the nearest dollar and all per unit numbers to two decimal places}
2. _{. 2. Journalize the above summary transactions, all dated January 31, 2023. (No new balance sheet accounts are required. You should need to add only the following temporary accounts: Revenue, Cost of Goods Sold, Selling & Administrative Expense, Factory Overhead.)}
3. _{3. Post to the general ledger and subledgers for January 31, 2023. (It is recommended that you post as you go, especially for accounts that have subledgers.)}
4. _{4. Prepare a Pre - Closing trial balance as of January 31, 2023.(This trial balance should include all the income statement accounts).}

Detail in Subsidiary Records As of December 31, 2022 Work in process: Finished goods: Raw materials: 8. The following additional overhead costs were incurred during January: 9. Utility bills received $2,721 (DR Accrued utilities and CR AP). 10. Utility bills paid, $2,521. 11. Other selling and administrative expenses incurred, $12,021. 12. Other payments on count, $61,378. 13. Collections on account, $117,721. 14. Close under- or over-applied Factory Overhead to Cost of Goods Sold. fx Received from Factory Automate Developer A B C D F G G H H I don't forget to keep in belance with control t / add starting balances. Stock \# X-1 5. Apply overhead to jobs. See data for item 6 to obtain machine hours worked. (A direct laborer operates more than one machine simultaneously, so machine hours are not necessarily equal to labour hours incurred by Builders). 6. Use the following information to (a) record the completion and (b) the sale of the items: BarBee Inc. *All sales are on account. 7. Gross payroll (factory and office) of $41,250 is paid in cash. BarBee Inc. is a small producer of custom doll houses in London. It uses a job order costing system because each doll house is custom build for its owner and therefore receives varying attention and effort from the two factory departments, building and finishing. BarBee uses a perpetual inventory system. BarBee Inc. had the following post-closing trial balance as of December 31, 2022: Direct Material Usage For the Month Ended January 31, 2023 4. A summary of payroll costs incurred as per the time tickets is as follows: Actual Labour Hours Worked For the Month Ended January 31, 2023 Other payroll costs: These overhead rates will be used throughout the year by each department. All overhead will be applied to all jobs worked on during the year in proportion to the machine-hour and/or direct-labour cost devoted to each job. BarBee Inc. rents its factory building. This budget was prepared after careful consideration of the sales outlook for the coming year. The forecasted budget consisted of the following items: BarBee Inc. Factory Overhead Budget For The Year Ended December 31, 2023 8. The following additional overhead costs were incurred during January: 9. Utility bills received $2,721 (DR Accrued utilities and CR AP). 10. Utility bills paid, $2,521. 11. Other selling and administrative expenses incurred, $12,021. 12. Other payments on count, $61,378. 13. Collections on account, $117,721. 14. Close under- or over-applied Factory Overhead to Cost of Goods Sold. Detail in Subsidiary Records As of December 31, 2022 Work in process: Finished goods: Raw materials: The following transactions occurred during the month of January 2023: 1. Purchases of raw materials (on account): Assume that osts have not changed in the last year. 2. Returns on account: 50 units of material B. (receiving report \#1019) 3. The direct material requisitions were summarized, and the following date were shown on a material usage report. Building Department Direct Material Usage For the Month Ended January 31, 2023