ABC Supplies is a business based in the Huon Valley, supplying apple trees to a number...

ABC Supplies is a business based in the Huon Valley, supplying apple trees to a number of retail
nurseries in Tasmania. The business is registered for GST. The owner David Branch is a qualified
horticulturalist and manages the nursery organising shipments and managing a small retail store
selling to the public direct. David’s bookkeeper has just retired and he asks you if you can help him
to record the transactions for June. As you are studying accounting he also asks you to finish off the
books for the year and prepare some financial statements for him. The bookkeeper has been keeping
the records manually but David is keen for you to use Excel to complete the various records each
month.
Other Information:
 David sells three varieties of apple trees, Pink Lady, Royal Gala and Golden Delicous.
 Credit terms are 2/10, n/30.
 All transactions are recorded on the day they occur.
 Assume transactions are on credit unless it is stated otherwise.
 Transaction amounts are “GST inclusive” were relevant.
 David uses a perpetual inventory system and the First-in, First-out method to assign costs to
Cost of Goods Sold.
 All cash payments are initially recorded as an expense or revenue. Any work not completed
or unused portion is adjusted at the end of the month.
 Expenses that are incurred but not paid at the end of the month are entered the general journal
at the end of the month.
 For convenience, round all figures to the nearest dollar (you can get Excel to do this for you
by showing no cents).

The Trial Balance as at 31 May 2018 prepared by the old bookkeeper is as follows:

Account Name Acc No Debit Credit

Cash at Bank 1-1100 72 500
Accounts Receivable Control 1-1104 19 030
Allowance for Doubtful Debts 1-1105 2 057
Inventory Control 1-1115 39 480
Office Supplies 1-2121 -
Prepaid Insurance 1-2125 -
Prepaid Advertising 1-2126 -
Land 1-3150 -
Building 1-3160 -
Accumulated depreciation - Building 1-3161 -
Bank Term Deposit 1-3200 40 000
Accounts Payable Control 2-1200 8 800
Accrued Expense Payable 2-1215 -
GST Collected 2-1345 68 344
GST Paid 2-1346 56 949
Long-term Loan Payable 2-2260 -
T Branch, Capital 3-1300 164 234
T Branch, Drawings 3-1310 154 600
Profit and Loss Summary 3-9000 -
Sales 4-1000 703 440
Sales Returns and Other Allowances 4-1005 4 300
Interest Revenue 4-8410 -
Discount Received 4-8420 235
Cost of Goods Sold 5-1000 429 822
Advertising Expense 6-1520 7 600
Salaries and Wages Expense 6-2540 48 000
Telephone and Internet Expense 6-2545 5 810
Electricity Expense 6-2547 10 248
Insurance Expense 6-2550 13 660
Office Supplies Expense 6-2555 1 510
Rent Expense 6-3570 36 000
Bank Fee Expense 6-3580 495
Bad Debts Expense 6-3590 -
Discount Allowed 6-3595 7 106
Inventory Write-off Expense 6-3600 -

947 110 947 110

Schedule of Accounts Receivable at 31 May 2018
Acc No Account Amount
101 Danta Trees 6 600
102 Mendez Plants 1 760
103 Errol Nursery 5 500
104 Fruit Specialist 3 080
105 Arch&Bow 2 090
19 030

Schedule of Accounts Payable at 31 May 2018
Acc No Account Amount
201 Environment Gardens 8 800
202 Sapling Supplies -
203 Planter Plus -
8 800

Inventory Subsidiary Ledger at 31 May 2018
Item No Product Name Units Unit Cost Amount
01 Pink Lady 200 85 17 000
02 Royal Gala 160 55 8 800
03 Golden Delicous 190 72 13 680
39 480

