Hi, I need to know how to formulate the goal programming model for this problem. I would also like to know how to input this information into Excel and/or QM for Windows and how to obtain these optimal solutions for this goal programming problem: x2 = 1 d1? = 1.01 x4 = 1 d2? = 1 x6 = 1 d3+ = 0.15 x7 = 1 d7? = 2 All goals achieved except priority 6 Thank you so much!

Infocomp Systems Lab is a research and development (R&D) company that develops computer systems and software primarily for the medical industry. The lab has proposals from its own researchers for eight new projects. Each of the proposed research projects requires limited resources, and it is not possible to undertake all of them. The following table shows the developmental budget, the number of researchers, and the expected annual sales from each project if successfully developed and implemented Developmental Budget ($1,000,000s) Number of Research Expected Annual Sales Personnel Project ($1,000,000s) 0.675 0.82 1.050 1.75 0.725 1.60 4 0.430 8 1.90 1.240 10 0.93 0.890 1.70 1.620 1.30 8 1.200 6 1.80 The lab has developed the following set of prioritized goals for selecting which projects to initiate