Microsoft Word - T2 2020 MAA103 Assessment 2 instructions.docx MAA103 – Accounting for Decision Making - Trimester 2 2020 Assessment Task 2 – BDAs and Financial Statements – Individual RELEASE DATE...

1 answer below »
Microsoft Word - T2 2020 MAA103 Assessment 2 instructions.docx

MAA103 – Accounting for Decision Making - Trimester 2 2020
Assessment Task 2 – BDAs and Financial Statements –
Individual

RELEASE DATE AND TIME: Week 7, Monday 31st August 2020, 5:00pm (AEST)
DUE DATE AND TIME: Week 8, Monday 7th September 2020, 8:00pm (AEST)
PERCENTAGE OF FINAL GRADE: 10%

Description and requirements
In this assignment, you have been given an ‘Unadjusted Trial Balance’ along with information
egarding some outstanding balance day adjustments for a particular business. First, you need to
ecord these adjusting entries in the ‘Journal’ and then post the entries into the various ‘Ledger’
accounts. Once completed, you will then need to manually transfer balances from the ‘Ledger’ into
the ‘Adjusted Trial Balance’ to complete the ‘Income Statement’ and ‘Balance Sheet’. IMPORTANT:
only the ‘Journal’, ‘Adjusted Trial Balance’, ‘Income Statement’ and ‘Balance Sheet’ are marked.
However, students are encouraged to use the ‘Ledger’ to prepare adjusted closing balances to
transfer to the ‘Adjusted Trial Balance’.
For this assignment, all the tasks and information will be sent to you via your Deakin Student
email. The email will be sent out by Monday 31st August 2020, 5:00pm (AEST). To access your
student emails, simply go to www.deakin.edu.au/email and log in with your Deakin username and
password. In the email, you will find TWO files, an Excel template (“MAA103 A2 {STUDENT_ID}.xlsx”)
and this instructions file. Once you start working on the file you may save and go back to it as many
times as you like; there is no need to complete it all in one go. Please make sure you use Microsoft
Office Excel1 to complete the assignment as not doing so may results in technical e
ors, delays in
your results, or loss of marks.
Important:
• Please make sure we have entered your student ID co
ectly for the Excel file.
• When calculating any figures please round values to the closest dollar. For example, $12.49 would
ound to $12 and $12.50 would round to $13.
• When filling out the General Journal, please use the drop-down a
ow to select the appropriate
account name. You will not be able to use any other account name not listed.
• Please enter in dates as dd/mm/yyyy. Note that your computer settings may have it displayed
differently – it is okay as long as no e
or message comes up.
• You are not required to manually enter in any “$” symbols.
• Do NOT use any copy/cut and paste as it will throw off the automatic marking. You do not need
to paste additional rows in the Excel file. There is enough space to record all transactions.
• If you see #REF! it means you have used cut and paste somewhere. Unless you can rectify
the issue, you should download a fresh copy and start again.

1 Microsoft Office is available through the Deakin software li
ary at http:
software.deakin.edu.au/category/office-
tools/. The link includes software and installation instructions for both Mac and Windows computers. Deakin students
and staff have free access to Microsoft Office via Office 365 login (using your Deakin username and password).
Sheet 1: Description
• This worksheet contains all relevant information including balance day adjustment items and
the unadjusted trial balance.
• IMPORTANT: Your Student ID and Student Username should already be included here,
please just check the information is co
ect before proceeding.
• If you find an e
or in your Student ID, please email the teaching team.

Sheet 2: Journal (marked)
• In this worksheet, you will need to record the entries co
esponding to the adjusting items
that you have been given under the ‘Description’ tab.
• Each entry must include a date, account names, and amounts in either the Dr or Cr column.
• Na
ations are not required and there is also no need to indent your accounts. Note that the
account names must be selected from the drop-down menu.
• You may leave a line in-between each transaction but you don’t have to (see below).
Sheet 3: Ledger (not marked)
• In this worksheet, you will need to post all the relevant adjusting journal entries.
• Unadjusted trial balances have already been pre-populated.
• Note that the closing balance is calculated for you automatically (see below).
• IMPORTANT: ‘Ledger’ is not marked. However, students are encouraged to use the ‘Ledger’
to prepare adjusted closing balances to transfer to the ‘Adjusted Trial Balance’.
Sheet 4: Adjusted Trial Balance (marked)
• This sheet is empty and is not updated automatically based on your closing balances from
the ‘Ledger’ worksheet. You must transfer adjusted closing balances from the ‘Ledger’ to
the ‘Adjusted Trial Balance’ manually.

