Quarter Sales Forecast (use this forecast for ALL problems).

I. 50

II. 120

III. 60

IV. 50

total 280

1. If the beginning inventory is 50 for Q-I, 70 units are produced during Q-1, and sales occur according to the forecast for Q-1, what is the average inventory for Q-I? (Show your calculations and CIRCLE your answer.)

Using the Aggregate Planning Worksheet labeled "A", show a plan that meets the following criteria. (NOTE: Do not use any data from question 1

The beginning inventory in Q-I is 20. The required ending inventory in Q-IV is 40 (which implies no back orders at the end of Q-IV). Sales occur according to the forecast. A level output plan is required. From this plan, answer questions 2 through 5.

2. What is the quarterly output rate?

3. What is the highest amount of inventory that appears in this plan?

4. Inventory Carrying Cost is $10.00 per unit per quarter based upon the average inventory in each quarter. What is the total carrying cost incurred using this plan? (Show your calculations and CIRCLE your answer.)

5. The division general manager directs you to eliminate all back orders while minimizing the impact on inventory carrying cost. Assuming that there are no capacity limitations, cost penalties, or other restrictions (such as maintaining completely level output), this request would best be accomplished by scheduling additional output when? (Circle you answer hereDO NOT enter this on the scanning form)

a) Split between Q-II and Q-III

b) Split between Q-I and Q-II

c) Q-III only

d) Q-II only

e) The general manager needs new glasses; there are no backorders in this plan.

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: 70 in Q-I, 70 in Q-II, 60 in Q-III, and 60 in Q-IV. Do any back orders appear in this plan? If so, how much and in what quarter?

*Please I need answers in 20 mins* Thank you.