Home Accounting Mathematics [SOLVED]Question & Answer: Historical demand for a product is: a. Using a weighted moving average with weights of 0.40…..

[SOLVED]Question & Answer: Historical demand for a product is: a. Using a weighted moving average with weights of 0.40…..

Author: Client Uploads

February 16th, 2022

Historical demand for a product is: a. Using a weighted moving average with weights of 0.40 (June), 0.20 (May), and 0.40 (April), find the July forecast. (Round your answer to 1 decimal place.) July forecast b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast c. Using single exponential smoothing with alpha = 0.20 and a June forecast = 12, find the July forecast. (Round your answer to 1 decimal place.) July forecast d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Do not round intermediate calculations. Round your intercept value to 1 decimal place and slope value to 2 decimal places.) Y = + t e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.) July forecast

Struggling to find relevant content? Order a custom essay on

[SOLVED]Question & Answer: Historical demand for a product is: a. Using a weighted moving average with weights of 0.40…..

Let our experts save you the hassle

Order Now

Expert Answer

Answer:- Weighted moving average ;

Forecast for July = (14*0.4 + 15*0.2+13*0.4)/(0.4+0.2+0.4) = (5.6+3+5.2)/1

Forecast for July =13.8

Answer:- Simple three-month moving average:-

Forecast for July =(14+15+13)/2=14

Answer:-

Month	Demand
Jan	13
Feb	10
March	14
April	13
May	15
June	14

Month (X)	Number of Accident(Y)	X*Y	X*X
1	13	13	1
2	10	20	4
3	14	42	9
4	13	52	16
5	15	75	25
6	14	84	36
∑X = 21	∑Y = 79	∑XY = 286	∑X^2 =91

Slope(b) = (N∑XY – (∑X)(∑Y)) / (N∑X² – (∑X)²)
Slope B = (6286 – 2179)/(6*91-21^2)
B = 0.543

Intercept(a) = (∑Y – b(∑X)) / N
a=(79-0.543*21)/6
a=11.27

Regression Equation(y) = a + bx
y=11.27+0.543*x

Forecast for July
y=11.27+0.543*7
y=15.071

Related: regression analysis

Calculate the price

Make an order in advance and get the best price

Type of paper

Academic level

Deadline

Pages (550 words)

$0.00

*Price with a welcome 15% discount applied.

Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.

We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.

step 1

Upload assignment instructions

Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.

step 2

Relax

Once you place an order with our professional do my paper services, all you need to do is relax as our experts work to impress you with amazing quality and timing for your order!

step 3

Review the final draft

As soon as the paper is ready, we’ll send you a copy via email. You'll also be able to download it from your account and request a revision or rate the work as appropriate.

Get personalized services with GPA Fix

One writer for all your papers

You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments

Same paper from different writers

Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers

Copy of sources used

Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order

What our partners say about us

We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.

Human Resources Management (HRM)

Great Work!

Customer 452767, November 18th, 2022

Education

Thank you so much for your help so I do not go insane from trying to do this. I have 2 more courses to do. Probably will be using you again.

Customer 452675, November 28th, 2021

Nursing

They research and provide the best and up-to-date information..

Customer 452707, June 27th, 2023

Nursing

Another great paper! Thank you!

Customer 452707, June 16th, 2022

Nursing

Not all sources were " American sources" as directed

Customer 452615, September 16th, 2021

Human Resources Management (HRM)

Thanks.

Customer 452701, August 15th, 2023

Business and administrative studies

Thanks

Customer 452701, August 16th, 2022

Nursing

Everything was done thoroughly and with care. Awesome job!!!

Customer 452453, April 10th, 2021

Criminal law

Thank You!

Customer 452465, January 29th, 2021

Political science

THANK YOU

Customer 453001, April 25th, 2024

English 101

Although a little late, the content and structure of the paper was great! I would definitely use this writer again!

Customer 452561, July 12th, 2021

Education

Thank you so much for all the help, I really appreciate it!

Customer 452631, November 3rd, 2021

OUR GIFT TO YOU

15% OFF your first order

Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.

Claim my 15% OFF Order in Chat