PLEASE SHOW ALL STEPS ON HOW TO COMPLETE EACH ANSWER PLEASE.

(IF SHOWN IN EXCEL) PLEASE EXPLAIN HOW TO USE EXCEL TO ANSWER AS WELL

STUDYING FOR FINAL WITH SIMILAR PROBLEMS :)

1.A

Therefore,

1.B Total relevent costs = total setup cost + total holding cost=??

2.

3. A

Dependant demand is calculated based on needs of parent items

		True
		False

3.B

What is a cause of system nervousness?

		Too many changes made to production schedule
		Too many production orders and products

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. 1 4 Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 40 70 30 20 80 60 *Holding cost = $3.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 2 3 5 6 7 8 9 10 11 12 Gross requirements 20 30 40 70 30 20 80 60 On-hand at beginning of 40 period On-hand at end of period Order receipt Order release You have developed the following simple product structure of items needed for your gift bag for a rush party for prospective pledges in your organization. You forecast 200 attendees. Assume that there is no inventory on hand of any of the items. Explode the bill of material. (Subscripts indicate the number of units required.) K(1) L5) M(3) Determine the number of units of each item required. Item K: units (enter your response as a whole number). Item L: units (enter your response as a whole number). Item M: units (enter your response as a whole number)