Question: I need this answered not using excel Given the following data, construct a material requirements plan which will result in 100 units of parent #1

I need this answered not using excel

Given the following data, construct a material requirements plan which will result in 100 units of parent #1 (P1), at the beginning of week 6 and 200 units of parent #2 (P2) at the beginning of week 8:

item	parent	quantity	on-hand	on order(due)	Lead Time	Order size
P1	-	-	-	-	1	Lot-for-Lot
P2	-	-	-	-	1	Lot-for-Lot
A	P1, P2	1,2	70	0	1	500
B	P1, P2	2, 1	50	0	3	250
C	A, B	3, 4	1000	2000 (wk2)	2	2000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Tanner-UNF Corporation acquired as a long-term investment $310 million of 6.0% bonds, dated July 1, on July 1, 2021. Company management has the positive intent and ability to hold the bonds until...

Given the following data, construct a material requirements plan which will result in 100 units of Parent #1 (P1) at the beginning of week 6, and 200 units of Parent #2 (P2) at the beginning of week...

please show all workings! thanks 8) (15 marks) Given the following data, construct a material requirements plan which will result in 100 units of Parent #1 (P1) at the beginning of week 6, and 200...

QUESTION 5 1 points Save Answer Given the following data, construct a material requirements plan which will result in 100 units of Parent 1 (P1) at the beginning of week 6, and 200 units of Parent 2...

Problem #3 Given the following data, construct a material requirements plan which will result in 160 units of Parent #1 (Pl) at the beginning of week 6, and 220 units at the beginning of week 8:...

Problem #3 MRP Problem #3 Given the following data, construct a material requirements plan which will result in 220 units of Parent #1 (P1) at the beginning of week 6, and 230 units at the beginning...

Problem: Given the following data, construct a material requirements plan which will result in 220 units of Parent #1 (P1) at the beginning of week 6, and 230 units at the beginning of week 8:...

No Spacing Text B 21 31 51 Q1. Prepare a schedule for the following situation: The forecast is 80 units for each of the first two periods and 60 units for each of the next three periods. The starting...

Please answer questions 4,5 & 6 in excel along with formulas A transportation planner has set up the following spreadsheet formulation of a transportation problem: Costs from Location to Location A 8...

Question: Given the following data construct A material requirements plan which will results in 102 units of A at the beginning of week 7. Calculate the X values given in the table according to the...

Show excel equations Given the following data, construct a material requirements plan for all components which will result in 200 units of (P) at the beginning of week 6. (Use Excel and submit your...

Usually, current assets are listed in a specific order, starting with cash. What is the objective of this order of listing?

From the sale of inventory by parent to sub, journalize elimination entries for the first and second year. First Year Beginning Inventory Sales Available Ending Inventory Cost of Goods Sold Second...

An informal credit arrangement supported by an invoice is called a ( n ) and is classified as an asset account. ( Enter one word per blank. )

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...