Answer Problem #3 : items 11& 12 Problem 3: Economic Order QuantityGHI Company has an annual demand of 100,000.00 units of Material Y. The ordering cost is 125.00 per order, cost perunit 5.00, and the annual carrying cost per unit is 1.00. Assume that the units will be required evenly throughout the year.Compute for the following:9. Economic order quantity10. Number of orders made on first quarter11. Total carrying cost12. Total ordering cost

Ordering Cost The total ordering cost would be the product of the cost per order O and the number of…

Answered: Problem 3: Economic Order Quantity GHI…

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

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.
please Solve question G,H AND I Question A to F IS SOLVED (a) What is the expected jet fuel yearly average demand D? =4160 tons(b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit(c) Given the EOQ, what is the total inventory holding cost?= $1067695.2(d) Given the EOQ, what is the total inventory ordering cost? =OC=$1067726.4(e) Given the EOQ, what is the total annual inventory cost?TIC=2135421.6 =1.32(f) What is the time between orders in weeks? = 39.39 The airport is convinced that placing an order every season (every P = 13weeks) will be best. It is also aware that the expected demand will varywith a standard deviation of 20 tons, so it needs to take this information into account. (g) What is the protection period required by the proposed 13-week periodic review system?(h) The airport is required by the airlines to maintain a 99.75% service level.What is the required safety stock?(i) Calculate the order size (Q) when using P = 13.(j)…
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
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. b. Determine the number of orders per year.
For a specific farm implement ‘FI’ is to be ordered by a food processing company, following data is available: Monthly Demand= 800 units Purchase cost/unit = $40/unit Ordering costs= $60/ order Holding costs (Ch) = $12/unit/year, fire insurance = 6% of the unit cost, 2% other overheads. Determine optimal order quantity of ‘FI’ items and how frequently the order should be placed?
Please do G,H,I,J,K and L (a) What is the expected jet fuel yearly average demand D? =4160 tons(b) Given D, find the order lot size Q that gives the economic order quantity (EOQ). =60.39 unit(c) Given the EOQ, what is the total inventory holding cost?= $1067695.2(d) Given the EOQ, what is the total inventory ordering cost? =OC=$1067726.4(e) Given the EOQ, what is the total annual inventory cost?TIC=2135421.6 =1.32(f) What is the time between orders in weeks? = 39.39 The airport is convinced that placing an order every season (every P = 13weeks) will be best. It is also aware that the expected demand will varywith a standard deviation of 20 tons, so it needs to take this information into account. (g) What is the protection period required by the proposed 13-week periodic review system?(h) The airport is required by the airlines to maintain a 99.75% service level.What is the required safety stock?(i) Calculate the order size (Q) when using P = 13.(j) What is the total annual inventory…
SOLVE THE NEWSPERSON PROBLEM. PROBABILITY 0.24 0.08 0.21 0.16 0.08 0.23 VALUE 1 2 3 4 5 6 PURCASE COST C = 12 SELLING PRICE P = 28 SALVAGE VALUE V = 4 What is the optimal order quantity?
A initially assume that Phi wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using a lot-for-lot (L4L). Gear box requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input shaft requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release
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…
Economic order quantity (Q*) is 4,000 units. Annual demand (D) is 12,000 units. Find number of orders per year (N*) and time between orders (T*) in years. Group of answer choices N*=3 times per year, T* cannot be calculated N*=0.33 times per year, T*= 0.33 weeks N*=17.3 times per year, T*= 3 years N*=3 times per year, T*= 0.33 years N*=3 times per year, T*= 3 years
PT Bulan Sabit is a company engaged in fan manufacturingair conditioner with the following production datai. Setup fee = $15ii. Inventory cost per fan per year = $ 125iii. Production capacity per day = 246 fansiv. Production time per fan = 2 daysv. Fan requirement per year = 20,000 fansvi. Safety stock = 1/2 day fan productionIf PT Bulan Sabit wants to implement Kanban, then calculate the needs of the companyas follows:a) Explain the definition and purpose of kanban b) Specify production order quantity c) Calculate the container kanban that must be provided by PT Bulan Sabit Assuming the time used is per year 50 weeks and 5 days per week
ITEMS 14 and 15 ARE BASED ON THE FOLLOWING INFORMATION: The following information is available for Edgar Corporation's Material X Annual usage 12,600 units Working days per year 360 days Normal lead time 20 days The units of Material X are required evenly throughout the year. 14. What is the reorder point? a. 35 units c. 700 units b. 20th-day d. 630 units 15. Assuming that occasionally, the company experiences delay in the delivery of Material X, such that the lead time reaches a maximum of 30 days, how many units of safety stock should the company maintain and what is the reorder point? Safety Stock Reorder Point a. 350 1,050 b. 350 700 c. 0 1,050 d. 1,050…

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