please answer within 30 minutes. Consider the following requirements for an office chair product.Week123Gross requirements15090 3004 5 60 350 200The company has a setup cost of $50, a holding cost per week of $10, beginning inventory of 400, and lead time of2 weeks. What is the total inventory holding cost of using a lot-for-lot policy for this six-week inventory period?A. $9,100B. $4,100C. $4,250D. $4,350E. $3,060

Answered: Consider the following requirements for…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 22P

See similar textbooks

Similar questions

Please complete the sup part: e,f and g. 1.B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth-order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&H’s average holding…
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
1) What is the total demand of an enterprise with an economic order quantity of 1,500 units, a cost of 11.250 TL for each order, and 75 TL for one unit of inventory?a) 20,000b) 17,500c) 7,500d) 12,500f) 2,500 2) What is the total inventory cost of this business?a) 200,000b) 239,000c) 185,250d) 168,750e) 218,500
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onb. Least unit cost
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ond. Which lot-sizing method resulted in the lowest cost for the 12 periods?
Average Inventory Calculation—Fixed–Order Quantity ModelSuppose the following item is being managed using a fixed–order quantity model with safety stock.Annual demand (D) = 1,000 unitsOrder quantity (Q) = 300 unitsSafety stock (SS) = 40 unitsWhat are the average inventory level and inventory turn for the item?
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ona. Silver–Meal.
The table below provides demand data for 11 days (days 10-20 for the current year) for one product for the next 4 questions. The previous order was for 300 units at the end of day 9. The lead time is a constant two days. At the beginning of day 10 the inventory level is 450 units. Orders are made at the end of a day. Suppose inventory is managed with a reorder point system where Q=300 and the reorder point is 250. Day Demand Inventory 10 120 11 150 12 120 13 100 14 80 15 80 16 60 17 60 18 60 19 40 20 80 1) When is the next order? end of day ________ 2) How large is the next order? ________ 3) When is the subsequent order (after that above)? end of day _______ 4) How large is that order? _________
c. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.
A mail-order house uses 17,460 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity __________ boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order _____________ per year
The time-phased net requirements for the base assembly in a table lamp over thenext six weeks areWeek 1 2 3 4 5 6Requirements 335 200 140 440 300 200The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week.c. Determine the lot sizes using the least unit cost heuristic
DOGGE Ltd has annual demand of 50,000 desks and the purchase price of each desk is K250. There are ordering costs of K200 for each order placed. Inventory holding costs amount to 10% per year of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph: 500 units, 750 units, 1000 units, 1250 units b) Using the information in (a) above calculate i) Economic Order Quantity and the total inventory costs for this order quantity.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS