Question: need help with this show in excel and show work how to solve please The followng table lists the components needed to assemble an end

need help with this show in excel and show workneed help with this show in excel and show work how to solve please

The followng table lists the components needed to assemble an end item, lead times (In weeks), and quantities on hand. Cllck here for the Excel Data File a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hilnt. You don't need to develop an MRP plan.) b. An order for the end item is scheduled to be shipped at the start of week 8 . What is the latest week that the order can be started and still be ready to ship on time? (Hint. You don't need to develop an MRP plan.)

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!