
Concept explainers
Determine material requirements plans for pans N and V and subassembly I as described in Solved Problem 3 for each of the following:
a. Assume that there are currently 100 Ns on hand and scheduled receipts of 40 Is and 10 Vs at the beginning of week 3. No Es are on hand: 120 Es are needed at the start of week 5.
b. Assume on-hand and scheduled receipts as in part a. Now suppose that 100 Es are needed at the stmt of week 5 and 55 at the start of week 7. Also, use multiples of these order sizes: N, 800; V, 200. Use lot-for-lot ordering for I.
C. Using your answer to part b, update the MRP for V, using the following additional information for each of these cases: (1) one week has elapsed (making it the start of week 2), and (2) three weeks have elapsed (making it the start of week 4).
The updated master
a)

To prepare A Material requirement plan for the given information.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which is used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of Week 3. 120 units of Component E are needed at the beginning of Week 5.
Product structure tree:
Prepare master schedule:
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Quantity | 120 |
Develop a material requirement planning for End item E:
- It is given that Person X has received an order to deliver 120 units of End item E, which must be shipped at the start of week 5.
- Beginning inventory is given as 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 120 units (120-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 120 units in the beginning of week 5. Hence, they need to order for 120 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.
Develop a material requirement planning for Component I (2):
- End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 40 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 200 units on week 4 (240-40).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 200 units in the beginning of week 4. Hence, they need to order for 200 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 5 is 0 units. Calculation is as follows:
Develop a material requirement planning for Component N (4):
- Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
- Beginning inventory is given as 100 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 700 units on week 3 (800-100).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
- Projected on hand inventory for week 4 is 0 units. Calculation is as follows:
Develop a material requirement planning for Component V:
- Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 10 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 190 units on week 3 (200-10).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
- Projected on hand inventory for week 4 is 0 units. Calculation is as follows:
b)

To prepare A Material requirement plan for the given information.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 40 units of Component I and 10 units of Component C would arrive at the beginning of week 3. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.
Product structure tree:
Develop a material requirement planning for End item E:
- It is given that Person X has received an order to deliver 100 units of End item E in the start of week 5 and 55 units of End item E in the start of week 7.
- Beginning inventory is given as 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units in week 5 (100-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 100 units in the beginning of Week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.
Develop a material requirement planning for Component I (2):
- End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 40 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 5 is 0 units. Calculation is as follows:
Develop a material requirement planning for Component N (4):
- Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
- Beginning inventory is given as 100 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 540 units on week 3 (640-100).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 540 units in the beginning of week 3. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
- Projected on hand inventory for week 4 is 260 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 620 units. Calculation is as follows:
Develop a material requirement planning for Component V:
- Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 10 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 150 units on week 3 (160-10).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 150 units in the beginning of week 3. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
- Projected on hand inventory for week 4 is 50 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 140 units. Calculation is as follows:
c)
1)

To prepare: Material requirement plan for the given information.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.
Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.
Product structure tree:
Develop a material requirement planning for End item E:
- It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
- Beginning inventory is given as 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.
Develop a material requirement planning for Component I (2):
- End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 40 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 5 is 0 units. Calculation is as follows:
Develop a material requirement planning for Component N (4):
- Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
- Beginning inventory is given as 100 units.
- Scheduled receipt is 800 units at the beginning of week 3
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 4 is 260 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 620 units. Calculation is as follows:
Develop a material requirement planning for Component V:
- Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 210 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
- Projected on hand inventory for week 4 is 50 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 140 units. Calculation is as follows:
1)

To prepare: Material requirement plan for the given information.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
On-hand balances are 100 units of Component N and 0 units of Component E. Scheduled receipts is 800 units of Component N and 200 units of Component V would arrive at the beginning of week 3. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.
Week 1 has elapsed. Hence, plan has to be prepared from week 2 through week 9. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.
Product structure tree:
Develop a material requirement planning for End item E:
- It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
- Beginning inventory is given as 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units (100-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.
Develop a material requirement planning for Component I (2):
- End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 40 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 160 units on week 4 (200-40).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 160 units in the beginning of week 4. Hence, they need to order for 160 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 5 is 0 units. Calculation is as follows:
Develop a material requirement planning for Component N (4):
- Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
- Beginning inventory is given as 100 units.
- Scheduled receipt is 800 units at the beginning of week 3
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 5 (440-260).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 5. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 3.
- Projected on hand inventory for week 4 is 260 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 620 units. Calculation is as follows:
Develop a material requirement planning for Component V:
- Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
- Beginning inventory is given as 0 units.
- Scheduled receipt is 210 units at the beginning of week 3.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 5 (110-50).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 700 units in the beginning of week 3. Hence, they need to order for 700 units (as the lot size is lot-for-lot) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 1.
- Projected on hand inventory for week 4 is 50 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 140 units. Calculation is as follows:
2)

