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

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.    

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.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?