Refer to problems 8 and 9. If the master schedule calls for 70 sidewalk skateboards to be assembled at the beginning of week 10, prepare a material requirements plan for all subassemblies and components. Assume no inventories are on hand and a lot-for-lot lot-sizing rule.

Data from problem 8

Dickinson Sports Equipment Inc. is a mythical manufacturer of a variety of sports goods. The bill of materials for one of its popular products, a sidewalk skateboard, is made up of a fiberglass board and two wheel assemblies. Each wheel assembly requires two wheels, one spindle, one wheel mount stand, and two locknuts.

Data from problem 9

You are the production planner at Dickinson Sports Equipment Inc. The lead times for assembling the skateboard and for assembling or acquiring the various subassemblies and components are as follows: skateboard (1 week), fiberglass board (2 weeks), wheel assembly (2 weeks), wheel mount stand (3 weeks), wheels (1 week), spindle (3 weeks), and locknut (1 week). Given this information, if an order for the skateboard is to be shipped at the beginning of week 10, what is the latest week by which work on that order has to be started and still be shipped on time?