Question: Item Robot B E F Lead Time (weeks) 2 1 1 2 3 2 1 On Hand 10 5 20 4 8 15 10 Components

Item Robot B E F Lead Time (weeks) 2 1 1 2 3 2 1

Item Robot B E F Lead Time (weeks) 2 1 1 2 3 2 1 On Hand 10 5 20 4 8 15 10 Components B, G, C(3) EF G(2), H UI Assume you are the manager of Assembly, Inc. You have just received an order for 39 units of an industrial robot, which is to be delivered at the start of week 7 of your schedule. Using the following information, determine how many units of subassembly G to order and the timing of those orders, given that subassembly G must be ordered in multiples of 80 units and all other components are ordered lot-for-lot. Assume that the components are used only for this particular robot. Item Robot B Lead Time (weeks) 2 On Hand 10 5 20 4 Components B, G, C(3) E, F G(2), H 1 1 2 3 2 1 F G H SITI 8 15 10 Click here for the Excel Data File Subassembly Gorder quantity (in units) Order subassembly G at start of week

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!

Data Window 100% GO *** Fri 9:07 pm Q Excel File Edit View Insert Format Tools AutoSave HESU- OFF Help FINC Assign 1 ashriya .xls - Compatibility Mode Tell me Q Home Insert Draw Page Layout Formulas...

Activity Immediate Predecessor Most Likely (Weeks) 5 7 B C D E F G Optimistic (Weeks) 2 3 4 2 3 6 1 6 3 B D E, F G H 6 7 5 Pessimistic (Weeks) 8 9 10 14 3 10 3 8 1 10 4 1 14 H 1 5 0 1 2 3 4 5...

Maggie is analyzing data for best buy based on customers income and wall size and TV purchase (defined as ownership and nonownership) This is similar to question done in class but not exactly the...

Please provide equations and/or explanation on how you found each answer for the following: (A screenshot of your cell references would be easiest) A B D E F Name Box jolution 2 #1 Sales Budget 3 4...

Need help on this assignment! MRP-2 MPS Assignment Fall 2021 - Saved to my Mic Mallings Review View Tell me MRP-2 MPS Assignment Fall 2021 20 points) Model A Item C(4) Component (2) Raw Material F...

1). Use the above Materials Requirement Planning (MRP) answer the question a). What is the Projected Available Balance for Item A in period 11.. b). In what period does Item B have a Gross...

Exp19_Excel_Ch08_Cap_Golden_State_5K Project Description: You are a volunteer for the Golden State 5k, an annual 5k held across several cities in California to raise money for at risk youth. As part...

The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item End B C D E F G H LT (wk) 1 2 3 3 1 2 1 2 Amount on hand 0 10 10 25 12 30 5 0 End...

answer question 1-8 please and show formula plese i need it to understand it in excel AutoSave Off H2 IMA Case Study - Snowies Shaved Ice Excel Template (1) - Excel Search olayerao78 X File Home...

BUDGET ACCOUNTING ASSIGNMENT You will prepare various budgets, conduct a variance analysis and write a memo to the CEO of Crown Hotel regarding ethical practices during budgeting. Calibri 11 BIU A 7...

Compute the current ratio and acid-test ratio for each of the following separate cases. (Round ratios to two decimals.) Which company case is in the best position to meet short-term...

Assume Dogwood Leaf Foods, Inc., experienced the following revenue and accounts receivable write-offs: Suppose Dogwood Leaf estimates that 1% of revenues will become uncollectible. Requirement 1....

When must a broker record a written release or satisfaction of the broker lien in the county recorder's office in which the lien was recorded? within 1 0 days after the owner satisfies the claim...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...