I am new to excel 2010 solver, so I need to know where to put the information in

Question

I am new to excel 2010 solver, so I need to know where to put the information in excel. I have the answer but I need to know how to do the problem. Please help I only need to know how to put the information in excel solver.

The famous Y. S. Chang Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 a.m., 7 a.m., 11 a.m., 3 p.m., 7 p.m., or 11 p.m., and ea. works an 8-hour shift. The following table shows the minimum number of workers needed during the six periods into which the day is divided. Chang's scheduling problem is to determine how many waiters and busboys should report for work at the start of each time period to minimize the total staff required for one day's operation. (Hint: Let X1 equal the number of waiters and busboys beginning work in time period i, where i = 1,2,3,4,5,6.)

Period         Time                      # of waiters & busboys required

1            3 a.m. - 7.a.m.                            3

2            7 a.m. - 11.a.m.                        12

  3            11 a.m. - 3 p.m.                        16

4             3 p.m. - 7 p.m.                         9

5             7 p.m. - 11 p.m.                     11

6             11 p.m. - 3 a.m.                       4

Explanation / Answer

http://www.excel-easy.com/examples/assignment-problem.html

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.