25 Nov Prepare the budget in Excel using your project WBS There are many free budget templates and resources; two have been attached to the assignment in the course. Use one of these resources rather
his week's assignment is to develop a budget for the project selected in Unit 2.
Prepare the budget in Excel using your project WBS.
- There are many free budget templates and resources; two have been attached to
the assignment in the course. Use one of these resources rather than creating
- Include two tabs in your Excel document: WBS and Budget.
- Include a report name, your name, and date.
- Use at least three levels with a minimum of five (5) Level 1 tasks, two (2) Level 2
tasks, with three (3) Level 3 tasks.
- Continue to decompose the tasks/activities in your WBS until you have tasks
which are small enough to assign to an individual and accurate estimate the cost
of each activity.
- Use the Excel math functions when you create your report, for instance,
- Do not hide numbers in formulas, for instance, =sum(A3,330), where 330 is a
- Include all project activities. Recall that we are rolling up the project
• Submit an Excel document.
|Project Budget for Project Name|
|Site||Units/Hours||Cost/Unit||Estimated||Actual||Actual Cost Breakdown|
|Room and hall fees||500||1||$500.00|
|Tables and chairs||$0.00|
|Miscellaneous||Estimated||Actual||Estimated vs. Actual|
|Staff and gratuities||40||50||$2,000.00|
Estimated Site Decorations Publicity Miscellaneous Refreshments Program Prizes 900 200 500 500 2000 0 0 Actual Site Decorations Publicity Miscellaneous Refreshments Program Prizes 0 0 0 0 0 0 0
Site Decorations Publicity Miscellaneous Refreshments Program Prizes 0 0 0 0 0 0 0
Made in Office 2007 for office2007.com
|Project Budget Plan|
|Category||Estimated Quantity||Estimated Cost per Unit||Estimated Subtotal||Notes|
|Research firm fees||2||$2,300.00||$4,600.00|
|Research Costs Total||$7,100.00|
|Communications Costs Total||$25,650.00|
|Networking Costs Total||$254.00|
|Number of attendees||50|
|Meal (breakfast, lunch, or dinner)|
|Food and beverage gratuity (20%)||$5.06||$253.00|
|Meal Costs Subtotal||$1,518.00|
|List Service Costs Subtotal||$2,500.00|
|Basic PA system and podium||1||$0.00||$0.00||Provided by venue (usually)|
|Screen||1||$0.00||$0.00||Provided by venue (usually)|
|XGA data/video projector rental||1||$45.00||$45.00|
|Power strips||1||$0.00||$0.00||Provided by venue (usually)|
|Extension cords||1||$0.00||$0.00||Provided by venue (usually)|
|Lavalier microphone||1||$0.00||$0.00||Provided by venue (usually)|
|Labor and AV technicians||1||$300.00||$300.00|
|Audio/Visual Services Subtotal||$388.42|
|Invitation (printing and postage costs)||$834.00||$834.00|
|Time & Expense (T&E)||$600.00||$600.00|
|Company staff T&E||$200.00||$200.00||<Number of persons onsite>|
|Customer testimonial T&E||$100.00||$100.00|
|Additional Costs Subtotal||$1,734.00|
|Giveaway #1||25||$10.00||$250.00||<Giveaway item description>|
|Giveaway #2||25||$5.00||$125.00||<Giveaway item description>|
|Event Costs Total||$6,515.42|
|Event Price per Person||$130.31|
|Promotions Costs Total||$1,800.00|
|Brochures (development and production)||5,000||$0.15||$750.00|
|Advertising Costs Total||$7,007.00|
|Public Relations Costs Total||$3,200.00|
|ESTIMATED PROJECT GRAND TOTAL||$51,526.42|
Confidential & Proprietary &8Page &P
Budget Plan Chart
Project Budget Plan
Research Communications Networking Event Promotions Advertising Public Relations 7100 25650 254 6515.4160000000002 1800 7007 3200
Project Management Terms and Concepts
Professor: Dr. Kathy Milhauser
November 4, 2022
Project management involves a process that leads a team to achieve a project's goals and objectives. It is the use of particular techniques, tools, skills, and knowledge in delivering a valuable aspect to the customers. Implementation of a project entails numerous stakeholders with respective roles to play in successfully completing the process. It also encompasses risks that affect the outcome of the implementation process. The impact risk factors might have on the process heavily relies on the techniques the project management will decide to utilize.
The Project Overview
The article chosen is about the project that Samsung recently unveiled. The project involves the construction of Samsung's first semiconductor fabrication facility in Taylor, Texas. The facility, which is intended to be located near Austin, Texas, is estimated to amount to a budget of $17 billion. It was set to begin this year and be completed by 2024 (The Guardian, 2021). The project cost estimation covers the buildings, machinery and equipment, and property improvement. Once completed, the project is said to be the substantial leading investment of the South Korean project in the United States. Samsung has operated a chip manufacturing entity in Austin since the late 1990s and has consistently shown its need to advance its chip operations within the country to curb stiff competition offered by larger entities like Apple, Google, and Amazon located within the geographical region. The company aims to take advantage of its technical experience to earn a significant share in the market of chip manufacturers globally. It is one of the leading technology-based organizations globally that drives the global market's largest share.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.