One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two- week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and È have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively, all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 20 units of B in Week 7,40 units of F in Week 5, and 60 units of E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave no cells blank-be certain to enter "0" wherever required.)

One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two- week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and È have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively, all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 20 units of B in Week 7,40 units of F in Week 5, and 60 units of E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave no cells blank-be certain to enter "0" wherever required.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: After you have presented your proposal to hospital administration, and it has been accepted, you are…

A: According to the case, The hospital CEO would address the staff at the hospital, supervisory staff,…

Q: A Secondary Residence has a main building with two detached private structures on the same premises.…

A: In this explanation, we will address two questions related to insurance coverage provisions. The…

Q: Can you provide in more detail

A: The Caramel Craze Iced Signature Latte is a Dunkin' beverage created with espresso, milk, caramel…

Q: Review of available resource material, analysis of metrics, recommendations from oversight bodies…

A: Needs assessment is a tool that helps organizations fill the gaps between what they currently have…

Q: 4. B.G.H.M. Inc. is a local buniness involved in many aspecta of the food supply industry. As demand…

A: PERT: Program evaluation and review technique is an approach used in project management to represent…

Q: Operational areas eligible for review include: sales of products and services hiring contractors…

A: Basically, a functional audit is an inside and out take a gander at the 10,000 foot view, tending to…

Q: Financing is needed to fund new equipment for the build sites. A) You are required to create a…

A: Business required regular maintenance and adoption of updated technology to cope up withthe problems…

Q: How can we improve shortlisting and screening for requirements

A: In the registration process, the shortlist comes after discovery (discovery and drawing) and before…

Q: This assignment gives you the opportunity to evaluate and critically analyse aspects of marketing…

A: Disclaimer: Since you have asked multiple questions, so we will solve the first question for you. If…

Q: Training and development Adequate training and development of the personnel who work in your…

A: In today's competitive business landscape, the success of any organization hinges significantly on…

Q: : Learn more about the forage platform and select one of these Consulting & Finance Work…

A: I completed the "Consulting Case: Financial Modeling" simulation on the Forage platform.The…

Q: Why is it important to inform a client early in the process of resolving a problem?

A: Resolving a problem is a process whereby an issue is observed, identified, and diagnosed to find out…

Q: 1)Summary - Can you pick out and condense the main ideas of what you've read - namely can you tell…

A: Super Sized Cycles, a niche bicycle company founded by Joan Denizot, specializes in manufacturing…

Q: In this section you must introduce your reader to Coca Cola for auditing, highlighting some of…

A: In the realm of business, a significant element influences how individuals collaborate – known as…

Q: which of the following will provide the must reliable estimate of the time required for a company…

A: Too often, deadlines are missed or teams overextend themselves because the project manager failed to…

Q: A study to determine the correlation between bankdeposits and consumer price indices in Birmingham,…

Q: mangement case outline for: Fusato v. Washington Interscholastic Activities Association…

A: Note: The answer has been provided in a generalized manner. Fusato v. Washington Interscholastic…

Q: 13.a. Which one of the following tasks isn’t a normal task of the preventive program administrator?…

A: As per Bartleby guidelines, we can only solve one question at a time...Kindly upload the other…

Q: Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of…

A: A linear objective function can be optimized using the linear programming (LP), also known as linear…

Q: For this assignment, you will be required to identify a research topic in logistics and supply chain…

A: The e-commerce industry has been growing rapidly, and it has revolutionized the way businesses…

Question

Please advise with Homework Chapter 20 Problem 1. Thank you. Please provide step by step explantion so I can use it for notes

One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units
of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week Items A, B, E, and F have two-
week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 20, 40,
and 160 are used for Items A, B, and D, respectively. Items A, B, D, and È have on-hand (beginning) inventories of 5, 10, 100, and 100,
respectively, all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3. 20 units of B in
Week 7, 40 units of F in Week 5, and 60 units of E in Week 2: there are no other scheduled receipts.
If 20 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned
order releases for all components. (Leave no cells blank-be certain to enter "0" wherever required.)
12 3 4 5 6 7 8 9 10
Item A
OH= 5
LT=2
SS=0
Item C
CH=0
LT=1
SS=0
|Q=LAL
em B
OH = 10
LT=2
SS=0
Q-40
Item D
Period
Gross requirements
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Plann orde releases
Gross requirements
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Scheduled receipts

