The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 120 90 100 75 110 50 75 130 110 90 a. Compute the monthly demand forecasts for April through November using a 3-month moving average. (5pts) b. Compute the monthly demand forecasts for June through November using a 5-month moving average. (5pts) c. Compute the mean absolute deviation (MAD) for June through October for each of the methods used. Which method would you use to forecast demand for November. (10pts)Why? (5pts) The Instant Paper Clip Office Supply Company sells and delivers office supplies to companies, schools, and agencies within a 50-mile radius of its warehouse. The office supply business is competitive, and the ability to deliver orders promptly is a big factor in getting new customers and maintaining old ones. (Offices typically order not when they run low on supplies, but when they completely run out. As a result, they need their orders immediately.) The manager of the company wants to be certain that enough drivers and vehicles are available to deliver orders promptly and that they have adequate inventory in stock. Therefore, the manager wants to be able to forecast the demand for deliveries during the next month. From the records of previous orders, management has accumulated the following data for the past 10 months: Month Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Orders 120 90 100 75 110 50 75 130 110 90 a. Compute the monthly demand forecasts for April through November using a 3-month moving average. (5pts) b. Compute the monthly demand forecasts for June through November using a 5-month moving average. (5pts) c. Compute the mean absolute deviation (MAD) for June through October for each of the methods used. Which method would you use to forecast demand for November. (10pts)Why? (5pts)
Expert Answer:
Answer rating: 100% (QA)
a Monthly data forecats for 3 months moving average Apr Nov Apr 90100753 8333 May 100751103 95 Jun 7... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these marketing questions
-
Hart Company sells and delivers office furniture across Western Canada. The costs associated with the acquisition and annual operation of a delivery truck are given below: Insurance. . . . . . . . ....
-
In what ways has culture been an important factor in human evolution?
-
An important factor in solid missile fuel is the particle size distribution. Significant problems occur if the particle sizes are too large. From production data in the past, it has been determined...
-
Requirement 1. Journalize the partners' initial contributions. (Record debits first, then, credits. Select the explanation on the last line of the journal entry table.) Begin by journalizing the...
-
Would you expect distributions of these variables to be uniform, unimodal, or bimodal? Symmetric or skewed? Explain why. (a) The number of songs that each student in your class has downloaded online...
-
Which of the following statements represents the valuation of accounts as of the end of the fiscal period? A. Balance sheet. B. Income statement. C. Statement of cash flows.
-
Hermione decided to purchase a new automobile. Being concerned about environmental issues, she is leaning toward the hybrid rather than the gasoline only model. Nevertheless, as a new business school...
-
Valmont, Inc., experienced the following events in 2012, in its first year of operation. 1. Received $20,000 cash from the issue of common stock. 2. Performed services on account for $50,000. 3. Paid...
-
Jane Company extends a warranty on childrens tablets. They estimate that 3% of tablets will need to be replaced. The sales price of one tablet is $150 and the cost is $75. Total tablet sales were...
-
Mesa, Inc., obtained 80 percent of Butte Corporation on January 1, 2011. Annual amortization of $22,500 is to be recorded on the allocations of Butte's acquisition-date business fair value. On...
-
A university lab is a research contractor to NASA for in-space fuel cell systems that are hydrogen- and methanol-based. During lab research, three equal-service machines need to be evaluated...
-
In auditing ICFR for a public company client, Emily finds that the com- pany has a significant subsidiary located in a foreign country. Emily's accounting firm has no offices in that country, and the...
-
What are the five components of an audit finding?
-
Audit evidence concerning proper segregation of duties ordinarily is best obtained by a. Inspection of documents prepared by a third party, but which contain the initials of those applying client...
-
AnnaLisa, an auditor for N. M. Neal & Associates, is prevented by the management of Lileah Company from auditing controls over inventory. Lileah is a public company. Management explains that controls...
-
What is an audit finding? How is an audit finding typically documented in the working papers?
-
31 of the current year a junior accountant prepared the following aging schedule for the company's outstanding receivables. Which of the following adjusting entries reflects the entry to record bad...
-
On October 1, 2014, the Dow Jones Industrial Average (DJIA) opened at 17,042 points. During that day it lost 237 points. On October 2 it lost 4 points. On October 3 it gained 209 points. Deter-mine...
-
Provide the missing data in the following table for a distributor of martial arts products: Division Alpha Bravo Charlie Sales $11,500,000 S ? $ 920,000 $210,000 Net operating income ? Average...
-
What is meant by the term cost behavior?
-
In the right-hand column below, certain financial ratios are listed. To the left of each ratio is a business transaction or event relating to the operating activities of Delta Company (each...
-
Is Russia experiencing a net capital inflow? Use the following balance of payments data for Russia (Russian Federation) from the IMF to answer this problem. Assumptions (million US$) 2000 2001 2002...
-
What is Russias total for Groups A and B? Use the following balance of payments data for Russia (Russian Federation) from the IMF to answer this problem. Assumptions (million US$) 2000 2001 2002 2003...
-
What is Russias total for Groups A through C? Use the following balance of payments data for Russia (Russian Federation) from the IMF to answer this problem. Assumptions (million US$) 2000 2001 2002...
Study smarter with the SolutionInn App