Ventura Vehicles Project
By making queries in Microsoft Access from tables given to us, we created account totals to make a trial balance. To find the cash total we deducted the sum of all cash disbursements from the sum of all cash receipts. To find the accounts receivable total, we deducted the sum of cash received for sales from the order total amount. Inventory - raw materials was found by multiplying unit cost by quantity on hand from the raw material table. Inventory- finished goods was found by multiplying the unit cost from the finished goods table by the quantity on hand from the finished goods table. By summing up the purchase price, we found the total for fixed assets. Accumulated depreciation and depreciation were found by summing up the amount numbers from the depreciation table. For interest, we summed up the total paid expense column on the cash disbursement table. The sales total was found by summing up the total order amount from the sales table. By summing up the total cost from the sales table, we found costs of goods sold.
To find notes payable we subtracted the sum of principle paid from the principle paid table from the sum of total borrowed from the ltd table. Salaries non factory was found by subtracting the sum of total labor money actual from total sum of wages. Services for rent, and administrative office was found by summing up the amount for rent and administrative office in the servacq table. Services for rent, factory was found by summing up the amount for rent, factory in the servacq table. Services for advertising was found by summing up the amount for advertising in the servacq table. Services for electricity was found by summing up the amount for electricity in the servacq table.
To find the accounts payable total, we had to calculate the accounts payable for raw material, services and fixed assets. The raw material total was found by subtracting the total inventory cash disbursements from the sum of purchase receipts. The...