Management Accounting Individual Assignment
Question 1: Cost estimation: High-low method and Least Squares regression
Motor Racer Pty Ltd is a manufacturer of timing components for speedways. The company's accountant, Casey Stoner is concerned with maintenance technician costs and has recently compiled the costs for the firm's Maintenance Department. He used the technician hours to quantify the Department's activity. Casey presents the following data for analysis.
Month
|
Technician hours
|
Maintenance costs
|
July
|
1,200
|
$62,500
|
August
|
1,600
|
$78,150
|
September
|
1,800
|
$83,000
|
October
|
1,330
|
$65,800
|
November
|
1,700
|
$79,900
|
December
|
1,600
|
$72,250
|
January
|
1,400
|
$66,600
|
February
|
1,350
|
$63,550
|
March
|
1,460
|
$69,110
|
April
|
1,660
|
$73,800
|
May
|
1,700
|
$79,500
|
June
|
1,500
|
$70,250
|
Required: Note all calculations are to be rounded to nearest cents
1. Using the high-low method, calculate;
a. Determine the highest point, the lowest point and the maintenance costs at theses points
b. The variable cost per unit of cost driver,
c. The fixed cost, and
d. Write the cost equation based on high-low method.
2. Casey wants to predict next month's maintenance cost using the high low cost equation. How much will be the maintenance costs when technician hours total 1,550.
3. Construct an Excel spreadsheet and use least squares regression analysis to estimate the Maintenance Department's:
a. Variable cost per unit of cost driver,
b. Fixed cost, and
c. Cost equation for the department's costs.
d. When is multiple regression required to explain cost behaviour?
4. What if Casey wants to use regression analysis cost formulae in Part 3 (c) to estimate maintenance cost for next month when he expects technician's hours to be 1,550. How much will be the estimated maintenance cost?
5. Explain the significance of the coefficient of determination measures for cost formulas. Why should these measures be considered when using the method of least squares?
6. Describe the method of least square. Why does the cost prediction estimate using the high- low and regression methods differ? Which method would you recommend? Justify your answer.
Question 2: Standard costing
Sydney Production Company has developed the following standards for one of its products:
STANDARD VARIABLE COST CARD: One Unit of Product
|
Materials: 30 square metres × $5.00 per square metre
|
$150.00
|
Direct labour: 16 hours × $7 per hour
|
$112.00
|
Variable manufacturing overhead: 16 direct labour hours × $5 per hour
|
$ 80.00
|
Fixed overhead (1 DL hour @ $4)
|
$4.00
|
Total standard cost per unit
|
$346.00
|
The company records materials price variances at the time of purchase. The following activity occurred during the month of April:
Materials purchased:
|
80,000 sq. metre at $5.30 per sq. metre
|
Materials used:
|
74,000 square metres
|
Units produced:
|
2,500 units
|
Direct labour:
|
42,000 hours at $6.70 per hour
|
Actual variable manufacturing overhead:
|
$228,000
|
Actual fixed overhead
|
$180,500
|
Required: Note: SHOW ALL WORKINGS and indicate whether the variances are favorable or unfavorable
1. Calculate the following variances for direct material;
a. Price variance.
b. Usage variance
c. Explain why the direct material price variance is often calculated at the point of purchase rather than at the point of purchase.
2. Calculate the following variances for direct labour
a. Rate variance
b. Efficiency variance
c. Suggest two possible causes of an unfavorable direct labour efficiency variance.
3. Calculate the following variances for variable overheads
a. Spending variance
b. Efficiency variance
c. Explain why the variable overhead spending variance is not a pure price variance.
4. Calculate the following variances for fixed overheads
a. Spending variance
b. Volume variance
c. What is the course of an unfavorable volume variance? Does the volume variance convey any meaningful information to managers?
Question 3: Plant-wide rate, departmental overhead rates and ABC
Sydney Electronics Company produces two types of calculators: scientific and business. Both products pass through two producing departments. The business calculator is by far the most popular. The following data have been gathered for these two products:
|
Product-Related Data
|
|
Scientific
|
Business
|
Units produced per year
|
75,000
|
750,000
|
Prime costs
|
$250,000
|
$2,500,000
|
Direct labor hours
|
100,000
|
1,000,000
|
Machine hours
|
50,000
|
500,000
|
Production runs
|
100
|
150
|
Inspection hours
|
2,000
|
3,000
|
Maintenance hours
|
2,250
|
9,000
|
|
Department Data
|
|
Department 1
|
Department 2
|
Direct labour hours:
|
|
|
Scientific calculator
|
75,000
|
25,000
|
Business calculator
|
112,500
|
887,500
|
Total
|
187,500
|
912,500
|
Machine hours:
|
|
|
Scientific calculator
|
25,000
|
25,000
|
Business calculator
|
400,000
|
100,000
|
Total
|
425,000
|
125,000
|
Overhead costs:
|
|
|
Setup costs
|
225,000
|
$225,000
|
Inspection costs
|
$175,000
|
175,000
|
Power
|
250,000
|
150,000
|
Maintenance
|
200,000
|
250,000
|
Total
|
$850,000
|
$800,000
|
Required:
1. Compute the overhead cost per unit for each product using a plant wide, unit-based rate using direct labor hours.
2. Compute the overhead cost per unit for each product using departmental rates. In calculating departmental rates, use machine hours for Department 1 and direct labor hours for Department 2.
3. Repeat using direct labor hours for Department 1 and machine hours for Department 2.
4. Calculate the activity rate for each activity using activity-based costing.
5. Compute the overhead cost per unit for each product using activity-based costing.
6. Comment on the ability of departmental rates to improve the accuracy of product costing. Which method of costing would you recommend to management, plant-wide, departmental rates or ABC and why.
Question 4: Support department cost allocation
Blue Point Ltd. has two support departments, Personnel and Maintenance, and two producing departments, Blending and Finishing. Estimated direct costs and hours of services used by these departments are as follows:
|
Support Departments.
|
Producing Departments
|
|
Personnel
|
Maintenance
|
Blending
|
Finishing
|
Personnel Hrs
|
-
|
800
|
4,800
|
2,400
|
Maintenance Hrs
|
1,500
|
-
|
6,000
|
7,500
|
Direct costs
|
$9,000
|
$13,500
|
$40,000
|
$35,000
|
The budgeted machine hours for the Blending department are 60,000 and the budgeted direct labour hours for the finishing department are 20,000. These activities are used to allocate manufacturing costs to products in the 2 departments.
Required:
1. Prepare a schedule allocating the support department costs to the producing departments using the direct allocation method and determine the predetermined overhead rates for the two producing departments.
2. Prepare a schedule allocating the support department costs to the producing departments using the sequential allocation method and determine the predetermined overhead rates for the two producing departments.
3. Explain the main differences between the direct, sequential and reciprocal methods of support department cost allocations.
Question 5: Preparation of budget
Kevin Limited owns a retail store that sells new and used sporting equipment. Recently the managing director Kevin is concerned about the cash flow situation of the company. He has asked his management accountant to prepare cash budget in order to look at future cash requirements for the company. Kevin provides the following information.
1. Kevin Limited has a sales budget for March of $440,000. About 10% are cash sales and the remainder is sold on account.
2. The company expects that 60% of credit sales will be collected in the month of the sale, 25% in the next month and 10% in the following month.
3. Materials purchased on account are expected to be $250,000. Kevin pays 35% in the month of the purchase, 50% in the month following the purchase and the remaining 15% in the second month after the purchase.
4. Salaries and wages of the workers are approximately $45,000 per month. The employees are paid weekly so on average 95% of their wages are paid in the month to which they relate and the remaining 5% is paid in the following month.
5. Utilities average $4,300 per month.
6. Rent on the building is $9,000 per month.
7. Insurance is $3,000 per month and advertising costs are $1,000 per month.
8. February sales were $320,000 and purchases of materials in February were $170,000; January sales were $200,000 and purchases of materials in January were $130,000.
9. The cash balance on 1st March is $5,400.
Required:
1. Prepare the following for the month of March. Please round all figures to the nearest dollar amount.
a. Schedule of cash receipts for March
b. Schedule of cash payments for March
2. Prepare a cash budget for March.
Question 6: Cost-Volume-Profit Analysis, Multiple products
Travel On Limited sells luggage. The company sells a duffle bag, a carry-on suitcase and a deluxe suitcase. The price and variable cost for each type of luggage is listed below.
|
Price
|
Variable Cost
|
Duffle bag
|
$100
|
$25
|
Carry-on
|
$180
|
$40
|
Deluxe
|
$300
|
$120
|
The total fixed costs for Travel On Limited equals $60,000. For every 8 duffle bags Travel On sells it sells 3 carry-on suitcases and 1 deluxe suitcase.
Required:
1. Calculate the package contribution margin.
2. Calculate the package break-even point in units for duffle bags, carry-on suitcases and deluxe suitcases.
3. If Travel On Limited has a target income for the coming year of $300,000, how many packages will company have to sell?
4. Based on your answer in Part 3, prepare a contribution margin income statement for the coming year.
5. What is the company's margin of safety in packages?
Question 7: Quality Cost Report
At the beginning of the year, Candy Company initiated a quality improvement program. The program was successful in reducing scrap and rework costs. To help assess the impact of the quality improvement program, the following data were collected for 2016 and 2015:
|
2015
|
2016
|
Sales
|
$5,000,000
|
$5,000,000
|
Quality training
|
6,000
|
9,000
|
Material inspections
|
15,000
|
12,000
|
Scrap
|
80,000
|
60,000
|
Rework
|
15,000
|
12,000
|
Product inspection
|
25,000
|
30,000
|
Product warranty
|
150,000
|
120,000
|
Required:
1. Prepare a Quality Cost Report for the two years (4 Marks) and compute each category of quality costs as a percentage of sales for each year. (Round to two decimal places).
2. How much has profit increased as a result of quality improvements?
3. If quality costs can be reduced to 2.5 percent of sales, how much additional profit would result?
Question 8: Process costing
Xanadu Company manufactures a product that passes through two departments, Assembly and Finishing. In the Finishing Department, materials are added at the end of the process. Conversion costs are incurred uniformly throughout the process. During the month of January, the Finishing Department received 60,000 units from the Assembly Department. The transferred-in cost of the 60,000 units was $69,900.
Costs added by Finishing during January included the following:
Direct materials - $35,200
Direct labour - $56,000
Overhead - $25,600
On January 1, the Finishing Department had 10,000 units in inventory that were 30 percent complete with respect to conversion costs. On January 31, 12,000 units were in inventory, one- third complete with respect to conversion costs. The costs associated with the 10,000 units in beginning inventory were as follows:
Transferred-in cost - $11,650
Direct labour - $8,750
Overhead - $4,000
Required:
1. Prepare a cost of production report for the Finishing Department using the weighted average method.
2. Explain the role of the departmental production report in process costing and name the five steps for completing the departmental production report.
3. Explain how non-uniform inputs and multiple departments affect process costing.