as well as Question 2 Linear Programming Cromosks) Oakey wines is considering expanding on foom the cafe to build a restaurant that will provide an evening experience of a meal, wine and entertaiment. The Package will be used to showcase New season wines Provide a winemder to explain the wine throughout the Night with a set menu. To ensure the evening is affordable to most people, there will be three Iwols OF Packages offered : Deluxe Royal an loxy. Each Package Includes a 3a course meal, enter tainment for the Night and matching wine. The 3 Packages costs are shown below: Deluxe Royal Luxury - Selling Price So55 65 - Direct to viel 21 20 6 21 21 22 6 6 - Direct Labour - variable over had Fixed over head wap 3 3 All Packages include entree, main, dessert and wine with the Deluxe and Royal Including some there with a winemakes. The time requirements per Personare below as well as the available time, all hours. Constraints Deluxe Royal Luxury Available hours 1 Entree 0-25 0-25 G malm 1 . 120 Dessert OS 03 -25 6w Lerine Selection and prep .5-25-25 200 winemaker 15 . 310 Required Ce formulate a linear Program to determine the expecsed mix of meal Packages to ensure that maximum Profit will be created. Show all supporting calevlahon and Solve using a computer Package (eg solves in Excel) to derive the optimon solution. Csmarks) upon reviewing the constraints, it has been noticed that the majority of direct Labour has been Incorrectly allocited to the deluxe Package. The monger revised these to: Deluxe Royal Luxur Selling 65 5055 - Vorable oves her - fixed overhead Formualte 4 second Liner Pooram taking into consider 6) Discuss the results from both of the solver Solution what recommendtion of Changes do you Suggest for Oakey wines ? Police Direct material 20 1512 66 6 333 tion the changes. (5 marks) Cromarks) as well as Question 2 Linear Programming Cromosks) Oakey wines is considering expanding on foom the cafe to build a restaurant that will provide an evening experience of a meal, wine and entertaiment. The Package will be used to showcase New season wines Provide a winemder to explain the wine throughout the Night with a set menu. To ensure the evening is affordable to most people, there will be three Iwols OF Packages offered : Deluxe Royal an loxy. Each Package Includes a 3a course meal, enter tainment for the Night and matching wine. The 3 Packages costs are shown below: Deluxe Royal Luxury - Selling Price So55 65 - Direct to viel 21 20 6 21 21 22 6 6 - Direct Labour - variable over had Fixed over head wap 3 3 All Packages include entree, main, dessert and wine with the Deluxe and Royal Including some there with a winemakes. The time requirements per Personare below as well as the available time, all hours. Constraints Deluxe Royal Luxury Available hours 1 Entree 0-25 0-25 G malm 1 . 120 Dessert OS 03 -25 6w Lerine Selection and prep .5-25-25 200 winemaker 15 . 310 Required Ce formulate a linear Program to determine the expecsed mix of meal Packages to ensure that maximum Profit will be created. Show all supporting calevlahon and Solve using a computer Package (eg solves in Excel) to derive the optimon solution. Csmarks) upon reviewing the constraints, it has been noticed that the majority of direct Labour has been Incorrectly allocited to the deluxe Package. The monger revised these to: Deluxe Royal Luxur Selling 65 5055 - Vorable oves her - fixed overhead Formualte 4 second Liner Pooram taking into consider 6) Discuss the results from both of the solver Solution what recommendtion of Changes do you Suggest for Oakey wines ? Police Direct material 20 1512 66 6 333 tion the changes. (5 marks) Cromarks)