Master Production Schedule as % of Sales Forecast Weeks in Quarter Item: NW Grunge Sampler 1 2 3 4 5 6 7 8 9 10 11 12 0% 5% 15% 5% 10% 5% 10% 25% 10% 10% 0% 5% Deep South 0% 20% 0% 0% 10% 0% 20% 25% 5% 15% 5% 0% Hooch Sampler Given the following bill of materials, master production schedule, and inventory master file, generate MRP matrices for each item and identify orders that are past due. If any orders are past due give a recommendation on what course of action to take. If past due, Jody can subcontract the samplers themselves but it costs 4 times the unit cost of each sampler (e.g., subcontract 1 unit NW Grunge- 4*56). Lower level items can be expedited if need be but the cost is twice as much as the unit cost of the item (e.g., expedite I unit Walla Walla Mud-2*S1).