Question i need help to answer

[Scott Hughson]

Hi,
I am looking at resolving the issue below.
Can anyone help?

Shipping work has been printed off and you have the line volumes for each work area, but the labour planning tool is not working. You have a 45 minute window (3 cycles) to process these orders before they need to be handed off to the driver for the departing truck, so you need to calculate the labour required for each work area manually.

• Zone A, 289 Lines, on a target of 152 LPH
• Zone B, 180 Lines, on a target of 96 LPH
• Zone C, 63 Lines, on a target of 37 LPH
• Zone D, 46 Lines, on a target of 70 LPH
• Work zones C & D are at the opposite end of the facility

Based on the above information, please create a 5 minute presentation to outline your strategy on how many people you need in each work zone.
Your presentation should include the following:

• How many labour hours are required to complete this work?
• How much headcount is required in each work zone to get the truck out on time?
• What is your strategy on labour deployment in the work areas?
• Which work zone has the highest production costs?
• How much labour would be required in each work area if there was a 10% decrease in target LPH?
• Assuming each team member earns $22.75/hr., what is the impact to budgets if there was a 10% decrease in target LPH over a fiscal quarter? (65 working days)

 

[etaf]

is this a homework/assignment ?
I dont usually answer these type of questions , as the idea is that this homework is set to see if you understand excel
so if you would perhaps , answer each of the questions , how you would think it needs to be done and where you are stuck

 

[Scott Hughson]

Hi,

Thanks for replying, this is not homework but part of a job interview i have to do as a test for Monday, i was looking for any help that i can get as i am at a loss.