Task Your assignment
Consists of different question styles including discussion questions, reports, exercises, problem questions and spreadsheet questions. It assesses learning outcomes as listed in the assignment rationale below. The purpose of this assignment is to continue to develop skills in costing systems with an emphasis on the role of control in managing the production of goods and services efficiently in the workplace. Each question builds on the knowledge gained through the first assignment to develop the concepts of management accounting control through costing. Each question uses realistic data and professional practices similar to that found in workplaces.
QUESTION 1 Job costing (20 marks)
A. (15 marks) Create a handwritten/manual solution AND 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. Create a spreadsheet solution showing the row and column headings and the formula view. Your report section should be completely formula driven. Scan or use your phone to copy and paste an image of your handwritten attempt into your assignment. If using a smart phone, consider using a free scanning app such as Camscanner, Office Lens or Google Drive or search for an app. Let us know which app you chose. Design your spreadsheet to meet the assignment requirements set out above. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF. B. Management accounting and history. (5 marks) Taking the Great Pyramid of Giza as an example, describe how modern cost management accounting could be applied to a current attempt to recreate this structure. Be creative in your discussion (about 200 - 300 words).
QUESTION 2 Process costing (15 marks)
Create a handwritten/manual solution AND a spreadsheet solution to the following problem. Scan or use your phone to capture an image and paste a copy of your manual solution in your assignment submission. Consider using a smart phone scanning app. Also paste a spreadsheet solution showing the row and column headings and the formula view. Your report should be completely formula driven. Design your spreadsheet to meet the assignment requirements set out above. In particular, check the spreadsheet requirements and the Spreadsheet Advice PDF. See pages 156-157 of your text for examples. Review the four process costing videos provided in Interact Resources. Note that in the situation below there are two production departments.