Transactions for the month of June are as follows:
June 1 Cash sales, 70 Golden Delicous @ $132 each. Tax invoice 301.
1 Paid the annual insurance premium of $858, Cheque No 940
2
Credit sales to Danta Trees of 150 Pink Lady @ $176 each and 80 Royal Gala @ $110
each. Tax invoice 302
4
Paid Environment Gardens the amount owing to them and received 2% discount for
early payment. Cheque No 941
6 Received payment in full from Errol Nursery (for credit sale 30 May). Receipt No 601.
6
Purchased 125 Pink Lady @ $94.60 each from Sapling Supplies (terms 3/10, 0 /30).
Tax invoice number 898.
7
Returned 20 Pink Lady purchased from Sapling Supplies because the plants were
damaged in transit. Sapling Supplies sent a credit note $1 892.
8 Paid wages owing for the fortnight $1 800. Cheque No 942.
14 Received $20 000 from Danta Trees. Receipt No 602.
14 Received $ 500 from Mendez Plants. Receipt No 603
15 Paid electricity bill of $451. Cheque No 943.
16 Purchased 100 Golden Delicous @ $82.50 each from Planters Plus (terms 3/10, 0/30).
Tax invoice No 753.
18
Credit sales to Fruit Specialists of 70 Royal Gala @ $110 each and 75 Golden Delicous
@ $132 each. Tax invoice 303.

18
Paid $ 4 400 for advertising campaign to appear in the monthly agricultural newspaper,
Farm News. The advertisement is to appear in the July to November issues of the
newspaper. Cheque No 944
19 Fruit Specialist returned 10 Royal Gala as they had over ordered. Credit note issued to
Fruit Specialist. The trees were returned to inventory.
21 Paid for office supplies $1 430. Cheque No 945.
22 Paid wages owing for the fortnight $1 800. Cheque No 946.
23 Cash sale 35 Pink Lady @ $176 each and 55 Golden Delicous @ $132 each. Tax
invoice 304.
24 Purchased 55 Royal Gala @ $66 each from Environment Gardens (terms 0/30). Tax
invoice 674.
25 Receive advice that Arch&Bow has gone into liquidation, the full amount of owing
written of as bad debt.
26 David contributed a further $10 000 capital to the business.
28 Credit sales to Errol Nursery of 70 Pink Lady @ $176 and 20 Royal Gala @ $110 each.
Tax invoice 305.
29 Received $10 000 from Fruit Specialists. Receipt No 604.

30
The business finalised a purchase agreement for the land and building that it currently
rents. The business borrowed $700 000 from the AgBank for the purchase of the land
and building. The bank paid this directly to the property agent. The value given for the
land is $290 000 and the buildings are valued at $410 000. Rent has been paid up to the
date of purchase.

30
End of Month adjustments
 Insurance policy paid 1 June each year. The previous insurance payments cover the
financial year.
 Advertising costs
 Wages owing at 30 June $ 1 200.
 A stocktake in the office reveals that Office Supplies are $1 640.
 The Telephone and Internet account for June for $250 has not been received or
paid.
 Allowance for Doubtful Debts needs to be adjusted to equal 5% of Accounts
Receivable Control at 30 June.
 Ten of the Royal Gala trees have perished and must be written off.

You are required to:
1. Record accurately all transactions in the correct journals. You will need to complete the Inventory
Subsidiary Ledger cards for the three items of inventory as you go so that you can calculate the
Cost of Goods Sold for each lot of sales.

2. Post the journals to the general ledger at the end of the month (and post to the subsidiary ledger
daily). The ledger accounts have been created for you but you will firstly need to enter the
opening balances in each account on 1st June. NOTE: the income and expense accounts will have

6
an opening balance at this point as they are only closed off using closing entries at the end of the
financial year. You should get these from the Trial Balance and Schedules above.
3. Reconcile your accounts receivable, accounts payable and inventory subsidiary records with
control accounts.
4. Complete the adjusted Trial Balance (do this BEFORE completing and posting closing entries).
5. Record closing entries necessary at the end of the accounting period and post them to the
Ledger. Balance the Balance Sheet accounts.
6. Complete an internal Income Statement and Balance Sheet. You should put aggregated amounts
and a “Note” for the following items:
 Sales and Sales Returns
 Cost of Sales
 Accounts Receivable and Allowance for Doubtful Debts
 GST
 T Branch, Capital (incorporate drawings and profit in the note)

