3.. Calculate the Economic Order Quantities (EOQs) for the A items. Cat. ref.Sales Unit DescriptionSamplenumberSales UnitLast 12 mo. Inventory as Reordersales (units) at last year Quantityend (units) (Units)1,0001,000numberCost (€)111036Disposable Aprons (10pk)Ear-loop Masks(Box)Drill Type 164Disposable Gloves Large150ml SyringeIntubation Tube (Adult)Pocket Organiser Blue2.40100,0002114563.6060,0001203115631.10220420250120541237243.5035,4008,50010,00011.3043012010097.406,5001206.127742020129797.00160500813063CPAP Consumable Kit187.0040010Zinc Oxide TapeStethoscope HeadDisp. Latex CatheterRoll-up Wheelchair RampLFT Tube132361.501,2605010134546.2510162511135970.603,56012201213999152.5012445013140681.4022,50010,5008,000Cervical CollarHead Wedge141424212.00140242014310144051589.00441016Three-Wheel Scooter755.00141714456Neonatal Trach. Tube80.402686.10014675Mouldable Strip PasteSequential Comp. PumpToilet Safety Frame10.201,250430181721001914854430.004050202494325.605601820Weeks per annum:52.14Holding cost (%)Ordering cost (€)1550 ABC Analysis of Usage ValueSample Number Cat. Ref. No. Sales Units Description Sales Unit Cost (a) Last 12 Month Sales Units (b) Usage Value (a x b) Percentage in Total Usage Value Cumulative Percenatge Analysis6,500€ 97.40€ 2.40€ 633,100.00€ 240,000.00€ 216,000.00€ 184,900.00€ 123,900.00€ 74,800,00€ 21,547.20€ 17,500.00€ 14,336.00€ 12,750.00€ 10,570.00€ 4,859.00€ 3,916.00€ 2,136.00€ 1,890.00€ 1,830.00€ 1,680.00€ 840.00€ 242.00€ 62.50€ 1,566,858.706.12774Intubation Tube40.41%40.41%A111036100,00055.72%Disposable Apron (10pk)Ear-loop Mask (Box)Sequential Comp. PumpDispisable Gloves Large15.32%B€ 3.60€ 430.0021145660,00013.79%69.51%191485443011.80%81.31%€ 3.50€ 187.00€ 80.40€ 1.40€ 25.60€ 10.20€ 755.0041205435,4007.91%89.22%813063CPAP Consumable Kit4004.77%93.99%1714456Neonatal Trach. Tube2681.38%95.37%1314068LFT Tube12,5001.12%96.48%Toilet Safety FrameMouldable Strip Paste20249435600.91%97,40%18146751,2500.81%98.21%1611405Three-Wheel Scooter140.67%98.89%150ml Syringe€ 11.30€ 89.00€ 0.60€ 1.50€ 152.50€ 12.00€ 7.00€ 1.10€ 6.255123724300.31%99.20%1514310Head Wedge440.25%99.45%Disp. Latex CatheterZinc Oxide Tape11135973,5600.14%99,58%9132361,2600.12%99.70%1213999Roll-up Wheel Chair Ramp120.12%99.82%1414242Cervical Collar1400.11%99.93%Pocket Organiser BlueDrill Type 164Stethoscope Head7129791200.05%99.98%3115632200.02%100.00%1013454100.00%100.00%Total

A item = Sample number 6 Annual usage (D) = 6500Ordering cost (O) = 50Holding cost (H) = 15 % of…

Answered: Calculate the Economic Order Quantities…

Business

Operations Management

Calculate the Economic Order Quantities (EOQs) for the A items.

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

Period 1 2 3 4 5 6 Demand 43 11 20 30 50 26 ordering cost 100 120 100 100 100 120 inventory cost 5 10 5 10 5 13 product cost 10 2 7.5 10 10 5 According to the W-W algorithm, what is the order quantity for the period two?
b. Suppose that the MPS for the end item isWeek 30 31 32 33 34 35MPS 165 180 300 220 200 240If production is scheduled on a lot-for-lot basis, find the planned order releasefor component F
Please do not give solution in image format thanku
Develop an EOQ solution and calculate total relevant costs for the data in the preceding table.
Here it’s the answers I just need an explanation of how did you get that number.
Using the gross requirements schedule below*, prepare an alternative ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100). What is the cost of this ordering system? D Period 1 2 3 Gross requirements 35 30 40 4 5 6 7 8 9 10 0 10 40 30 0 30 55 *Holding cost = $1/unit/week; setup cost = $100; lead time = 1 week; beginning inventory = 35 units. Prepare a net requirements plan (enter your responses as whole numbers). The holding cost of this ordering system is $ The setup cost of this ordering system is $ The total cost of this ordering system is $ Period Gross requirements On-hand at beginning of period 35 On-hand at end of period Net requirements Order receipt Order release (enter your response as a whole number). (enter your response as a whole number). (enter your response as a whole number). 1 35 2 3 30 40 4 0 7 8 9 10 0 30 55 5 6 10 40 30
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. 5 6 7 30 70 30 9 10 11 12 60 10 70 Period 1 Gross requirements 20 2 Period Gross requirements On-hand at beginning of period 40 On-hand at end of period Order receipt Order release 3 40 1 20 4 *Holding cost = $3.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). 2 3 40 4 8 5 6 30 7 70 30 8 9 10 11 12 10 70 60 corn
Please do not give solution in image format thanku
If no safety stock is required, what would the re-order point be?
Full steps
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…
In reference to the attached image: What would be the impact of a scheduled receipt of 200 units for item B in week 3 (and allother data remained the same) on your calculated planned order receipts and releases?