Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set.Use the the excel spreadsheet image and show constraints. 10111213141516BDay 1HalDay 1Day 2Day 3TotalDay 2Day 3TotalсVenue Rental9000450012000DFood and Drinks900050005000EEntertainment600050008000Decorations400050007000F$5,000$5,000GStaff and Security600030004000$6,000$5,000$8,000$4,000$5,000$7,000HMiscellaneous300025002000Venue Rental Food and Drinks Entertainment Decorations Staff and Security Miscellaneous$9,000$9,000$6,000$4,500$3,000$12,000$4,000=SUM(C12:H12)=SUM(C13:H13)=SUM(C14:H14)=SUM(112:114)$3,000 $37,000$2,500 $25,000$2,000 $38,000$100,000

Linear Programming is a mathematical and statistical tool that is used in operations management to…

Answered: Finally, due to budget constraint, your…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set.

Use the the excel spreadsheet image and show constraints.