Solutions

Expert Solution

Answer:-

Journal Entries
Date	Particulars		Debit	Credit
Jun-01	Cash A/c	Dr	9,240
	To Sales A/c			9,240


Jun-01	Insurance Expense A/c	Dr	501
	Prepaid Insurance A/c	Dr	358
	To Cash A/c			858

Jun-02	Danta Trees A/c	Dr	26,400
	Royal Gala A/c	Dr	8,800
	To sales A/c			35,200

Jun-04	Enivornment Garden A/c	Dr	8,800
	To Discount Received A/c			176
	To Cash A/c			8,624

Jun-06	Cash A/c	Dr	5,500
	To Errol Nursey A/c			5,500

Jun-06	Purchase A/c	Dr	11,825
	To Sampling Supplies A/c			11,825

Jun-07	Sampling Supplies A/c	Dr	1,892
	To Purchase A/c			1,892

Jun-08	Wages A/c	Dr	1,800
	To Cash A/c			1,800

Jun-14	Cash A/c	Dr	20,000
	To Danta Trees A/c			20,000

Jun-14	Cash A/c	Dr	500
	To Medez Plants A/c			500

Jun-15	Electricity Expenses A/c	Dr	451
	To Cash A/c			451

Jun-16	Purchase A/c	Dr	8,250
	To Planters Plus A/c			8,250

Jun-18	Fruit Specialists A/c	Dr	17,600
	To Sales A/c			17,600

Jun-18	Advertising Expenses A/c	Dr	4,400
	To Cash A/c			4,400

Jun-19	Sales Return A/c	Dr	1,100
	To Fruit Specialists A/c			1,100

Jun-21	Office Supplies A/c	Dr	1,430
	To Cash A/c			1,430

Jun-22	Wages A/c	Dr	1,800
	To Cash A/c			1,800

Jun-23	Cash A/c	Dr	13,420
	To Sales A.c			13,420

Jun-24	Purchase A/c	Dr	3,630
	To Planters Plus A/c			3,630

Jun-25	Bad Debts A/c	Dr	2,090
	To Arch & Blow A/c			2,090

Jun-26	Cash A/c	Dr	10,000
	To Branch Capital A/c			10,000

