+ Reply to Thread
Results 1 to 6 of 6

Scenario

  1. #1
    Registered User
    Join Date
    10-12-2006
    Location
    CA
    Posts
    31

    Scenario

    I need some help. The book does not describe in enough detail for me.

    I have to create 6 scenarios.
    Steady-One: Steady economy. 8% pay raise, and a work-rules agreement is reached that does relax the work rules.

    Steady-Two: Steady economy. 2% pay raise, and work-rules agreement is not reached to relax the rules.

    Up-One: Up economy, 2% pay raise and work-rules agreement is not reached to relax the work rules.

    Up-Two: Up economy, 8% pay raise and work-rules agreement is reached to relax the work rules.

    Down-One: Down economy, 8% pay raise, and work-rules agreement is reached to relax the rules.

    Down-Two: Down economy, 2% pay raise, and work rules agreement is not rached.
    __________________________________________

    The likely finanical results in each scenario will act as a negotation guide to management. You will run "what-if" scenarios with the six sets of input values.

    Perform the proceduers and set up and run the Scenario Manager. Record the six possible scenarios. The changing cells are the cells used to input the economic outlook, pay rate increase, and work rule agreement. (In the Scenario Manager, you can enter non-contiguous cell ranges as follows: C20.... F20, C21, C22. Cell addresses are arbitary). The Output cells are the 2009 Summary of Key Results cells.

    assignment.zip

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    This is a challenging assignent and I'm sure you'll lear a lot once YOU work it out!
    Best regards,

    Ray

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Ray,

    Very well done ... !!!
    Couldn't agree more ...

    Cheers
    Carim

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Gotta tell you i felt exacly the same!, it didnt half make me chuckle when i read these responses!

    Regards,
    Simon

  5. #5
    Registered User
    Join Date
    10-12-2006
    Location
    CA
    Posts
    31
    it's not funny. it's due tomorrow (monday) and i didn't start it yet. i don't even know where to start. can you guys just help me please? what am i supposed to do, put the 8% in each cell.. because i just don't understand ANY of it. it's not at all funny.

  6. #6
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Punkie....really sorry but it would be classed as cheating!, the tutors are there for a reason....so if you dont understand ASK!.

    Now if your anything like my kids you will have sat on this for a week or two and then panicked when there was only a day or two left!

    Honesty is your best policy..........ask your tutor to explain and run through a similar scenario to give you the basics.

    Regards,
    Simon

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1