Question

Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study...

Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs:

Number of employees 6
Average salary per employee $ 29,500
Weeks of employment per year 52
Hours worked per week 40
Practical capacity percentage 85 %
Requisition Processing Bid Evaluation Inspection
Minutes per unit of the activity 15 45 30
Job X Job Y Job Z
Number of requisitions processed 7 4 3
Number of bid evaluations 3 2 4
Number of inspections 6 2 6

Now assume that Saratoga Company would like to answer the following “what if” question using its time-driven activity-based costing system: Assuming our estimated activity demands for all jobs in the next period will be as shown below, how will this affect our job costs and our staffing levels within the Purchasing Department?

Requisition Processing Bid Evaluation Inspection
Activity demands for all jobs 1,800 4,200 8,200

Required:

1. Will the revised activity demands affect the total Purchasing Department labor costs assigned to Job X, Job Y, and Job Z?

2. Using the revised activity demands, calculate Saratoga’s used capacity in minutes.

3. Using the revised activity demands, calculate Saratoga’s unused capacity in minutes.

4. Using the revised activity demands, calculate Saratoga’s unused capacity in number of employees. (Round your answer to 2 decimal places.)

5. Based on the revised activity demands, calculate the impact on expenses of matching capacity with demand. (Be sure to round down your potential adjustment in the number of employees to a whole number. Negative amount should be indicated by a minus sign.)

1 Revised activity demands affect total Purchasing Department labor costs assigned to Jobs X, Y, and Z ? No
2 Used capacity in minutes
3 Unused capacity in minutes
4 Unused capacity in number of employees
5 Impact on expenses of matching capacity with demand

Homework Answers

Answer #1

A

Number of employees

6

B

Average salary per employee

29500

C

Weeks of employment

52

D

Hours per week

40

E

Practical capacity %

85%

F

Maximum capacity hours (A*C*D)

12480

G

Practical capacity hours (F*E)

10608

Particulars

Requistion
processing

Bid
Evaluation

Inspection

Total

H

Activity demand

1800

4200

8200

I

Minutes required per activity

15

45

30

J

Used capacity in minutes (H*I)

27000

189000

246000

462000

K

Practical capacity minutes (G*60)

636480

L

Unused capacity minutes (K-J)

174480

M

Per employee practical capacity (mins) per annum (C*D*E*60)

106080

N

Unused Capacity (no of employees) (L/M)

1.645

O

Impact on expenses on matching capacity with demand ($) (N*B)

48521.49

Requirements :

1.

Revised activity demands affect total Purchasing Department labor costs assigned to Jobs X, Y, and Z = NO

No

2

Used capacity in minutes = 462,000

3

Unused capacity in minutes = 174,480

4

Unused capacity in number of employees = 1.645

5

Impact on expenses of matching capacity with demand = $ -45821.49

kindly upvote

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study...
Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs: Number of employees 9 Average salary per employee $ 28,000 Weeks of employment per year 52 Hours worked per week 40 Practical capacity percentage 85 % Requisition...
Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study...
Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs: PLEASE ONLY ANSWER #4 & #5 Number of employees 8 Average salary per employee $ 28,500 Weeks of employment per year 52 Hours worked per week 40...
Exercise 7A-3 Time-Driven Activity-Based Costing [LO 7-6, LO 7-7] Saratoga Company manufactures jobs to customer specifications....
Exercise 7A-3 Time-Driven Activity-Based Costing [LO 7-6, LO 7-7] Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs: Number of employees 23 Average salary per employee $ 21,500 Weeks of employment per year 52 Hours worked...
Exercise 7A-1 Time-Driven Activity-Based Costing [LO 7-6] Saratoga Company manufactures jobs to customer specifications. The company...
Exercise 7A-1 Time-Driven Activity-Based Costing [LO 7-6] Saratoga Company manufactures jobs to customer specifications. The company is conducting a time-driven activity-based costing study in its Purchasing Department to better understand how Purchasing Department labor costs are consumed by individual jobs. To aid the study, the company provided the following data regarding its Purchasing Department and three of its many jobs: Number of employees 20 Average salary per employee $ 25,000 Weeks of employment per year 52 Hours worked per week...
1.Lemaire Corporation is conducting a time-driven activity-based costing study in its Customer Support Department. The company...
1.Lemaire Corporation is conducting a time-driven activity-based costing study in its Customer Support Department. The company has provided the following data to aid in that study: Lemaire Corporation Customer Support Department Data Inputs Resource Data: Number of employees 17 Average salary per employee $ 38,700 Practical capacity per employee (in minutes) 90,000 Activity Data: Receiving Calls Resolving Issues Settling Disputes Minutes per unit of the activity 10 26 44 Cost Object Data: All Customers Number of calls received 34,710 Number...
Hollifield Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company...
Hollifield Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company has provided the following data to aid in that study: Hollifield Corporation Order Fulfillment Department Data Inputs Resource Data: Number of employees 18 Average salary per employee $ 33,300 Weeks of employment per year 50 Minutes available per week (40 hours × 60 minutes) 2,400 Practical capacity percentage 75 % Activity Data: Processing Orders Preparing Deliveries Handling Returns Minutes per unit of the activity...
1. Choi Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The...
1. Choi Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company has provided the following data to aid in that study: Activity Data: Processing Orders Preparing Deliveries Handling Returns Minutes per unit of the activity 14 30 32 Cost Object Data: Customer P Customer Q Customer R Number of orders processed 32 24 3 Number of deliveries prepared 14 9 9 Number of returns handled 0 0 1 The cost per minute of the...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
Job Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost    Driver Amount of Driver Materials handling $ 72,000      Number of moves 3,000   Engineering 165,000      Number of change orders 10,000   Other overhead 280,000      Direct labor hours 50,000   Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44...
ob Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing...
ob Costs Using Activity-Based Costing Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows: Activity Cost Driver Amount of Driver Materials handling $117,500 Number of moves 5,000 Engineering 128,000 Number of change orders 8,000 Other overhead 265,200 Direct labor hours 52,000 Heitger worked on four jobs in July. Data are as follows: Job 13-43 Job 13-44 Job...
Zayner Company is a job-order costing firm that use activity based costing to apply overhead to...
Zayner Company is a job-order costing firm that use activity based costing to apply overhead to jobs. Zayner identified three overhead activities and their related drivers. Budgeted information for the year is as follows: Zayner Company is a job order costing company that uses activity-based costing (ABC) to apply manufacturing overhead to different jobs. Zayner identified three activities and the related cost drivers. The budgeted information (budget) for the year is as follows: Activity Cost Driver Amount of Driver Engineering...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT