Assignment Prompt & Instructions
see attached
– ## UnitVIInstructions-2.docx
– ## UnitVITemplate.xlsx
**## UnitVIInstructions-2.docx**
You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of employees needed. Complete the
[Unit VI Assignment Template](https://online.columbiasouthern.edu/bbcswebdav/pid-17551117-dt-asiobject-rid-182285654_1/xid-182285654_1) for this assignment and submit it for grading in Blackboard.
**## UnitVITemplate.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<br> <br>Thanasak Ruankaew: Author:<br>@ 1 labor hour per unit per row #4 | 40,000 | 41,000 | 42,000 | 38,000 | 161,000 |
| Average hours per quarter per employee<br> <br>Thanasak Ruankaew: Author:<br>Each employee can work 480 hours per quarter | 480 | 480 | 480 | 480 |
| Approximate number of employees needed<br> <br>Thanasak Ruankaew: Author:<br>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: |
**## UnitVITemplate.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<br> <br>Thanasak Ruankaew: Author:<br>@ 1 labor hour per unit per row #4 | 40,000 | 41,000 | 42,000 | 38,000 | 161,000 |
| Average hours per quarter per employee<br> <br>Thanasak Ruankaew: Author:<br>Each employee can work 480 hours per quarter | 480 | 480 | 480 | 480 |
| Approximate number of employees needed<br> <br>Thanasak Ruankaew: Author:<br>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: |
**## UnitVIInstructions-2.docx**
You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of employees needed. Complete the
[Unit VI Assignment Template](https://online.columbiasouthern.edu/bbcswebdav/pid-17551117-dt-asiobject-rid-182285654_1/xid-182285654_1) for this assignment and submit it for grading in Blackboard.
**## UnitVITemplate.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<br> <br>Thanasak Ruankaew: Author:<br>@ 1 labor hour per unit per row #4 | 40,000 | 41,000 | 42,000 | 38,000 | 161,000 |
| Average hours per quarter per employee<br> <br>Thanasak Ruankaew: Author:<br>Each employee can work 480 hours per quarter | 480 | 480 | 480 | 480 |
| Approximate number of employees needed<br> <br>Thanasak Ruankaew: Author:<br>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: |
**## UnitVIInstructions-2.docx**
You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of employees needed. Complete the
[Unit VI Assignment Template](https://online.columbiasouthern.edu/bbcswebdav/pid-17551117-dt-asiobject-rid-182285654_1/xid-182285654_1) for this assignment and submit it for grading in Blackboard.
**## UnitVITemplate.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<br> <br>Thanasak Ruankaew: Author:<br>@ 1 labor hour per unit per row #4 | 40,000 | 41,000 | 42,000 | 38,000 | 161,000 |
| Average hours per quarter per employee<br> <br>Thanasak Ruankaew: Author:<br>Each employee can work 480 hours per quarter | 480 | 480 | 480 | 480 |
| Approximate number of employees needed<br> <br>Thanasak Ruankaew: Author:<br>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: |
– 1
– 2