What is the 3-month simple moving average for February 2017, given that demand was 100 during October 2016, 200 in November 2016, 300 in December 2016 and 400 in January 2017? a. 350 b. 300 c. 250 d. 400

What is the 3-month simple moving average for February 2017, given that demand was 100 during October 2016, 200 in November 2016, 300 in December 2016 and 400 in January 2017? a. 350 b. 300 c. 250 d. 400

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: The table above provides the aggregate plan of production by a firm. It is known that the firm uses…

A: Stockout is a situation when the inventory stock of a company is less than the demand for the…

Q: Describe the concept of independent vs dependent demand. Give an example of each.

A: Demand refers to the desire that a consumer has to buy a good or service. It depends on many factors…

Q: Barangay Punta Princesa is trying to decide between two alternative order plans for its inventory of…

A: Given- Annual Demand (D) = 1000 units For plan A: Ordering cost (S)=40 per order Holding Cost (H) =…

Q: Use the following data of Starfish, Inc. Unit Total Units Units Cost Cost Sold Beginning inventory…

A: Step 1: Determine the total cost of goods available for saleStep 2: Divide the total cost of goods…

Q: What is the difference between dependent and independent demand?

A: Demand refers to the desire of the consumer to buy a good or service. It depends on many factors…

Q: 2. Avondale ice-cream shop in St Catherine's has been buying vegan-custard for its own plant base…

A: Given - Annual Demand (D) = 720 units Ordering Cost (S) = $6 Holding cost (H) = 20% × $25 = $5

Q: A: Find the expected demand for (2020) by using SMA and WMA. Years Demand Probability 2016 8 0.11…

A: Expected demand=8+11+13+154=11.75 Hence, the expected demand using SMA is 11.75.

Q: If a company's product demand is 100 units in month 1, 75 units in month 2, 110 units in month 3 and…

A: MonthDemand11002753110450

Q: Month# Forecast# Jan Feb Mar Apr May 1800 2000 1000 320 1500 Starting inv. # 109 0 0 0 197 Net…

A: level plan means similar production rate in every period.

Q: G E D в A Application of weights 1month oder quantity 20 weights the month 0.3 1 2month 0.4 15 2…

A: This is the information given:

Q: In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each…

A: Average = 1100 Projected sales = 1300 Future Sale(F)= 1300/1100 = 1.18 Average demand(D) F…

Q: Use the decomposition technique to forecast demand for the next four quarters. (Do not round…

A: Seasonal average = Average of each quarter of every given year. Seasonal indices = Deseasonalized…

Q: Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-in, first-out…

A: According to the FIFO method, the inventory which comes first in the warehouse will be sold first.…

Q: Meaning of ABC analysis?

A: ABC stands for Always Better Control analysis. It is one of the most commonly used inventory…

Q: Cost of Good Sold Beginning Inventory (In Pesos) Ending Inventory (In Pesos) 1…

A: Inventory Turnover Ratio is calculated with the help of following formula Inventory Turnover Ratio…

Q: Given the information below, conduct an ABC analysis and determine which items should be classified…

A: ABC analysis is used to help identify the most important products in their portfolio and ensure they…

Q: Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50…

A: There are different forecasting techniques are available to predict future values. But for different…

Q: Assume an initial starting Ft of 200 units, a trend (Tt ) of 8 units, an alpha of 0.30, and a delta…

A: C 208Explanation:

Q: What is marginal revenue (MR)?

A: Marginal revenue (MR) is the expansion/additional in income that comes from the offer of one extra…

Q: Q4) ABC costing helps the organization decreases costs associated with good decisions and keep pace…

A: The ABC costing is for better allocating expenses and thus help in getting appropriate cost which…

Q: ••$11.8 Over the past 12 months, Super Toy Mart has expe- rienced a demand variance of 10,000 units…

A: A Small Introduction About Forecast Forecasting is a strategy that involves recorded information…

Q: Explore the impact of demand variability on the effectiveness of the Wilson approach

A: A common method for managing inventory is the Wilson Inventory Model, sometimes referred to as the…

Q: 1. What is the total revenue of Solet's Paradise Guest House in Negril Jamaica for the year 2021 or…

A: Solet's Paradise Guest House is a small, family-owned guest house located in Negril, Jamaica. It has…

Q: What is the reorder point? What would be the effect on the ROP if lead time were five weeks instead…

A: The process of ordering, storing, using, and selling a company's inventory is called inventory…

Q: Define safety stock and service level? How these two are related to each other?

A: Safety Stock A quantity of excess stock maintained on hand to avert stock outs caused by supply and…

Q: You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the…

A: The optimal number of newspaper can be calculated using below given standard equations. Optimal…

Q: • 12.10 Matthew Liotine's Dream Store sells beds and as- sorted supplies. His best-selling bed has…

A: Annual Demand = 400 unitsOrdering Cost = $40Holding Cost = $5 per unit per year

