translators - 8d915d8f2ec09697ec72b36679cbdcf2b3299059.xls...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
8d915d8f2ec09697ec72b36679cbdcf2b3299059.xls translators setup Translator Hiring Problem Demand Historical Level Frequency Chance of Overtime Availability 35% 0 1% Fixed Cost per Translator $10.00 1 2% Regular Order Cost $50.00 2 5% Overtime Order Cost $75.00 3 5% Revenue per Filled Order $95.00 4 7% 5 8% Translators Hired #NAME? 6 9% 7 11% Actual Demand #NAME? 8 13% Overtime Translators Available #NAME? 9 13% 10 9% Regular Orders Filled #NAME? 11 9% Overtime Orders Filled #NAME? 12 5% 13 1% Fixed Cost #NAME? 14 1% Regular Cost #NAME? 15 1% Overtime Cost #NAME? Total Cost #NAME? Revenue #NAME? Profit #NAME? Orders not Filled #NAME? A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
YASAI Simulation Output Workbook translators.xls YASAI Version: 1.1 Sheet Values Use Same Seed? Yes Start Date 1/2/2003 Random Number Seed: 1 Start Time 1:42:22 PM Run Time (h:mm:ss) 0:00:36 Scenarios: 8 Sample Size: 1000 Parameter Scenario Translators Hired 1 5 2 6 3 7 4 8 5 9 6 10 7 11 8 12 Output Name Scenario Mean Orders Refused 1 1000 1.732 2.049 Orders Refused 2 1000 1.006 1.583 Orders Refused 3 1000 0.547 1.151 Orders Refused 4 1000 0.245 0.755
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

translators - 8d915d8f2ec09697ec72b36679cbdcf2b3299059.xls...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online