6. Using the Aggregate Planning Worksheet labeled "B", show a plan that meets the following criteria The beginning inventory in Q-1 is 30. Sales occur according to the forecast. Output occurs as follows: 140 in Q-1, 140 in Q-11, 100 in 0-|||. and 100 in Q-IV. Do any back orders appear in this plan? If so how much and in what quarter? 3 (Four-Period Format) AGGREGATE PLANNING WORKSHEET "B" (use for the extra credit problem) Period 1 II III Total IV Forecast Output Output minus Forecast (optional-use if it helps you) Inventory Beginning Ending Average Backorders 6. Using the Aggregate Planning Worksheet labeled "B", show a plan that meets the following criteria The beginning inventory in Q-1 is 30. Sales occur according to the forecast. Output occurs as follows: 140 in Q-1, 140 in Q-11, 100 in 0-|||. and 100 in Q-IV. Do any back orders appear in this plan? If so how much and in what quarter? 3 (Four-Period Format) AGGREGATE PLANNING WORKSHEET "B" (use for the extra credit problem) Period 1 II III Total IV Forecast Output Output minus Forecast (optional-use if it helps you) Inventory Beginning Ending Average Backorders