I did the first part of requirement one - I finished the entries for the general ledger, but how to do calculate the values for the trial balance sheet ?

Ozark Dock and Lift Company (Fall 2017) ODLC was incorporated in 2003 as a marine service company that sells and installs boat lifts, piers, and docks. ODLC refers to a pier as a purchased light-weight assembly that is purchased from suppliers, ready to install. A dock is a custom-made unit built at the customer's location. ODLC also builds seawalls to protect customer lakefront land from erosion. ODLC also sells water activity items like water skis, wakeboards, and paddle boards. Just this year, ODLC began to rent this equipment. Late in 2016, a decision was made to also sell and rent snowboarding equipment. ODLC has a working president-manager, a store clerk-secretary, and two technicians that assemble and install boat lifts and piers, build custom docks, and install seawalls. Part-time employees are also used on a seasonal basis. A private accounting service maintained the books until December 12, 2016, when the accountant in charge of the account took ill. You have been asked to record all transactions for the balance of December 2016, to close the books for 2016, and to prepare the financial statements for 2016. This entire case is on D2L under the Ozark Case (Fall 2017) file. All templates needed to solve the case are also located there. All parts of the case must be done using Excel. Each requirement is due as indicated below and on the Class Syllabus. The solutions for each requirement will be posted right after the due date. Please adjust your solution to agree with our before you go on to the next requirement. Questions concerning the case can be addressed in class, discussion sessions, or during office hours. You may also email mbyeager@uwm.edu or pfischer@uwm.edu. If any updates are needed, they will be placed under \"announcements\" on D2L. Before you read the details, there are several topics you may want to refresh on, using either the Intermediate Text or even better, your Introductory Accounting Text. The topics include: Periodic versus perpetual inventory systems Gross versus net method of recording purchases Determining the cost of goods sold using a periodic inventory system Allowance for bad debt procedures Straight line depreciation Recording and paying sales taxes Wage withholdings and taxes Deferred (unearned) revenue Major accounts in the chart of accounts can be summarized as follows: Revenue Types Acct No. Account Description 101 Pier and lift sales Retail sale of boat lifts and ready to install piers. The units sold are removed from a perpetual inventory account, number 501, which is maintained using specific identification of units sold. Cash payment for units sold is due on delivery. 1 102 Pier and lift installation labor 103 Custom dock sales 104 Seawall installations 105 Sport Equipment Sales 106 Sport Equipment Rentals Cost of Sales Accounts Acct No. Account 201 Cost of sales - Piers and lifts Labor charges for installation of new boat lifts and piers. Cash payment is due upon completion of installation. About 70% of the units sold are installed by ODLC, remaining units are selfinstalled by customers. Total sales price of custom docks includes purchased lumber, fittings, and associated labor. Some parts and supplies are taken from perpetual inventory account 503 and are debited to account 203, \"Dock parts costs\