Jun-28	Errol Nursey A/c	Dr	ekkarill92 answered 1 year ago Next > < Previous Related Solutions A study of 100 apple trees showed that the average number of apples per tree was... A study of 100 apple trees showed that the average number of apples per tree was 1,000. The standard deviation of the population is 150. Which of the following is the 95% confidence interval for the mean number of apples for all trees? a.) (975.3, 1024.7) B.) (970.6, 1029.4) C.) (967.7, 1032.3) D.) (965.1, 1034.9) A study of 35 apple trees showed that the average number of apples per tree was... A study of 35 apple trees showed that the average number of apples per tree was 725. The standard deviation of the population is 100. Which of the following is the 99% confidence interval for the mean number of apples per tree for all trees? Case Study Organophosphate Poisoning John has a number of prize apple trees in his backyard. To... Case Study Organophosphate Poisoning John has a number of prize apple trees in his backyard. To prevent them from becoming infested with insects, he sprayed them with an organophosphate insecticide. He was in a rush to spray the trees before leaving town on vacation, and he failed to pay attention to the safety precautions on the packaging. He sprayed the trees without using any skin or respiratory protection. Soon he experienced severe stomach cramps, double vision, difficulty breathing, and was... Apple Valley Orchards, Inc. (AVO) make apple products. A certain apple pie requires the following: ... Apple Valley Orchards, Inc. (AVO) make apple products. A certain apple pie requires the following: Direct materials standard 1.5 pounds at $7.25 per pound Direct labor standard 0.25 hours at $14.00 per hour During September, AVO purchased 1,875 pounds of direct materials costing $13,125 and used 1,825 pounds of direct materials to produce and sell 1,200 pies. Direct labor totaled 280 direct labor hours for $3,990. Required: a. Compute the direct materials variances for September. b. ... A small garage business employs the following activities: Supplying and mounting of draw-hooks for caravans. Supplying... A small garage business employs the following activities: Supplying and mounting of draw-hooks for caravans. Supplying and mounting of fog-lamps. Supplying and mounting of sunshine roofs. Repairing of bodywork damage. Besides the garage proprietor, there are five mechanics who can perform all occurring tasks. The required parts are kept in stock. In the last years, profits have been declining.The garage proprietor thinks that this is mainly caused by some severe control problems within the firm. These problems include: When a... A small garage business employs the following activities: Supplying and mounting of draw-hooks for caravans. Supplying... A small garage business employs the following activities: Supplying and mounting of draw-hooks for caravans. Supplying and mounting of fog-lamps. Supplying and mounting of sunshine roofs. Repairing of bodywork damage. Besides the garage proprietor, there are five mechanics who can perform all occurring tasks. The required parts are kept in stock. In the last years, profits have been declining.The garage proprietor thinks that this is mainly caused by some severe control problems within the firm. These problems include: When a... Apple Country Orchards in Idalou, Texas, has 6,000 apple trees and offers 30 varieties of apples.... Apple Country Orchards in Idalou, Texas, has 6,000 apple trees and offers 30 varieties of apples. The orchard is 29 years old and allows customers to pick their own apples or to purchase pre-picked apples. In addition to apples and apple picking, the orchard offers hayrides, lunch, pumpkins, and a variety of other items.Apple Country Orchards makes cider from several different apple varieties. One of the varieties used to make cider is the Granny Smith apple, which is known for... Discuss the five alternative ways used for supplying medicines and medical supplies to health services. Discuss the five alternative ways used for supplying medicines and medical supplies to health services. The increasing number of competitors, which leads to the decline in the business profits of ABC... The increasing number of competitors, which leads to the decline in the business profits of ABC Restaurant, has been brought to the attention of a senior manager. He believes that training should be given to regain the market lead in a highly competitive market. You, as a training manager, are approached by him for assistance. In a meeting with him, you are required to: (a) discuss the type of training needs analysis relevant to the situation and (b) elaborate how... QUESTION 1 ..... [20%] The breakdown of the cars in Apple Valley Honda according to color... QUESTION 1 ..... [20%] The breakdown of the cars in Apple Valley Honda according to color is 5% white, 27% black, 11% orange, 6% red and 5% for all others. A car is randomly selected from the lot (to select “randomly” means that every car has the same chance of being selected ). Find the probability (as a percentage) of the following events: (a) The car is black (b) The car is not white (c) The car is not black ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Please write a paper about the qualification process to serve as an investment adviser. Does an... A property costs $100,000. A borrower can obtain an 80% loan with an 8% interest rate... Scenario 13‐2: Upgrading a Cluster to Windows Server 2016 As an administrator at the Contoso Corporation,... A 2.90-kg box is sliding along a frictionless horizontal surface with a speed of 1.8 m/s... At 650 K, the reaction MgCO3(s)<->MgO(s)+CO2(g) has Kp=0.026. A 10.1L container at 650 K has 1.0g... Knowledge Management has become a crucial component of a competitive organization and this argues that knowledge... History of world civilization: What does the Tao-te Ching influence, and reveal about the Chinese civilization?... ADVERTISEMENT About @ 2020 WizEdu

Question

ABC Supplies is a business based in the Huon Valley, supplying apple trees to a number...

Solutions

Expert Solution

Related Solutions