Question: Please explain and show how to do problem number 3 for problem B, thanks. 1. Ms. Winnie Lin's company sells computers. The monthly sales for

Please explain and show how to do problem number 3 for problem B, thanks.

1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH SALES Jan 18,000 Feb 22,000 Mar 16,000 Apr 18,000 May 20,000 Jun 24,000 a. Plot the monthly data on a sheet of graph paper. b. Compute the sales forecast for July using the following approaches: (1) a three-month moving average: (2) a weighted three-month moving average using 0.50 for June, 0.30 for May, and 0.20 for April (3) a linear trend equation; and (4) exponential smoothing with a (smoothing constant) equal to 0.40, assuming a February forecast of 18,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

just need question C and D. please do not copy what the other chegg answers have put for these questions. 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as...

This assignment provides you with the opportunity to synthesize and apply what you have learned in chapters 3 through 5. It consists of 3 questions and multiple sub-questions for a total of 100...

b . Compute the sales forecast for July using the approaches given below. Do not round intermediate calculations. Round your answers to the nearest whole number. a three - month moving average...

Excel format please: 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH Jar Feb Mar Apr May Jun SALES 18.000 22.000 16.000 18.000 20.000...

s. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: Compute the sales forecast for July using the approaches given below. Do not round intermediate...

how would i put these answers on an excel spread sheet? PROBLEMS 1. Ms. Winnie Lin's company sells computers. The monthly sales for a six-month period are as follows: MONTH SALES Jan Feb Mar Apr May...

Problem 1: (5.pts.-> 3+2: Brian Adams, the manager of the company Design-Plus is upgrading his ERP software. The high-performance software (ORACLE) can be rented for $3.000 per month per computer...

A retailer purchases an item called XYZ at $ 10 per unit from its supplier. The demand is steady at 100 units per week. This retailer has 50 working weeks per year. The supplier decides to offer...

wrong). Weights Days Package 1 Package 2 Package 3 Package 4 Monday 21 22 20 24 Tuesday 23 21 19 21 Wednesday 20 19 20 21 Thursday 18 19 20 19 Friday 18 20 22 20 Q.3.A. What is the sample size (n) in...

1. Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows: Month Sales Jan 18,000 Feb Mar 22,000 16,000 18,000 Apr May 20,000 Jun 24,000 a. Plot the monthly...

In a recent city meeting, it was agreed that the city was going to build a new town hall. Long-term bonds, intergovernmental transfers, and public donations will be used to construct and maintain the...

A retail company offers a "scratch off" promotion. Upon entering the store, you are given a card. When you pay, you may scratch off the coating. The company advertises 50% of the cards are winners...

One of our suppliers is offering the above terms ( 5 1 6 net 9 1 ) . We can borrow at an interest rate of 6 . 6 % . Should we take the early payment option? No , the cost to borrow is higher than the...

Which statement is true regarding corporations?