Accounting Assignment 1

Accounting Assignment 1 - COMMERCE 294 FALL 2010 ASSIGNMENT...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: COMMERCE 294 FALL 2010 ASSIGNMENT # 1 DUE: Friday, October 1 HAND IN ONLY THE PAGES BEGINNING WITH THE NAME SPACES (Pages 5-9) Question #1 Cost Behavior [Chapter 6] (15 marks) Guy Cabling Inc (Guy) supplies and installsfiber optic cable for data transmission. Guy has been approached by UBC to lay fiber optic cable in the existing space and the new development, in the Henry Angus building. You were hired for the summer by Guy, the owner of the company because of your remarkable success in Commerce 294. Guy will be relying upon you to assist in the assessment of this project for the company. To date, the company has not demonstrated much sophistication in understanding how their costs behave and in predicting costs. ' You spent some time pouring through financial information and you were able to obtain the following information from past projects that Guy had completed: - Meters of cable Project Job # laid in project Cost 208,250 250,675 125,550 30,125 m 190,450 141,750 ‘1 170,400 E 254750 The costs in the table above include: 0 Custom fibre optic cable: Guy purchases the custom fiber optic cable from a German supplier at a rate of $17.50/m. The supplier confirmed the price of $17.50 up to and including 6600 metre spools. For spools beyond 6,600 metres, the order requires a heavier cable and the cost increases by $2.50/m for the entire spool. ( i.e. , for every metre in the spool). - Cable installers are contract labourers and are paid $1,100 per 100 metres of cable installed. ' a Building amortization is allocated at $2,500 per job. 0 The project costs include a charge of $5,000 for an engineer. Memos in the project files indicate that one engineer was just able to handle projects of this size, however, with the higher amounts of cable, there was a diminished ability of the engineer to service the project. It was recommended that in the future, any job (project) greater than 5,000 metres should include two engineers. 0 Each job is allocated $3,000 of the marketing administration costs. - Project Logistics includes shop supplies, support labour and other additional costs needed to support the projects. Guy charges a contractors fee of 15 percent on all of his projects. This represents the profit component for the company. This has not been included in the table above. Required: a) For the Projects Costs, Identify the behaviour of each of the costs should be included (be specific). Explain why you may have excluded some costs. b) Using the hi/lo method, provide the cost function for logistics support costs. 0) The Henry Angus project is estimated to be 6,750 metres of cable. Guy would like you to prepare a detailed analysis of this project. Ensure that you indicate what the different costs of the project would be. d) The Sauder School of Business has been given an approved budget by the UBC Senate of $300,000 for the fiber optic cabling of Henry Angus. Should Guy accept this contract? Explain your answer. e) Guy has seen your analysis and is quite concerned about the method that you used to predict the logistics support costs. He feels that the model selected cannot work with the activity level suggested. Identify what Guy is likely concerned about and address his concerns. Question #2 [Chapter 3] (15 marks) Analysis of Cost Flows and Inventories under Job-Order Costing Quickmix Ltd. manufactures electric mixers and chopping tools. A job-order costing system is used, since the products are manufactured in batches rather than on a continuous basis. The company started operations on January 2, 2009. Operating activities during the first 11 months of the year (through November 30) resulted in the following balances in selected accounts: Raw Materials# Manufacturin Overhead Bal. 36,000 2,260,000* Work-in-Process Cost of Goods Sold Bal. 1,200,000 Bal. 14,200,000 Finished Goods Bal. 2,785,000 # The raw materials account includes (both) direct materials and indirect materials. * This figure represents the debits to the manufacturing overhead account for the first eleven months of the year. The following additional information is available on the company: a. The work-in-process inventory at November 30 consisted of two jobs: Total Cost as of Job No. Units Item November 30 5011 ............. ..48,000 Professional mixers $700,000 6011 ............. ..39,000 Base mixers 500,000 W b. The finished goods inventory at November 30 consisted of five separate items in stock: Items Quantity and Unit Cost Total Cost Professional mixers .......... ..5,000 units at $22 each $110,000 Premium mixers ............... ..115,000 units at $17 each 1,955,000 Brass choppers ................ ..10,000 units at $14 each 140,000 Steel choppers ................. ..5,000 units at $16 each 80,000 Mixer utensil set ............... ..100,000 units at $5 each 500,000 $2,785,000 0. Manufacturing overhead is applied to jobs on a basis of direct labour-hours. For 2009, management estimated that the company would work 450,000 direct labour-hours and incur $3,150,000 in manufacturing overhead costs. d. A total of 367,000 direct labour-hours were worked during the first 11 months of the year. Items (e) through (j) below summarize the activity that took place in the company during the month of December 2009. e. A total of $708,000 in raw materials was purchased during the month. f. Raw materials were requisitioned as follows: Job No. Quantity and Items Materials 5011 ................................. ..See above $210,000 6011 ................................. ..See above 6,000 1021 ................................. ..30,000 Steel choppers 181,000 2021 ................................. ..10,000 Premium mixers 92,000 3021 ................................. .. 50,000 Costco mixers 163,000 — ................................... .. Indirect materials 20,000 $672,000 g. The payroll during December was as follows: Job No. Hours Total Cost 5011 .................................................. .. 6,000 $62,000 6011 .................................................. .. 2,500 26,000 1021 ................................................ .. 18,000 182,000 2021 ..................................................... .. 500 5,000 3021 .................................................. .. 5,000 52,000 Indirect labour ................................... .. 8,000 84,000 Sales and administration ................... .. — 120,000 w h. Other costs incurred in the factory during December were: Amortization ..................................... .. $62,500 Utilities ............................................... .. 15,000 Insurance ............................................. .. 1,000 Property taxes ...................................... .. 3,500 Maintenance .................................... .. 5,000 $81,990 i. Jobs completed during December and the units transferred to the finished goods warehouse were as follows: Job No. Quantity Items 5011 .................................. ..48,000 units Professional mixer 6011 ............................... .. 39,000 units Base mixers 1021 ................................... .. 30,000 units Steel choppers 3021 .................................. ..50,000 units Costco mixers j. Finished products were shipped to customers during December as follows: Items Quantity —_—_—___—__—__.__ Professional mixers ............................................. .. 16,000 units Premium mixers .................................................. .. 32,000 units Base mixers ........................................................ .. 20,000 units Costco mixers ..................................................... .. 22,000 units Brass choppers ..................................................... .. 5,000 units Steel choppers .................................................... .. 10,000 units Mixer utensil set .................................................. .. 26,000 units Required: a) Determine the amount of under/over-applied manufacturing overhead for the year 2009 and indicate whether it is underapplied or overapplied. b) (i) What is the appropriate accounting treatment for under-or overapplied overhead in general- i.e., not for this specific case. (ii) For this specific case, discuss what the appropriate accounting treatment should be and why? Actual journal entry is not required. 0) Determine the dollar balance in the work-in-process inventory account as of December 31, 2009. Show all computations. [Ignore any under/over-applied overhead] d) For the Professional mixers only, determine the dollar balance in the finished goods inventory account as of December 31, 2009. Assume a FIFO flow of units- i.e., the professionals mixers produced the earliest are sold first. Show all computations. [Ignore any under/over—applied overhead] 294 — ASSIGNMENT #1 NAME (Last, First): DUE: Friday, October 1 Student No.: Section: 01 Grade 02 Grade Total = [out of 30] Question #1 Cost Behavior (15 marks) a) For the Projects Costs, Identify the behaviour of each of the costs that should be included (be specific). Explain why you may have excluded some costs. b) Using the hi/lo method, provide the cost function for logistics support costs. c) The Henry Angus project is estimated to be 6,750 metres of cable. Guy would like you to prepare a detailed analysis of this project. Ensure that you indicate what the different costs of the project would be. d) The Sauder School of Business has been given an approved budget by the UBC Senate of $300,000 for the fiber optic cabling of Henry Angus. Should Guy accept this contract? Explain your answer e) Guy has seen your analysis and is quite concerned about the method that you used to predict the logistics support costs. He feels that the model selected cannot work with the activity level suggested. Identify what Guy is likely concerned about and address his concerns. Question #2 [15 marks] a) Determine the amount of under/over-applied manufacturing overhead for the year 2009 and indicate whether it is underapplied or overapplied. [Additional space is provided on the next page for your answer.] b) (i) What is the appropriate accounting treatment for under/over-applied overhead in general- i.e., not for this specific case. (ii) For this specific case, discuss what the appropriate accounting treatment should be and why? Actual journal entry is not required. 0) Determine the dollar balance in the work-in-process inventory account as of December 31, 2009. Show all computations. [Ignore any under/over-applied overhead.] d) For the Professional mixers only, determine the dollar balance in the finished goods inventory account as of December 31, 2009. Assume a FIFO flow of units- i.e., the professionals mixers produced the earliest are sold first. Show all computations. [ignore any under/over-applied overhead.] ...
View Full Document

Page1 / 9

Accounting Assignment 1 - COMMERCE 294 FALL 2010 ASSIGNMENT...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online