Question: Question 4: Develop a Material Requirements Plan (MRP) for the data in the following table that minimizes the total relevant costs. Count and cost inventory

Question 4: Develop a Material Requirements Plan (MRP) for the data in the following table that minimizes the total relevant costs. Count and cost inventory at the end of each period for calculating the inventory holding cost. 2 5 7 9 11 12 1 30 10 3 4 60 10 6 10 8 20 10 30 50 10 Week Gross requirement Scheduled receipt On hand (beginning) On hand (end of period) Net requirement Planned order receipt Planned order release Lead time = 2 weeks; ordering cost = $400/order; holding cost = $0.5/unit/week; stockout cost = $10/unit; beginning inventory = 20 units. (a) What is the total cost associated with the optimal MIRP? (b) What value of ordering cost will make the decision maker indifferent between the two lot sizing techniques (lot-for-lot and EOQ) for this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Develop a Material Requirements Plan (MRP) for the data in the following table that minimizes the total relevant costs. Count and cost inventory at the end of each period for calculating the...

SEMESTER ONE & TWO ASSIGNMENT 2 QUESTION 1 1.1 Explain how higher quality can lead to reduced costs. 1.2 List four (4) examples of costs that may be influenced by the location of an organisation 1.3...

QUESTION 1 1.1 Explain how higher quality can lead to reduced costs. (4) 1.2 List four (4) examples of costs that may be influenced by the location of an organisation. (4) 1.3 Discuss the strategic...

Question 18 only. Please provide Excel calculations. Week Demand 60 90 60 130 65 75 100 85 2. Suppose a customer cancels an order of 60 units in Week 3. What effect will it have on the projected...

Student Name: Student Number: Section Number: Question Maximum Mark Mark Obtained 1 4 2 4 3 4 4 4 5 4 4 6 7 4 Total 28 Company X produces an end product 'A' for the market. One unit of 'A' is made by...

A company produces an end item 'C', which is composed of three subassemblies: 3 units of D, 1 unit of E, and 2 units of F. D is made of 1 R and 2 Ss; E is assembled using 1 T and 3 Us; and F is made...

In Figure I, a basketball is tossed from A at an angle of 30 from the horizontal: 1. Compute the speed VA at which the ball is released in order to make the basket B and (15 marks; C3) 2. Calculate...

Quick Test Laboratories evaluates the reaction of materials to extreme increases in temperature. Much of the companys early growth was attributable to government contracts, but recent growth has come...

Complete the table below on financial activity. a. Identify at least two reporting requirements for each financial activity described in the scenario. b. Explain the application of each identified...

Which of these is among the four major problems that emerge when companies engage in the strategic marketing process? Multiple Choice Resource allocation causes factions to develop within the...