Need Finance Homework Help? Ask an Expert

# The following table gives average UK household electricity

Customer Question
Customer: The following table gives...
Customer: The following table gives average UK household electricity demand in kilowatt hours (kWh) over some years. Quarter 1 represents Spring, Quarter 2 represents Summer etc.Year Q1 Q2 Q3 Q4 2005 4.5 4.1 4.4 5.1 2006 4.9 4.6 4.6 5.3 2007 5.0 4.7 4.8 5.5 2008 5.2 5.0 5.1 5.6 2009 5.3 5.1 5.2 5.7i. State two features about household electricity demand which are apparent from these data.ii. Show that the 4-point centred moving average for Quarter 3 in 2007 is 5.025.iii. Calculate the ratio-to-moving-average (R2MA) for Quarter 3 in 2007.iv. Compute the four seasonal indices using the following table of R2MA values. Replace ‘?’ with your answer to part ‘iii.’.￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼Season AutumnSeasonal averages *Winter SpringSummer 0.953368 0.944724 0.959233 0.9600000.961749 0.946015 ? 0.9737471.088000 1.084399 1.081081 1.0641331.026178 1.015228 1.007264 1.002364v. The estimated trend line is found to be:y􏰏 = 4.461 + 0.050xwhere x is the Quarter number (Q1 of 2005 corresponds to x = 1). Provide a forecast, to three decimal places, for average UK household electricity demand for the summer of 2015. Comment briefly on this forecast. Hi I need help to solve this problem
JA: Thanks. Can you give me any more details about your issue?
Customer: Year Q1 Q2 Q3 Q4 2005 4.5 4.1 4.4 5.1 2006 4.9 4.6 4.6 5.3 2007 5.0 4.7 4.8 5.5 2008 5.2 5.0 5.1 5.6 2009 5.3 5.1 5.2 5.7 this is the first table
JA: OK got it. Last thing — JustAnswer charges a fee (generally around \$18) to post your type of question to Business and Finance Homework Experts (you only pay if satisfied). There are a couple customers ahead of you. Are you willing to wait a bit?
Customer: Yes, But how long have i to wait? because of I need it for this afternoon and I am willing to pay no problem about it
JA: OK. Now I'm going to take you to a page to place a secure deposit with JustAnswer. Don't worry, this chat is saved. After that, we will finish helping you.
Submitted: 2 years ago.Category: Business and Finance Homework
Show More
Show Less
12/19/2015
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago
F. Naz, Bachelor's Degree
Satisfied Customers: 5,378
Experience: Have completed B.COM and CA Finalist
Verified

Customer reply replied 2 years ago
My deadline is tonight, at least tomorrow morning
Customer reply replied 2 years ago
thanks
Customer reply replied 2 years ago
If you need, I can upload my calculations that I've just made..
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago

You may upload at www.wikisend.com or www.medifire.com and provide me the link, thanks.

Customer reply replied 2 years ago
No, I prefer if you could send by email the answers and then I will check then. OK?
Customer reply replied 2 years ago
Especially, I need help about the point V:The estimated trend line is found to be:
y􏰏 = 4.461 + 0.050x
where x is the Quarter number (Q1 of 2005 corresponds to x = 1). Provide a forecast, to three decimal places, for average UK household electricity demand for the summer of 2015. Comment briefly on this forecast.
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago

4.461+.05*1 = 4.511

Customer reply replied 2 years ago
3. The prospective operator of a shoe store has the opportunity to locate in an established shopping centre. Alternatively, at lower cost, the prospective operator can locate in a new centre, whose development has recently been completed. If the new centre turns out to be very successful, it is expected that annual store profits from location in it would be £130,000. If the new centre is only moderately successful, annual profits would be £60,000. If the new centre is unsuccessful, an annual loss of £10,000 would be expected. The profits to be expected from location in the established centre will also depend to some extent on the degree of success of the new centre, as potential customers may be drawn to it. If the new centre was unsuccessful, annual profits for the shoe store located in the established centre would be expected to be £90,000. However, if the new centre was moderately successful, the expected profits would be £70,000, while they would be only £30,000 if the new centre turned out to be very successful. All profits are inclusive of location cost. The probability that the new shopping centre will be very successful is 0.4 and the probability it will be moderately successful is also 0.4.
(a) Draw the decision tree for this problem.
(b) According to the expected monetary value criterion, where should the shoe store be located? Assume a risk-neutral decision-maker.(c) Explain briefly how a perfect forecast of shopping centre success changes the order of the decision tree in (a).
Customer reply replied 2 years ago
Please, if you could: send me a file through email with the asnwer
Customer reply replied 2 years ago
the former answer that you gave me isn't correct: i need to calculate the estimated trendline by providing a forecast using excel
Customer reply replied 2 years ago
I finished my calculations on exercise 5 so I need only the calculations of the exercise 3 that I uploaded before.
I attach you the file with the comment about part V of the exercise 5. Please have a look and tell me your opinion.
Thanks
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago

Sorry could not do it as for y=a+bx, therefore should be two variables but here only one variable is given, and you can see that you have given x=1, so how 42 may be replaced with 1 for X, I am opting out so other experts may help you, take care.

