stsolve thisKIf D = 7,700 per month, S = $46 per order, and H= $1.50 per unit per month,a) What is the economic order quantity?The EOQ is 1458 units (round your response to the nearest whole number).Calculator Ask my instructor2F23F3$45F56F6&7F7*F

Answered: If D = 7,700 per month, S = $46 per…

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

i need the answer quickly
10.5 An SKU has an annual demand of 10,000 units, each costing $20, ordering costs are $80 per order, and the cost of carrying inventory is 25%. Calculate the EOQ in units and then convert to dollars.
If D = 7,800 per month, S = $46 per order, and H= $2.50 per unit per month, a) What is the economic order quantity? The EOQ is units (round your response to the nearest whole number).
Discuss what is meant by ABC analysis of inventory.Name several measures that can determine ABCstatus
Can someone please help me with the folowing problems on excel with the formulas. Thank you
Enter the formulas in the template. The numeric answers are to the right. Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand = Carrying cost = Ordering cost = EOQ = Average Inventory Order per year = Total Cost = Quantity Ordered $200.00 $190.00 2,500 Total Cost Order Cost Order Cost (D/Q* Ordering Cost) Carry Cost Carry Cost (Q/2* Carrying Cost) Purchase Cost (D* Price) Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand = Carrying cost = Ordering cost = EOQ = Average Inventory Order per year = Total Cost = Quantity Ordered 72.5 72.5 90.0 125.0 150.0 200.0 $200.00 $190.00 2,500 72.5 36.3 2.8 $13,784.05 Order Cost $6,892 Total Cost $ 293,784.05 $ 233,784.05 $ 194, 105.56 $ 194,875.00 $ $ 198,500.00 $2,500.00 Order Cost (D/Q* Ordering Cost) $6,892.02 $6,892.02 $5,555.56 $4,000.00 195,583.33 $3,333.33 Carry Cost $6,892…
If D = 8,500 per month, S = $46 per order, and H = $2.00per unit per month, a) What is the economic order quantity? The EOQ is enter your response here units (round your response to the nearest whole number).
i need the answer quickly
Joe Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The fo llowing information is known about the brackets: a) Given the information, what would be the economic order quantity (EOQ)?b) Given the EOQ, what would be the average inventory? What would be the annual inventory holding cost?c) Given the EOQ, how many orders would be made each year? What would be the annual order cost?d) Given the EOQ, what is the total annual cost of managing the inventory?e) What is the time between orders?f) What is the reorder point (ROP)?
Abey Kuruvilla, of Parkside Plumbing, uses 1,250 of a certain spare part that costs $26 for each order, with an annual holding cost of $27. a) Calculate the total cost for order sizes of 25, 40, 50, 60, and 100 (round your responses to two decimal places). b) What is the economic order quantity? units (round your response to two decimal places).
m12h6p5
1. What is the economic order quantity for BBE in units? In pounds? 4.What is the total cost for using air carrier transportation?

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

If D = 7,700 per month, S = $46 per order, and H = $1.50 per unit per month, a) What is the economic order quantity? The EOQ is 1458 units (round your response to the nearest whole number).