Turn on thread page Beta
    • Thread Starter
    Offline

    5
    ReputationRep:
    Having trouble working out this question as I don't know how to set it out in excel to find the minimum cost and optimum programmes could some please help me thanks

    As a part of a quality improvement initiative, government employees complete a three- day training programme on teamwork and two-day training programme on problem solving. The manager of quality improvement requested that at least eight training programme on teamwork and at least ten training programmes on problem solving be offered during the next six months. In addition, senior-level management specified that at least 25 training programmes must be offered during this period. A consultant is used to teach the training programmes. During the next six months, the consultant has 84 days of training time available. Each training programme on teamwork costs £10,000 and each training programme on problem solving costs £8,000.

    Use Excel Solver to find the optimum number of programmes while minimising total costs.
    • Study Helper
    Offline

    15
    Study Helper
    (Original post by JoeyA95)
    Having trouble working out this question as I don't know how to set it out in excel to find the minimum cost and optimum programmes could some please help me thanks

    As a part of a quality improvement initiative, government employees complete a three- day training programme on teamwork and two-day training programme on problem solving. The manager of quality improvement requested that at least eight training programme on teamwork and at least ten training programmes on problem solving be offered during the next six months. In addition, senior-level management specified that at least 25 training programmes must be offered during this period. A consultant is used to teach the training programmes. During the next six months, the consultant has 84 days of training time available. Each training programme on teamwork costs £10,000 and each training programme on problem solving costs £8,000.

    Use Excel Solver to find the optimum number of programmes while minimising total costs.
    You want to start by writing it as an l.p. problem.
    • Thread Starter
    Offline

    5
    ReputationRep:
    (Original post by ghostwalker)
    You want to start by writing it as an l.p. problem.
    Yeah I've done that

    Decision variables
    X1 number of teamwork programme
    X2 number of problem solving programme

    Objective Func

    Min 8000X1+10000X2

    Constraints

    X1+X2>25
    X1+X2<84
    X1>8
    X2>10
    • Study Helper
    Offline

    15
    Study Helper
    (Original post by JoeyA95)
    Yeah I've done that

    Decision variables
    X1 number of teamwork programme
    X2 number of problem solving programme

    Objective Func

    Min 8000X1+10000X2

    Constraints

    X1+X2>25
    X1+X2<84
    X1>8
    X2>10
    Your strict inequalities shouldn't be. They're all \geq or \leq

    And X1+X2<84 should be 3X1 + 2X2 <= 84 taking the number of days each course runs into account .

    Personally, I find it easier to use P and T; it's easier to keep track.

    What's the problem you're having with the Solver then?
    • Thread Starter
    Offline

    5
    ReputationRep:
    i don't know how to design the model in excel ive set it out like a product mix example but it doesn't work ive attached my file
    Attached Files
  1. File Type: xlsx TrainingProgramme.xlsx (10.2 KB, 57 views)
    • Study Helper
    Offline

    15
    Study Helper
    (Original post by JoeyA95)
    i don't know how to design the model in excel ive set it out like a product mix example but it doesn't work ive attached my file
    You don't seem to have any formulae in the G16:G19 cells, so usage is not tied in to the X1,X2 values.

    Also, the E18:F19 square should have one "1" and one "0" in each row. Whichever way around.
    • Thread Starter
    Offline

    5
    ReputationRep:
    ok ive updated it but i dont think its the correct answer
    Attached Files
  2. File Type: xlsx TrainingProgramme.xlsx (10.3 KB, 58 views)
    • Study Helper
    Offline

    15
    Study Helper
    (Original post by JoeyA95)
    ok ive updated it but i dont think its the correct answer
    The E18:F19 square wants to be:

    10
    01

    Not

    10
    10

    Also I think you have the "Cost per programme" values the wrong way round.

    I think that's it.

    It's just a question of checking what you have matches the lp.
    • Thread Starter
    Offline

    5
    ReputationRep:
    (Original post by ghostwalker)
    The E18:F19 square wants to be:

    10
    01

    Not

    10
    10

    Also I think you have the "Cost per programme" values the wrong way round.

    I think that's it.

    It's just a question of checking what you have matches the lp.
    brilliant i think thats right now thanks for you help
    • Study Helper
    Offline

    15
    Study Helper
    (Original post by JoeyA95)
    brilliant i think thats right now thanks for you help
    You're welcome.
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: November 1, 2016
The home of Results and Clearing

3,642

people online now

1,567,000

students helped last year

University open days

  1. SAE Institute
    Animation, Audio, Film, Games, Music, Business, Web Further education
    Thu, 16 Aug '18
  2. Bournemouth University
    Clearing Open Day Undergraduate
    Fri, 17 Aug '18
  3. University of Bolton
    Undergraduate Open Day Undergraduate
    Fri, 17 Aug '18
Poll
Will you be tempted to trade up and get out of your firm offer on results day?
Useful resources

Make your revision easier

Maths

Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

Equations

How to use LaTex

Writing equations the easy way

Student revising

Study habits of A* students

Top tips from students who have already aced their exams

Study Planner

Create your own Study Planner

Never miss a deadline again

Polling station sign

Thinking about a maths degree?

Chat with other maths applicants

Can you help? Study help unanswered threads

Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.