Comm294
COMMERCE 294 WINTER 2011 ASSIGNMENT # 1 DUE: Monday, January 30 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 installs fiber 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: Job # 1 2 3 4 5 6 7 8 9
Meters of cable laid in project
4000 5500 6500 3000 250 5000 3500 4500 6000
Project Cost $ 152,100 208,250 250,675 125,550 30,125 190,450 141,750 170,400 254,750
The costs in the table above include: 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. Building amortization is allocated at $2,500 per job. 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
Meters of cable laid in project
4000 5500 6500 3000 250 5000 3500 4500 6000
Project Cost $ 152,100 208,250 250,675 125,550 30,125 190,450 141,750 170,400 254,750
The costs in the table above include: 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. Building amortization is allocated at $2,500 per job. 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