Q: Compute and tabulate the daily demand for each month in the table below (round off to the nearest…

A: Level produciton in aggregate planning refers to production of same number of units in each period…

Q: (a) Give examples of independent and related dependent demand

A: Note:- We are authorized to answer one question at a time, since you have not mentioned which…

Q: One unit of A is made of three units of B. one unit of C. and two units of D. B is composed of two…

Q: Period On hand = 30 1 2 5 6 Forecast 100 50 100 50 100 50 Customer Orders 75 50 116 73 45 23 Master…

A: available to promise ( ATP) for Period 1 = Previous Period Inventory + MPS of Current Period -…

Q: Using the actual demand shown in the table below, and a 3-month weighted moving average with weights…

A: Sl No. Months Demand 3-month Wt. Moving Average (weights: 0.1, 0.4, 0.5) 1 Nov 39 2 Dec 36…

Q: Question 2: Your firm uses a periodic review system for all SKUs classified, using ABC analysis, as…

A: Given data: Demand = 29000 units/yearOrdering cost = $125 per orderHolding cost = $3 per unity per…

Q: The current data for five trees that will be analyzed in the exercise are shown in the following…

A: Inventory position is the total inventory an organization has in its supply chain. It includes the…

Q: Problem 16-16 (Algo) The McDonald's fast-food restaurant on campus sells an average of 4,800…

A: Given- Average Sales = 48 Qtr PoundInventory On-hand = 465 poundsPurchase cost = $3Working weeks in…

Q: am. 183.

A: The 4-period moving average method is a commonly used technique in time series forecasting. It…

Q: Franklin Company makes fine jewelry that it sells to department stores throughout the United States.…

A: Fixed cost will be advertising and depreciation. Bracelet A: Advertising cost per year = 8,800…

Question

What is the 3-month simple moving average for February 2017, given that demand was 100 during October 2016, 200 in November 2016, 300 in December 2016 and 400 in January 2017?

350

300

250

400

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

If the company in #8 uses exponential smoothing (smoothing factor = .6) and the forecast for the year is the figure they use for EOQ calculations, calculate the EOQ using the following information: The cost of ordering and carrying cost % are the same as #7 Cost of ordering: $25 Carrying costs: 45% Starting with 2018, Forecast the 2020 demand using exponential smoothing and then use that forecast as the annual demand. year sales 2017 1,000,000 2018 1,200,000 2019 2,000,000 2020
Ex2: Find the expected demand for 2020. a = 0.6 (picture)
Answer 12.8
Does variation in demand matter? What is its respective implications? (High/low)
PLEASE ANSWER BOTH QUESTIONS without excel a) Using a weighted moving average with three periods, determine the demand for period 13. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively b) Find the MAD, MSE and MAPE
Q2) Groundz Coffee Shop uses 4 kgs of a specialty tea weekly; each kg costs $16. Carrying costs are $1 per kg per week because space is very scarce. It costs the firm $8 to prepare an order. Assume 52 weeks per year. How many kgs of tea should Groundz order at a time? What is total annual cost. How many orders should Groundz place annually. Q2) Groundz Coffee Shop uses 4 kgs of a specialty tea weekly; each kg costs $16. Carrying costs are $1 per kg per week because space is very scarce. It costs the firm $8 to prepare an order. Assume 52 weeks per year. How many kgs of tea should Groundz order at a time? What is total annual cost. How many orders should Groundz place annually.
Which product represent cash caw, question mark, dog and star in mtn products
Please do not give solution in image formate thanku.
Amy lives in Papar but works in Kota Kinabalu. After struggling for years with public transport such as mini-buses and the train and receiving many complaints from fellow travelers, she has decided to look into providing several upgraded bus services in and around Kota Kinabalu which would provide more comfort and hygiene. The busses will be modern, air-conditioned and either hybrids or electrical. Amy is using the public transport busses as used in KL as a model. The prices charged to the customer would be somewhat above the current mini-bus prices but Amy believes that many commuters will be more than willing to pay a bit extra for a comfortable and safe alternative. Prepare Porter’s Five Forces for Amy’s planned bus services.
Toys "R" Us had cost of goods sold of $12,355 million, ending inventory of $3,187 million, and average inventory of $2,343 million. Its days' sales in inventory equals:
Demand history for the past three years is shown below, along with the seasonal indices for each quarter. Seasonal Index Year Year 1 Year 2 Year 3 Quarter Q1 02 03 04 Q1 02 Q3 04 01 Q2 Q3 04 Demand 225 253 392 310 229 242 391 360 220 256 400 288 0.756 0.845 1.327 1.075 0.756 0.845 1.327 1.075 0.756 0.845 1.327 1.075 Do not round intermediate calculations. Round your answer to the nearest whole number. Use exponential smoothing with alpha (a) = 0.2 and an initial forecast of 297 along with seasonality to calculate the Year 4, Q1 forecast.
Please do not give solution in image format thanku