Question
Company Name: Abcde Pty Ltd The company began operations as a retailer on 1 July 2018. It buys and sells one inventory item, derrings, from
Company Name: Abcde Pty Ltd The company began operations as a retailer on 1 July 2018. It buys and sells one inventory item, derrings, from a leased warehouse in the outer suburbs of Melbourne. The company is registered for GST, which it pays quarterly. Assume GST was last paid on 30 June. It uses the Moving Weighted Average method and the perpetual inventory recording method. The company uses the straight line depreciation method for office furniture and computers and the reducing balance method for motor vehicles.
The company employs two people who are rostered over a seven day working week. The employees are paid fortnightly up to and including the day of payment. There are no penalty wages. The company has one debtor (Debtor1) and one creditor (Creditor1). Terms for all credit sales and purchases are 30 days. Relevant information 1. The company has the following opening balances as at the 1st of July in the current financial year:
Cash at Bank: $20,892.00
Accounts receivable: $3,728.00
Allowance for doubtful debt: $316.00
Inventory: $11,860.00
Motor vehicle: $20,802.00
Accumulated depreciation motor vehicle: $2,647.00
Accounts payable: $4,898.00
Bank loan owing (due in 20 months): $10,619.00
Telephone payable: $124.00
Office furniture: $13,232.00
Accumulated depreciation office furniture: $1,215.00
Office supplies: $446.00
Share capital: $39,926.00
Retained earnings: balance amount $11,215.00 2. Transactions for the month (all dollar amounts include GST where applicable):
02 July Sales on credit 79 units
05 July Sales on credit 52 units
11 July Sales on credit 80 units
18 July Sales on credit 53 units
22 July Sales on credit 58 units
29 July Sales on credit 80 units
06 July Customer returned 4 unit(s) in excellent condition for a full refund from the sale on 05 July
10 July Paid wages (ignore PAYG tax) $1,932.00
24 July Paid wages (ignore PAYG tax) $2,193.00
29 July Paid rent for the current month $3,231.00
07 July Paid insurance $1,023.00
16 July Received advertising invoice (due in 30 days) $606.00
16 July Purchased computer on credit $2,427.00
07 July Purchased inventory on credit 23 units at the cost per unit of $24.00
14 July Purchased inventory on credit 29 units at the cost per unit of $26.00
20 July Purchased inventory on credit 20 units at the cost per unit of $26.00
24 July Purchased inventory on credit 29 units at the cost per unit of $27.00
30 July Purchased inventory on credit 25 units at the cost per unit of $24.00
25 July Abcde returned 4 unit(s) to their supplier for a full refund from the purchase on 24 July
23 July Received payment from accounts receivable $642.00
11 July Received payment from accounts receivable $874.00
26 July Received payment from accounts receivable $802.00
07 July Purchased office supplies on credit $619.00
20 July Paid motor vehicle expenses $131.00
15 July Paid accounts payable $1,259.00
21 July Paid accounts payable $1,262.00
22 July Paid accounts payable $946.00
25 July Paid outstanding telephone bill in full
3. Additional information:
Selling Price per unit (GST inclusive) $55.00
Insurance commences from the first of the month in which it is paid, and covers 8 months in total. All asset purchases and expenses except wages include GST. In addition the cost per unit for inventory purchases includes GST.
Cost of opening inventory items per unit $20.00
Depreciation rate for the motor vehicle is 20%
Residual value of the motor vehicle: $2,767.00
Depreciation rate for the office furniture is 20%
Residual value of the office furniture: $690.00
Regardless of purchase date, company policy is to depreciate new assets for 15 days in the month of purchase. Depreciation rate for the computer is 35%
No residual value is expected for computers.
The company counted inventory at the end of the month. They discovered that 7 units were missing and these must be removed from inventory.
Office supplies on hand at end of the month were $266.00 At the end of the month the company records potential bad debts expense using the percentage of sales method. The business uses 1% of net sales to determine estimated bad debts. Interest owing on the bank loan at the end of the month is $60.00
Required;
1. Sort all transactions in the order of date (transactions must be recorded in date order). This will be critical to the calculation of cost of sales. 2. Based on the assignment information you generated, record the opening balances in the general journal and the general ledger. 3. Record all transactions for the month of July in the: a. General journal
b. General ledger and
c. For inventory transactions in the stock card to determine cost of sales.
4. Record the end-of-month balance day adjustments in the general journal and post them to the relevant general ledger accounts. You need to determine the balance day adjustments from the transactions which occurred in July and the additional information provided in your questions
. 5. Prepare an adjusted trial balance as on 31st July, i.e. after posting all balance day adjustments. If the trial balance does not balance, please attempt to find out the potential error.
6. You are required to record the closing entries in the general journal and general ledgers.
7. Prepare a Statement of Financial Performance for the month ended 31st July, and Statement of Financial Position as on 31st July.
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