v vucollaborate.vu.edu.au C + D2L Excel Pr... i M O O o O O O O G The recent cost report for the business shows that the ratio of prime costs to manufacturing overhead cost is above 1:3. The new Management Accountant Ms Andi is considering the use of Activity Based Costing to apply overhead and has collected some data (see below) but requires your assistance: Number of Events Activity Cost driver Traceable GY costs $ MX ? ? $50,000 150 50 ? $182,000 00 300 ? ? $250,000 20,000 20,000 ? ? $150,000 7,000 3,000 ? 7 $200,000 3,000 2,000 Note: (where necessary round off answer to 2 decimal places). ALL workings must be shown for each part. SECTION A Requirements, to be completed in EXCEL. A. Given the first paragraph sets the scene surrounding the industry the company fits into and the products it manufactures, you now need to think about what type of activities would be involved in making these products and what drives these activities to occur. Complete the shaded sections of the table above. B. Using the traditional costing system, calculate the company's predetermined overhead rate. :Reflect in ePortfolio Download Print A Alternative formats Activity Details Completed: You have viewed this topicvucollaborate.vu.edu.au + 2L Excel Project Sydney Winter Block - (BA... MInbox (1,123) - amejiaa.92@gmail.com -... MyVU CVP Comfort Lid . docx ABC Delicious Lid manufactures 1.docx VICTORIA UNIVERSITY (BAO2204) Management Accounting - SY D . .... AM Astrid Mejia Arcos MELBOURNE AUSTRALIA Learning Space Communication Assessments " Tools Video Help v Table of Contents > Assessment Information > Project - Additional Resources > Excel Project Sydney Winter Block Excel Project Sydney Winter Block > ED 1 of 6 - + 90% View as Text Download > > E 8 the dropbox of the VUC space. The assignment addresses LO 1, 2 & 3. Assignment Question: Tech Ltd manufactures various types of "smart phones". Two of its latest products on the market are the "Generation Y" otherwise referred to as the GY and the "Matrix X"- otherwise referred to as the MX. In order to remain competitive the business is looking at expanding its products in the next 12 months. The business hopes to not only expand on its smart phone selection but also look at offering home insurance to its customers. The company currently uses a traditional costing system and allocates overhead costs based on an estimated 83,200 direct labour hours. The following cost information has been used as a basis for pricing decisions over the past year. The company has produced a total of 165,000 units, 60% are of the GY and 40% are of the MX. Per-unit data GY MX Direct labour hours 1.20 2.60 Direct labour cost per hour $15 $12 Direct materials $45 $25 Direct machine hours 3.5 1.5 Selling Price $195 $155 Administrative costs $30 $25