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
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,
=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 | ||||||
| Gifts | |||||||
| 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 | <Number of persons onsite> | |
| Customer testimonial T&E | $100.00 | $100.00 | ||
| Additional Costs Subtotal | $1,734.00 | |||
| Giveaways | 0 | |||
| Giveaway #1 | 25 | $10.00 | $250.00 | <Giveaway item description> |
| Giveaway #2 | 25 | $5.00 | $125.00 | <Giveaway item description> |
| 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.
