ACT202 - Assignment Details - Student Number 287391 Student Name Instructions: SCROLL DOWN TO VIEW YOUR DATA MS UMMAY HANI KALPONA (WFD) ACT202 ASSIGNMENT DATA - SEMESTER 1 2018 Enter your student...

plz do it as its ur own assignment.... its 40% worth of my assignment .....really need help...read very carefully the question and ans aswell plz


ACT202 - Assignment Details - Student Number 287391 Student Name Instructions: SCROLL DOWN TO VIEW YOUR DATA MS UMMAY HANI KALPONA (WFD) ACT202 ASSIGNMENT DATA - SEMESTER 1 2018 Enter your student number in the cell above (shaded Yellow) When you enter your student number you will generate the relevant data and figures necessary to complete your assignment. These data and figures will be unique to your student number. Do NOT use figures generated for other student numbers. You cannot use this workbook, or link to this workbook to complete your assignment. You will need to print this worksheet and/or transcribe the data and figures manually. HINT!! If you print this worksheet to PDF format, you can "copy & paste" or "export" the details from the PDF document to an excel worksheet.[Select the right-click dropdown menu options, after selecting the text in the PDF document.] 1 of 6 ACT202 - Assignment Details - The anemometers are sold to various engineering companies that produce wind-powered generators in Australia and Europe. · The direct labour used per unit of output. · The average direct labour cost per hour. Details of the Overheads for each month are provided in the data list. The Overheads are estimated using a flexible budget formula. (Activity is measured in direct labour hours). You will have to determine the Maintenance cost and relevant statistical data necessary for you to do so is provided in the data List Monthly selling and administrative overhead expenses are also estimated using a flexible budgeting formula. (Activity is measured in units sold.) Finance charges and bad debts are included in the figures provided and do not need to be identified separately in the selling and administrative overhead expenses. Details are provided in the data list. Heidegger Pty Ltd Case and Data Schedules Heidegger Pty Ltd Case Background Heidegger Pty Ltd produces anemometers used in the production of wind-powered electricity generating equipment. Projected sales in units for the coming four months are provided in the assignment data sheet. The following data pertain to production policies and manufacturing specifications followed by Heidegger Pty Ltd. The following details are provided in the assignment data sheet: · Finished goods inventory on January 1. · The full absorption cost of the opening finished goods inventory. · The variable manufacturing cost of the opening finished goods inventory. · The desired finished goods ending inventory for each month. · The data on materials used. · The amount of materials to be on hand at the beginning of the month · This stipulated amount of materials to be on hand at the beginning of the month is exactly the amount of material on hand on January 1. · (Assume that the material costs per unit are the same throughout the current quarter's production.) Other information provided the assignment data list are: · The unit selling price of the anemometers. · The cost of land to be purchased in February. The company plans to purchase the land for future expansion. · The value and timing of dividends paid to shareholders. · Sales are on credit and the cash receipts pattern for each month is provided, as is the level of Accounts Receivable as at January 1. · Amounts not received in the month following the sale are written off as Bad Debts immediately. · The payment for labour and purchases of materials and other costs are for cash and paid for in the month of acquisition. · There is no Accounts Payable amount for this assignment. · The cash balance on January 1. 2 of 6 ACT202 - Assignment Details - If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage (including any interest payments due). Any cash borrowed is repaid one month later, as is the interest due. The annual interest rate is provided with the assignment data. During the process of preparing the organisation's budget, the sales manager is discussing the possible outcome of the forthcoming election with the production manager. She noted that if one of the major political parties wins the election and forms government, there is a strong possibility that alternative energy sources such as wind-powered electricity may no longer be as actively supported by the new government as is the case under the current government. The sales manager's primary concern is that the current market for alternative power generation equipment is already volatile and subject to significant uncertainty. The production manager is also concerned about his plans to build the new highly automated manufacturing facility on the land to be purchased in February. This new manufacturing facility will enable him to manufacture, in-house, the major two parts he is now purchasing for assembly and to significantly automate the assembly process that is currently somewhat labour intensive. His projections for the new facility indicate a reduction in direct material and direct labour costs of 30% but that his fixed manufacturing overheads are likely to increase by 60% due to the increased investment in production capacity. 3 of 6 ACT202 - Assignment Details - Sales January February March April Units 35,000 28,000 31,500 42,000 Unit selling price $3,630 The desired finished goods ending inventory for each month is 20% of the next month's sales. The full absorption cost of the opening finished goods inventory is $2,450 per unit The variable manufacturing cost of the opening finished goods inventory is $1,000 per unit Finished goods inventory on January 1 is 22,400 units. Materials be on hand at the beginning of the month to produce 60% of that month's estimated sales. Direct Materials used per unit Cups Vanes Cups Vanes Quantity 2 3 160,000 35,500 Cost per unit $42 $56 $8,064,000 $4,502,400 Budgeted Direct Labour time per unit 4 (hrs.) Direct labour cost per hour $20 Actual Materials Used - 3 Months to March Actual Sales Volume 3-months to March Actual Cost of Materials Used - 3 Months to March Actual Labour Used - 3 Months to March Actual Cost of Labour Used - 3 Months to March 276,340 $6,355,800 104,900 4 of 6 ACT202 - Assignment Details - Budgeted Manufacturing Overheads Fixed Cost Component per month Variable Cost Component per DL Hour Labour Hrs Total Maintenance Cost Indirect Labour -$ $29.40 675,500 $41,440,000 Power -$ $2.80 770,000 $45,010,000 Maintenance ??? ??? 707,000 $42,630,000 644,000 $40,250,000 Supervision $19,600,000 $0.00 Depreciation $1,750,000 $0.00 Rates and Utilities $1,446,200 $0.00 Other $7,000,000 $21.00 January February March Variable Selling Expenses $19,057,500 $15,246,000 $17,151,750 Fixed selling & admin expenses $12,600,000 $10,080,000 $11,340,000 Total selling & administrative expenses $31,657,500 $25,326,000 $28,491,750 Recent Statistical Data for Mainentance Costs 5 of 6 ACT202 - Assignment Details - Cash on hand at opening $1,750,000 Annual Interest Rate on Borrowings 8% pa Cash from Sales 0% Received in Month of Sale 20% Received in Month After Sale 78% $109,009,000 Dividends Paid in January $619,500 Land purchased in February $18,200,000 Balance of Accounts Receivable at the start of the period 6 of 6 College of Business and Law Semester 1, 2018 Page 1 of 4 ACT202_ASSIGN01_S12018V3 UNIT CODE: ACT202 UNIT NAME: MANAGEMENT ACCOUNTING Assignment Information Semester 1 2018 Assessment 40% Submission Requirements. This assignment may be submitted at or before 11.59pm (ACST) Monday Study Week 11 Assignments are to be submitted by one of the following means; DO NOT LODGE BY FAX nor EMAIL nor at LECTURER'S OFFICE - KEEP A COPY • The assignment must be lodged on or before the due date indicated in the assignment details. • Submit your Assignment using PDF file format1 . • The assignment must conform to the requirements set out in this assignment • The assignment must be lodged online via the ACT202 Learnline Assignment Lodgement link on the ACT202 Learnline site. Ensure your file is named using a file naming convention that allows the lecturer to identify to whom it belongs. Failure to use an acceptable file naming convention may result in your assignment lodgement being rejected. • DO NOT LODGE VIA EMAILor FAX - assignments lodged by email or fax will not be accepted. • KEEP A COPY - Ensure you have a copy of the assignment lodged. If you have submitted assessment work electronically please make sure you have a backup copy. • Assignment lodgements will be acknowledged automatically on the Learnline site, on submission. In addition the lecturer will acknowledge receipt of the assignment on the CDU ACT202 Learnline site within one business day of receipt. It is the students responsibility to ensure that the lecturer has received (and acknowledged receiving) the assignment. · . Coversheet Coversheets are no longer required. Students will now be required to affirm at the point of submission that the work they are submitting is their original work. This is built into the submission point. The submission text reads as follows: By clicking the SUBMIT button I certify that this assignment is my own work, based on my own personal study and research, and that I have acknowledged all material and sources in the preparation of this assignment, whether they be books, articles reports, lecture notes, images, videos, any other kind of document or personal communication. I also certify that this assignment has not previously been submitted for assessment in any other course or at any other time in the same course (except as a DRAFT submission) and that I have not copied in part or whole or otherwise plagiarised the work of other students and/or persons. I have read Charles Darwin University's Plagiarism policy which is available at: http://www.cdu.edu.au/governance/doclibrary/pol-001.pdf and Student Breach of Academic Integrity Procedures http://www.cdu.edu.au/governance/doclibrary/pro-092.pdf and understand 1 Instructions for creating PDF documents and/or combining documents of different formats are provided on the Learnline site. http://www.cdu.edu.au/governance/doclibrary/pol-001.pdf http://www.cdu.edu.au/governance/doclibrary/pro-092.pdf College of Business