It is a group assignment just need the answer for Q.1 , i will ask other members if they want to do by themselves or not .i want to give a try how you guys go with it ?i am student with GPA 6.5 /7 please get me that standard of answer otherwise i will be in trouble by dean.
Assessment Information Subject Code: ACC 205 Subject Name: Management Accounting 1 Assessment Title: Excel group work Weighting: 25% of overall subject mark Total Marks: 75 Marks Due Date: Monday 14 May 2018 15.55 AEST (Students in Adelaide please note to adjust for the time difference) Assessment Description Learning Outcome 2: Apply basic costs and costing techniques to practical scenarios. Learning Outcome 4: Create a budget and a cost volume profit analysis given practical scenarios. Work in teams (groups) of 3 members (you must obtain your lecturer’s approval for a group of a different number). You may discuss the selection of teams with your lecturer, who may decide to allocate you into teams or he/she may decide to form teams using a random process. You must notify your lecturer of your teams by the Friday of week 6 and be prepared to be allocated into teams if the lecturer so decides. Any work which has been copied or shared between groups or teams will result in a “Fail” grade for all students concerned. So please make sure that the answer to this team assignment is your own work and not copied from any source. Submission: The assignment will need to be submitted electronically through the student portal – use the link under “Assessments” to submit the information. Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel. Note that marks are also allocated for professional presentation and the use of formulas within Excel. Please check the marking sheet (included below) for each part to ensure that you have followed all the guidelines for presenting your work. Please make sure you follow the guidelines noted in your subject outline especially those relating to presentation, late policy and academic integrity. . COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B. Assessment Information Assignment Details: QUESTION 1 (14 marks) Big Ginger Ltd produces crystallised and chocolate coated ginger pieces at its Gothenburg factory. The ginger is purchased by the factory as clean, pealed, and raw ginger. Big Ginger Ltd chops the ginger into uniform pieces which are then transferred to other departments for further processing to crystallised ginger or chocolate coated ginger treats. In the Chopping Department, the process-costing system at Big Ginger Ltd has two cost categories – Direct materials and conversion costs. Direct materials, being the pealed ginger and secret other ingredients, are added at the beginning of the process. Conversion costs are added evenly during the process. When the Chopping Department finishes with the ginger, it is immediately transferred to either Crystallisation or Chocolate Coating Departments, and then packaged for sale. Big Ginger Ltd uses the weighted-average method of process costing. Data for the Chopping Department for January 2018 are: Physical Units[kg] Direct Materials Conversion costs Work in process, 1 January 20,000 $70,000 $3,600 Started during January 200,000 Completed during January 210,000 Total costs added during January $1,470,000 $40,000 Opening work in process is 70% complete with regards to conversion costs and closing work in process is 80% complete with regards to conversion costs. REQUIRED: Produce a production cost report in order to calculate the cost of chopped ginger transferred out and the value of closing work in process in the Chopping department. Round any workings to 4 decimal places and the final answers to the nearest dollar. COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B. Assessment Information QUESTION 2 (15 marks) Milka Chocolate Limited is located in Mount Vinson and produces quality chocolate for plain wrapped blocks, specialty boxed chocolates and chocolate figurines from its state of the art production facility. The initial joint cost of production is $1,300,000 for the year. This cost results in an output of 2,600,000 kilograms of chocolate blocks. Details relating to the 3 joint products are given below: Chocolate Wrapped Boxed Figurines Quantity at split-off point 1,000,000 kg 1,000,000 kg 600,000 kg Selling price at split-off point $ 2.00 per kg $ 2.00 per kg $ 2.00 per kg Separable cost $ 0.50 per kg $ 2.50 per kg $ 1.50 per kg Sales price of ultimate product $3.00 per kg $ 5.00 per kg $ 6.00 per kg REQUIRED: 1. Allocate the joint cost between Wrapped, Boxed and Figurines using: a) The Physical Units Method. (3 Marks) b) The Relative Sales Value Method. Round your final answer to whole dollars. (3 Marks) c) Net Realisable Value Method. Round your final answer to whole dollars. (3 Marks) 2. Milka Chocolate Limited has a request from a prospective customer to further process its chocolate figurines into Chocolate Gift Baskets which will then be bought by the customer for $9.00 per kilogram. This will increase the separable costs of chocolate per kilogram to $3.00. Would you advise the company to accept the offer? Why or why not? (6 Marks) COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B. Assessment Information QUESTION 3 (21 marks) Chocmust Ltd buys and sells premium chocolates and sweets wholesale for distribution to retail outlets and has decided to prepare a cash budget for the quarter ending 31 March 2018. As at 1 January 2018, the Cash at bank ledger account had a debit balance of $30,000. The following estimates have been made for the next three months: January $ February $ March $ Sales 100,000 150,000 200,000 Purchases 75,000 100,000 125,000 Cash wages 15,000 20,000 28,000 Depreciation on Fixtures 5,000 5,000 5,000 Rental expenses 10,000 10,500 11,000 Insurance expenses 500 500 500 Loan repayment 0 1,000 1,000 All sales are on credit. It is expected that debtors will pay their accounts as follows: • 50 per cent in the month following the sale. • 40 per cent in the second month following the sale. • 10 per cent in the third month following the sale. Actual sales for the previous three months were as follows: • $300,000 in December 2017 • $250,000 in November 2017 • $150,000 in October 2017 Purchases are paid 50% in the same month, and 50% in the month following the sale. December purchases amounted to $50,000. Rental expenses and insurance expenses are paid the following month after they are incurred. December expenses were as follows: Rental Expense $10,000 and Insurance Expense $500 REQUIRED: Part A: Prepare a schedule of cash receipts from debtors for the Quarter ending 31st March 2018. (7 marks) Part B: Prepare a Cash budget for the Quarter ending 31st March 2018. (14 marks) COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B. Assessment Information QUESTION 4 (9 marks) SuperParkas Pty Ltd incurred the following costs for job number PP549, which consisted of 900 waterproof purple jackets for sale to an outdoor clothing store. Direct material: 1 January Requisition no. 235: 1800 metres of Coated Plastic Material @ $8.50 per metre 3 January Requisition no. 718: 1100 metres of Nylon Mesh Material @ $3.25 per metre Direct labour: 31 January Timesheet no. 45: 300 hours@$25 per hour Manufacturing overhead: Applied on the basis of direct labour hours @$13 per hour Additional information: