Question: please help me answer all 4 questions a,b,c,d and present all in excel 1 Exercise. An organisation produces X, which includes 3 parts A, B,

please help me answer all 4 questions a,b,c,d and present all in excel please help me answer all 4 questions a,b,c,d and
1 Exercise. An organisation produces X, which includes 3 parts A, B, and C and in particular quantity: 2 A, 1 B and 1 C. A is made from F B from 1D, 2E, 1G C from 2D and 2H D from F The assembly time for each component and part is as followed: Unit X A B C D E F G H Time(weeks) 2 1 2 1 3 2 3 a. Build up the master production schedule for X (required for delivery at the beginning of week 9) b. Make a production structure tree, c. Draw an assembly time chart d. The organisation received an order of 300 X at the beginning of week 9, determine the net requirement of F and its planned-order released. 1

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!