Question: please show how to answer in excel with formulas Big Blue Office Equipment sells computers. Monthly sales for a six-month period are as follows: Month

please show how to answer in excel with formulas

Big Blue Office Equipment sells computers. 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 Using Excel, answer the following items: a). Plot the demand on a chart b). Calculate a three-month moving average and a weighted moving average using .50 for June, .30 for May, and .20 for April. c). Which method has a higher forecasted amount for July? YOU MUST SHOW YOUR WORK TO RECEIVE FULL CREDIT. O both moving averages are the same O weighted moving average three-day moving average

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!

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...

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...

please show work and formulas. thank you National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Peb. Mar. Apr. May. Jun. Jul Nug....

How do you prepare the following journal entries needed after the beginning balance? Global Bike, Inc. 1a (Excel) 2015 WINT ACCY 310 - Accounting Systems Due, Monday, Jan 12, 8am Estimated time to...

Could you provide me with the necessary journal entries for each event from pages 9,10,11,12, and 13. while using the accounts listed on page 8. (Some events may not need journal entries) (Some...

Hello...I am in need of help with the adjusting entries please 100000 Bank Account 110100 Accounts Receivable (Direct Posting Account) 110150 Allowance for Bad Debts 110200 Interest Receivable 200600...

In this weeks small group discussion, youll share and evaluate communications audits for brands you know. First, pick a brand (each group member should have a DIFFERENT brand). Then, conduct an...

The design of Example 10.3 determined a lead network in order to obtain desirable dominant root locations using a cascade compensator Gc(s) in the system configuration shown in Figure 10.1 (a). The...

Shareholders have the right to know all except the company s financial position. True or False

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...