Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, Based on the table below, can you please help me make a quarterly cash budget? PROJECT: Project Budget Networking and software upgrade Hours/unit by

Hi, Based on the table below, can you please help me make a quarterly cash budget?

image text in transcribed
PROJECT: Project Budget Networking and software upgrade Hours/unit by development phase Cost by development phase Chargeout Implemen Total rate/hour Total by cost Cost categories Analysis Design tation hours/unit or unit cost Analysis Design Implementation Total cost category Labour Project manager 256 224 136 616 $ 653 $ 167,168 $ 146,272 $ 88,808 $ 402,248 Application customization and implementation 40 100 35 175 $ 369 $ 14,760 $ 36,900 $ 12,915 64,575 End user training 50 180 176 406 $ 398 $ 19,900 $ 71,640 70,048 161,588 Process analysis and development 110 250 120 480 $ $ 33,110 $ 75,250 36,120 144.480 $ 234,938 $ 330,062 $ 207,891 $ 772,891 $ 772,891 Hardware Servers 3 3 $ 156,500 $ $ 469,500 $ 469,500 Network connections (equipment and telecommunications) 85,400 $ 85,400 85,400 Network connection fees 2,500 2,500 CA CA A FA 2,500 Hardware maintenance contract 1 10,000 $ 10,000 10,000 $ 87,900 $ 479,500 $ 567,400 $ 567,400 Software Application software licence fees 1 25,000 $ 25,000 $ 25,000 Application maintenance contract 1 1 13,000 $ 13,000 13,000 $ 25,000 13,000 38,000 $ 38,000 Testing Testing 20 144 600 764 $ 100 $ 2.000 $ 14.400 $ 60,000 $ 76,400 $ 76,400 Reserves (10% of total estimate) $ 23,694 $ 45,736 $ 74,739 $ 144,169 $ 144, 169 Total project cost estimate $ 260,632 $ 503,098 $ 835,130 $ 1,598,860 1,598,860

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

Understanding Corporate Annual Reports

Authors: William Pasewark

7th Edition

0073526932, 9780073526935

More Books

Students also viewed these Accounting questions

Question

=+a) Is this an experiment or observational study? Explain.

Answered: 1 week ago

Question

The quality of the proposed ideas

Answered: 1 week ago

Question

The number of new ideas that emerge

Answered: 1 week ago