Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

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
Ask Your Own Homework Question
Answered in 7 hours by:
3/4/2016
Tutor: F. Naz, Chartered Accountant replied 2 years ago
F. Naz
F. Naz, Chartered Accountant
Category: Homework
Satisfied Customers: 5,492
Experience: Experience with chartered accountancy
Verified

Do you only need the excel work sheet, thanks.

Ask Your Own Homework Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Scott Your Own Question
Scott
Scott
Scott, MIT Graduate
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

How JustAnswer works:

  • 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.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

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.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...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

LogicPro

Engineer

5,894 satisfied customers

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

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,556 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,699 satisfied customers

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

F. Naz

F. Naz

Chartered Accountant

5,492 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

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

< Previous | Next >

Related Homework Questions
Personal Budget Exercise – MS Excel (These instructions are
Personal Budget Exercise – MS Excel (These instructions are also attached here as a Word document) Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this ex… read more
Steve Herrod
Steve Herrod
Senior Customer Care Engineer
Master\u0027s Degree
882 satisfied customers
Budgeted unit sales 1st Quarter 8,000 2nd quarter 7,000 3rd
Budgeted unit sales 1st Quarter 8,000 2nd quarter 7,000 3rd quarter 6,000 4th quarter 7,000 The company expects to start the first quarter with 1600 units in finished goods inventory. Management desir… read more
Manal Elkhoshkhany
Manal Elkhoshkhany
Tutor
4,556 satisfied customers
Muhammad Jawaad Ahmed Thanks I came across this site searching
Muhammad Jawaad Ahmed Thanks I came across this site searching the web, and i noticed you provided the draft for another member. Its similiar to what I started, but been busy recently and fell behind … read more
F. Naz
F. Naz
Chartered Accountant
5,492 satisfied customers
Muhammad Jawaad Ahmed I just saw on a post that you recently
Muhammad Jawaad Ahmed: I just saw on a post that you recently helped someone on providing ratios of the 2007 fiscal year numbers for oracle and microsoft. I just realized that I have the same project … read more
F. Naz
F. Naz
Chartered Accountant
5,492 satisfied customers
You currently work for an automotive parts supply store. Your
You currently work for an automotive parts supply store. Your company is growing, and is considering expansion. The company currently has three locations (North, South, and Central) in one state, and … read more
BMW
BMW
Post-Doctoral Degree
1 satisfied customers
Below is the answers and questions to my team questions only
Below is the answers and questions to my team questions only difference is my values. here are my numbers can you help me figure out how they got the answer for below site: see Answer and questions My… read more
getsetgo
getsetgo
Master\u0027s Degree
496 satisfied customers
1-2 page memo You and the VP of Accounting are meeting with
1-2 page memo You and the VP of Accounting are meeting with the CFO next week to discuss critical areas of the operating budget for next year and the capital budget as well. Of particular concern to t… read more
F. Naz
F. Naz
Chartered Accountant
5,492 satisfied customers
I already paid and tried to view this answer, but all I got
NEO: I already paid and tried to view this answer, but all I got were links to download from. When I tried to download it would not allow me. Please help! Problems 4-5A and 4-6A. When responding to th… read more
Neo
Neo
Bachelor\u0027s Degree
1,144 satisfied customers
FOR GETSETGO EXCEL ASSIGNMENT DUE 4/28 1 Excel workbook,
FOR GETSETGO: EXCEL ASSIGNMENT DUE 4/28 1 Excel workbook, and 1 Word document Details: You are now ready to create the invoices you will present to each family that attends the high school reunion pic… read more
getsetgo
getsetgo
Master\u0027s Degree
496 satisfied customers
EXCEL ASSIGNMENT DUE APRIL 28, 2010 1 Excel workbook, and
EXCEL ASSIGNMENT DUE APRIL 28, 2010 1 Excel workbook, and 1 Word document Details: You are now ready to create the invoices you will present to each family that attends the high school reunion picnic.… read more
chibiutena
chibiutena
Bachelor's Degree
14 satisfied customers
To close the accounting cycle for Joe Smiths business, complete
To close the accounting cycle for XXXXX XXXXX's business, complete the following: 1. Journalize and post the adjusting entries for Joe's business. Make the following adjusting entries: (Note: you may … read more
Annie Kavitha
Annie Kavitha
Master's Degree
713 satisfied customers
Deliverable Length 1 Excel Worksheet Details It is time
Deliverable Length: 1 Excel Worksheet Details: It is time to collate all the department budgets into the final Pro Forma Income Statement that will become part of the strategic plan. As the accounting… read more
F. Naz
F. Naz
Chartered Accountant
5,492 satisfied customers
i need some body to help me out with the Sales Budget Details
i need some body to help me out with the Sales Budget Details: One of the main roles of the accounting manager or CFO during the strategic planning process is compiling numbers so that a Pro Forma Inc… read more
F. Naz
F. Naz
Chartered Accountant
5,492 satisfied customers
Deliverable Length 2-4 paragraphs and 1 Excel workbook A
Deliverable Length: 2-4 paragraphs and 1 Excel workbook A couple of your friends have heard from your family members that you are using Excel to organize the high school reunion data and create invoic… read more
Carla
Carla
IT Consultant
Bachelor\u0027s Degree
82 satisfied customers
1 Excel workbook Details Using the documents given to you
1 Excel workbook Details: Using the documents given to you by your cousin, you will be entering more data into the Excel workbook you created in Phase 1. You will also insert a new sheet into that wor… read more
Craig S
Craig S
President
Master's Degree
50 satisfied customers
Deliverable Length 1 Excel workbook, and 1 Word document Details
Deliverable Length: 1 Excel workbook, and 1 Word document Details: The family reunion data has been entered into your Excel workbook and the event is only a few weeks away. Your next step is to create… read more
Craig S
Craig S
President
Master's Degree
50 satisfied customers
Deliverable Length 1-2 paragraphs Details Your mother heard
Deliverable Length: 1-2 paragraphs Details: Your mother heard that you created the budget for the family reunion and has asked if you could help her to create a monthly household budget. She has creat… read more
Craig S
Craig S
President
Master's Degree
50 satisfied customers
Use the graph below, showing the number of robberies in a ...
Use the graph below, showing the number of robberies in a town during the last 6 months of a year, for exercises 5 to 8. a.How many robberies occurred in November? b.What was the mean number of robber… read more
Scott
Scott
MIT Graduate
Master's Degree
3,040 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

Ask Your Question

x