Question: 1). Use the above Materials Requirement Planning (MRP) answer the question a). What is the Projected Available Balance for Item A in period 11.. b).

1). Use the above Materials Requirement Planning (MRP) answer the question

1). Use the above Materials Requirement Planning (MRP) answer the question a). What is the Projected Available Balance for Item A in period

a). What is the Projected Available Balance for Item A in period 11..

b). In what period does Item B have a Gross Requirements..

c). What is the amount of the Gross Requirements for item B..

d). In what period does Item C have a Gross Requirements..

e). What is the amount of the Gross Requirements for Item C..

f). What is the Projected Available Balance for Item C in period 11..

g). What is the Projected Available Balance for Item D in period 4..

h). What is the amount of the Planned Order Release in period 4..

i). What is the Net Requirements for Item D in period 8..

j). What is the Projected Available Balance for Item D in period 11..

k). What is the amount of the Planned Order Release for Item D in period 5..

l). What is the Gross Requirement for Item E in period 5..

m). What is the Projected Available Balance for Item E in period 11..

n). What is the Net Requirements for Item E in period 7..

o). What is the amount of the Planned Order Release for Item E in period 3..

p). What is the sum of the Gross Requirements for Item F on the worksheet..

q). What is the Net Requirement for Item F in period 6..

r). What is the Projected Available Balance for Item F in period 11..

s). What is the amount of the Planned Order Release for Item F in period 1..

t). What is the sum of the Planned Order Releases for Item G..

u). What is the Gross Requirements for Item G in period 8..

v). What is the Projected Available Balance for Item G in period 4..

w). What is the Projected Available Balance for Item G in period 6..

x). What is the Projected Available Balance for Item G in period 11..

y). What is the Net Requirement for Item G in period 7..

F E 2 900 2 200 G 2 500 Ch9: Material Requirements Planning (MRP) Blackboard Assignment Item A B D Lead Time (LT) 2 2 1 3 Order Quantity (0) 50 L4L LAL 150 Scheduled receipts (Amount) 150 Scheduled receipts (Period) Period 2 Projected Available Balance 20 0 20 You require 100 units of Item A in Period 10. 0 400 50 135 1 You need 100 units of A in week 10. 1 2 3 4 4. 5 6 7 8 9 9 11 10 100 Item: A LT=2 0-50 Item: B LT-2 Q=L4L Item: C LT=1 Q-L4L Item: D 150 LT-3 Period Gross requirements Scheduled receipts Projected Available Balance 20 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 0 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 0 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 20 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 400 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 50 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 135 Net requirements Planned order receipts Planned order releases Q-150 Item: E LT-2 Q-900 Item: F LT-2 Q-200 Item: G LT-2 0-500 3 2 2 Item LT Q Sch. Rec. Amt Sch. Rec. Per. Beg. Inv. A B C D E F G 2 2 1 3 2 2 2 50|L4L L4L 150 900 200 500 150 2 20 0 0 20 400 50 135 A B (2) C (4) D (1) E (3) D (2) F (1) E (2) G (4) F (3) G (2) F (3) G (2) F E 2 900 2 200 G 2 500 Ch9: Material Requirements Planning (MRP) Blackboard Assignment Item A B D Lead Time (LT) 2 2 1 3 Order Quantity (0) 50 L4L LAL 150 Scheduled receipts (Amount) 150 Scheduled receipts (Period) Period 2 Projected Available Balance 20 0 20 You require 100 units of Item A in Period 10. 0 400 50 135 1 You need 100 units of A in week 10. 1 2 3 4 4. 5 6 7 8 9 9 11 10 100 Item: A LT=2 0-50 Item: B LT-2 Q=L4L Item: C LT=1 Q-L4L Item: D 150 LT-3 Period Gross requirements Scheduled receipts Projected Available Balance 20 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 0 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 0 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 20 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 400 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 50 Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected Available Balance 135 Net requirements Planned order receipts Planned order releases Q-150 Item: E LT-2 Q-900 Item: F LT-2 Q-200 Item: G LT-2 0-500 3 2 2 Item LT Q Sch. Rec. Amt Sch. Rec. Per. Beg. Inv. A B C D E F G 2 2 1 3 2 2 2 50|L4L L4L 150 900 200 500 150 2 20 0 0 20 400 50 135 A B (2) C (4) D (1) E (3) D (2) F (1) E (2) G (4) F (3) G (2) F (3) G (2)

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 Accounting Questions!

