Question

Calculate the cost of operating under the different MRP lot sizing techniques: Lot-for-Lot (L4L) Economic Order...

Calculate the cost of operating under the different MRP lot sizing techniques:

Lot-for-Lot (L4L)

Economic Order Quantity (EOQ)

Least Total Cost (LTC)

Least Unit Cost (LUC)

Compare your results and state which method is the most cost efficient in this situation.

Consider the following MRP lot sizing problem:

Cost per item

$50

Order/setup cost

$75

Inventory carrying cost per item per week

$1

Weekly net requirements:

1

2

3

4

5

6

7

8

75

90

100

90

80

95

90

80

Homework Answers

Answer #1

A

Economic Order Quantity (EOQ)

2*Total Quantity*Ordering cost/Carrying cost

Total Quantity
(75+90+100+90+80+95+90+80)

700

Ordering cost

$75

Carrying cost

$1

EOQ

105000

EOQ

                                324.04

B

Least total cost

Ordering Quantity

324

Total Quantity

700

No of orders (700/324) rounded to next 1

3

Ordering cost (3*75) (A)

$225

Carrying cost (324/2) (B)

$162

Cost Material (700*50) (C)

$35,000

Ans

Total cost (D=A+B+C)

$35,387

C

Least unit cost

No of units (A)

700

Total cost (B)

$35,387

Unit cost per unit (C=B/A)

$50.55

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead...
The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $9. There is a carrying cost of $0.02 per unit per week. Beginning inventory is 75 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 20 10 15 45 10 30 90 20 45 160 Use the least total cost lot-sizing method to determine the quantity to order with...
The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead...
The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $10. There is a carrying cost of $0.010 per unit per week. Beginning inventory is 85 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 20 55 10 22 70 87 19 63 210 58 Use the least total cost and the least unit cost lot-sizing methods to determine...
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule Skate 1 1 Lot for Lot Lace 1 1 FOQ = 500 Box 1 2 FOQ = 500 Board 1 2 Lot for Lot Wheel Assembly 2 1 FOQ = 800 Body 2 2 Lot for Lot Axle 2 1 Lot for Lot Hardware 2 3 FOQ = 1500 BOM                                                                         Draw Product Structures Here Boxed Skates       Skates (2)             Body             Axle (2)             Hardware             Wheel Assembly (2)       Laces (2)       Box Skateboard       Board       Wheel Assembly (4)       Axle (2)...
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule
Solve the MRP Item                         LLC    Leadtime      Lot Sizing Rule Skate 1 1 Lot for Lot Lace 1 1 FOQ = 500 Box 1 2 FOQ = 500 Board 1 2 Lot for Lot Wheel Assembly 2 1 FOQ = 800 Body 2 2 Lot for Lot Axle 2 1 Lot for Lot Hardware 2 3 FOQ = 1500 BOM                                                                         Draw Product Structures Here Boxed Skates       Skates (2)             Body             Axle (2)             Hardware             Wheel Assembly (2)       Laces (2)       Box Skateboard       Board       Wheel Assembly (4)       Axle (2)...
The time-phased net requirements for the base assembly in a table lamp over the next six...
The time-phased net requirements for the base assembly in a table lamp over the next six weeks are: Week 1 2 3 4 5 6 Requirements 335 240 180 340 320 200 The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week. What lot sizing do you obtain from the EOQ formula? Determine the lot sizes using the Silver–Meal heuristic. Determine the lot sizes using the least unit...
Problem 9A-5 Economic Order Quantity; Safety Stock; Just-in-Time Purchasing Impact [LO6] Imagine It manufactures 3D printers...
Problem 9A-5 Economic Order Quantity; Safety Stock; Just-in-Time Purchasing Impact [LO6] Imagine It manufactures 3D printers and purchases one of the components used in the printers from a supplier in the U.S. Imagine It uses 4,000 of these components per year at a cost of $160 each. The components are used evenly in the production process throughout a 360-day production year. The company estimates that it costs $20 to place a single purchase order and about $100 to carry each...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of a specific product in the past three years. Quarter Year 1 2 3 4 2015 350 254 176 228 2016 367 258 169 236 2017 342 250 166 228 Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units. Question 6: DRP (8 p) A central DC supplies a...
1-How important do you believe it is to be task-oriented and relationship-orientated? How would you describe...
1-How important do you believe it is to be task-oriented and relationship-orientated? How would you describe Musk? 2-Why do you think Musk is successful in overcoming obstacles and handling conflict? How do you overcome obstacles in influencing individuals in your life? 3-Besides the personality traits given in chapter 2, what other traits attribute to a great leader? Recognizing Your Traits The definition of intelligence is the ability to acquire and apply knowledge and skills. Elon Musk knew little about rockets...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...