My Math Forum  

Go Back   My Math Forum > Science Forums > Computer Science

Computer Science Computer Science Forum


Reply
 
LinkBack Thread Tools Display Modes
December 3rd, 2010, 01:01 PM   #1
Newbie
 
Joined: Dec 2010

Posts: 2
Thanks: 0

LP, matrix and multiple conditions

I am up against an ultimate hard task with my homework.

I must organize an optimal cost saving work scheduling table with excel

Here is link for the whole case (question 2; the second half of the text)
http://itdc.im.cyut.edu.tw/~jerry/op...n/ch11Cas2.pdf


I think this is ultimate hard to solve by hand. I donīt assume you know how this is solved but if you can help me I am more than thankful!
viliperi is offline  
 
December 3rd, 2010, 07:35 PM   #2
Global Moderator
 
CRGreathouse's Avatar
 
Joined: Nov 2006
From: UTC -5

Posts: 16,046
Thanks: 938

Math Focus: Number theory, computational mathematics, combinatorics, FOM, symbolic logic, TCS, algorithms
Re: LP, matrix and multiple conditions

Calculate the number of hours you need. To get the best price you want to shoot for about half full-time and half part-time. Part-time employees are easy to schedule, so start with the full-time employees and try to fit them in as best you can. Once you schedule in half the hours that way, fill the rest with part-time workers. Now move on to figuring out the split between baggers and stockers, keeping in mind the requirements. Once you have that, move on to fairness issues in terms of who works what shifts.
CRGreathouse is offline  
December 4th, 2010, 08:55 AM   #3
Newbie
 
Joined: Dec 2010

Posts: 2
Thanks: 0

Re: LP, matrix and multiple conditions

Ok, I try to figure it out now.

Tank you for your helpful advice. Now it is easier to prioritise the tasks!
viliperi is offline  
December 4th, 2010, 05:40 PM   #4
Global Moderator
 
CRGreathouse's Avatar
 
Joined: Nov 2006
From: UTC -5

Posts: 16,046
Thanks: 938

Math Focus: Number theory, computational mathematics, combinatorics, FOM, symbolic logic, TCS, algorithms
Re: LP, matrix and multiple conditions

Glad to help. Let us know how this goes (and if you need help again, feel free to post).
CRGreathouse is offline  
Reply

  My Math Forum > Science Forums > Computer Science

Tags
conditions, matrix, multiple



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How is the initial conditions for PDE? Jhenrique Calculus 7 January 16th, 2014 10:01 PM
Exponents - conditions arnold Number Theory 8 September 20th, 2011 10:40 AM
Field Conditions NightBlues Advanced Statistics 1 September 7th, 2010 01:11 PM
conditions without if statements metaphist Algebra 3 April 3rd, 2010 04:53 AM
probability of multiple events with multiple trials prwells32 Advanced Statistics 4 January 30th, 2010 02:42 PM





Copyright © 2019 My Math Forum. All rights reserved.