Unit VII

profilebreal

see attachment

  • 7 months ago
  • 12
files (3)

UnitVIITemplate.xlsx

Problem

ABC Manufacuring Instructions:
Direct Labor Budget for the Year Ending Dec 31, 202X 1. Review the data given, fill in the information in yellow cells to determine number of employees needed.
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year
Direct labor hours per unit 1 1 1 1 1
Labor rate per hour $20.00 $20.00 $20.00 $20.00 $20.00 2. Based on the calculations result and information given, address how this information can be useful for managers in terms of scheduling, planning, and control. Include ethical considerations in the budget process. Type your response in the box below.
Direct labor cost per unit
Units to be produced 40,000 41,000 42,000 38,000 161,000
Total direct labor cost
Total hours needed
Thanasak Ruankaew: Author: @ 1 labor hour per unit per row #4
40,000 41,000 42,000 38,000 161,000
Average hours per quarter per employee
Thanasak Ruankaew: Author: Each employee can work 480 hours per quarter
480 480 480 480
Approximate number of employees needed
Thanasak Ruankaew: Author: Students may round up the value.
3. Brieftly address how regulatory and compliance requirements (e.g., minimum wage, benefits, safety, etc.) might impact labor costs and pricing decision. Type response in the below box.
Name:
Date: