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)

Thanks for your assistance.

Customer 452701, November 9th, 2022

Social Work and Human Services

Excellent Work!

Customer 452587, August 24th, 2021

Human Resources Management (HRM)

Thanks. I am very pleased with my paper.

Customer 452701, August 1st, 2023

Classic English Literature

Nicely done. Ty. Worth every penny.

Customer 452455, June 6th, 2021

Technology

Great job on the paper!

Customer 452885, December 14th, 2022

ENVIRONMENT SCIENCE

EXCELLENT

Customer 452813, June 19th, 2022

Human Resources Management (HRM)

awesome job

Customer 452701, August 14th, 2023

Nursing

Thank you for a great paper.

Customer 452707, August 6th, 2022

Nursing

Thank you!

Customer 452707, June 29th, 2022

Education

Great

Customer 452813, June 29th, 2023

Nursing

They so amazing work!!

Customer 452707, January 29th, 2023

Nursing

Great work! Thank you so much.

Customer 452707, July 15th, 2022

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