To prepare: Material requirement plan for the given information.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item).
Explanation of Solution
Given information:
On-hand balances are 100 units of Component N and 0 units of Component E. Lot size is multiple of 800 for Component N, multiples of 200 for Component V, and lot-for-lot for Component E and Component I.
Two weeks (week 2 and week 3) has elapsed. Hence, plan has to be prepared from week 4 through week 11. 100 units of Component E are needed at the beginning of week 5 and 55 units needed at the beginning of week 7. In addition to that, 100 units of End item E are needed in week 9.
Planned order releases from 2nd and 3rd week should be used as scheduled receipt units. Scheduled receipt are 160 units of Component I at the start of 4th week, 800 units of Component N at the start of 5th week, and 200 units of Component V at the start of 5th week.
Product structure tree:
Develop a material requirement planning for End item E:
- It is given that Person X has received an order to deliver 100 units of End item E in week 5, 55 units in week 7, and 100 units in week 9.
- Beginning inventory is given as 0 units.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units at week 5 (100-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 100 units in the beginning of week 5. Hence, they need to order for 100 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 4.
Develop a material requirement planning for Component I (2):
- End item E is the parent item of Component I (2). Hence, the planned order release of E is the gross requirement for Component I (2). As number of units required is 2 for Component I, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component I.
- Beginning inventory is given as 40 units.
- Scheduled receipt is 160 units at the beginning of week 4.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 100 units on week 6 (110-0).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 1 week. Company requires 110 units in the beginning of week 6. Hence, they need to order for 110 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week). Thus, company need to order the required units in week 5.
- Projected on hand inventory for week 5 is 0 units. Calculation is as follows:
Develop a material requirement planning for Component N (4):
- Component I (2) is the parent item of Component N (4). Hence, the planned order release of Component I (2) is the gross requirement for Component N (4). As number of units required is 4 for Component N, the planned order release row should be multiplied with 2 to attain the gross requirement column of Component N.
- Beginning inventory is given as 260 units.
- Scheduled receipt is 800 units at the beginning of week 3
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 180 units on week 7 (800-620).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 180 units in the beginning of week 7. Hence, they need to order for 800 units (as the lot size is multiples of 800) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
- Projected on hand inventory for week 5 is 1,060 units. Calculation is as follows:
- Projected on hand inventory for week 6 is 620 units. Calculation is as follows:
Develop a material requirement planning for Component V:
- Component I (2) is the parent item of Component V. Hence, the planned order release of Component I (2) is the gross requirement for Component V. As number of units required is 1 for Component V, the planned order release row should be multiplied with 1 to attain the gross requirement column of Component V.
- Beginning inventory is given as 50 units.
- Scheduled receipt is 200 units at the beginning of week 5.
- Net requirement can be calculated by subtracting the projected on-hand from the gross requirement. Hence, the net requirement is 60 units on week 7 (200-140).
- Planned order release is the order given by the company and planned order receipts is the order received by the firm.
- Lead-time is given as 2 weeks. The company requires 60 units in the beginning of week 7. Hence, they need to order for 200 units (as the lot size is multiples of 200) two weeks before (as the lead-time is 2 weeks). Thus, company need to order the required units in week 5.
- Projected on hand inventory for week 6 is 140 units. Calculation is as follows:
Want to see more full solutions like this?
Chapter 12 Solutions
Operations Management (Comp. Instructor's Edition)
Additional Business Textbook Solutions
Intermediate Accounting (2nd Edition)
Managerial Accounting (5th Edition)
Marketing: An Introduction (13th Edition)
Horngren's Accounting (12th Edition)
Essentials of MIS (13th Edition)
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
- The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in gallons) for the next four quarters are 60,000, 90,000, 90,000, and 140,000 respectively. A level workforce is desired, relying only on anticipation inventory as a supply option. Stockouts and backorders are to be avoided, as are overtime and undertime. a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is 0. The quarterly production rate is ☐ gallons. (Enter your response as an integer.)arrow_forwardHow would you design an operations plan and schedule for a new product/service? What factors would you consider and what challenges would you anticipate? Why are these factors and challenges relevant and how would you address them?arrow_forwardYou are the newly appointed CEO of TechSouth, a South African multinational technology company based in Cape Town. TechSouth specialises in manufacturing smartphones, laptops, and smart home devices. The company has a significant presence in the African market and has recently expanded into Europe and Asia. However, TechSouth is facing several critical challenges:· Declining Market Share - Over the past three years, TechSouth has lost considerable market share to both localcompetitors and international giants like Samsung and Apple. The company's products are perceived as outdated and lacking innovation.· Employee Engagement Issues - Recent employee surveys indicate low morale and engagement levels, particularly among the younger workforce, leading to high turnover rates. Many employees feel disconnected from the company's vision and mission.· Siloed Departments - The organizational structure at TechSouth is highly siloed, with departments operatingindependently rather than…arrow_forward
- What is the best way to manage emotions and thoughts? How to work through Emotions and thoughts?arrow_forwardWhat are the emotions or stressful thoughts? What are the differences between them? How can we work through the emotions or stressful thoughts? How can we avoid or prevent emotions or stressful thoughts from happening or occurring? What are the obstacles?arrow_forwardMain Challenges at TechInnovateStrategic DirectionTechInnovate's board of directors is pushing for a more aggressive expansion into emerging markets, particularly in Africaand Southeast Asia. However, there's internal disagreement about whether to focus on these new markets or consolidatetheir position in existing ones. Sarah Chen favors rapid expansion, while some senior executives advocate for a morecautious approach.Ethical ConcernsThe company's AI algorithms have come under scrutiny for potential biases, particularly in facial recognition technology.There are concerns that these biases disproportionately affect minority groups. Some employees have voiced ethicalconcerns about selling this technology to law enforcement agencies without addressing these issues.Team Leadership and DiversityTechInnovate's leadership team is predominantly male and Western, despite its global presence. There's growing pressurefrom employees and some board members to diversify the leadership team to…arrow_forward
- Sarah Anderson, the Marketing Manager at Exeter Township's Cultural Center, is conducting research on the attendance history for cultural events in the area over the past ten years. The following data has been collected on the number of attendees who registered for events at the cultural center. Year Number of Attendees 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 You have been hired as a consultant to assist in implementing a forecasting system that utilizes various forecasting techniques to predict attendance for Year 11. a) Calculate the Three-Period Simple Moving Average b) Calculate the Three-Period Weighted Moving Average (weights: 50%, 30%, and 20%; use 50% for the most recent period, 30% for the next most recent, and 20% for the oldest) c) Apply Exponential Smoothing with the smoothing constant alpha = 0.2. d) Perform a Simple Linear Regression analysis and provide the adjusted…arrow_forwardRuby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 70 units and is valued at $90 per unit. Inbound shipments from vendor 1 will average 390 units with an average lead time (including ordering delays and transit time) of 4 weeks. Inbound shipments from vendor 2 will average 490 units with an average lead time of 2 weeksweeks. Ruby-Star operates 52 weeks per year; it carries a 4-week supply of inventory as safety stock and no anticipation inventory. Part 2 a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $enter your response here.arrow_forwardSam's Pet Hotel operates 50 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $13.00 per bag. The following information is available about these bags: > Demand 75 bags/week > Order cost = $52.00/order > Annual holding cost = 20 percent of cost > Desired cycle-service level = 80 percent >Lead time = 5 weeks (30 working days) > Standard deviation of weekly demand = 15 bags > Current on-hand inventory is 320 bags, with no open orders or backorders. a. Suppose that the weekly demand forecast of 75 bags is incorrect and actual demand averages only 50 bags per week. How much higher will total costs be, owing to the distorted EOQ caused by this forecast error? The costs will be $higher owing to the error in EOQ. (Enter your response rounded to two decimal places.)arrow_forward
- Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 2,250 rolls. The cost per roll is $625, and the annual holding cost is 20 percent of the cost. Each order costs $75. a. How many rolls should Yellow Press order at a time? Yellow Press should order rolls at a time. (Enter your response rounded to the nearest whole number.)arrow_forwardPlease help with only the one I circled! I solved the others :)arrow_forwardOsprey Sports stocks everything that a musky fisherman could want in the Great North Woods. A particular musky lure has been very popular with local fishermen as well as those who buy lures on the Internet from Osprey Sports. The cost to place orders with the supplier is $40/order; the demand averages 3 lures per day, with a standard deviation of 1 lure; and the inventory holding cost is $1.00/lure/year. The lead time form the supplier is 10 days, with a standard deviation of 2 days. It is important to maintain a 97 percent cycle-service level to properly balance service with inventory holding costs. Osprey Sports is open 350 days a year to allow the owners the opportunity to fish for muskies during the prime season. The owners want to use a continuous review inventory system for this item. Refer to the standard normal table for z-values. a. What order quantity should be used? lures. (Enter your response rounded to the nearest whole number.)arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational PublishingPurchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning

