In: Accounting
Player’s Sports has a machine that can be used to sharpen skill-saws and/or sharpen skates. The machine is available 8 hours per day for 25 days per month.
They charge $22.00 to sharpen a skill-saw. This process consumes $2.00 worth of supplies. The machine can sharpen 2 skill-saws per hour.
They charge $5.25 to sharpen a pair of skates. The process consumes $0.25 worth of supplies.
Each skate uses 3 minutes of machine time (6 minutes per pair).
The total demand for skill-saw sharpening is 800 per month.
The total demand for skate sharpening is 1,200 pairs per month.
Fixed costs related to the machine (insurance, repair contract, labour, amortization, etc.) total $3,200 per month. The marginal tax rate is 40%.
Required:
Question 2 – Activity Costing Exercise
“We just can’t seem to make any money”, exclaimed the President. “Profits are falling every month. This month we lost money. What is going on?”
A quick look at the books revealed that the company had $250,000 in manufacturing overhead costs. The $250,000 had traditionally been applied based on Direct Labour hours. The company used 10,000 Direct Labour hours, so a pre-determined rate of $25 per Direct Labour Hour was used.
Product Y |
Product Z |
||||
Direct Materials |
$10 |
$18 |
|||
Direct Labour |
|||||
(1 hour) |
$20 |
||||
(2 hours) |
$40 |
||||
Manufacturing Overhead |
$25 |
$50 |
|||
Total Cost |
$55 |
$108 |
|||
The company has been selling 5 of the cheaper product Y for each unit of Product Z. The company used a 40% markup to cover non-manufacturing operating costs.
Product Y |
Product Z |
||||
Selling Price |
$77.00 |
$151.20 |
|||
An in-plant study recently revealed that the $250,000 could be traced to the following activities:
Activity |
Cost |
Total Number for Year |
Material moves |
$30,000 |
15,000 moves |
Inspections |
$20,000 |
20,000 inspections |
Machinery hours |
$90,000 |
9,000 machine hours |
Testing |
$10,000 |
5,000 tests |
Setups |
$60,000 |
60,000 setups |
Receiving |
$40,000 |
10,000 orders processed |
$250,000 |
Further inspection revealed the following activities related to Products Y and Z.
Product Y |
Product Z |
|
Material moves |
3 |
4 |
Inspections |
2 |
3 |
Machinery hours |
2 |
1 |
Testing |
3 |
3 |
Setups |
4 |
6 |
Receiving |
2 |
1 |
Required: Advise the President on the cause and solution for the current dilemma.
Determine what the new selling prices should be for Products Y and Z.
Question 3 – Job Costing
On March 1, Pixma Company had the following balances in its inventory accounts:
Raw Materials $42,000
Work in Process $ 9,905
Finished Goods $ 0
Work in Process of $9,905 on March 1 was made up of three jobs with the following costs:
Job 817 |
Job 818 |
Job 819 |
|
Raw materials |
$2,100 |
$1,410 |
$1,915 |
Direct labour |
900 |
850 |
1,050 |
Applied overhead |
540 |
510 |
630 |
Hint:
Add these to get your beginning WIP amounts for March.
During March, the following transactions occurred:
[Hint: Look at the overhead applied to Jobs 817-819 to determine the overhead rate.]
Required:
Use the reverse side of this page.
Q1)
Company's Limiting Factor is Machine Hours. In total company has (25 Day * 8 hours a Day) 200 Hours a Month.
Now we have to find out the contribution margin & contribution margin per limiting factor for each product.
Contribution Margin & Contribution Margin Per Limiting Factor for Skill Saw:-
Contribution Margin = Selling Price - Variable Cost
= 22 - 2
= 20
Contribution Margin Per Limiting Factor =
Contribution Margin/Limiting Factor
= 20/2 hours
= 10 per hour
Contribution Margin & Contribution Margin Per Limiting Factor for Skates
Contribution Margin = 5.25 - .25
= 5
Contribution Margin Per Limiting Factor = 5/.1
= 50
(It takes 6 minutes to do the work of one pair of Skates. So 6 Minutes/60 Minutes = .1Hours to complete one Pair)
So here Skates Has the Highest Contribution Margin Per Limiting Factor. So Company should produce it first & maximum.
Demand for Skates are 1,200
So it would require (1,200*6) 7,200 Minutes. Which means (7,200/60) 120 Hours.
Remaining Time is (200-120) 80 Hours. Each Skill Saw Require 2 Hours. So we can sell (80/2) 40 Skill Saw Sharpening.
Computation of Operating Income & Net Income
Revenue:-
Skill Saw 40*22 880
Skates 1,200*5.25 6,300
7,180
- Variable:-
Skill Saw 40*2 80
Skates 1,200*.25 300
380
Total Contribution Margin 6,800
- Total Fixed Cost 3,200
Operating Income 3,600
- Tax @ 40% 1,440
Net Income 2,160