Concept explainers
Videos
a)
To develop: A gross requirements plan for all the items.
Introduction:
Gross requirements plan:
The gross requirements plan is the plan where the independent and dependent demand for a product or a component before the on-hand inventory and the scheduled receipts are netted with.
a)
Explanation of Solution
Given information:
Product structure:
Master production
| MPS for X1 | ||||||
| Period | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||
Inventory and lead time:
| Item | X1 | B1 | B2 | A1 | C | D | E |
| Lead time | 1 | 2 | 2 | 1 | 1 | 1 | 3 |
| On hand | 50 | 20 | 20 | 5 | 0 | 0 | 10 |
Item X1:
| Week | ||||||||||||
| Item X1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Order release | 50 | 20 | 100 | |||||||||
The gross requirements are 50, 20 and 100 (1 assembly of X1) in weeks 8, 10 and 12 respectively derived from the master production schedule of X1. The lead time is 1 week. Therefore, the order release will be 50, 20 and 100 in weeks 7, 9 and 11 respectively.
Item B1:
| Week | ||||||||||||
| Item B1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Order release | 50 | 20 | 100 | |||||||||
The order release of X1 will become the gross requirements of B1. The gross requirements are 50, 20 and 100 (1 assembly of B1) in weeks 7, 9 and 11 respectively. The lead time is 2 weeks. Therefore, the order release will be 50, 20 and 100 in weeks 5, 7 and 9 respectively.
Item B2:
| Week | ||||||||||||
| Item B2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 100 | 40 | 200 | |||||||||
| Order release | 100 | 40 | 200 | |||||||||
The order release of X1 will become the gross requirements of B2. The gross requirements are 100, 40 and 200 (2 assemblies of B2) in weeks 7, 9 and 11 respectively. The lead time is 2 weeks. Therefore, the order release will be 100, 40 and 200 in weeks 5, 7 and 9 respectively.
Item A1:
| Week | ||||||||||||
| Item A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Order release | 50 | 20 | 100 | |||||||||
The order release of B1 will become the gross requirements of A1. The gross requirements are 50, 20 and 100 (1 assembly of A1) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 50, 20 and 100 in weeks 4, 6 and 8 respectively.
Item C:
| Week | ||||||||||||
| Item C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 200 | 80 | 400 | |||||||||
| Order release | 200 | 80 | 400 | |||||||||
The order release of B2 will become the gross requirements of C. The gross requirements are 200, 80 and 400 (2 assemblies of C) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 200, 80 and 400 in weeks 4, 6 and 8 respectively.
Item D:
| Week | ||||||||||||
| Item D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 100 | 40 | 200 | |||||||||
| Order release | 100 | 40 | 200 | |||||||||
The order release of B2 will become the gross requirements of D. The gross requirements are 100, 40 and 200 (2 assemblies of C) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 100, 40 and 200 in weeks 4, 6 and 8 respectively.
Item E:
| Week | ||||||||||||
| Item E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 200 | 50 | 80 | 20 | 400 | 100 | ||||||
| Order release | 200 | 50 | 80 | 20 | 400 | 100 | ||||||
The order release of B1 and D will become the gross requirements of E. The gross requirements are 50, 20 and 100 (1 assembly of E) in weeks 5, 7 and 9 respectively. The lead time is 3 weeks. Therefore, the order release will be 50, 20 and 100 in weeks 2, 4 and 6 respectively.
The gross requirements are 200, 80 and 400 (2 assembly of E) in weeks 4, 6 and 8 respectively. The lead time is 3 weeks. Therefore, the order release will be 200, 80 and 400 in weeks 1, 3 and 5 respectively.
b)
To develop: A net requirements plan for all the items.
Introduction:
Net requirements plan:
The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.
b)
Explanation of Solution
Given information:
Product structure:
Master production schedule for X1:
| MPS for X1 | ||||||
| Period | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||
Inventory and lead time:
| Item | X1 | B1 | B2 | A1 | C | D | E |
| Lead time | 1 | 2 | 2 | 1 | 1 | 1 | 3 |
| On hand | 50 | 20 | 20 | 5 | 0 | 0 | 10 |
Item X1:
| Week | ||||||||||||
| Item X1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 50 | 20 | 100 | |||||||||
| Scheduled receipt | ||||||||||||
| On hand (50) | 50 | 0 | 0 | |||||||||
| Net requirement | 0 | 20 | 100 | |||||||||
| Planned order receipt | 20 | 100 | ||||||||||
| Planned order release | 20 | 100 | ||||||||||
Week 8:
The gross requirement is 50 (1 assembly)derived from the master production schedule of X1. The on hand inventory is 50. Hence, the net requirement is 0. The lead time is 1 week. Therefore, there will be no planned order release.
Week 10:
The gross requirement is 20 (1 assembly) derived from the master production schedule of X1. The on hand inventory is 0. Hence, the net requirement is 20. The lead time is 1 week. Therefore, the planned order release will be 20 in week 9 which will be the planned order receipt in week 10.
Week 12:
The gross requirement is 100 (1 assembly) derived from the master production schedule of X1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 11 which will be the planned order receipt in week 12.
Item B1:
| Week | ||||||||||||
| Item B1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 20 | 100 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (20) | 20 | 0 | ||||||||||
| Net requirement | 0 | 100 | ||||||||||
| Planned order receipt | 100 | |||||||||||
| Planned order release | 100 | |||||||||||
Week 9:
The gross requirement is 20 (1 assembly) derived from the planned order release of X1. The on hand inventory is 20. Hence, the net requirement is 0. The lead time is 2 weeks. Therefore, there will be no planned order release.
Week 11:
The gross requirement is 100 (1 assembly) derived from planned order release of X1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 9 which will be the planned order receipt in week 11.
Item B2:
| Week | ||||||||||||
| Item B2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 40 | 200 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (20) | 20 | 0 | ||||||||||
| Net requirement | 20 | 200 | ||||||||||
| Planned order receipt | 20 | 200 | ||||||||||
| Planned order release | 20 | 200 | ||||||||||
Week 9:
The gross requirement is 40 (2 assembly) derived from the planned order release of X1. The on hand inventory is 20. Hence, the net requirement is 20. The lead time is 2 weeks. Therefore, the planned order release will be 20 in week 7 which will be the planned order receipt in week 9.
Week 11:
The gross requirement is 200 (2 assembly) derived from planned order release of X1. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 9 which will be the planned order receipt in week 11.
Item A1:
| Week | ||||||||||||
| Item A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 100 | |||||||||||
| Scheduled receipt | ||||||||||||
| On hand (5) | 5 | |||||||||||
| Net requirement | 95 | |||||||||||
| Planned order receipt | 95 | |||||||||||
| Planned order release | 95 | |||||||||||
Week 9:
The gross requirement is 100 (1 assembly) derived from the planned order release of B1. The on hand inventory is 5. Hence, the net requirement is 95. The lead time is 1 week. Therefore, the planned order release will be 95 in week 8 which will be the planned order receipt in week 9.
Item C:
| Week | ||||||||||||
| Item C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 40 | 400 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (0) | 0 | 0 | ||||||||||
| Net requirement | 40 | 400 | ||||||||||
| Planned order receipt | 40 | 400 | ||||||||||
| Planned order release | 40 | 400 | ||||||||||
Week 7:
The gross requirement is 40 (2 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 40. The lead time is 1 week. Therefore, the planned order release will be 40 in week 6 which will be the planned order receipt in week 7.
Week 9:
The gross requirement is 400 (2 assembly) derived from planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 1 week. Therefore, the planned order release will be 400 in week 8 which will be the planned order receipt in week 9.
Item D:
| Week | ||||||||||||
| Item D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 20 | 200 | ||||||||||
| Scheduled receipt | ||||||||||||
| On hand (0) | 0 | 0 | ||||||||||
| Net requirement | 20 | 200 | ||||||||||
| Planned order receipt | 20 | 200 | ||||||||||
| Planned order release | 20 | 200 | ||||||||||
Week 7:
The gross requirement is 20 (1 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 20. The lead time is 1 week. Therefore, the planned order release will be 20 in week 6 which will be the planned order receipt in week 7.
Week 9:
The gross requirement is 200 (1 assembly) derived from planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 8 which will be the planned order receipt in week 9.
Item E:
| Week | ||||||||||||
| Item E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Gross requirements | 40 | 400 | 100 | |||||||||
| Scheduled receipt | ||||||||||||
| On hand (10) | 10 | 0 | 0 | |||||||||
| Net requirement | 30 | 400 | 100 | |||||||||
| Planned order receipt | ||||||||||||
| Planned order release | 30 | 400 | 100 | |||||||||
Week 6:
The gross requirement is 40 (2 assembly) derived from the planned order release of B2. The on hand inventory is 10. Hence, the net requirement is 30. The lead time is 3 weeks. Therefore, the planned order release will be 30 in week 3 which will be the planned order receipt in week 6.
Week 8:
The gross requirement is 400 (2 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 3 weeks. Therefore, the planned order release will be 400 in week 5 which will be the planned order receipt in week 8.
Week 9:
The gross requirement is 100 (1 assembly) derived from the master production schedule of B1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 3 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 9.
Want to see more full solutions like this?
Chapter 14 Solutions
PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB
- Please show all units, work, and steps needed to solve this problem I need answer typing clear urjent no chatgpt used pls i will give 5 Upvotes.arrow_forwardIM.82 A distributor of industrial equipment purchases specialized compressors for use in air conditioners. The regular price is $50, however, the manufacturer of this compressor offers quantity discounts per the following discount schedule: Option Plan Quantity Discount A 1 - 299 0% B 300 - 1,199 0.50% C 1,200+ 1.50% The distributor pays $56 each time it places an order with the manufacturer. Holding costs are negligible (none) but they do earn 10% annual interest on all cash balances (meaning there will be a financial opportunity cost when they put cash into inventory). Annual demand is expected to be 10,750 units. When there is no quantity discount (Option Plan A, the first row of the schedule listed above), what is the adjusted order quantity? (Display your answer to the nearest whole number.) 491 Based on your answer to the previous question, and based on the annual demand as stated above, what will be the annual ordering costs? (Display your answer to the…arrow_forwardExcel Please. The workload of many areas of banking operations varies considerably based on time of day. A variable capacity can be achieved effectively by employing part-time personnel. Because part-timers are not entitled to all the fringe benefits, they are often more economical than full-time employees. Other considerations, however, may limit the extent to which part-time people can be hired in a given department. The problem is to find an optimal workforce schedule that would meet personnel requirements at any given time and also be economical. Some of the factors affecting personnel assignments are listed here: The bank is open from 9:00am to 7:00pm. Full-time employees work for 8 hours (1 hour for lunch included) per day. They do not necessarily have to start their shift when the bank opens. Part-time employees work for at least 4 hours per day, but less than 8 hours per day and do not get a lunch break. By corporate policy, total part-time personnel hours is limited…arrow_forward
- IM.84 An outdoor equipment manufacturer sells a rugged water bottle to complement its product line. They sell this item to a variety of sporting goods stores and other retailers. The manufacturer offers quantity discounts per the following discount schedule: Option Plan Quantity Price A 1 - 2,399 $5.50 B 2,400 - 3,999 $5.20 C 4,000+ $4.50 A large big-box retailer expects to sell 9,700 units this year. This retailer estimates that it incurs an internal administrative cost of $225 each time it places an order with the manufacturer. Holding cost for the retailer is $55 per case per year. (There are 40 units or water bottles per case.) Based on this information, and not taking into account any quantity discount offers, what is the calculated EOQ (in units)? (Display your answer to the nearest whole number.) Number Based on this information, sort each quantity discount plan from left to right by dragging the MOST preferred option plan to the left, and the LEAST preferred…arrow_forwardIn less than 150 words, what is an example of what your reflection of core values means to you and your work: Commitment, Perseverance, Community, Service, Pride?arrow_forwardPrepare a report on the following: Part 1: Discuss the role of the corporate secretary in facilitating effective governance in a limited liability company. Include the relationships with directors, shareholders, and other officers. Part 2: Compare and contrast two characteristics of different business entities (sole trader, partnership, and limited liability company). Use examples to recommend the most appropriate type of business entity for the scenario below: Scenario Background Alex, Taylor, and Jordan plan to collaborate to launch a tech startup focused on developing and selling innovative software solutions. Each individual brings unique skills and resources to the venture: Alex: A skilled software developer with technical expertise and a vision for the product. Taylor: A marketing professional with extensive connections in the technology industry, aiming to drive sales and build the brand. Jordan: An investor willing to contribute significant financial resources but…arrow_forward
- Problem 1 (20 Points) Davison Electronics manufactures three LED television monitors, identified as Model A, Model B, and Model C. Davison Electronics four manufacturing plants. Each model has its lowest possible production cost when produced at Plant 1. However, Plant 1 does not have the capacity to handle the total production of all three models. As a result, at least some of the production must be routed to the other manufacturing plants. The following table shows the minimum production requirements for next month, the plant capacities in units per month, and the production cost per unit at each plant: Model Production Cost per Unit Minimum Production Requirements Plant 1 Plant 2 Plant 3 Plant 4 A $25 $28 $37 $34 48,000 B $26 $35 $36 $41 75,000 C $20 $31 $26 $23 60,000 Production Capacity 65,000 50,000 32,000 43,000 Davison’s objective is to determine the cost-minimizing production plan. Without…arrow_forwardSECTION B: TOPIC STRUCTURE CAPSTONE PROJECT TOPIC SUBMISSION TEMPLATE SECTION A: STUDENT DETAILS Student number Title (Mr/Miss/Ms/Mrs) Surname First name/s Title of research Date and year of registration Work Home Contact details Cell Region Date submitted Email 1.1 Title Insert title of the research. Choose a title that captures the essence of your proposed project. 1.2 Background to the Problem This section will be used to create the readers' interest. It can include a specific description of the topic that is to be investigated. A brief preview of the topic and the foundation of the problem should also be given. The researcher can achieve this through building up a detailed background of circumstances that lead to the problem being examined. Therefore, the background helps the reader understand the specific problem addressed by the researcher. This section should not include the background/history of the organisation. The background to the problem should not be more than ½ a page.…arrow_forwardDoes Nike Corporation's emphasis on lean operations help the Vietnamese workforce that still earns $150.00 minimum wage a month since 2014?arrow_forward
- Information Security Innovation within a Contemporary Business Environment All organisations using computers need to consider the security of information they keep. Many organisations utilise Websites for their core business functions and this results in monetary transactions being carried out on the Websites.arrow_forwardPlease help with a complete research report on the topic below: "Information Security Innovation within a Contemporary Business Environment " The format of the report should follow this below.arrow_forward7. Wireless Infrastructure in the Cloud Wireless devices have changed the way organisations and their customers interact. Wireless enabled devices have driven the mindset that wireless networks must be ubiquitous, fast, and constantly available. These are demands that have traditionally put organisations and their user communities in direct conflict with their IT departments, as constructing and maintaining wireless infrastructures are typically time-consuming, complex, and costly endeavours.arrow_forward
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,