HI5001-Accounting for Business Decisions- Holmes Instititute

Question 1 (10 marks)

The accounting department of MNO Limited (MNO) provides two sets of data for June. The first data relates to the purchase, and the second data relates to the sales.

Table 1. The First Set of Data - Purchases
1st June	1185 units @ 9
6th June	711 units @ 10
11th June	474 units @ 12
19th June	1185 units @11
28th June	158 units @ 13

The following data relates to the sales:

Table 2. The Second Set of Data - Sales
9th June	237 units @ 13
14th June	1422 units @ 13
24th June	553 units @ 15

Required:

Based on the above information, calculate the following for the month of June 20X0:

1. Cost of goods sold (COGS) (4 Marks)

ANSWER a: (answer box will enlarge as you enter your response)

1. Cost of closing inventory (3 Marks)

ANSWER b:

1. The gross profit (3 Marks)

ANSWER c:

Question 2 (10 marks)

Credit Sales refer to the revenue earned by a company from its products or services, where the customer paid using credit rather than cash. JKL Limited (JKL) sells its products on credit. The table below presents the information relating to the selected accounts.

Table 1. Sales, A/R and Allowances for Doubtful Debts
Accounts receivable (balance 30 June 20X3)	120 805
Allowance for doubtful debts (credit balance 1st July 20X2)	555
Credit sales returns and allowances during the year	33 300
Credit sales during the year	395 900

In the past, the company’s yearly bad debt expense had been estimated at 2% of net credit sales revenue. It was decided to compare the current method with an ageing of the accounts receivable method. The following analysis was obtained with respect to the accounts receivable.

Nature of A/R	Age	Balance	% of estimated uncollectable
Not yet due	64 972	0.50%
Overdue	10-30 days	22 570	02%
31-60 days	16 280	10%
61-120 days	9 398	25%
121 days and over	7 585	40%
120 805

Required:

1. Prepare journal entries to adjust the Allowance for Doubtful Debts at 30 June 20X9 using the net credit sales method. (3 marks)

ANSWER:

1. Prepare journal entries to adjust the Allowance for Doubtful Debts at 30 June 20X9 using the ageing of accounts receivable method. (3 marks)

ANSWER:

1. Determine the balance in the Allowance for Doubtful Debts account under the net credit sales method. (2 marks)

ANSWER:

1. Determine the balance in the Allowance for Doubtful Debts account under the ageing of accounts receivable method. (2 marks)

ANSWER:

Question 3 (10 marks)

On 1st January 20X1, WWW Limited (WWW) purchased new machinery for $210 560. WWW paid some directly attributable cost to bring this machinery into working condition. In particular, WWW paid the freight cost of $3 580 and the installation cost of $4 843. This machine is expected to have a useful life of ten years with a residual value of $2 106. The pattern of economic benefits from using this machinery is constant. Therefore, it is decided that the straight-line depreciation method will be used. Ignore GST.

Required:

1. Determine the cost of the machine (4 marks)

ANSWER:

1. Assuming that year ends on 30 June, record the journal entry of depreciation expenses on 30 June 20X3 (3 marks)

ANSWER:

1. Calculate the accumulated depreciation balance at the end of the fourth year (3 marks)

ANSWER:

Question 4 (10 marks)

Table 1 presents the information extracted from the accounting records and bank statement of GHI Limited (GHI) at 30 June 20X3.

Table 1.
The closing balance, as shown on the bank statement (Cr)	1 575
Cash receipts of 30 June which were deposited on 30th June did not appear on the bank statement.	792
Cheques recorded in the cash payments but not yet presented for payment to the bank.	589

Required:

1. Prepare the bank reconciliation statement at 30 June, 2010 disclosing the closing balance of cash at the bank. (5 marks)

ANSWER a:

1. Assume the same data as above, but assume further that the closing balance of the bank account shown on the bank statement is $1 575 Dr., i.e., the bank account is overdrawn). Prepare the bank reconciliation statement at 30 June, 20X3 disclosing the closing balance of cash at the bank. (5 marks)

ANSWER b:

Question 5 (10 marks)

You have performed the processes involved in the SAP S/4HANA Procurement and Fulfilment (recall your SAP ERP assessment). Briefly describe these processes. Is there any theoretical linkage between the fulfilment process and the procurement process? Finally, what challenges did you face in completing SAP ERP Assessment? Note: Your responses will be verified using your SAP ERP account details.

ANSWER:

END OF FINAL ASSESSMENT

Please complete the following details:

Integrity Declaration	I have read and understand academic integrity policies and practices and my assessment does not violate these.
	Student Number
	Full Name
	Submission Date

Submission instructions:

Before you submit your assessment, please check the following:
 

• You have entered your Student Number and name on the first page
• You have signed the submission declaration
• You have named your file with your Student Number and Unit Codeg. GWA1995-HI5001
  It is critical you follow this file name instruction to ensure the file belongs to you.
• You have saved your file in MICROSOFT WORD format only. No other format is accepted.
• You have checked you are submitting the correct document as special consideration is not granted if you make a mistake.

Once you have checked the above:

Upload your file to the appropriate link on Blackboard.

You have two attempts to submit your assessment with only the final submission being marked.

** Note: All submissions are automatically passed through SafeAssign to assess academic integrity.