M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month.The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in thetable. Ordering cost is $55, and annual holding cost per unit is $4.OAllen Mfg.Quantity1-499500-9991000+Unit Price$16.0015.5015.00Baker Mfg.Quantity1-399400-799800+Unit Price$16.1015.6015.10a) What is the economic order quantity if price is not a consideration? 489 units (round your response to the nearestwhole number).b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg.c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component?The optimal order quantity is 1000 with a total cost of $ (round your responses to the nearest whole number).

Inventory management is the process of planning, organizing, and controlling the flow of goods and…

Answered: M. P. VanOyen Manufacturing has gone…

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

Similar questions

5. A product whose EOQ is 120 units experiences a decrease in ordering cost from $90 per order to $10 per order. The revised EOQ is: Select one: a. 900 b. 40 c. 360 d. 30 e. 10
A. Ltd buys 400 units of an item at a purchase cost Sh.5000 per unit and ordering cost of Sh.2,000 per order placed. The carrying cost is estimated at 24% of cost of an item p.a. The Co. has received a 2% discount offer for purchases of 100 or more units. Required: a) Determine the best inventory policy for this item. b) Determine the discount level at which the firm will be indifferent between taking and not taking the discount offer.
The next four questions concern the swim team at Blacksburg High School (BHS). The coach of the team must choose 4 swimmers for the 800 meter medley relay team. The medley relay consists of four strokes – backstroke, breaststroke, butterfly, and freestyle. The Excel spreadsheet illustrating the solution to this problem, as well as the coach’s expected times of each of her top 6 swimmers, are pasted below:
Develop an EOQ solution and calculate total relevant costs for the data in the preceding table.
Given the information below, conduct an ABC analysis and determine which items should be classified as A, B, and C. Which items do you suggest the firm keep the tightest control over? Explain. Item Part Number Item Cost Quantity In Stock 142-AZ $546.00 318 4392-GF $45.00 1250 86935-ES $15.35 3546 173-DC $653.00 1876 999-BA $199.00 526 7846-NM $23.00 973 2765-OP $385.00 790 103-VX $12.50 4875 2648-YT $16.75 5185
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.
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is $6. Allen Mfg. Quantity 1-499 Baker Mfg. Unit Price Quantity Unit Price $16.00 1-399 $16.10 15.50 15.00 400-799 800+ 500-999 1000+ 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 381 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? The optimal order quantity is ☐ with a total cost of $ (round your responses to the nearest whole number).
Scary Clowns, Inc., supplies special makeup cases to a major circus. The circus orders its EOQ of 800 cases every 3 months from Scary Clowns. Scary Clowns incurs setup costs of $5,000 every time it produces these cases, and its annual holding cost per case is $14. Question content area bottom Part 1 a. Which inventory model fits the best to this problem? A. All-units quantity discounts model B. Incremental quantity discounts model C. One-time sale model D. EOQ model E. POQ model F. Lumpy demand model b. Scary Clowns should produce enter your response here units in each batch (round your response to the nearest integer). c. The total annual setup and holding cost for Scary Clowns using this policy is $enter your response here (round your response to the nearest
Q4: Suppose that the demand for a product is 400 per year, and the items are withdrawn uniformly. The order cost is $25 and the inventory holding cost is $0.5 per item per year. If shortages cost $1 per item per year, find: 1. The economic order quantity. 2. Maximum inventory. 3.Shortage allowable quantity.
am. 124.
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $45, and annual holding cost per unit is $4. Allen Mfg. Quantity 1-499 500-999 1000+ Baker Mfg. Unit Price $16.00 15.50 15.00 Quantity 1-399 400-799 800+ Unit Price $16.10 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 435 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? (round your responses to the nearest whole number). The optimal order quantity is ☐ with a total cost of $
1. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the EOQ. 2. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the total carrying cost. 3. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the total ordering cost. 4. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the number of orders required per year. 5. Minmax Processing Company has an average requirement of 5 boxes of…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS