1. Project Budget

make the project budget with both high-level details (i.e., summary budget by milestone or deliverable) and a time-phased budget breakdown by milestone. The summary budget has two columns (Milestone and budget amount). The time-phased budget shows the budget amounts over the time period of the project.

Include a budget contingency and explain how that was calculated.

Project Budget

Following is the summary budget and time-phased budget by milestone:

Info Summary Budget: I did the summary budget

Expenses	Cost
Restaurant Equipment	40,000
Furniture and fixtures	20,000
Appliances	10,000
Playground Structures	11,000
Land Cost	550,000
Farm Equipment	250,000
Fencing	6,000
Advertising	30,000
Salaries	34,500
Insurance	10,000
Gas	7,000
Utilities	6,000
Inventory Supplies	40,000
Total	$1,015,000

Contingency?

Time Phased Budget:

Expenses	Jan	Feb	March	April	May	June	Total
Restaurant Equipment
Furniture and fixtures
Appliances
Playground Structures
Land Cost
Farm Equipment
Fencing
Advertising
Salaries
Insurance
Gas
Utilities
Inventory Supplies
Total							$1,015,000

2.Cash Flow

Identify which time period in your budget is at the greatest risk of cash flow problems. Explain your plan to manage or minimize any cash flow issues that might occur during the project

3.Project cost control

Illustrate three methods that you plan to use for measuring and controlling financial progress and the results of your project.

With References plz

\fStyles supplying the public with healthy, natural, and eco-friendly meals and beverages. The project associates with the organization's objectives because it offers the people healthy food options and will also support the community with a place to meet, act, and have fun. The project will also offer local residents with employment opportunities. Also, it clearly impacts the economy of the surrounding area. The stakeholders for this project will be customers, children, employees, suppliers, the project sponsor, the Hydro company, government, and the resources are waitpersons, chefs, farmers, maintenance for the playground, and cashiers. The project cost is expected at around $1,015,000. It will involve the land price with the equipment, the plant seeds and sprouts with the fence, the furniture and fixtures with the appliances, marketing and advertising, insurance, and electricity and gas. Sales per Day = 800 * 30 * 12=288000 Sales per Day = 900 * 30 *12 - 324000 2 Sales per Day = 1100 * 30 * 12 = 396000 Sales per Day = 1400 * 30 * 12 = 504000Year Cashflows 1 . $-1,015,000 2. $288000 3. $324000 4. $396000 5. $504000 Financial Models Suppose there is an inflation rate of 3% . Discount Factor = 1/ (1+Inflation Rate) ^T Year 2: 1/ (1.03) ^1= 0.9708737864 Year 3: 1/ (1.03) ^2=0.94259590913 Year 4: 1/ (1.03) ^3= 0.91514165935 Year 5: 1/ (1.03) ^4= 0.88848704791 Discounted cashflow = Cash flow * Discount Factor Discounted Cash Flow Year 1- 288000 * 0.9708737864 - 279,611,6505 Discounted Cash Flow Year 2-324000 * 0.94259590913 - 305,401.0746 Discounted Cash Flow Year 3 = 396000 * 0.91514165935 - 362,396.0971 Discounted Cash Flow Year 4 - 504000 * 0.88848704791 - 447,797.4721Year Discount Factor Discounted Cashflow 0.9708737864 $279,611.6505 0.94259590913 $305,401.0746 0.91514165935 $362,396.0971 0.88848704791 $447.797.4721 1,395,206.294 NPV-Sum of discounted cashflows - Initial Investment NPV= 1,395,206.294 - 1,015,000 = $380,206.29 ROI - (Final Value - Initial Value) / Initial Value * 100 ROI = (1,395,206.294 - 1,015,000) / 1,015,000 * 100 -37.45%A. One-time Costs Expenses Estimated Cost Method Restaurant Equipment 40,000 Three point (triangular) Furniture and fixtures: 20,000 Bottom-up Appliances 10,000 Paramteric Playground Structures 1 1,000 Analogous Land cost 550,000 Bottom-Up Farm Equipments 250,500 Historical sources Fencing 6,000 Bottom UP Total 887,000 B. Ongoing Costs Fixed Cost Amount Method Advertising 30,000 Fixed Salaries 34500 Fixed insurance 10,000 Fixed Total 74,500 Variable Cost Amount Method Gas 7,000 Parametric Utilities 6,000 Bottom-UP Inventory Supplies 40,000 Parametric Total 53,000 Examples: Using the fixed method salaries are calculated as follows: Salary for 1 employee - $2,300 per month and there are 15 employees. Total salaries - 15*2300 - $34,500' J ' ' Variable Cost 7 ' ' ' 0 Gas Utilities Inventory Supplies 7,000 I 6,000 40,000 Examples: +1' Using the xed method salaries are calculated as 'follows: ' _ Hilltfill" f - Salary for 1 employee = $2,300 per month and there are 15 employees. - Total salaries = 15*2300 = $34,500 I AW\" Y '1' , Advertising = $2500 per month but we are paying marketing expenses annual Advertising expense = 2500*12= $30,000