Sheet: Income Statement (marked)
• On this sheet you will need to fill out the Income Statement according to the ‘Adjusted Trial
Balance’ that you have manually prepared.
• You do not need to classify expenses into selling, general and administrative expenses. You
can list all expenses under the Selling, General & Administrative Expenses heading.
• You will need to enter in negative values (use a “-“ minus symbol) for any expenses so that
the profit/loss will be calculated co
ectly.
• All shaded cells will automatically sum the appropriate values for you.



















Sheet: Balance Sheet (marked)
• On this sheet you will need to fill out the Classified Balance Sheet according to the ‘Adjusted
Trial Balance’ Sheet you manually prepared.
• All shaded in cells will automatically sum the appropriate values for you.
• You will need to enter in negative values (use a “-“ minus symbol) for any “negative” accounts.


Learning Outcomes
This task allows you to demonstrate achievement towards the unit learning outcomes. The ULOs are
aligned with specific graduate learning outcomes – that is, the skills and knowledge graduates are
expected to have upon completion of their studies – and this assessment task is an important tool in
determining achievement of those outcomes. If you do not demonstrate achievement of the unit
learning outcomes, you will not be successful in this unit.
Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO)
ULO 1: Describe the accounting processes and how
accounting information can be effectively used for making
informed business decisions.
GLO1: Discipline-specific knowledge
and capabilities.
GLO3: Digital literacy
GLO4: Critical thinking ULO 2: Explain how business transactions are analysed
using the ‘accounting equation’ and how the resulting
figures can assist in preparing accounting reports.
ULO 3: Use visual and other technology such as
spreadsheets to communicate researched information.
Submission
This assessment is to be submitted ONLINE into the “T2 2020 MAA103 Assignment 2 Dropbox”
available on the MAA103 Cloud Deakin site as follows:
This will load up a new screen where you can “Add a File”. Once you have added the file, please
don’t forget to press “Submit”


The Assessment Dropbox via CloudDeakin has been set up so that a new submission will replace the
old one completely. Please note that you will be required to submit only ONE Microsoft Excel
workbook in .XLSX format2. Please do not submit in any other file format otherwise a penalty
in marks will be imposed. Please do not rename the file after you download it.

You must keep a backup copy of every assignment you submit, until the marked assignment has
een returned to you. In the unlikely event that one of your assignments is misplaced, you will need
to submit your backup copy. Any work you submit may be checked by electronic or other means for
the purposes of detecting collusion and/or plagiarism. When you submit an assignment through your
CloudDeakin unit site, you will receive an email to your Deakin email address confirming that it has
een submitted. You should check that you can see your assignment in the Submissions view of the
Assignment Dropbox folder after upload, and check for, and keep, the email receipt for the
submission.
A word for Mac users. When opening the Assignment 2 file using Excel on a Mac, this message is
likely to pop up. Please select “Yes” to allow Excel repair itself. Once repaired, click “Delete”.
Marking and feedback
Students who submit their work by the due date will receive their marks and feedback on
CloudDeakin 15 working days after the submission date.
Extensions
Extensions will only be granted for exceptional and/or unavoidable circumstances outside the
student’s control. Students seeking an extension for an assignment prior to the due date should
apply directly to the Unit Chair by completing the Assignment and Online Test Extension Application
Form. Requests for extensions will not be considered after Monday 7th September 2020, 8pm (AEST).
Applications for special consideration after the due date must be submitted via StudentConnect.




