Purchase Solution

Stock of sales merchandise

Not what you're looking for?

Ask Custom Question

Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the 1st day of each month, compute your forecast sales by each of the 3 methods requested below.
ACTUAL
June 140
July 180
August 170

a. Using a simple 3-month moving average, what is the forecast for September?
b. Using a weighted moving average, what is the forecast for September with wights of .2,.3, and .5 for June, July & August respectively?
c. Using single exponential smoothing & assuming that the forecast for June had been 130, forecast sales for September with a smoothing constant alpha of .3.

Please use Microsoft excel spreadsheet, thanks!

Purchase this Solution
Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Record transactions, sale, return, discount period

    446888 Accounting_integrated financial statement Merchandise with a list price of $7,500 and a cost of $7,000 is sold on account, terms 1/10, n/30. Prior to payment, merchandise with a list price of $1,000 and a cost of $800 is returned.

  • Midwest Distributing Company

    Midwest Distributing Company's chart of accounts includes: Cash, Accounts Receivable, Merchandise Inventory, Accounts Payable, Common Stock, Sales, Sales Returns and Allowances, Sales Discounts, Cost of Goods Sold, and Freight-out.

  • Accounting treatment for inventory

    Olaf Company's chart of accounts includes the following: No. 101 Cash, No. 112 Accounts Receivable, No. 120 Merchandise Inventory, No. 201 Accounts Payable, No. 311 Common Stock, No. 401 Sales, No. 412 Sales Returns and Allowances, No. 414 Sales Discounts

  • Prepare a merchandise purchases budget for the first quarter.

    answer jan feb march april may june opening stock 56000 90400 74000 62000 sales 24800 35600 26400 28400 19200 14400 closing stock 90400 74000 62000 opening stock+purchases-closing stock=sales purchases=sales-opening stock

  • At the beginning of the current season, the ledger of Villag

    The chart of accounts for the tennis shop includes Cash; Accounts Receivable; Merchandise Inventory; Accounts Payable; Common Stock; Sales; Sales Returns and Allowances; Purchases; Purchase Returns and Allowances; Purchase Discounts; and Freight-in.

  • Fairway Pro Shop - Journal entries and income statement

    shop includes Cash, Accounts Receivable, Merchandise Inventory, Accounts Payable, Common Stock, Sales, Sales Returns and Allowances, and Cost of Goods Sold Instructions: (a) Journalize the April transactions using a perpetual inventory system.

  • Midwest Distributing Company

    At the beginning of April, the ledger of Midwest showed Cash of $9,000 and Common Stock of $9,000.

  • CONSIGNMENT ACCOUNTING

    516932 Consignment Accounting for Tingey Industries Tingey Industries sells merchandise on a consignment basis to dealers. The selling price of the merchandise averages 25% above cost of merchandise.

  • Budget: Sales and Purchased

    187334 Sales budget and merchandise purchases budget Compare and contrast sales budget and merchandise purchases budget. How is the sales budget prepared? How is the merchandise purchases budget constructed?

View More Related Solutions