Question

In: Accounting

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 24
Average salary per employee $ 21,000
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 6 3 2
Number of bid evaluations 4 3 5
Number of inspections 7 3 7

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 20,500 24,750 25,900

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.)

Solutions

Expert Solution

Answer with working is given below


Related Solutions

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: Number of employees 17 Average salary per employee $ 24,500 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: Number of employees 18 Average salary per employee $ 27,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: Number of employees 24 Average salary per employee $ 21,000 Weeks of employment per year 52 Hours worked per week 40 Practical capacity percentage 85 % Requisition...
Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department.
Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the study, the company provided the following data regarding its Shipping Department and the customers served by the department.Required: 1. Using the customer cost analysis as demonstrated in Exhibit 7A-2 in your textbook, compute the following: a. The cost per minute of the resource supplied in the Shipping Department. b. The time-driven activity rate for each of Stahl's three activities. c.The total labor costs consumed by Customer L. Customer...
Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the...
Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the study, the company provided the following data regarding its Shipping Department and the customers served by the department: Number of employees 30 Average salary per employee $ 30,000 Weeks of employment per year 52 Hours worked per week 40 Practical capacity percentage 85 % Line-Item Picking Packaging Loading Deliveries Minutes per unit of the activity 5 15 30 Customer L Customer M Customer N...
Corporation is conducting a time-driven activity-based costing study in its Tech Support Department. The company has...
Corporation is conducting a time-driven activity-based costing study in its Tech Support Department. The company has provided the following data to aid in that study: Jahnel Corporation Tech Support Department Data Inputs Resource Data: Number of employees 7 Average salary per employee $ 43,200 Weeks of employment per year 50 Minutes available per week (40 hours × 60 minutes) 2,400 Practical capacity percentage 90 % Activity Data: Routing Calls Resolving Problems Preparing Change Orders Minutes per unit of the activity...
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...
Spillett Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company...
Spillett 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: Spillett Corporation Order Fulfillment Department Data Inputs Resource Data: Number of employees 22 Average salary per employee $ 43,860 Weeks of employment per year 50 Minutes available per week (40 hours × 60 minutes) 2,400 Practical capacity percentage 85 % Activity Data: Processing Orders Preparing Deliveries Handling Returns Minutes per unit of the activity...
The company for which you work recently implemented time-driven activity-based costing (TDABC) in conjunction with its...
The company for which you work recently implemented time-driven activity-based costing (TDABC) in conjunction with its enterprise resource planning (ERP) system. Management is pleased with the revised product and customer cost information that the TDABC system produces. It is now wondering how this system can be used for budgeting purposes. You have been asked to provide an example of using time-driven activity-based budgeting, given the following information: There are two resources (departments): indirect labor and computer support. There are two...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT