Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

FebMarchAprilMayJuneTotal
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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Capitalist Political Economy Thinkers And Theories

Authors: Heather Whiteside

1st Edition

0429888031, 9780429888038

More Books

Students also viewed these Economics questions

Question

Are you at your best around 8 or 9 AM? Yes No

Answered: 1 week ago