You work as a planner in the supply chain department for AFIA co. Given the monthly gross requirements for one of theitems (Carton). Your job is to develop an ordering plan and costs for:a) Lot-for-lot.b) EOQ.c) Which plan should we select ?Calculate the total cost of each plan.Please use the following information :Holding Cost per month = $ 0.75Set Up Cost = $ 150Lead time = 0Master Production Schedule :Month12456.Grossrequireme100150200150100150250ntsAttach your solutions(Answer the total cost of EOQ plan in field)

Given- Setup cost (S) = $150 Holding cost per month (H) = $0.75

Answered: You work as a planner in the supply…

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

Fush uses an average of 40 boxes of paper serviettes a day. The restaurant operates 260 days per year, storage and handling costs for the serviettes are $ 30 per year per box, and it costs approximately $60 to order and receive a shipment of serviettes. a. Calculating the order size would minimise the sum of annual ordering and carrying costs? b. compute the total annual costs using your size from part a?
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…
Enumerate and explain the methods of inventory tracking. Give some examples of businesses where they are best applicable.
hello please answer number 2 only thank you
52 Demand for an item is 3,800 units per year. Each order placed costs $15; the annual cost to carry items in inventory is $10 each. In what quantities should the item be ordered? Note: Round your answer to the nearest whole number.
The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $ 1.3 Calculate total ordering cost using following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity Which method you will chose to order and why? Please do fast... ASAP... do fast
Please do not give solution in image format thanku A mail-order house uses 16,820 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.
Answer all sub part questions.
answer both parts
Jean-Ma rie Bourjolly's restau rant has the followinginventory items that it orders on a weekly basis: a) Which is the most expensive item, using annual dollar volume?b) Which are C items?c) What is the annual dollar volume for all 20 items?
Develop a POQ solution and calculate total relevant costs for the data in the preceding table.
Please do not give solution in image format thanku Carousel Restaurant in Coquitlam is using perpetual inventory control method. Determine the reorder quantity of chickpeas cans if the par stock is 25 cans, delivery takes 5 days, the daily usage is 2 cans and the desired safety factor is 1.5 a. 10 b. 20 c. 25 d. 15

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