Question i need help to answer

Scott Hughson

New Member
Joined
Feb 28, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
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)
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top