Homework

# The CFO has given you a workbook (see table below) showing…

Customer Question
The CFO has given you...
The CFO has given you a workbook (see table below) showing the estimated expenses for the upcoming fiscal year. At the meeting, the stakeholder’s must vote for approval of the budget that takes effect on in the upcoming year. Unfortunately, the workbook is incomplete, so you are asked to make the necessary updates.Q1 Q2 Q3 Q4
Technology: \$4,872,340.00 \$4,359,850.00 \$3,994,500.00 \$6,500,400.00
Communications:\$1,287,000.00 \$2,324,000.00 \$1,875,000.00 \$2,050,300.00
Travel: \$985,000.00 \$1,020,000.00 \$750,000.00 \$875,000.00The CFO has given you the figures above and the following directions:1. The figures shown are the projected expenses for the new fiscal year. Copy them to a workbook.
2. On a new worksheet using absolute references from the expense budget worksheet, indicate the expense budget of the last fiscal year, which was 4.5% less than the figures shown.
3. Name the worksheet – Last Year Expenses and place it before the new expense worksheet.
4. PEI expects to spend over \$113 Million in the upcoming fiscal year. The company has made a profit of 20% for each of the last five years but next year they project a 25% profit. On another worksheet show the projected 25% profit in each category by quarter using absolute cell references from the new expense budget worksheet.
5. Name the sheet – New Projected Profits.
6. Create a separate pie chart for each quarter of the expense budget showing the percentage of expenditures for each category.
7. Place it on a separate sheet and name it - Pie Charts.
8. PEI is also thinking of expansion into the Latin American market. This move would mean an increase in expenditures of 15% in each category beginning in Quarter 3 of the new expense budget. On a separate worksheet, use a formula to show the increased expenses this expansion would add to the new budget.
9. In another table located below the expenses in the Latin America project use cell references in a formula to indicate the overall projected profits for the expansion if it took place.
10. Name the sheet – Latin America Expansion.
11. Create a documentation sheet (title page) for the workbook and place it in front of all other work sheets. Title it appropriately.
12. On the top of the Documentation sheet give your name and the date.
13. On the documentation sheet, list the other worksheets in the workbook and create hyperlinks to the corresponding worksheet with a brief explanation of each.
14. Also on the documentation sheet, explain the contents and purpose of the workbook.
15. Name the workbook – PEI Upcoming Annual Budget
Submitted: 2 years ago.Category: Homework
Show More
Show Less
3/4/2016
Tutor: F. Naz, Chartered Accountant replied 2 years ago
F. Naz, Chartered Accountant
Category: Homework
Satisfied Customers: 5,460
Experience: Experience with chartered accountancy
Verified

Do you only need the excel work sheet, thanks.

Category: Homework
Satisfied Customers: 3,040
3,040 Satisfied Customers
Experience: MIT Graduate (Math, Programming, Science, and Music)

Scott is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

LogicPro

Engineer

5,731 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Tutor

4,551 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

M.S.W. Social Work

2,636 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

Chartered Accountant

5,460 satisfied customers

Experience with chartered accountancy

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
Task 1. Do a risk management plan: list of risks involved,
Task 1. Do a risk management plan: list of risks involved, level of the risk, the likelihood of the risks of occurring, management plan, who is responsible for what, the implications/consequences to t… read more
F. Naz
Chartered Accountant
5,460 satisfied customers
A standard deck of cards contains 52 cards. One card is
A standard deck of cards contains 52 cards. One card is selected from the deck. ​(a) Compute the probability of randomly selecting aa ninenine or aceace. ​(b) Compute the probability of randomly selec… read more
GLENN
Master of Mathematics
411 satisfied customers
I need help with testout PC Pro exam. Here is a sample link
I need help with testout PC Pro exam. Here is a sample link below: http://www.testout.com/home/certification/testout-pc-pro-certification http://www.testout.com/sample-exam Will provide additional inf… read more
David L.
Bachelor\u0027s Degree
6 satisfied customers
A rubber ball retains 95% of its kinetic energy after each
A rubber ball retains 95% of its kinetic energy after each bounce. If a ball is dropped from a height of 2 meters what will its speed be just as it hits for its fourth bounce?… read more
GLENN
Master of Mathematics
411 satisfied customers
JUST CHECKING OUT MY OPTIONS. IS THERE A FEE? Hmmmmm, I have
Hmmmmm, I have a face to face guy who charges \$40. hr but he can't always make it when I need him and he's always in a rush to leave. I like to get everything done in one sitting. I am usually able to answer about 80% of the questions on my own and just need him as a supplement but it seems I usually have to wait a couple of days to see him again and sometimes it's inconvenient for me but I do it anyway because I have to meet the deadline for assignments. If I could get a set fee, maybe this would be more appealing to me. I just like to know what to budget it out to before I commit. … read more
GLENN
Master of Mathematics
411 satisfied customers
700138 pennfoster answer. It's a writting
700138 pennfoster answer JA: The Expert will know what to do. Please tell me everything you can so the Expert can help you best. Customer: it's a writting JA: Is there anything else the Expert should … read more
GLENN
Master of Mathematics
411 satisfied customers
Write a main function that asks the user for four floats and
Write a main function that asks the user for four floats and then outputs the minimum, maximum, their sum and mean value. Use the functions from (a) – (d) to implement this. (a) Take two floats as arg… read more
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
A dear friend has written a series of three words which she
Hi. A dear friend has written a series of three words which she has used as the title of an essay and in the body of an essay and in a published book. The book is available as a paper version and also… read more
Olivia Kent
Managing Partner
Doctoral Degree
3,228 satisfied customers
Statistics question. Just a couple of question
Bachelor of Education
9 satisfied customers
F. Naz
Chartered Accountant
5,460 satisfied customers
In C Program. Write functions for the four basic
In C Program. Write functions for the four basic mathematical operations addition, subtraction, multiplication and division. Each function has two numbers as parameters and returns the result. Use int… read more
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
I need help with my Marketing course but I do not see
I need help with my Marketing course but I do not see Marketing in the Category below. This assignment is due by May 25, 2018. This assignment has 20 questions. Select the best answer to each question… read more
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
A friend gives you a metal cube that measured 2.0cm on each
A friend gives you a metal cube that measured 2.0cm on each side and has a mass of 27.5g.what can be deduced from the cube and the table(the table has the density of aluminum 2.7) I planed to find the… read more
Bachelor of Education
9 satisfied customers
Need help with IT Project Management assignment. The
Need help with IT Project Management assignment. The assignment information is attached.TASK: 1. Do a risk management plan: list of risks involved, level of the risk, the likelihood of the risks of oc… read more
F. Naz
Chartered Accountant
5,460 satisfied customers
I need help, Psychology, Right know just this
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
A screening examination was performed on 250 persons for
A screening examination was performed on 250 persons for Factor X, which is found in disease Y. A definitive diagnosis for disease Y among the 250 persons had been obtained previously. The results are… read more
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
The death rate per 100,000 for lung cancer is 7 among
The death rate per 100,000 for lung cancer is 7 among non-smokers and 71 among smokers. The death rate per 100,000 for coronary thrombosis is 422 among non-smokers and 599 among smokers. The prevalenc… read more
GLENN
Master of Mathematics
411 satisfied customers
I'm in the process of writing a story and am second-guessing
Hello. I'm in the process of writing a story and am second-guessing the structure of the following paragraph. Is it acceptable as is, or do I need to precede the last quoted sentence by a blank line. … read more
GLENN
Master of Mathematics
411 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less