Kam Company purchased a machine on January 2, 2019, for $20,000. The machine had an expected life of 8 years and a residual value of $300. The double-declining-balance method of depreciation is used....

1). Use the above Materials Requirement Planning (MRP) tree to answer the question a). What is the Projected Available Balance for Item A in period 11.. b). In what period does Item B have a Gross...

please fill in the answer sheets. please This is a Group Mini Case Study (15\%) for your existing teams and each team will receive a team specific data sheet on their MS Teams chat box. This Group...

Analytics Exercise 21-3 (Algo) Recently, Phil Harris, the production control manager at Brunswick, read an article on time phased requirements planning. He was curious about how this technique might...

Reverse the Bullwhip Effect As the global pandemic continues to affect the retail industry, retailers and store operators must stay ahead of the curve to stay afloat. During the onset of the health...

One unit of A is made of three units of B. one unit of C, and two units of D. Bis composed of two units of E and one unit of D. Ci made of one unit of B and two units of EE is made of one unit of F...

I need assistance with some SAP Classic Rockers Case Student Exercises (Setup, MM, PP, SD, FI/CO). let me know if interested. Chapter 1: Setup Exercises EXERCISE 1:SETUP PARAMETER ID This exercise...

X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 4 / 6 o 82.1% 2 do Share Search 'Rotate Page Po Export PDF 11 13...

Question 3 (a) KANJAR Company is a manufacturer of light aircraft components in Oman. For the past two years of operation, the company is experiencing production backlog. A number of its customers...

(b) The XYZ Company produce Notebook with product structure in Figure Q2(b). The Material Requirement Planning (MRP) for these three item shows in Table Q2(b)(i), Table Q2(b)(ii) and Table...

Question 3: (a) KANJAR Company is a manufacturer of light aircraft components in Oman. For the past two years of operation, the company is experiencing production backlog. A number of its customers...

For each positive integer n, let a Sketch a graph of g"(x). b. c. Evaluate and sketch a graph. Does the sequence fn(x) converge to the step function a (x) as n ? (d) Find the derivative hn(x) =...

If A is symmetric, show that each matrix Ak in the QR-algorithm is also symmetric. Deduce that they converge to a diagonal matrix.

E7.3 A unity feedback control system for an automobile suspension tester has the loop transfer function [12] L(s) Ge(s)G(s) = K(s+3) s2 (s+10) We desire the dominant roots to have the maximum...

Cascade Company was started on January 1, 2018, when it acquired $60,000 cash from the owners. During 2018, the company earned cash revenues of $35,000 and incurred cash expenses of $18,100. The...

The JM Partnership was formed to acquire land and subdivide it as residential housing lots. On March 1, 2013, Jessica contributed land valued at $600,000 to the partnership, in exchange for a 50%...

Explain how to calculate the shared responsibility payment under the Affordable Care Act.

Explain how a company might use the accounting rules for impairment of long-lived assets to manage earnings.

Tinsel town Construction just received a $2 billion contract to construct a modern football stadium in the City of Industry located in southern California for a new National Football League (NFL)...

Tristan and Tyreek are managers in the shipping and receiving department at Snowman's Top Hat Company. They are responsible for hiring, firing, and overall performance against goals within the...

3.89 State, with evidence, whether each of the following statements is true or false: a. The complement of the union of two events is the intersection of their complements. b. The sum of the...

3.86 You are the meat products manager for Gigantic Foods, a large retail supermarket food distributor who is studying the characteristics of its whole chicken product mix. Chickens are purchased...

3.87 You and a friend are big soccer fans and are debating the possibility that FC Barcelona will win the final of the UEFA Champions League against Manchester United. You are supporting Manchester...