2 You must use Excel if you are using a Mac. Assignment 2 completed using “Numbers” will not be accepted.
Late submission
The following marking penalties will apply if you submit an assessment task after the due date without
an approved extension: 5% will be deducted from available marks for each day up to five days, and
work that is submitted more than five days after the due date will not be marked and will receive 0%
for the task. 'Day' means working day for paper submissions and calendar day for electronic
submissions. The Unit Chair may refuse to accept a late submission where it is unreasonable or
impracticable to assess the task after the due date.
Calculation of the late penalty is as follows:
• 1 day late: submitted after Monday 11:59pm and before Tuesday 11:59pm– 5% penalty.
• 2 days late: submitted after Tuesday 11:59pm and before Wednesday 11:59pm – 10% penalty.
• 3 days late: submitted after Wednesday 11:59pm and before Thursday 11:59pm – 15% penalty.
• 4 days late: submitted after Thursday 11:59pm and before Friday 11:59pm – 20% penalty.
• 5 days late: submitted after Friday 11:59pm and before Saturday 11:59pm – 25% penalty.
• Dropbox closes on Saturday September 12th after 11:59pm (AEST).

Support
The Division of Student Life (see link
Answered Same DayAug 31, 2021MAA103Deakin University

Solution

Khushboo answered on Sep 02 2021
63 Votes
Description
    MAA103 Assessment 2: Balance Day Adjustments & Financial Statements
        Student ID    217056243
        Student Username    tzaytou     @deakin.edu.au
            Business Name: Ms Robyn Hoodling Trading As 'Loxley Farms'
            'Loxley Farms' is owned and operated by Ms Robyn Hoodling. Robyn opened the business some time ago and has had some training in basic bookkeeping. Robyn has been keeping a pretty good record of her business so far and has even managed to do some of the needed balance day adjustments already. There are a few balance day adjustment items remaining that she was unsure on and so she has enlisted your help and has provided you with her unadjusted trial balance for the month of August 2020. Your task is to record the adjusting entries in the 'Journal', post these entries to the 'Ledger', manually prepare the 'Adjusted Trial Balance' and finally help fill out the 'Income Statement' and 'Balance Sheet' based on the 'Adjusted Trial Balance' for the month of August 2020. You can assume all other balance day adjustments not listed have already been accounted for.
            Relevant information:
            1. Adjusting Items:
            Date    Description
            8/31/20    The business has 5 sales staff. Each sales staff member is paid a GROSS wage of $792 per week [PAYG withheld of $128]. At the end of the month, the business owed 2 weeks of wages to the sales team and that is yet to be recorded.
            8/31/20    Received $26928 (including GST) from a customer at the start of August 2020 for provision of services and the amount was initially recorded as unearned revenue and GST Collected. The business delivered these services by the end of August 2020.
            8/31/20    A bank loan for the amount of $93600 was taken out on August 1, 2020. The bank charges interest of 6% per annum and interest payments are due quarterly. The interest on the $93600 loan is yet to be recorded. The bank loan is due in August 2025.
            8/31/20    On August 1, 2020 the business paid $4950 (including GST) for 5 months of office rent. This was recorded at the time as Prepaid Rent and GST Paid.
            8/31/20    The motor vehicle is depreciated using the straight line method. It has a useful life of 9 years and a zero residual value.
            8/31/20    The business hires 7 general office assistants. Each assistant is paid a NET wage of $792 per week [PAYG withheld of $120]. At the end of the month, the business owed its office assistants 1 week of wages and that is yet to be recorded.
            8/31/20    The office furniture is depreciated using the straight line method. It depreciates at 10% per annum and is assumed to have a zero residual value.
            8/31/20    On August 1, 2020 the business paid $9009 (including GST) for 7 months of business insurance. This was recorded at the time as Prepaid Insurance and GST Paid.
            8/31/20    On August 15, 2020 the business purchased 18 packs of sticky notes worth $594 (including GST) which were recorded as Office Supplies and GST Paid. Robyn counted these packs of sticky notes at the end of August 2020 and found that 13 packs have been consumed but their consumption has not been recorded.
            Unadjusted Trial Balance
            "For the Month Ending 31/8/2020"
            Acc. No.    Account     Dr    C
            101    Cash    291,648    
            102    Accounts receivable    22,354    
            103    Inventory    68,498    
            104    Office Supplies    8,586    
            111    GST Paid    10,739    
            141    Prepaid Insurance    8,190    
            142    Prepaid Rent    4,500    
            143    Interest Receivable    8,749    
            155    Office Furniture    75,240    
            156    Accum. Depreciation - Office Furniture         7,524
            158    Motor Vehicle    82,080    
            159    Accum. Depreciation - Motor Vehicle         36,480
            201    Accounts Payable         8,220
            222    GST Collected         28,984
            240    Interest Due         0
            241    Unearned Revenue         38,250
            242    Wages Payable         2,560
            243    Utilities Payable         2,437
            244    Consulting Fees Payable         3,000
            251    Bank Loan         93,600
            261    PAYG Withheld    0    9,116
            301    Capital         201,182
            302    Drawings    11,950    
            401    Sales Revenue         226,430
            402    Service Revenue    0    63,408
            403    Interest Revenue         730
            501    Cost of Good Sold    67,929    
            601    Computer Expense    2,462    
            602    Office Supplies Expense    0    
            603    Interest Expense    0    
            604    Consulting Expense    6,000    
            605    Insurance Expense    0    0
            606    Rent Expense    0    
            607    Sales Commission Expense    15,850    
            608    Utilities Expense    7,310    
            609    Wage Expense    25,586    
            610    Advertising Expense    4,250    0
            651    Depreciation Expense - Motor Vehicle    0    0
            655    Depreciation Expense - Office Furniture    0    
                TOTAL    721,921    721,921
Journal
    GENERAL JOURNAL
        Instructions:
         -Fill out the journal entries below based on the 'Description' tab.
         -You must write the Date, Account Name, and fill out the co
esponding values in the Debit (Dr) or Credit (Cr) column.
         -There is no need to indent your accounts and also na
ations are NOT required
         -Please ensure that your date format is in dd/mm/yyyy format and that your dates fall between 1 Aug 2020 - 31 Aug 2020.
         -Note: The account name used in the journal must come from the drop down menu.
         -Failure to follow the instructions precisely may result in a loss of marks.
        The General Journal                        Chart of accounts
        Date    Accounts    Dr    Cr            Account
No    Account Name
        31/08/2020    Wage Expense    7,920                101    Cash
            Wages Payable        6,640            102    Accounts Receivable
            PAYG Withheld        1,280            103    Inventory
                                104    Office Supplies
        31/08/2020    Unearned Revenue    24,480                111    GST Paid
            Service Revenue        24,480            141    Prepaid Insurance
                                142    Prepaid Rent
        31/08/2020    Interest Expense    468                143    Interest Receivable
            Interest Due        468            151    Computer equipment
                                152    Accum. Depreciation - Computer Equipment
        31/08/2020    Rent Expense    900                155    Office Furniture
            Prepaid Rent        900            156    Accum. Depreciation - Office Furniture
                                158    Motor Vehicle
        31/08/2020    Depreciation Expense - Motor Vehicle    9,120                159    Accum. Depreciation - Motor Vehicle
            Accum. Depreciation - Motor Vehicle        9,120            201    Accounts Payable
                                222    GST Collected
        31/08/2020    Wage Expense    6,384                240    Interest Due
            Wages Payable        5,544            241    Unearned Revenue
            PAYG Withheld        840            242    Wages Payable
                                243    Utilities Payable
        31/08/2020    Depreciation Expense - Office Furniture    7,524                244    Consulting Fees Payable
            Accum. Depreciation - Office Furniture        7,524            251    Bank Loan
                                261    PAYG Withheld
        31/08/2020    Insurance Expense    1,170                301    Capital
            Prepaid Insurance        1,170            302    Drawings
                                401    Sales Revenue
        31/08/2020    Office Supplies Expense    390                402    Service Revenue
            Office Supplies        390            403    Interest Revenue
                                501    Cost of Good Sold
                                601    Computer Expense
                                602    Office Supplies Expense
                                603    Interest Expense
                                604    Consulting Expense
                                605    Insurance Expense
                                606    Rent Expense
                                607    Sales Commission Expense
                                608    Utilities...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here