Chat with us, powered by LiveChat 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 - Wridemy Bestessaypapers

## 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.

Instructions:

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
something new.
• 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
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,
=sum(A3:A5).
• Do not hide numbers in formulas, for instance, =sum(A3,330), where 330 is a
cost.
• Include all project activities. Recall that we are rolling up the project
Requirements:

• Submit an Excel document.

## Budget

Project Name [Date]
Project Budget for Project Name
Site Units/Hours Cost/Unit Estimated Actual Actual Cost Breakdown
Room and hall fees 500 1 \$500.00
Site staff 8 50 \$400.00
Equipment \$0.00
Tables and chairs \$0.00
Total \$900.00 \$0.00
Decorations Estimated Actual
Flowers 1 200 \$200.00
Candles \$0.00
Lighting \$0.00
Balloons \$0.00
Paper supplies \$0.00
Total \$200.00 \$0.00
Publicity Estimated Actual
Graphics work 1 500 \$500.00
Photocopying/Printing \$0.00
Postage \$0.00
Total \$500.00 \$0.00
Miscellaneous Estimated Actual Estimated vs. Actual
Telephone 1 500 \$500.00
Transportation \$0.00
Stationery supplies \$0.00
Fax services \$0.00
Total \$500.00 \$0.00
Refreshments Estimated Actual
Food \$0.00
Drinks \$0.00
Linens \$0.00
Staff and gratuities 40 50 \$2,000.00
Total \$2,000.00 \$0.00
Program Estimated Actual
Performers \$0.00
Speakers \$0.00
Travel \$0.00
Hotel \$0.00
Other \$0.00
Total \$0.00 \$0.00
Prizes Estimated Actual
Ribbons/Plaques/Trophies \$0.00
Total \$0.00 \$0.00
Total Expenses Estimated Actual
\$4,100.00 \$0.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

\$0.00

Site Decorations Publicity Miscellaneous Refreshments Program Prizes 0 0 0 0 0 0 0

Made in Office 2007 for office2007.com

,

## Budget Plan

 Project Budget Plan Category Estimated Quantity Estimated Cost per Unit Estimated Subtotal Notes Research fsdds Research firm fees 2 \$2,300.00 \$4,600.00 Web research 1 \$1,100.00 \$1,100.00 Independent research 3 \$300.00 \$900.00 Other research 2 \$250.00 \$500.00 Research Costs Total \$7,100.00 Communications Promotional brochures 5,000 \$0.15 \$750.00 Television 5 \$4,000.00 \$20,000.00 Radio 13 \$350.00 \$4,550.00 Web 1 \$350.00 \$350.00 Communications Costs Total \$25,650.00 Networking Memberships 3 \$50.00 \$150.00 Affiliations 2 \$20.00 \$40.00 Subscriptions 2 \$32.00 \$64.00 Networking Costs Total \$254.00 Event Number of attendees 50 Meal (breakfast, lunch, or dinner) Food \$23.00 \$1,150.00 Tax (10%) \$2.30 \$115.00 Food and beverage gratuity (20%) \$5.06 \$253.00 Meal Costs Subtotal \$1,518.00 List Services Valet services 1 \$300.00 \$300.00 Entertainment #1 1 \$800.00 \$800.00 Entertainment #2 1 \$1,200.00 \$1,200.00 Other services 1 \$200.00 \$200.00 List Service Costs Subtotal \$2,500.00 Audio/Visual Services 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 Wireless mouse 1 \$12.00 \$12.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 Tax (8.8%) \$31.42 \$31.42 Audio/Visual Services Subtotal \$388.42 Additional Costs 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 Customer testimonial T&E \$100.00 \$100.00 Additional Costs Subtotal \$1,734.00 Giveaways 0 Giveaway #1 25 \$10.00 \$250.00 Giveaway #2 25 \$5.00 \$125.00 Giveaway Subtotal \$375.00 Event Costs Total \$6,515.42 Event Price per Person \$130.31 Promotions Product giveaways 50 \$8.00 \$400.00 Product discounts 300 \$3.00 \$900.00 Special offers 200 \$2.50 \$500.00 Promotions Costs Total \$1,800.00 Advertising Brochures (development and production) 5,000 \$0.15 \$750.00 Mailings 15,000 \$0.04 \$600.00 Postcards 15,000 \$0.03 \$450.00 Television 2 \$600.00 \$1,200.00 Radio 4 \$300.00 \$1,200.00 Newspapers 6 \$220.00 \$1,320.00 Billboards 2 \$556.00 \$1,112.00 Bus sides 3 \$125.00 \$375.00 Advertising Costs Total \$7,007.00 Public Relations Charity events 3 \$200.00 \$600.00 Advertising 4 \$200.00 \$800.00 Employee promotions 6 \$200.00 \$1,200.00 Sponsorships 3 \$200.00 \$600.00 Public Relations Costs Total \$3,200.00 ESTIMATED PROJECT GRAND TOTAL \$51,526.42

&A

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

,

6

Project Management Terms and Concepts

Sarah Matheny

Post University

Professor: Dr. Kathy Milhauser

BUS530

November 4, 2022

Introduction

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.