Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer this question: UsingtheCashflowS-CurveTemplatePrepareacashflow(MSExcel)ofmajorcost milestones above that would need to be calculated when addressing such a projectandplotthemonthlycashinbank.CashinBankatstartofproject$550,000. The Project for all four tasks will be

Answer this question:

Usingthe"CashflowS-CurveTemplate"Prepareacashflow(MSExcel)ofmajorcost milestones above that would need to be calculated when addressing such a projectandplotthemonthlycashinbank.CashinBankatstartofproject$550,000.

The Project for all four tasks will be a 50 store - 3 story/ underground car park shoppingcomplexcommercialproject.Valueoftheprojectwillbe$13.2million.

Assumptions:

  1. BuildCost:$10.5million
  2. Paymentschedule:Monthlyoncompletedcostcentre
  3. TotalCompanyOverheads$792,000
  4. CompanyOverheadsrelatedtotheproject

$72,000/month

  1. CostCentreBreakdown-%ofbuildcost

ITEM

COSTCENTRE

% WBS

1

Preliminaries

3.8

2

SiteEstablishment

5.5

3

Siteexcavation& Cleaning

4.5

4

Drainage

9.0

5

Concreting

6.0

6

Masonry

8.5

7

Electrical

8

8

Services

7

9

Plumbing

7.5

10

RoofPlumbing

10.2

11

Glazing

10.5

12

Carpentry

7.5

13

Painting

3.5

14

Tiling

3.5

15

Fire Services

5

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_2

Step: 3

blur-text-image_3

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

Principles Of Management For The Hospitality Industry

Authors: Dana TesoneAbraham Pizam

1st Edition

1856177998, 9781856177993

More Books

Students also viewed these General Management questions

Question

Show that an n-element heap has height [lg n].

Answered: 1 week ago

Question

What are the functions of data centers?

Answered: 1 week ago

Question

Relax your shoulders

Answered: 1 week ago

Question

Keep your head straight on your shoulders

Answered: 1 week ago