Introduction to Management Science

please need specific answer. The spreadsheet model (process) & algebraic model

Correct spreadsheet model, quality of spreadsheet model, correct algebraic model and explanations.

Learned Integer Optimization

- Selection problems

- Assignment Problems

- Packing Problems

Develop an Excel spreadsheet optimization model to solve the SUITCASE PACKING problem that is described below. In addition to solving the problem correctly, the model should be clear and well presented. Also type the corresponding algebraic model SUITCASE PACKING Problem A woman wants to decide the items to include in her luggage to comply with space (32000 cm3 max) and weight (4000 grams max) regulations. She will buy a warm jumper at her destination The items under consideration are shown in the table. The weight in grams and volume in cm3 is given for each item. She wants to maximise the number of 'fashionable outfits' available at her destination, in addition to another dress that she will wear during the flight. Each dress counts as an outfit and also a combination of blouse or jumper and either skirt or trousers count as an outfit. However, certain combinations are not 'fashionable'. The table shows the 'fashionable combinations marked with an X. Jumper 1 234 Trousers Blouses Dresses Skirts2X weight (x 100) volume 1 231 2 3 1 2 3 41 2 3 6 4.5 76 5.5 53.5 334.5 67 8 3 3.5 6 44 3.5 35 6 5 4 Trousers 2 XX (x 1000) 53.5