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...
-
Contrast CRT and LCD display monitors.
-
Give several examples of projects found in our society, avoiding those already discussed in the chapter.
-
Define the following: a. Asset b. Liability c. Net asset
-
The comparative financial statements of Blige Inc. are as follows. The market price of Blige Inc. common stock was $60 on December 31, 2012. Instructions Determine the following measures for 2012,...
-
Discuss the opportunities and threats that is associated with the external environment of the company selected
-
The plots below show sampling distributions of p-values for different values of power. Match the distribution to the power. Please note that for this problem, you must pick values of power for all...
-
Suppose that we wish to add the operation PRINT-SET.x/, which is given a node x and prints all the members of xs set, in any order. Show how we can add just a single attribute to each node in a...
-
After considerable research, a winter products line has been developed. However, Silven's president has decided to introduce only one of the new products for this coming winter. If the product is a...
-
Data for six weeks from a carpeting crew is as follows: Week Crew Size Yards Installed 1 4 96 2 3 72 3 4 92 4 2 50 5 3 69 6 2 52 Compute the labor productivity (= yards installed per crew member) for...
-
Case Study: Impact of International Financial Reporting Standards (IFRS) on Auditing Introduction: The adoption of International Financial Reporting Standards (IFRS) has significantly influenced the...
-
After watching the video posted below, answer the review questions. 6 Steps to Formulate a STRONG Hypothesis | Scribbr Link: https://youtu.be/PCgLjDDD4ek How To Write Literature Review In 3 Simple...
-
Complete the following table by matching each of the scenarios to the concept of resale price maintenance, predatory pricing, or tying. Scenario Resale Price Maintenance Predatory Pricing Tying...
-
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $6.2 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and...
-
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...
-
Consider the electrical circuit shown below where \(v_{i}(t)=\beta\), for \(t \geq 0\). Find the dynamic system response \(v_{o}(t)\). VC C ww R V;(t) R ww R3 A First-Order Electrical System Vo (t) +
-
Find the dynamic system response for the spring mass damping system shown in Figure 3.2, where \(f(t)=\beta, x(0)=0\) (i.e. there is no initial energy stored). b f(t) k Figure 3.2 A first-order...
-
Consider a first-order system with a forcing function \(f(t)\) such that input-output differential equation is given by \[\begin{equation*}\dot{y}+3 y=f(t) \text {, } \tag{3.7}\end{equation*}\] where...
Study smarter with the SolutionInn App