Use Microsoft excel Spreadsheets. $100,000 is the total budget. Use the picture as an example for the format. ▪ You are hosting an important event (Event examples: Graduation celebration, Family Reunion, Wedding, etc) and there will be about 100guests (not fellow students) attending. The event will be for three (3) consecutive days. It is now up to you to make this a successful event.Over the next week you need to identify tasks, set priorities and come up with a plan to make this happen.You have initial budget of $100,000.00.o You must identify at least five (5) areas/tasks where you need to spend this money for the three days of the event, example hall rental,equipment rental, food and drinks, entertainment, etc.o You must create an initial budget sheet showing the distribution of the $100,000 for the three days. raLO032-& Ca15 Canof Format PeterChytont56BPage Layod12-PuidTermudasX✓& Professional FeesA1 EXAMPLE 22341.Type here to searchAAADutaSheBevonMALTDAY 17DAY 28 DAY 39 Total10Constraints11 Minimum office total budget12 Maximum salaries budgetView hulp& When TextFORRE&CentrBFSOLVERINORKBOOK20 dA13 Minimum communication budget14 Total budgetAdrebalC% 2823Burpe$18,645$16,71214 EBET NormalConded For Cel- 10k-2021 BUDGETCommunications Equipment Advertising Salaries Rent$63,542 $17,640 $56,280 $425,854 $66,065$44,442 $391,859 $55,900$43,522 $428,625 $60,586$61,248$64,897$600,000$400,000$65,000$2,000,000DEDonatoryStyleFGculationMeteHhet ekte FumaCatΣAutumPON-ClearH280Set & Find &Fe Seled-tarny1516 Achieve the total budget by altering budget for Communications and Salaries subject to the given constraints171819202122Professional Fees Vehicle Expenses Total$80,281$81,330$81,425$73,565 $783,227$71,435 $724,859$70,920 $766,687$2,274,773Average 1008102KCore 13 Su

A budget in business refers to a financial plan that outlines the expected revenue and expenses for…

Answered: Use Microsoft excel Spreadsheets.…

Business

Operations Management

Use Microsoft excel Spreadsheets. $100,000 is the total budget. Use the picture as an example for the format.

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

Similar questions

WZ Inc. is an event planning and promotion company who organizes events of different sizes for their clients. Planning and managing events have more than their fair share of frustrations and stressors. From last-minute changes to procrastinating clients, the profession isn’t for the faint of heart. Luckily, executing a successful event makes everything else (like the crazy long hours) worth it. There is a major event planning project due in 8 weeks. The penalty for planning the event late is $14 000 per week,
You have been hired by a contractor, who wants you to manage a constructionproject for one of their clients. The project team has been working for twomonths, and is 35% done with the job. Two of your team members come toyou with a conflict about how to handle the ongoing maintenance for a pieceof equipment. You know that they can safely ignore the problem for a while,and you’re concerned that if your project falls behind schedule before nextweek’s stakeholder meeting, it will cause problems in the future. You tell thetwo team members that the problem really isn’t as bad as they think it is, andif they take a few days to cool off about it you’ll help them with a solution.This approach to conflict resolution is known as ______.A. WithdrawalB. CompromiseC. SmoothingD. Forcing You are a project manager for a software project. As you are defining thescope of the work you need to do, you sit down with all of the project’sstakeholders and record all of the requirements you can get from…
As a communication tool, these can be used in the management control process. Which is the correct sequence? Select the correct response Approval of plans, feedforward, corrective action, feedback feedforward, Approval of plans, corrective action, feedback feedforward, Approval of plans, feedback, corrective action Approval of plans, feedforward, feedback, corrective action
In Special Events and Management 1. Event Planning and Organization  Choose a type of special event (e.g., fundraiser, conference, gala) anddevelop a comprehensive plan for organizing it. Identify the event's goals, target audience, timeline, and location. Develop a detailed schedule of activities and assign responsibilities toteam members. Ensure that all necessary permits, licenses, and insurance are obtained.2. Budgeting and Financial Management  Develop a realistic budget for the special event. Identify all sources of revenue and expenses. Monitor expenses throughout the planning process to ensure that thebudget is not exceeded. Develop contingency plans for unexpected expenses. 3. Logistics and Operations Management  Develop a detailed plan for managing logistics and operations during thespecial event. Ensure that all necessary equipment, supplies, and personnel areavailable. Coordinate with vendors, contractors, and other third-party serviceproviders as…
Assume Bangladesh National Cricket Team needs to find a new head coach for the team. The cricket team’spresent and the future success largely depends on the formulations and implantation of the plans laid by thehead coach. The cricket board has given you the responsibility to prepare the job responsibilities of the newhead coach. You need to pinpoint very carefully which tasks he is supposed to do, as you also need to identifywhich skills and qualifications he must possess to do those required tasks smoothly. Prepare the job descriptionand job specification for the position of “Head Coach” of Bangladesh Cricket Team.
Video: https://youtu.be/VI0Qh_VpIEw Phill AlzinwaleTitle: Earned Value Management Basics1. What are the three basic questions to ask regarding the budget and earned value?2. What are formulas for earned value management?3. What is the criteria to determine if the cost or schedule variance is over budget or underbudget and over schedule or under schedule?4. How much work will be done? represents the work was _________ for the project and isthe ______________.5. How much work was done? represents the amount of work that was ____________ andis the _______________.6. How much was spent on work done represents what was __________ spent and is the__________.
You are hosting an important event on campus, the RSVP’s are in and there will be 100 guests (not fellow students) attending. You forgot to ask for help and the event is only 4 days away; it is now up to your group members to make this a successful event. Over the next week your group needs to identify tasks, set priorities and come up with a plan to make this happen. You cannot ask any other people to help You have a budget of $20,000.00 YOU MUST CREATE AN INITIAL BUDGET SPREADSHEET SHOWING A BUDGET GREATER THAN $20,000. SET YOUR CONSTRAINTS, DECIDE WHICH 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. Also submit the excel spreadsheet showing your initial budget and your final budget with the constraints.
What method of planning the sequence of events has been shown to be the most successful?
Training and developmentAdequate training and development of the personnel who work in your business is important to achieve the objectives set during the planning process. That is why it is important to develop activities that promote the continuous development of staff. For this part of the assignment, write a training program that includes the following aspects: IV. Determine the modality in which the activity will be carried out (in person, e-training, workshop, etc.)V. Includes the budget items that you must consider for the development of the activity.
what tools do we use to manage pjoect schedules and how do we decide what to use? does it work effectively
Suppose that your boss, Tony Hu, who is the operations manager of your company, sends you an email asking for your input on holding joint planning sessions with people from marketing and finance. A portion of that email follows: Gail in Marketing and Jim in Finance have been bugging me lately about holding joint meetings. They’re real gung-ho on this. But I’m a little concerned about agreeing to it. I don’t want them to get the impression that they can come in here and tell us what to do. They don’t really understand what it is we do or the kinds of problems we have. I’m sure they think we aren’t doing as well as we could, but that’s not any of their concern. I don’t know why they just don’t concentrate on what they do, and leave operations to us. Compose an email that summarizes the potential benefits of holding joint planning meetings with Marketing and Finance.
XYZ is a privet company planning to open a new department and hire new employees. A. What type of plan must be adopted by XYZ company? Why? B. Explain any two planning tools and techniques with suitable examples?