EOQ | 100 | |||||||||
Holding cost | 1 | per unit per week | ||||||||
Setup cost | 200 | |||||||||
Lead time | 1 | week | ||||||||
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Gross requirement | 25 | 20 | 50 | 0 | 10 | 40 | 30 | 0 | 30 | 65 |
On hand at beginning of period|25 | 25 | 100 | 80 | 30 | 30 | 120 | 80 | 50 | 50 | 120 |
On hand at end of period | 0 | 80 | 30 | 30 | 20 | 80 | 50 | 50 | 20 | 55 |
Net requirement | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 45 |
Order receipt | 100 | 100 | 100 | |||||||
Order release | 100 | 100 | 100 | |||||||
Average inventory (beginning inventory+onhand inventory at end of period)/2 | 12.5 | 90 | 55 | 30 | 25 | 100 | 65 | 50 | 35 | 87.5 |
Average Inventory | 55 | |||||||||
Holding cost | 1 | per unit per week | ||||||||
Holding cost per unit per 10 weeks (10 week period) | 10 | |||||||||
Inventry holding cost | 550 | |||||||||
Number of orders | 3 | |||||||||
Ordering or set up cost (no of order*set up cost (200) | 600 | |||||||||
The cost of this ordering system (Hoding cost+setup cost) | 1150 |
Using gross requirements schedule below, prepare an alternative ordering system that always orders 100 units the...
American Electronics produces Tough-Robot for lawn mowing purposes. The production manager of American Electronics would like to create an MRP for their Tough-Robot with a minimum cost possible for the plan. The following table show gross requirements of Tough-Robot for ten weeks. You are asked to develop a solution using an ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100) as a Lot Sizing technique. What is the cost of...
3. Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table" Period 1 2 3 4 5 6 789 10 12 Gross requirements20 40 40 70 30 10 70 50 Holding cost- $3.50/unit/week; setup cost $150; lead time 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers) Period Gross 3 4 5 6 9 20 40 40 70 30 10 uirements On-hand at beginning of On-hand at...
Problem 14.22 Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Period 1 2 3 4 5 6 789 10 11 12 Gross requirements 30 40 40 70 20 10 80 60 Holding cost$1.50unit/week; setup cost $150; lead time 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 78 9 0 11 12 Gross requirements 40 40 70 20...
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table Period 1 23 4 5 6 7 89 10 12 Gross requirements 30 40 40 70 20 10 80 60 Holding cost $1.50/unit/week; setup cost $150; lead time 1 week; beginning inventory 40 Develop a lot-for-lot solution (enter your responses as whole numbers) Period 1 2 3 45 6 7 8 9 10 111 Gross requirements 30 40 40 70 20 10 80...
Develop a lot-for-lot 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 | 30 40 30 70 30 20 70 50 *Holding cost = $3.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). 2 4 8 11 3 40 5 30 6 70 7...
The total cost is $____ )enter your response as a whole number) Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 6 11 12 2 4 7 8 10 Gross requirements 30 70 30 10 80 20 30 60 Holding cost= $3.50/unit/week; setup cost = $150; lead time= week; beginning inventory 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 6 7 10 12...
B. TOTAL COST________ Develop a lot-for-lot 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 | 30 30 30 60 20 20 70 60 *Holding cost = $1.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). 11 9 20 10 70 12 60 Period 1...
Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan Week 1 2 3 4 5 6 8 10 11 12 7 Gross requirements 20 40 40 70 30 10 80 40 Also, for this plan the Holding cost $2.50/unit/week; setup...
Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan. Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 40 60 20 10 80 40 Also, for this plan the Holding cost =$2.50/unit/week;...
What will the total cost be? (nearest whole number) Develop a lot-for-lot 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 40 40 60 30 10 80 50 "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). Period 1 2 3...