Assessment
\nconditions: This is an individual assessment task (not a group assessment task).
\nComplete the 4 questions given below. A total of 50 marks are allocated to the questions below, which will then be converted to a mark out of 20%.
\nAll workings, where appropriate, must be shown to substantiate your answers.<\/p>\n
Question 1 [15 marks]
\nRetail operations and retail inventory
\n\u2018Little Red Riding\u2019 began business on 1 June 2019. The business is a partnership, between Mr Wheeler and Mrs Wheeler. The business will sell children\u2019s bicycles at the local markets. The business is not registered for GST. The following transactions occurred during June 2019:
\nDate:\tDetails:
\n1-Jun\tMr and Mrs Wheeler deposited $30,000 into the business bank account.
\n2-Jun\tPurchase of bicycles (100 small bicycles, and 100 large bicycles) from Red Bikes Rock Ltd on account for $10,000 ($50 per bicycle) on terms of 2\/10, n\/30.
\n4-Jun\tLittle Red Riding received an invoice from Fast Freight Ltd relating to delivery costs for the bicycles purchased on 2 June. The amount due is $300, and is due on 18 June.
\n5-Jun\tSent a cheque in the mail to Groove Markets Ltd for $300, for stall fees at the local markets for the month of June.
\n6-Jun\tSale of 30 bicycles (20 small bicycles, and 10 large bicycles) at the local markets, at $100 each. All of the customers paid by cash. The money was banked at the end of the day.
\n10-Jun\tPaid Red Bikes Rock Ltd for purchases made on 2 June (net of the early payment discount), by electronic funds transfer.
\n13-Jun\tSale of 10 small bicycles to a local childcare centre, at $100 each, on 30 day credit terms.
\n15-Jun\tSent a cheque in the mail to Fast Freight Ltd, in relation to the invoice received on 4 June.
\n22-Jun\tPurchase of bicycles (30 small, and 10 large) from Red Bikes Rock Ltd on account for $2,200 ($55 per bicycle) on terms of 2\/10, n\/30.
\n23-Jun\tLittle Red Riding received an invoice from Fast Freight Ltd relating to delivery costs for the bicycles purchased on 22 June 2019. The amount due is $180, and is due on 6 July 2019.
\n24-Jun\tReturned 20 of the small bicycles purchased on 22 June as they were damaged.
\n28-Jun\tSale of 40 bicycles (25 small, and 15 large) at the local markets, at $100 each. All of the customers paid by cash. The money was banked at the end of the day.
\n30-Jun\tA stocktake was completed, and the number of bicycles on hand was 139 (54 small bicycles, and 85 large bicycles).<\/p>\n
Mr and Mrs Wheeler have come to you for assistance, as they would like to use the perpetual inventory system and the First-in-first-out (FIFO) costing method, but are not sure how to set this up.
\nRequired:
\ni) Prepare an Excel worksheet for each of the bicycle lines for June (one for the small bicycles, and one for the large bicycles) using the FIFO costing method to keep track of the number of bicycles purchased, bicycles sold, bicycles on hand, cost of goods sold and gross profit made.
\nii) Prepare journal entries (including any adjusting entries) for all of the business\u2019s transactions for June (using the perpetual inventory system and FIFO costing method). Include dates, references and narrations.
\niii) Prepare T-accounts in an Excel spreadsheet, and post all of the above journal entries to the T-accounts. Include dates and references for each entry. Total all of the T-accounts to determine their balances at the end of the June 2019.
\niv) Prepare the \u2018Adjusted Trial Balance\u2019 in an Excel spreadsheet as at 30th June 2019. Use formulas to generate all of the figures in the \u2018Adjusted Trial Balance\u2019 from the balances in the T-Accounts.
\nv) The business has a year-end of 30th June. Prepare the closing entries as at 30th June 2019.
\nPlease also refer to the ‘Requirements’ section below for additional submission and spreadsheet requirements.<\/p>\n
Question 2 [10 marks]<\/p>\n
Bank reconciliations and cash<\/p>\n
This question continues on from question 1 above.
\nIt is now September 2019, and two months have passed since you first met with Mr and Mrs Wheeler to assist them with implementing their inventory system and preparing their accounting records.<\/p>\n
They have come to you for some assistance as the balance in the \u2018bank\u2019 T-Account at the end of August 2019 doesn\u2019t agree with the closing balance on the August bank statement… and they are not sure what they have done wrong.<\/p>\n
The August 2019 bank statement appeared as follows:<\/p>\n
Bank statement for August 2019:<\/p>\n
Date\tDescription\tDeposit\tWithdrawal\tBalance<\/p>\n
1\/08\/2019\tOpening balance\t\t\t$12,060.00
\n2\/08\/2019\tDeposit\t500.00\t\t$12,560.00
\n5\/08\/2019\tCheque 3\t\t200.00\t$12,360.00
\n7\/08\/2019\tCash deposit\t3,600.00\t\t$15,960.00
\n12\/08\/2019\tEFT – Red Bikes Rock Ltd\t\t2,200.00\t$13,760.00
\n16\/08\/2019\tEFT – Fast Freight Ltd\t\t190.00\t$13,570.00
\n16\/08\/2019\tCash deposit\t4,200.00\t\t$17,770.00
\n19\/08\/2019\tCheque 5\t\t280.00\t$17,490.00
\n20\/08\/2019\tCheque 6\t\t250.00\t$17,240.00
\n23\/08\/2019\tEFT – Red Bikes Rock Ltd\t\t4,300.00\t$12,940.00
\n23\/08\/2019\tCash deposit\t3,400.00\t\t$16,340.00
\n25\/08\/2019\tCheque 7\t\t2,000.00\t$14,340.00
\n26\/08\/2019\tCheque 10\t\t260.00\t$14,080.00
\n30\/08\/2019\tCash deposit\t5,000.00\t\t$19,080.00
\n31\/08\/2019\tAnnual bank fee\t\t60.00\t$19,020.00
\n31\/08\/2019\tInterest\t20.00\t\t$19,040.00
\n31\/08\/2019\tClosing balance\t\t\t$19,040.00<\/p>\n
Little Red Riding\u2019s accounting records for August 2019 showed an opening balance for the \u2018bank\u2019 account of $12,060, which agreed with the bank statement at 31 July 2019. Following is a summary of deposits and withdrawals recorded by Mr and Mrs Wheeler in their accounting records during August:<\/p>\n
Withdrawals:\t\tDeposits:
\nAmount
\nDate\tDetail\tAmount\t\tDate\tbanked
\n2\/08\/2019\tCheque 3\t$200.00
\n15\/08\/2019\tEFT – Fast Freight Ltd\t$199.00\t\t7\/08\/2019\t$3,600.00
\n16\/08\/2019\tCheque 4\t$160.00\t\t16\/08\/2019\t$4,200.00
\n18\/08\/2019\tCheque 5\t$280.00\t\t23\/08\/2019\t$4,300.00
\n18\/08\/2019\tCheque 6\t$250.00\t\t30\/08\/2019\t$500.00
\n23\/08\/2019\tEFT – Red Bikes Rock Ltd\t$3,400.00
\n22\/08\/2019\tCheque 7\t$2,000.00
\n23\/08\/2019\tCheque 8\t$260.00
\n25\/08\/2019\tCheque 9\t$390.00
\n25\/08\/2019\tCheque 10\t $260.00\t\t\t__________
\n$7,399.00\t\t\t$12,600.00<\/p>\n
The bank did not make any errors.<\/p>\n
Required:<\/p>\n
i) Prepare a letter to Mr & Mrs Wheeler, explaining why the bank balance in the ledger account (or T-Account) won\u2019t always equal the balance on the bank statement on a particular date, and common reasons for differences. Also provide an introduction and overview of bank reconciliations \u2013 What is a bank reconciliation? What is its purpose? How is it prepared?<\/p>\n
ii) Prepare the bank reconciliation for Little Red Riding at 31 August 2019.<\/p>\n
iii) Prepare the journal entries to correct any errors made by Little Red Riding, and to record transactions that have not yet been entered into the business\u2019s accounting records. (Note: The correction of any errors relating to the recording of cheques or EFT payments should be made to \u2018Accounts payable\u2019. The correction of any errors relating to deposits (other than interest received) should be made to \u2018Accounts receivable\u2019.)<\/p>\n
iv) Prepare the \u2018bank\u2019 T-Account account for August 2019, in order to determine the balance in the ledger account after the above journal entries have been recorded and posted.<\/p>\n
Question 3 [15 marks]
\nInternal controls
\nThis question continues on from question 1 and question 2 above.
\nIt is now July 2020, and Mr and Mrs Wheeler have been very successful in growing the business of Little Red Riding. The business now operates at 3 markets in the region, and employs 4 employees (Mr and Mrs Wheeler sell bicycles at one local market each week, and 2 employees are assigned to sell bicycles at the Bidgee Markets, and 2 employees are assigned to sell bicycles at the Junee markets).
\nMr and Mrs Wheeler have come to you for advice, as they appear to be having problems with their inventory and\/or cash receipts. They have been keeping track of inventory using the two worksheets that you showed them (in Question 1(i) above). They really like how it keeps track of inventory on hand, and they tell you how much they love not having to count inventory each and every week after the markets to see what inventory is left.
\nWhen they completed the stocktake on 30 June 2020, the closing balance of inventory in each worksheet didn\u2019t match with the actual number of small and large bicycles on hand. The worksheets showed that the closing inventory was 58 small bicycles, and 46 large bicycles. The stocktake showed that the business actually had 42 small bicycles and 30 large bicycles.
\nYou review their inventory worksheets, and there are no errors in their worksheets… so it appears that cash takings and\/or some bicycle have been stolen. You also review the three cash receipt books (one used at each of the three markets), and the amount of cash takings banked for the year was $300 less than the takings as per the cash receipt books.
\nMr and Mrs Wheeler are unsure what has happened.
\nRequired:
\nUndertake some research on internal controls and employee theft.<\/p>\n
Prepare a business report on internal controls for Mr and Mrs Wheeler. In your business report:
\n\u2022\tExplain what internal controls are, and the importance of implementing internal controls to safeguard the business\u2019s assets;
\n\u2022\tDiscuss the risk of employee theft, and how big of a problem employee theft is in Australia;
\n\u2022\tExplain three possible ways that employees could have stolen cash and\/or bicycles from the business without Mr and Mrs Wheeler realising;
\n\u2022\tDiscuss three controls\/procedures that Mr and Mrs Wheeler should implement in their business to help prevent employee theft.
\n(Word guide: 1,500 \u2013 2,000 words)<\/p>\n
Question 4 [10 marks]
\nProperty, plant and equipment
\nThis question continues on from question 1, 2 and question 3 above.
\nLittle Red Riding purchased a 3 tonne Isuzu truck on 1st July 2020, for $45,000, funded via a bank loan. The truck will be used to store and transport bicycles to and from each of the weekly markets. Mr and Mrs Wheeler have contacted you to find out how they need to account for depreciation. They would like to use the cost model, but don\u2019t have any understanding of the straight-line method, units-of-production method and reducing balance method. The truck has an estimated useful life of ten years (300,000 kilometres), and the estimated residual value is $10,000.<\/p>\n
Mr and Mrs Wheeler estimate that the truck will travel 20,000km\/year in years 1 \u2013 3, 30,000km\/year in years 4 \u2013 7, and 40,000km\/year in years 8 \u2013 10.
\nRequired:
\nPrepare a memo to Mr & Mrs Wheeler, explaining what depreciation is, and how depreciation is calculated under each of the three methods. To illustrate the differences in the annual depreciation expense to Mr & Mrs Wheeler, prepare a depreciation schedule (for the entire useful life of the truck) using each of the three methods. When preparing the depreciation schedule using the reducing balance method, use 2 times the straight-line rate. Ignore any GST. Show all relevant workings.<\/p>\n
Online submission via Turnitin is required for this assignment. Details will be provided by your subject lecturer.
\nRationale
\nback to top
\nThis assessment task will assess the following learning outcome\/s:
\n\u2022\tbe able to apply conceptual and technical aspects of accounting and prepare relevant business financial statements.
\n\u2022\tbe able to appraise the use of information technology including spreadsheet software in accounting problem solving, and evaluate the Internet as a professional resource.
\n\u2022\tbe able to demonstrate relevant business communication skills including report writing.
\n\u2022\tbe able to contextualise and evaluate accounting information for decision making purposes.
\nAssessment task 2 is designed to give you further opportunity to demonstrate knowledge and skills in more in-depth aspects of accounting and information systems including bank reconciliations, inventory systems, financial reports, accounting for non-current assets, as well as concepts and the application of spreadsheet software to the presentation and solution of accounting problems.<\/p>\n","protected":false},"excerpt":{"rendered":"
Assessment conditions: This is an individual assessment task (not a group assessment task). Complete the 4 questions given below. A total of 50 marks are\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12179,12176,12187,12181,12180,12177,12184,12188,12183,12182,12190,12186,12189,12178,12185],"tags":[12014,10925,12010,10920,11092,10879,12013,12015,10926,10922,10924,1402,12012,12011],"class_list":["post-137743","post","type-post","status-publish","format-standard","hentry","category-best-ideas-for-dissertation-topics","category-best-ideas-for-research-paper-topics-in","category-best-research-paper-topics-for-examples","category-custom-thesis-writing-service-help","category-dissertation-topics-for-ph-d-and-thesis-ideas","category-dissertation-topics-for-students-in","category-nursing-thesis-writing-service-assistance","category-research-titles-examples","category-research-topics-for-college-students","category-sample-thesis-titles","category-thesis-and-dissertation-ideas-for-research-topics-in-uk","category-thesis-topics-for-your-final-academic-project","category-thesis-topics-for-your-masters-degree","category-trending-dissertation-topics-ideas-for","category-undergraduate-dissertations-topics-examples-ideas","tag-cheap-essay-service-online","tag-dissertation-ideas","tag-essay-service-website","tag-essay-topics","tag-i-need-help-writing","tag-page-paper","tag-pay-for-essay-get-top-quality","tag-professional-to-write-my-essay","tag-research-paper-samples","tag-thesis-examples","tag-write","tag-write-a-paper","tag-write-my-essay-for-me-by-native-writer","tag-write-my-essay-no-plagiarism"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/137743","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=137743"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/137743\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=137743"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=137743"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=137743"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}