Fall 2014
MID-TERM EXAMINATION STUDENT NAME
STUDENT NUMBER
MANAGEMENT ACCOUNTING ACCT 361 VERSION 1
PROFESSOR:
KEVIN PARENT
DATE: TIME:
October 24, 2014 9-11am
INSTRUCTIONS: TRANSLATION dictionaries ARE PERMITTED. Calculators ARE PERMITTED in this examination. ANSWER BOOKLET to be used for answers. This examination has a total of 5 pages including this cover page. Please ensure that you have a complete examination paper before starting.
THIS EXAMINATION IS PRINTED ON BOTH SIDES OF THE PAGE THIS EXAMINATION PAPER MUST BE RETURNED
1. Bear Manufacturing begins operations on October 1. Information from job cost sheets shows the following: Manufacturing Costs Assigned (non-cumulative) Job October November December A $ 11,500 B $ 5,200 $ 8,300 C $ 3,000 $ 5,800 $ 4,200 D $ 7,100 $ 8,000 E $ 3,400 Job A was completed in October. Job B was completed in November. Job C was completed in December. Each job was sold in the month following completion. Required (12) (15 min.) Determine the following amounts: 1. 2. 3. 4. 5. 6.
Work in process inventory, October 31 Finished goods inventory, October 31 Work in process inventory, November 30 Finished goods inventory, November 30 Work in process inventory, December 31 Finished goods inventory, December 31
$_______________ $_______________ $_______________ $_______________ $_______________ $_______________
2. Required (5) (5 min.) Classify the following manufacturing costs and expenses by using the following code letters: A. B. C. D.
Direct materials cost Direct labour cost Manufacturing overhead cost Period cost
Abel Manufacturing Company incurs the following costs and expenses in making furniture: ____ 1. ____ 2. ____ 3. ____ 4. ____ 5. ____ 6. ____ 7. ____ 8. ____ 9. ____ 10.
Insurance on factory building Oak and pine wood used in desks and chairs Lubricants, rosin, and polishing compounds used in manufacturing Advertising in trade magazines Rent on leased factory machinery Wages of assembly line workers Salesperson's commissions Depreciation on delivery equipment Depreciation on factory machinery Wages of factory maintenance workers
3. Farrell Company manufactures a product that sells for $ 50 per unit. Farrell incurs a variable cost per unit of $ 30 and $ 3,400,000 in total fixed costs to produce this product. They are currently selling 200,000 units. Required (18) (20 min.) Complete each of the following requirements, presenting labelled supporting computations. (a)
Calculate and label the contribution margin per unit and contribution margin ratio.
(b)
Using the contribution margin per unit, calculate the break-even point in units.
(c)
Using the contribution margin ratio, calculate the break-even point in dollars.
(d)
Calculate the margin of safety and margin of safety ratio.
(e)
Calculate the number of units that must be sold in order to generate net income of $400,000 using the contribution margin per unit.
(f)
Should Farrell give a commission to its salespeople based on 10% of sales if it will decrease fixed costs by $400,000 and increase sales volume 10%? Support your answer with labelled computations.
4. Required (8) (10 min.) Write a linear cost function equation for each of the following conditions. Use y for estimated costs and X for activity of the cost driver. (a)
Direct manufacturing labour is $ 10 per hour.
(b)
Direct materials cost $ 9.20 per cubic yard.
(c)
Utilities have a minimum charge of $ 1,000, plus a charge of $ 0.05 per kilowatt-hour.
(d)
Machine operating costs include $ 200,000 of machine depreciation per year, plus $ 75 of utility costs for each day the machinery is in operation.
5. Bright Window Company designs and builds custom windows for luxury homes. Most of the windows are custom made but occasionally the company does mass production on order. Its budgeted manufacturing overhead costs for the year 2012 are as follows: Overhead Cost Pools Purchasing Production (cutting, milling, finishing) Setting up machines Inspecting Utilities Total budget overhead costs
Amount 180,000 400,000 135,000 160,000 300,000 $ 1,175,000 $
For the last three years, the company has been charging overhead to products on the basis of machine hours. For the year 2012, 100,000 machine hours are budgeted. Susan Craft, owner-manager of Bright Window, recently directed her accountant to implement the activity-based costing system she has repeatedly proposed. At Susan's request, the accountant and production foreman identify the following cost drivers and their usage for the previously budgeted overhead cost pools.
Overhead Cost Pools Purchasing Production (cutting, milling, finishing) Setting up machines Inspecting Utilities
Activity Cost Drivers Number of orders Direct labour hours Number of setups Number of inspections Square metres occupied
Total Drivers 500 80,000 1,000 5,000 75,000
During this month, the company received an order for 50 window sets from a housing development contractor. The accountant prepares cost estimates for producing components for 50 window sets so Susan can submit a contract price per window set to the contractor. The following data for the production of 50 window sets is accumulated: Direct materials Direct labour Machine hours Direct labour hours Number of purchase orders Number of machine setups Number of inspections Number of square metres occupied
$ 120,000 $ 135,000 12,000 10,000 50 80 380 7,000
Required (17) (20 min.) (a) Calculate the predetermined overhead rate using traditional costing with machine hours as the basis. (3) (b) Calculate the manufacturing cost per window set under traditional costing. (6) (c) Calculate the manufacturing cost per window set under the proposed activity-based costing. (8)
6. KevPar Inc. manufactures and sells sea kayaks. KevPar’s manufacturing operations are organized into one quality control (QC) department and three production departments – fiberglass (F), kevlar (K) and plastic (P). Each production department manufactures sea kayaks in different material. The QC department provides verifications of the sea kayaks for each of the three production departments. Each production department is treated as a cost centre. The respective managers are awarded year-end performance bonuses on the basis of meeting budgeted costs or achieving cost savings. All costs incurred by the QC department are allocated to the production departments using the number of quality control verifications as an allocation base. When planning the 2013 fiscal year, KevPar’s senior management budgeted for total QC department costs of $ 100,000 based on 100 verifications. The request for verifications by F, K and P were expected to be 30, 50 and 20. Actual costs incurred by the QC department during 2013 were $ 126,500 and the actual QC jobs requested by F, K and P were 50, 50 and 15 resulting in the total costs allocations to F, K and P of $ 55,000, $ 55,000 and $ 16,500 respectively. Because of the increased demand of verification services, the QC department incurred overtime expenses. During performance evaluations at year end, the manager of K expressed serious misgivings about the costs allocated to his division: “I don’t think our cost allocation system is fair. Why should I be held accountable for someone else’s efficiency or someone else’s level of consumption?” Required (40) (50 min.) Prepare a report to KevPar’s senior management addressing the concerns of K’s manager – specifically, consider whether KevPar’s cost allocation system is fair. As well you could suggest alternatives that may improve how the costs are allocated and the way the performances within KevPar are evaluated.
Solutions 1. 1. 2. 3. 4. 5. 6.
$8,200 $11,500. $15,900 $13,500 $18,500 $13,000
2. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10.
C A C D C B D D C C
($5,200 + $3,000). ($3,000 + $5,800 + $7,100). ($5,200 + $8,300). ($7,100 + $8,000 + $3,400). ($3,000 + $5,800 + $4,200).
3. (a)
Unit selling price Unit variable costs Contribution margin per unit
(b)
$3,400,000 ÷ $20 = 170,000 units
(c)
$3,400,000 ÷ 40% = $8,500,000
(d)
$10,000,000 – $8,500,000 = $1,500,000 margin of safety $1,500,000 ÷ $10,000,000 = 15% margin of safety ratio
(e)
($3,400,000 + $400,000) ÷ $20 = 190,000 units
(f)
Current expected income Sales (200,000 × $50) $10,000,000 V.E. (200,000 × $30) 6,000,000 C.M. 4,000,000 F.E. 3,400,000 N.I. $ 600,000
Therefore, No. 4. (a) (b) (c) (d)
y = $10X y = $9.20X y = $1,000 + $0.05X y = $200,000 + $75X
$50 (30) $20
Contribution margin per unit Unit selling price
New expected income Sales (220,000 × $50) V.E. [(220,000 × $30) + ($11,000,000 × 10%)] C.M. F.E. N.I.
$20 ÷ $50 40%
$11,000,000 7,700,000 3,300,000 3,000,000 $ 300,000
5. (a)
(b)
Predetermined overhead rate using machine hours: $1,175,000 ÷ 100,000 hours = $11.75 per machine hour Manufacturing cost per window set under traditional costing: Direct materials $120,000 Direct labour 135,000 Overhead (12,000 × $11.75) 141,000 Total cost of 50 window sets $396,000 Cost per window set ($396,000 ÷ 50)
(c)
$7,920
Manufacturing cost per window set under activity-based costing: Computation of Activity-Based Overhead Rate
Activity Cost Pool
Estimated Overhead Purchasing $ 180,000 Production 400,000 Setting up machines 135,000 Inspecting 160,000 Utilities 300,000 $1,175,000
Total Estimated Drivers 500 orders 80,000 D/L hrs. 1,000 setups 5,000 inspections 75,000 sq. metres
Activity-Based Overhead Rate $360 per order $5 per D/L hr. $135 per setup $32 per inspection $4 per sq. metre
Assignment of Overhead to Order of 50 Window Sets
Activity Cost Pool Purchasing Production Setting up machines Inspecting Utilities
Expected Use of Driver 50 orders 10,000 D/L hrs. 80 setups 380 inspections 7,000 sq. ft.
Activity-Based Overhead Rate $360 $5 $135 $32 $4
Total manufacturing cost per window set under ABC: Direct materials $120,000 Direct labour 135,000 Overhead 118,960 Total cost of 50 window sets $373,960 Total cost per window set:
$7,479
Cost Assigned $ 18,000 50,000 10,800 12,160 28,000 $118,960
6. Objective/Criteria
Adresses the organization's cost allocation fairness.
Performance Indicators Did not Somewhat address Below (0 points) (1 point)
Below
Meets
(2 points)
(3 points)
Somewhat Above (4 points)
Exceeds (5 points)
Adresses how costs are being allocated presently.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Identifies the cause for the greivance of part K.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Suggests sensible alternatives of how costs are presently allocated.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Suggests alternative cost allocation of QC costs.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Provide a well reasoned conclusion consistent with analysis.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Exercices a high level of professional judgement.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Communicates information in a timely, clear and concise manner.
(0 points)
(1 point)
(2 points)
(3 points)
(4 points)
(5 points)
Fairness: From an individual perspective, F, K or P may perceive the cost allocation system to be “fair” if they are being or not being allocated cost for which they are responsible and “unfair” if they are being allocated costs for which they are not responsible. To achieve “fairness” in performance evaluation from an overall perspective, F,K, P and QC must be evaluated and rewarded based on results they have achieved that are within their control. “Fairness” can also be analysed for the purposes of allocation of resources, organizational control and cost recovery.
Overtime costs and other incremental costs caused by demands exceeding budgeted numbers may be the extra costs in the QC department. The QC department may also be inefficient and thus allocated extra costs to F, K and P. QC offers services to all other departments and a deviation of budgeted costs is to be expected. Present cost allocation: Calculation of cost allocation method based on budget and actual. Budget
Actual
Difference
F
30
1000
30000
50
1100
55000
25000
K
50
1000
50000
50
1100
55000
5000
P
20 100
1000
20000 100000
15 115
1100
16500 126500
-3500 26500
K Grievance: K planned to use 50 QC checks and planned on being allocated $ 50,000. K used 50 QC checks but was allocated $ 55,000 which will influence the bonus to be received by each department related to equivalence or reduction of budget. K is being allocated the extra costs form other department’s requirement of extra QC checks on which it has no influence. Alternative to present cost allocations: Extra costs allocated only to departments that have requested superior numbers of QC checks. Normal
Extra
Total
Difference
F
50
1000
50000
20
11500
61500
11500
K
50
1000
50000
0
0
50000
0
P
15 115
1000
15000 115000
-5 15
0 11500
15000 126500
0 11500
Alternative to cost allocations: Different cost allocations such as using the number of direct hours per department, number of items actually verified per department, ABC, etc.