A Decision Support System (DSS) for the iTab Company

You have been hired by management of the iTab Company to help determine a production plan for the next year. After studying the information you have collected (see Attachment 1), you decide to develop an Excel spreadsheet simulation (see Attachment 2 for a sample format). Specifically, you would like to use this application to address two issues:

  1. To recommend a production plan (Plan A) for the next 12 calendar months. Your plan must meet all the policy constraints as listed in Attachment 1 (e.g., hiring, firing, overtime, minimum workforce, demand, and minimum inventory). You have been given a minimum gross profit target for the next 12 months at $1,500,000.
  2. To study the impact of the policy that limits hiring to 30 percent, and firing to 10 percent, of the existing workforce. For this purpose, you will develop a production plan (Plan B) that lets management 1) increase the wage rate from $12/hour to $14/hour and firing cost from $650 to $800 per worker, and 2) be allowed to hire or fire as many people as it feels necessary in any month (all other constraints still hold, including the minimum workforce requirement). Management of iTab would like to see how a more flexible hiring/firing policy would influence profitability. Not knowing the precise impact of this policy change, management has set a minimum 12-month gross profit target at $1.4 million.
You can leave a response, or trackback from your own site.


5 Responses to “A Decision Support System (DSS) for the iTab Company”

  1. 938855 412846Sweet internet web site , super style and design , rattling clean and utilize genial . 667419

  2. tangerine says:

    9531 138976Id ought to seek advice from you here. Which is not something I do! I adore reading an article that could make men and women feel. Also, several thanks permitting me to comment! 552298

  3. eu dump says:

    599669 262520A persons Are typically Weight loss is certainly a practical and flexible an eating plan method manufactured for people who suffer that want to weight loss and therefore ultimately conserve a a lot a lot more culture. weight loss 644338

  4. 287153 422391I really like this information presented and possesses given me some type of resolve forpersistance to succeed i really enjoy seeing, so sustain the outstanding work. 268220

  5. judi online says:

    316891 294364building websites is not only enjoyable, but it can also generate an income for yourself;; 868961

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes