Period 1 2 3 4 5 6 Demand 43 11 20 30 50 26 ordering cost 100 120 100 100 100 120 inventory cost 5 10 5 10 5 13 product cost 10 2 7.5 10 10 5 According to the W-W algorithm, what is the order quantity for the period two?

Period 1 2 3 4 5 6 Demand 43 11 20 30 50 26 ordering cost 100 120 100 100 100 120 inventory cost 5 10 5 10 5 13 product cost 10 2 7.5 10 10 5 According to the W-W algorithm, what is the order quantity for the period two?

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: A clothing manufacturing company requires raw materials for 8 consecutive weeks as follows: 30, 40,…

A: To find out- The total cost of Procurement Meaning- Total Cost of Procurement (TCP) is a cost idea…

Q: 1

Q: A=$100 per order i = 25% c=$3 per unit Month, t Demand, Dt 1 20 2 50 3 10 50

A: Total Cost = Total Fixed Cost + Total Variable Cost Total Variable Cost = Average Variable Cost Per…

Q: answer in 30 minutes. The seasonal demand for a particular product is given below: Period 1 2 3 4 5…

A: Given:The fixed cost .The unit production cost .The holding cost is .Formula used:The total ordering…

Q: Determine the total inventory-related costs associated with the optimal ordering policy (do not…

A: Given data Annual demand (D) =5 tonnes × 12 converters ×360 days per year =21600 tons per years…

Q: 5. FCC Company has estimated the demands for a particular part as follows: Period 1 3 4 5 6. Demand…

A: Note: - Since we can answer only up to three subparts we will answer the first three…

Q: 1.) Assume a certain product has an order cost of $12. Holding cost is $1 per product to hold for a…

A: Order cost S = $12Holding cost H= $1Demand D= 200 units

Q: INVENTORY MANAGEMENT 6. Piped Piper has projected sales of 72,000 pipes this year, ordering cost of…

Q: How do I find the Economic Order Quantity (EOQ), the optimal order quantity, and the total annual…

A: Given data is

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: Describe methods other than the EOQ and EPQ for evaluating order amounts.

A: Inventory control mangement: Inventory control supports your business secure a fair amount of…

Q: If the company in #8 uses exponential smoothing (smoothing factor = .6) and the forecast for the…

A: Find the given details below: Given Details: Year Sales 2017 1000000 2018 1200000…

Q: )Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs…

A: use the minimax method to solve For respectively demand level, Regret =max (payoff for a demand…

Q: Company XYZ follows fixed order quantity model for Inventory planning. Annual Demand for the product…

A: Economic order quantity is the optimal quantity of inventory that the company should purchase to…

Q: The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 Demand 300 450 100…

A: Inventory management is the aspect of management that deals with managing, storing, and maintaining…

Q: Objectives of Inventory Control in Procter & Gamble.

A: Procter and gamble is an American MNC that produces consumer goods. They offer a huge range of goods…

Q: The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 Demand 300 450 100…

A: Inventory management is part of operations management that is concerned with managing and storing…

Q: 1. Determine the inventory order quantity for Diamant’s distributor. 2. Compare the optimal order…

A: 2) The economic order quantity is the optimal order quantity that would minimize the overall holding…

Q: A product whose EOQ is 120 units experiences a decrease in ordering cost from $90 per order to $10…

A: Companies determine their optimal order size by performing a calculation known as the economic order…

Question

Period	1	2	3	4	5	6
Demand	43	11	20	30	50	26
ordering cost	100	120	100	100	100	120
inventory cost	5	10	5	10	5	13
product cost	10	2	7.5	10	10	5

According to the W-W algorithm, what is the order quantity for the period two?

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: Define order quantity:

VIEW

Step 2: Calculate order quantity:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Josie Gall's firm has developed the supply, demand, cost, and inventory data that follow. Supply Available Period 1 2 3 Regular Time 40 35 40 Overtime 15 15 15 Subcontract 10 10 10 Demand Forecast 30 units $100 $150 $200 $6 50 65 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period, and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is (Enter your response as a whole number.)
10. A company will sell remote control devices online. Expected yearly demand is 3000 units and it is sold per 250TL. The controllers can be purchased from supplier A. Ordering cost is 40 TL and annual holding cost is 25% of the price. a. Calculate the economic order quantity for the company. b. Calculate the number of orders per year. c. List the assumptions of EOQ model that you used to calculate the value in part A.
can you help me with this, show me how to do on excel plz
An organization can use ABC analysis as a way of classifying its existing inventory. Explain how the ABC can be applied
Here it’s the answers I just need an explanation of how did you get that number.
please answer number 3 letter d only thanks
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
Use a mixed strategy - level of procuction (Jan-June) and chase demand (July- September with a support of overtime and sub-contracting not more than two workers and no limid for back orders. Jan 1000 Feb 2750 March 1250 April 1500 May 2250 June 1750 July 2750 August 2250 Sept 2500 Current work force 10 workers Production per worker Inventory holding cost Regular wage rate Overtime wage rate Sub-contracting wage rate Back-ordering wage rate Hiring cost Firing cost Beginning inventory 250 units per month S0.50 per unit per month $50.00 per unit S60.00 per unit $70.00 per unit $90.00 per unit $500 per worker S800 worker per 250 units Mth Regular Production Ending Back Order Demand OT S/k Workers Inventory J F M A. M J J Total Kos (Cost:
Sh29
A clothing manufacturing company requires raw materials for 8 consecutive weeks as follows: 30, 40, 50, 35, 60, 30, 40, and 30 units with a one-time order cost of $50,000 and a storage fee of $500 per unit/week. From these data calculate the total cost of procurement using:a. Lot For Lot (LFL) Methodb. Economic Order Quantity (EOQ) Methodc. Period Order Quantity (POQ) Method Using this table format: Week 1 2 3 4 5 6 7 8 Gross requirements Schedule receipts Projected on hand Net requirements Planned order receipts Planned order releases
Items purchased from a vendor cost $250 each, and the forecast for next year’s demand is 2,000 units. The optimal order size is 100. The firm operates 52 weeks next year and lead time is 3 weeks. It costs $5 every time an order is placed for more units, and the storage cost is $2 per unit per year. What is the number of orders per year? a.35 b.20 c.22 d.25 e.5
Given: Demand is 1984 items per month. The order frequency is 8 per quarter. The reorder point is 0. What is the lot size (Q)?