CH-100
LT-3
SS=0
Q-160
hem F
CH=0
LT=2
SS=0
hem E
CH-100
LT=2
SS=0
Q=L4L
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Scheduled receipts
Projected available balance
Planned order receipts
Planned order releases
Gross requirements
Scheduled receipts
Projected available balance
Planned order receipts
Planned order releases

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Calculation methods:

Product tree:

Calculations:

Final answer:

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 9 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Hi please will you help me with this question
develop a merchandise management plan for a retail establishment that you create and design. A different part of the plan will be completed each week. The plan will be detailed and comprehensive, and each element will often require more than one week's work. Therefore, the course project section will often be broken up into two parts, one which will ask you to preview and begin work that will be completed in future weeks, and the second part which will be the assignment that will actually be submitted that week.
Please do not give solution in image format thanku
I need a Business Plan including the executive summary and so forth for a day Care business.
Indicate whether the item below is used as key performance indicators for the areas of (A) Financial, (B) Customer, (C) Internal Process, or (D) Learning and Growth performance. Choose the one best choice. Average time from when clients enter and leave the bank (A) Financial(B) Customer(C) Internal Process(D) Learning and Growth performance.
I work as a stocking associate at Home Depot. What are my job responsibilities, duties, and activities? What are the skills used in my previous job?
After you have presented your proposal to hospital administration, and it has been accepted, you are informed that the impending cost reductions will need to be implemented. You are told to meet with your supervisory staff to organize the implementation of your plan. The CEO will be holding hospital employee briefings beginning the next afternoon to provide the employees with an overview of the situation confronting the hospital. Over the next two to three days, you will be meeting with your supervisory staff and then with the laboratory employees to provide additional detail specifically as it pertains to the laboratory and its staff. Your goals are to have your employees fully understand the situation and its implications, allow them to communicate their thoughts and concerns, and to finally accomplish buy-in from the staff regarding the proposal you must implement. Question: What are the various means of communication that could be used in this situation? Which one(s) is chosen…
1 Wendy is unsure how she can find new customers through online selling. You explain to her that there are already facilities available online to help her find new customers. 2 Finally Wendy asks you about the business of doing transactions on the Internet and how she will deal with getting the product to the customer and finalizing the sale. No hand written and fast answer
Brief Exercise #40: Think about a person's most recent appointment at the dentist's office. In a one (1) page response, describe the business processes that affected this person as the patient/customer. In addition, describe the administrative and accounting processes that are likely to support this business. Problem #50: Suppose that a large company is considering replacing a legacy system that is nearing obsolescence. In a one (1) page response, describe any aspects of this decision that the company should consider.
INSTRUCTIONS: Make a summary report of each table. Make it in a paragraph format and include learning experience each table. Specific Task Performed Ma'am Joy teaches me how to use the system they are using in the company. Arrange for a copy of the request forms for the months of April and May. Assisted ma'am Juliet in purchasing a soft broom. Check, verify, and count the supplies that were delivered yesterday. Prepare the request of the Billing department and medical records Do a physical count of the supplies that are lacking in number. Assist in the preparation of supply requests for other departments and assist in the distribution of supplies. Problems Encountered WEEK 11 Some of the supplies requested by the laundry department are not yet accounted for in the system. They are asking for items that are now unavailable in the supply. There are certain goods for which we are unfamiliar with the account name. As a result of the existence of an error, we are unable to fulfill the…
For questions 32-35, use the word list to label the circular flow diagram. I Household Market (Households Sell. Firms Buy.) 35. Market (Firms Sell. Households Buy.) Businesse 34. Product Factor Firms sell goods and services Households sell the factors of production Households pay for the goods and services
Chapter 3. Dr. Kay is learning how to make some traditional Indian food and comes upon this recipe for a childhood favorite (White Dhokla): https://recipes.timesofindia.com/us/recipes/white-dhokla /rs59190882.cms 2. In an effort to remain organized she sorts out the steps of the recipe to get an estimate of how much time it would take her to complete the recipe. Immediate Time Activity Description Predecessor (Hours) A Soak lentils & rice 8 Grind lentil-rice mixture A 0.5 Ferment lentil-rice C В mixture D Heat the steamer C 0.5 Prepare the pans with 0.25 mixture F Steam the pans D, E 0.5 Prepare tempering 0.1 H Temper, Cool, and serve F, G 0.5 1. Draw a network diagram for this process (include it in your final submission file at the end of the exam). What is the total expected time in hours for this recipe to be completed? hours 2. Show the activity schedule (include it in your final submission file at the end of the exam). What is the Critical Path for this recipe? 3. If Dr. Kay can…