Question
1. Project Budget Present the project budget with both high-level details (i.e., summary budget by milestone or deliverable) and a time phased budget breakdown by
1. Project Budget
Present 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:
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 |
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 at least three methods that you plan to use for measuring and controlling financial progress and the results of your project.
With References plz
The population is rising, and many problems arise from this growth, including the lack of nutritious foods and beverages. There is a massive demand for vegetables and food items in Ottawa and the rural of Ottawa, yet producers are not patient enough to grow these vegetables without utilizing chemicals. In addition, dealers do not care about value, resulting in further misery of quality when the products are shipped. While organic foods and vegetables are more pricey than non-organic foods, people are eager to pay for them since they are more nourishing, natural, and biologically friendly. Most individuals choose to get away from the city, so they eatStyles natural, and biologically friendly. Most individuals choose to get away from the city, so they eat in restaurants in the nearest rural neighborhoods. They pursue a calm target near where they can spend time with their family. Organic farms and restaurants with simple parks in rural areas recommend a wonderful way for kids to learn public and passionate skills, inspiration, self- control, risk-taking, and following rules while having fun. Moreover, outdoor play offers an exceptional opportunity for kids to build empathy; one child might inspire another to try a slip, while another encourages a child who has dropped while running (Kinsner, 2019). A business like this will be a fantastic idea that can turn into a reality and deliver significant profit to everyone. The project maintains the organization's objective of supplying the public with healthy, natural, and eco-friendly meals and beverages. The project od to go\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