A company specializes in leather boots for children in Northern Jamaica. The process of producing the boots involves both manual labour and machine time. The business has two production departments (but no service departments): (1) Forming and (2) Assembly The factory operates 48 weeks annually and is closed for 4 weeks for maintenance; during this time, all workers go on unpaid vacation leave. LABOUR The factory employs twenty-eight (28) workers who are directly involved in the production process. Each employee works from 8:00 a.m. to 5:00 p.m. daily, Monday to Saturday. Workers are paid hourly, excluding the hour taken for lunch, from 12 noon to 1:00 p.m. Seven (7) of the employees work in the Forming department (mechanized) and are paid $275 per hour, while twenty-one (21) employees work in the Assembly department (labour intensive) and are paid $330 per hour. The company pays for overtime work at time and a half on weekdays and double time on Saturdays; the factory is closed on Sundays. On average, each worker in the Forming department is allowed 6 minutes to gather all the material before Forming. Workers in the Assembly department are allowed 12 minutes to ensure the assembly line is ready for operations. MACHINE TIME There are seven (7) forming machines operated by two workers per machine. The machines are semi-automated. On average, each pair of boots requires 15 minutes of machine time. OVERHEAD RATES Overheads are absorbed on a machine hour basis in the Forming Department and on a labour hour basis in the Assembly Department. MATERIALS Direct materials for production are imported from the United States. The materials imported are as follows: (1) Leather $425 per square foot and (2) Synthetic fibre laces $325 for a pack of 10 (each pair of boot requires 2 laces). Each pair of boots requires 4 square feet of leather. The threads for sewing the edges are considered indirect materials and is included in miscellaneous expenses. BUDGET FOR YEAR ENDING 31 DECEMBER 2019 For the coming year, the company plans to produce 250,000 boots. The labour and machine hours planned for the coming year is based on the estimated production of the boots. Any shortfall in labour hours during regular time will be supplemented through overtime work; 80% on weekdays and 20% on Saturdays. All overtime work will be treated as worked done normally to fulfill production requirements. The following costs are also associated with the operation of the factory: 1) Rental expense; $86,000 per month 2) Insurance of factory, on average $700,000 per annum 3) Janitorial service, $20,000 per month 4) Factory manager's salary is $460,000 per month 5) Miscellaneous factory expenses $270,000 per annum* INFORMATION ABOUT THE PRODUCTION DEPARTMENTS Forming Dept. 3,000 $2,000,000 Area in square meters Plant valuation Assembly Dept. 5,000 $6,000,000 Janitorial hours per year Factory managers oversight *Miscellaneous expenses are utilized equally by both departments 600 55% 400 45% REQUIRED: 1. Prepare an overhead analysis sheet for the business based on the plan for the year ending 31 December 2021 2. Calculate overhead absorption rates for both production departments. 3. Calculate the total cost of overtime pay. A company specializes in leather boots for children in Northern Jamaica. The process of producing the boots involves both manual labour and machine time. The business has two production departments (but no service departments): (1) Forming and (2) Assembly The factory operates 48 weeks annually and is closed for 4 weeks for maintenance; during this time, all workers go on unpaid vacation leave. LABOUR The factory employs twenty-eight (28) workers who are directly involved in the production process. Each employee works from 8:00 a.m. to 5:00 p.m. daily, Monday to Saturday. Workers are paid hourly, excluding the hour taken for lunch, from 12 noon to 1:00 p.m. Seven (7) of the employees work in the Forming department (mechanized) and are paid $275 per hour, while twenty-one (21) employees work in the Assembly department (labour intensive) and are paid $330 per hour. The company pays for overtime work at time and a half on weekdays and double time on Saturdays; the factory is closed on Sundays. On average, each worker in the Forming department is allowed 6 minutes to gather all the material before Forming. Workers in the Assembly department are allowed 12 minutes to ensure the assembly line is ready for operations. MACHINE TIME There are seven (7) forming machines operated by two workers per machine. The machines are semi-automated. On average, each pair of boots requires 15 minutes of machine time. OVERHEAD RATES Overheads are absorbed on a machine hour basis in the Forming Department and on a labour hour basis in the Assembly Department. MATERIALS Direct materials for production are imported from the United States. The materials imported are as follows: (1) Leather $425 per square foot and (2) Synthetic fibre laces $325 for a pack of 10 (each pair of boot requires 2 laces). Each pair of boots requires 4 square feet of leather. The threads for sewing the edges are considered indirect materials and is included in miscellaneous expenses. BUDGET FOR YEAR ENDING 31 DECEMBER 2019 For the coming year, the company plans to produce 250,000 boots. The labour and machine hours planned for the coming year is based on the estimated production of the boots. Any shortfall in labour hours during regular time will be supplemented through overtime work; 80% on weekdays and 20% on Saturdays. All overtime work will be treated as worked done normally to fulfill production requirements. The following costs are also associated with the operation of the factory: 1) Rental expense; $86,000 per month 2) Insurance of factory, on average $700,000 per annum 3) Janitorial service, $20,000 per month 4) Factory manager's salary is $460,000 per month 5) Miscellaneous factory expenses $270,000 per annum* INFORMATION ABOUT THE PRODUCTION DEPARTMENTS Forming Dept. 3,000 $2,000,000 Area in square meters Plant valuation Assembly Dept. 5,000 $6,000,000 Janitorial hours per year Factory managers oversight *Miscellaneous expenses are utilized equally by both departments 600 55% 400 45% REQUIRED: 1. Prepare an overhead analysis sheet for the business based on the plan for the year ending 31 December 2021 2. Calculate overhead absorption rates for both production departments. 3. Calculate the total cost of overtime pay.