Question: Please solve the table in part c show how to get calculations WITHOUT EXCEL! Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs

Please solve the table in part c show how to get calculations WITHOUT EXCEL!
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 9. Subscripts indicate quantity required for each parent. Assume lot-for-lot ordering.
This exercise contains only parts b and c.
Click the icon to view information about the steppers.
The product structure is as follows:
b) Choose the correct time-phased structure.
A. B. B.
Q
A. C.
D.
c) Develop a net material requirements plan for F(enter your responses as whole numbers).
\table[[Item,,Week,,\table[[Lead Time],[(weeks)]]],[,2,3,4,5,6,7,8,9],[F,Gross req,,,,,,,,,2],[On hand,,,,,,,,],[Net req,,,,,,,,],[Order receipt,W,,,,,,,],[Order release,,,|,,,,,]]
A horizontal line labeled Time in weeks, marked with 8 ticks from left to right. From the left, the ticks are labeled 2,3,4,5,6,7,8, and 9. There is a horizontal line segment from 7 to 9 labeled as stepper. stepper has three branches labeled A, B, and C. A horizontal line segment from 4 to 7 is labeled A and placed above stepper. A horizontal line segment from 4 to 7 is labeled B and is in line with stepper. A horizontal line segment from 4 to 7 is labeled C and placed below stepper. A has 2 branches, labeled D and F. A horizontal line segment from 2 to 4 is labeled D and placed above A. A horizontal line segment from 2 to 4 is labeled F and placed below A. B has 2 branches, labeled E and F. A horizontal line segment from 2 to 4 is labeled E and placed above B. A horizontal line segment from 2 to 4 is labeled F and placed below B. C has 2 branches, labeled D and E. A horizontal line segment from 2 to 4 is labeled D and placed above C. A horizontal line segment from 2 to 4 is labeled E and placed below C.
\table[[More Info],[Item,\table[[Lead],[Time]],\table[[On-Hand],[Inventory]],Components],[Stepper,2,10,
 Please solve the table in part c show how to get

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!