Production Line Calculations.

TazmanDev

New Member
Joined
Nov 3, 2018
Messages
1
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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,214,651
Messages
6,120,744
Members
448,989
Latest member
mariah3

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