Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F.

One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 20, 50, 60, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 50, 100, and 100, respectively, to be purchased. B has scheduled receipts of 30 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 20 units in Period 1, 20 units in Period 2, 60 units in Period 6, and 50 units in Period 8.

Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)

image text in transcribedimage text in transcribed \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & Period & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 \\ \hline & Gross requirements & & & & & & & & \\ \hline Item A & Scheduled receipts & & & & & & & & \\ \hline OH=20 & Projected available balance & & & & & & & & \\ \hline LT=1 & Net requirements & & & & & & & & \\ \hlineSS=0 & Planned order receipts & & & & & & & & \\ \hline \multirow{2}{*}{Q=L4L} & Planned order releases & & & & & & & & \\ \hline & Gross requirements & & & & & & & & \\ \hline Item B & Scheduled receipts & & & & & & & & \\ \hline OH=50 & Projected available balance & & & & & & & & \\ \hline LT=1 & Net requirements & & & & & & & & \\ \hlineSS=0 & Planned order receipts & & & & & & & & \\ \hline \multirow[t]{2}{*}{Q=L4L} & Planned order releases & & & & & & & & \\ \hline & Gross requirements & & & & & & & & \\ \hline Item C & Scheduled receipts & & & & & & & & \\ \hline OH=60 & Projected available balance & & & & & & & & \\ \hline LT=2 & Net requirements & & & & & & & & \\ \hlineSS=0 & Planned order receipts & & & & & & & & \\ \hline \multirow[t]{2}{*}{Q=L4L} & Planned order releases & & & & & & & & \\ \hline & Gross requirements & & & & & & & & \\ \hline Item D & Scheduled receipts & & & & & & & & \\ \hline OH=25 & Projected available balance & & & & & & & & \\ \hline LT=1 & Net requirements & & & & & & & & \\ \hlineSS=0 & Planned order receipts & & & & & & & & \\ \hline \multirow[t]{2}{*}{Q=50} & Planned order releases & & & & & & & & \\ \hline & Gross requirements & & & & & & & & \\ \hline Item E & Scheduled receipts & & & & & & & & \\ \hline OH=0 & Projected available balance & & & & & & & & \\ \hline LT=2 & Net requirements & & & & & & & & \\ \hlineSS=0 & Planned order receipts & & & & & & & & \\ \hlineQ=100 & Planned order releases & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{l|l} \hline Item E & Sross requirements \\ \hline OH=0 & Projected available balance \\ \hline LT=2 & Net requirements \\ \hline SS=0 & Planned order receipts \\ \hline Q=100 & Planned order releases \\ \hline Item F & Gross requirements \\ \hline OH=0 & Scheduled receipts \\ \hline LT=2 & Projected available balance \\ \hline SS=0 & Net requirements \\ \hline Q=100 & Planned order receipts \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Options Futures And Other Derivatives

Authors: John Hull

11th Global Edition

1292410655, 9781292410654

More Books

Students also viewed these Finance questions

Question

Simulate an inventory problem 834

Answered: 1 week ago

Question

Explain the need for a critical analytical approach to studying HRM

Answered: 1 week ago