Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »

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 cu
ent 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 Fe
uary. 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 bo
owed to cover the shortage (including any interest payments due).
Any cash bo
owed 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 cu
ent government.
The sales manager's primary concern is that the cu
ent 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 Fe
uary.
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 cu
ently 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 Fe
uary 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 XXXXXXXXXX,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 -$ $ XXXXXXXXXX,500 $41,440,000
Power -$ $ XXXXXXXXXX,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 Fe
uary 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 Bo
owings 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 Fe
uary $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
elongs. Failure to use an acceptable file naming convention may result in your assignment lodgement being
ejected.
• 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
eceipt. 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
eports, 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/docli
ary/pol-001.pdf and
Student Breach of Academic Integrity Procedures http:
www.cdu.edu.au/governance/docli
ary/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/docli
ary/pol-001.pdf
http:
www.cdu.edu.au/governance/docli
ary/pro-092.pdf

College of Business
Answered Same Day May 14, 2020 ACT202 Charles Darwin University

Solution

Aarti J answered on May 15 2020
143 Votes
Heidegger Pty Ltd
    Sales Budget
    For the 3 months ended March
    
    
    
    
    Jan
    Fe
    Ma
    Yea
    Percent of Annual Sales
    20%
    78%
    0%
    98%
    Expected sales in units
     35,000
     28,000
     31,500
     94,500
    Selling price per unit
     $ 3,630.00
     $ 3,630.00
     $ 3,630.00
     $ 3,630.00
    Total Budgeted Sales
     $ 1270,50,000
     $ 1016,40,000
     $ 1143,45,000
     $ 3430,35,000
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    Heidegger Pty Ltd
    Schedule of Expected Cash Collections
    For the 3 months ended March
    
    
    
    
    
    
    Jan
    Fe
    Ma
    Yea
    Cu
ent month sales 20%
     $ 254,10,000
     $ 203,28,000
     $ 228,69,000
     686,07,000
    Prior month's sales 78%
     792,79,200
     990,99,000
     792,79,200
     3468,46,500
    Two months prior sales 0%
     -
     -
     -
     -
    Total cash collections
     $ 1046,89,200
     $ 1194,27,000
     $ 1021,48,200
     $ 4154,53,500
    
    
    
    
    
    
    
    
    
    Nov
    
    
    
    
    Dec
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    Heidegger Pty Ltd
    Schedule of Expected Cash Collections
    For the 3 months ended March
    
    
    
    
    
    
    Jan
    Fe
    Ma
    Yea
    AR from Novembe
     -
    
    
     -
    AR from Decembe
     792,79,200
     -
    
     792,79,200
    Jan
     254,10,000
     990,99,000
     -
     1245,09,000
    Fe
    
     203,28,000
     792,79,200
     996,07,200
    Ma
    
    
     228,69,000
     1120,58,100
    Ap
    
    
    
     -
    May
    
    
    
     -
    June
    
    
    
     -
    July
    
    
    
     -
    August
    
    
    
     -
    Sept
    
    
    
     -
    Oct
    
    
    
     -
    Nov
    
    
    
     -
    Dec
     -
     -
     -
     -
    
     1046,89,200
     1194,27,000
     1021,48,200
     4154,53,500
    Heidegger Pty Ltd
    Production Budget
    For the 3 months ended March
    
    
    
    
    
    
    Jan
    Fe
    Ma
    Yea
    Budgeted sales in units
     35,000
     28,000
     31,500
     94,500
    Add desired ending inventory of finished goods
     5,600
     6,300
     8,400
     8,400
     Total needs
     40,600
     34,300
     39,900
     1,02,900
    Less beginning inventory of finished goods
     22,400
     5,600
     6,300
     22,400
    Required production
     18,200
     28,700
     33,600
     80,500
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    Heidegger Pty Ltd
    Manufacturing Overhead Budget
    For the 3 months ended March
    
    
    
    
    
    
    Jan
    Fe
    Ma
    Yea
    Production in Units
     18,200
     28,700
     33,600
     79,100
    Variable overhead rate per unit
    ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here