QUESTION 1 Job costing A. Create a spreadsheet solution to the following problem. Follow the template provided. Play the Job cost podcasts and work through the example problem in those podcasts. Design your spreadsheet to meet the assignment requirements set out above. In particular, check the spreadsheet requirements and the spreadsheet advice PDF. B. Distinguish between job costing and process costing. Give your own examples. QUESTION 2 Process costing Prepare a spreadsheet to solve the following process costing problem. Review the four process costing videos provided in Interact Resources. Note that in the situation below there are two production departments. QUESTION 3 Joint costing – decision making Create a spreadsheet to solve the following joint cost problem. Joint cost allocation: additional processing beyond split-off point In a certain production process 100 000 kg of a single raw material were processed at a cost of $250,000. At split-off two intermediate products, A and B emerged, weighed as 60,000 kg of A and 40,000 kg of B. A was processed further at a cost of $45,000 to produce C, and B was processed further at a cost of $25,000 to produce D. C sold for $4.50 per kg. Required: (a) If A was allocated $187,500 of the joint production costs under the net realisable value method, what was the selling price of D? (b) Suppose the firm receives an offer to buy all of product A for $2 per kg at the split-off point. Would the firm be better off selling A or processing further to produce C? By how much? Question 4 Variance analysis Borg Ltd has set up the following standards for material and labour: Materials:10 kg @$6 Direct labour:1 hr @ $20 During a month 19,500 units were produced, 197,000 kg of material were used and 20,100 hours of labour were worked. 220,000 kg of materials were purchased for $1,364,000. Required: (a) Calculate the materials price variance (on purchase) and materials usage variance. (b) If the total direct labour variance was $1,950 unfavourable, what was the actual direct labour rate per hour? (c) Journal entries to record these facts. A. Answer the requirements using a spreadsheet. Include the IF function to determine Favourable and Unfavourable variances. B. Prepare a Business Report as if for senior management critically evaluating the purpose of variance analysis, why the materials price variance should be calculated on purchase, other areas in an organisation where variance analysis would be useful and the practical relevance of detailed overhead variance analysis. See the reading by Murray Wells. Search the CSU library for the ACC512 readings. Suggested word limit about 500 words. Ensure that your answer is in business report format. Read the following online references regarding business report writing. http://bit.ly/FoBAcademic-Writing-Skills and http://unilearning.uow.edu.au/report/4b.html QUESTION 5 Budgeting A. B. Write a business report describing budgeting as a non technical process. Refer to satisficing, budgeting as a political process and budget ploys. Give examples. About 500 words excluding references. Use the Internet as a reference ANDrefer to relevant academic research papers. See the text page 249 Rationale This assignment assesses your achievement of learning outcomes including the application of cognitive skills in the design and operation of costing systems; the design and operation of performance management systems; the role of management accounting in organisational contexts and the implications for management accounting of different paradigms; the application of analytical and synthetical skills in report writing; quantitative techniques and computer software including using the Internet as a professional source; the creation and implementation of computerised decision models; and to critique how managers make decisions. In particular, this assignment is designed to assess your application of knowledge, understanding and skills in certain topics including cost flows in management accounting, spreadsheet construction, job and process costing, variance analysis, joint costing and budgeting. For spreadsheet problems, good answers will comply with the spreadsheet requirements including the separation of data entry and report/solution areas, pasted normal and formula view with row and column headings and the use of the IF function where appropriate. Review the examples in the Spreadsheet Advice PDF provided online in Interact2 Resources. Marking criteria For spreadsheet questions formula views showing row and column headings are important. Your assignments will be marked as a whole with recognition being given to application of knowledge, quality thinking and application of skills. For some questions, students have a chance to demonstrate some creativity, or provide their own examples or give evidence of wider reading or structure a computer spreadsheet model in an innovative manner. We also need to avoid the snowballing effects of cumulative errors – that is, an error early in a practical question which carries through. Thus a marking system is used with deductions for errors and omissions. Full marks are possible for well structured, complete, quality answers. Any assignments with significant evidence of plagiarism may be referred to the university’s academic misconduct processes and will receive a grade of zero. See www.csu.edu.au/faculty/business/studentresources/plagiarism The marking criteria for your assignments will be based on the content of the subject as identified by thelearning objectivesas outlined above and at the beginning of each of the various topics as outlined at the beginning of each Interact2 topic. Good spreadsheet answers will comply with the assignment requirements. Example criteria used in marking essays/discussion questions/case studies/business reports While there is no particular format required for these answers, the following criteria are likely to be used. Note that business reports are normally more structured than essays. Note: Normal distribution curves for grades are not utilised in this subject. Penalties will apply for late submission at 10% of the total mark available per day; it is important that submitted assignments are complete; omitted answers will result in mark deductions; refer to the University regulations contained in the CSU online handbook for matters pertaining to special consideration, misadventure and extenuating circumstances, academic misconduct, code of conduct for users of electronic facilities, assessment regulation, grading scale, progression and academic performance, grade point average, examination regulations and other matters pertaining to assessment. The regulations can be found at the University’s web site: < http://www.csu.edu.au> You can discuss your work with each other prior to submission using the discussion forum. However, please do not post complete versions of answers to the forum. Do not leave assignments until the last minute.
The post QUESTION 1 Job costing A. Create a spreadsheet solution to the following problem. Follow the template provided. Play the Job cost podcasts and work through the example problem in those podcasts. Desi appeared first on Homeworkaider.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