Customer reply replied 2 years ago
3. The prospective operator of a shoe store has the opportunity to locate in an established shopping centre. Alternatively, at lower cost, the prospective operator can locate in a new centre, whose development has recently been completed. If the new centre turns out to be very successful, it is expected that annual store profits from location in it would be £130,000. If the new centre is only moderately successful, annual profits would be £60,000. If the new centre is unsuccessful, an annual loss of £10,000 would be expected. The profits to be expected from location in the established centre will also depend to some extent on the degree of success of the new centre, as potential customers may be drawn to it. If the new centre was unsuccessful, annual profits for the shoe store located in the established centre would be expected to be £90,000. However, if the new centre was moderately successful, the expected profits would be £70,000, while they would be only £30,000 if the new centre turned out to be very successful. All profits are inclusive of location cost. The probability that the new shopping centre will be very successful is 0.4 and the probability it will be moderately successful is also 0.4.
(a) Draw the decision tree for this problem.
(b) According to the expected monetary value criterion, where should the shoe store be located? Assume a risk-neutral decision-maker.(c) Explain briefly how a perfect forecast of shopping centre success changes the order of the decision tree in (a).
F. Naz, Bachelor's Degree
Satisfied Customers: 5,378
5,378 Satisfied Customers
Experience: Have completed B.COM and CA Finalist

F. Naz 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:

linda_us

Master's Degree

852 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

Bachelor's Degree

5,378 satisfied customers

Have completed B.COM and CA Finalist

Bizhelp

Accountant

260 satisfied customers

BA degree and Certified Public Accountant

214 satisfied customers

dasdasd

Mr. Gregory White

Master's Degree

211 satisfied customers

M.A., M.S. Education / Educational Administration

Brittany

Professional

30 satisfied customers

Dimitry K., Esq.

Doctoral Degree

19 satisfied customers

< Previous | Next >

Related Business and Finance Homework Questions
Locate a recent annual report for a public company that
Locate a recent annual report for a public company that includes a disclosure note that describes an investment in a trading security. Explain why this company would report their investment as a tradi… read more
Expert
214 satisfied customers
Could you do variance analysis>? I have an assigment due on
on Variance analysis I need to provide notes on each line item… read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
This morning, the hair dryer of one of the students in this
This morning, the hair dryer of one of the students in this class broke. The student, Jane, discussed the problem with her older brother Dick.Dick: Hi, Jane. What happened to your hair dryer? Jane: It… read more
Expert
214 satisfied customers
This question is do today by 4pm. I am able to pay an
This question is do today by 4pm. I am able to pay an additional charge to get it completed asap. I have attached the questions below and the grading rubric. Please follow the directions closely. This… read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
For writer F. Naz. This assignment is due saturday 1/13 by
For writer F. Naz. This assignment is due saturday 1/13 by 6pm. I have attached the assignment page and grading rubric. Please read the directions and follow them closely. This is for a healthcare fin… read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
Complete assignment as follows: Record the transactions for
Complete assignment as follows: Record the transactions for May 1 through May 31 in a general Journal using the account names listed in the chart of accounts (red tab). Post the entries to general led… read more
Expert
214 satisfied customers
Business Law - Answer each of the following questions in a composition of 10 to 20 sentences:1. Discuss the difference between larceny, embezzlement, and robbery and give an example of each that would… read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
I will need to take the Ashworth College Semester Exam which
I will need to take the Ashworth College Semester Exam which is a series of 50 q's in 3hrs. Accounting. Can i get some help? … read more
Expert
214 satisfied customers
Is there a charge? I just want the answers to the final exam
is there a charge? JA: You just pay a \$5 deposit now and the rest only when you get a reply from the Tutor. All of this is 100% satisfaction guaranteed, so you can get a refund if you're not happy for… read more
GLENN
Master of Mathematics
340 satisfied customers
Use all of the three methods you have learned in class and
Use all of the three methods you have learned in class and take a weighted average of the three methods. Weights are subjective. (CAPM, DCF, bond-yield-plus-risk-premium) FOR TOYOTA MOTORS … read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
How much will it cost it is due at midnight. Compose a 4-6
Compose a 4-6 page report, double-spaced, on the following topic: If the Fed decides to raise interest rates next year, what effect would rising rates have upon the following: (1) Consumer financing for big-ticket items such as autos and homes; (2) the present and future values of annuities; (3) the NPV calculation; (4) the WACC; (5) corporate earnings ? … read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
What is the answer Marshall, Inc., produces three products
what is the answer Marshall, Inc., produces three products but weekly demand for the three products exceed the available amount of machine time. Following is information about each product: Product A … read more
Carter McBride
LLM
247 satisfied customers
It is an accounting questio (usa taX) need help with this
it is an accounting questio (usa taX) need help with this due by tomorrow . pls write answer question in separate document… read more
Expert
214 satisfied customers
Assignment 1. Plot in Excel the risky asset opportunity set
Assignment 1. Plot in Excel the risky asset opportunity set for Portfolios A & B. Hint: create the following table in excel assuming weights of portfolio A & B in 10 percentage point increments. Then … read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
Manal, I see that you have previously helped someone answer
Hi Manal,I see that you have previously helped someone answer a tax return problem that is very similar to the one I am having trouble with. It is so similar that actually all of the same numbers, the… read more
Expert
214 satisfied customers
Cassius Clay operates a bituminous coal home heating and
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Centre counties. He must have a supply of bituminous coal on hand so customers may get the coal they need to he… read more
F. Naz
Bachelor's Degree
5,378 satisfied customers
Tax Return Problem 5 -Individual Tax Instructions: Please
Tax Return Problem 5 -Individual Tax Instructions: Please complete the 2016 federal income tax return for Joseph and Diana Cohen. You may complete the tax return using Tax Act or paper forms. The link… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
I'm enrolled at Portland Community College and for my
I'm enrolled at Portland Community College and for my Entrepreneurship class we are developing a workplace harassment app that would possible partner with BOLI and EEOC. What kind of information would… read more
Dr. Donna Kakonge
Doctor of Education
201 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