Task Assignment - Business Scenario and Instructions

Magic Mufflers - Business Background

Introduction

Magic Mufflers is a proprietorship of Mr Innis Hornet who established this new business on 1st June 2017. Magic Mufflers is a GST-registered muffler and exhaust business that specialises in a small range of high-performance mufflers and exhaust systems. The business sources its products from a number of suppliers and trade expos, and sells to car enthusiasts.

The business currently sells three types of mufflers: Sports SP, Retro RR, and Racer CC.

Innis Hornet, sole proprietor, has established a reputable and growing business with and has employed four staff members. Being an astute businessperson, Innis is using Microsoft EXCEL software to maintain the accounting records of the business transactions during the month of June 2017, which is the last month of the Australian financial year.

Adjustments for end of financial year 2017 -

A physical stocktake of supplies revealed supplies on hand at 30 June totalling $1380.

Calculate and record the adjusting entry for rent for the end of the month given that June rent (2weeks) has been used up.

Calculate the amounts for depreciation expense for each of the three types of non-current Assets: equipment & tools; technology & security; vehicles (Estimate expense as though assets held for whole of month of June.)

Calculate and record the adjusting entry for insurance for the end of the month given that the June portion has been used up. (Estimate by weeks.)

Calculate and record the adjusting entry for wages payable for employee earnings not yet paid as at 30 June. Apportion weekly salary earners by day; B Heat & C McQueen both worked 5 hours each between Mon 26/6 and Fri 30/6.

Calculate the Provision for Doubtful Debts based on 4% of accounts receivable at the end of the year and make the necessary adjusting entry.

Accounting Requirements and Instructions -

Spreadsheet software - The file on the course Blackboard site (ACC106 Task 2 Student Templates) contains a series of worksheets that you should use to complete the requirements below. Make changes as required including formulas and links.

Completing the Accounting Cycle:

Record all the business transactions from section 3 above in the relevant special journals and post the Account totals to the relevant ledgers using EXCEL linking function. Use the accounts listed in the Chart of Accounts and enter names of the ledger accounts as required. In the ledgers, use formulas to create running totals. DO NOT POST ADJUSTMENTS yet.

Prepare an 'Unadjusted' Trial Balance as at 30 June 2017 by linking balances in the ledger accounts to the Trial Balance. It will be a 'Live' Trial Balance but at this point it is unadjusted as the Adjustments have not yet been posted. When completed, check the debit and credit columns are equal in the Trial Balance. Then copy and special paste (as values only) the Trial Balance into the Worksheet columns 'Unadj Trial Balance'. These should not change now as they are raw figures. (Tip: Use Paste Special to paste in as values.)

Record the end of year Adjustments, listed above at section 4, in the Worksheet and complete the Worksheet by calculating balances in the Adjusted Trial Balance columns. Then complete the Income Statement and Balance Sheet columns in the Worksheet.

Record the Adjustments in the General Journal and post these adjustments to the General Ledger using new accounts as necessary. (This will change the figures in your Trial Balance which should now match the Adjusted Trial Balance figures in the Worksheet.)

Prepare the closing entries in the General Journal, and post these to the General Ledger. (As with adjustments, this will change your Trial Balance figures if you have linked correctly. NOW, your Adjusted Trial Balance figures in the Worksheet will NOT match the Trial Balance figures for the Revenue and Expense accounts and totals.) Remember: for closing, close revenue and expense accounts to the P&L Closing Account, then close P&L Closing Account to the Capital account and finally, close drawings to the Capital account.

Finally, prepare the Financial Statements for 30 June 2017 by copying or linking the appropriate figures into your Financial Statements. Refer to your textbook or course Learning Materials for guidance on the format of these Statements. For Balance Sheet, use the Classified Balance Sheet in report form as demonstrated on p.184 of the text; and Income Statement and Statement of Changes in Equity as demonstrated on p.240 of the text. (Note, for the Income Statement, there will be three revenue streams including discount received.)

Attachment:- Assignment Files.rar