Question
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.
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,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started