Question: 1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble X product As and X/2 (if the

1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble X product As and X/2 (if the ratio is not integer then round it down) product Bs. The current projected available balance is 11 and 6 for products A and B respectively.

a. Given this information and the following product structure diagrams for A and B, fill out the MRP records (inventory status files) for component parts G and Y for the next seven weeks.

1. Ajax produces two basic products called A and

Part G

Week		1	2	3	4	5	6	7
Gross Requirements
Scheduled Receipts		2X
Projected Available Balance	15
Planned Order Release

Q = X, LT = 1, SS = 5

Part Y

Week		1	2	3	4	5	6	7
Gross Requirements
Scheduled Receipts		2X
Projected Available Balance	2X
Planned Order Release

Q = L4L, LT = 2, SS = 3

X= 38, please provide excel formulas

A B X Y G F Y (2 required) z

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!

1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X" product As and "X/2" ( if the ratio is not integer then round it down ) product Bs. The current...

1.Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X" product As and "X/2" ( if the ratio is not integer then round it down ) product Bs. The current...

Please provide answer in excel format with formulas. Y is (2 required) Q = 64. Disregard the X and 2. 1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble...

X=32 1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble X product As and "X/2" (if the ratio is not integer then round it down) product Bs. The current...

x=36 1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X"product As and X/2** (if the ratio is not integer then round it down) product Bs. The current...

with excel formulas 1 Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X"product As and X/2" (if the ratio is not integer then round it down) product...

x=40 please show excel formulas 1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X" product As and " X/2 " (if the ratio is not integer then round it...

X=32 please post formulas and work used in excel!! 1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "X" product As and "X/2" (if the ratio is not...

1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble X product As and X/2 ( if the ratio is not integer then round it down ) product Bs. The current...

1. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble "37" product As and "18" product Bs. The current projected available balance is 20 and 40 for...

2. def split(pq: PriorityQueue): split() function accepts a priority queue which keys are integers and which values are strings and splits it to two priority queues based on whether the key is even...

In the retail industry, when customers pay cash at the time of sale, revenue is recognized a) when the inventory is purchased. b) at the time of sale. c) when the time frame for returns has passed....

State sales taxes can be complicated, the number of different jurisdictions that levy sales and use tax is: Multiple choice question. about 6 , since many states operate the same about 5 0 0 or so...

What is an example of constructive feedback? provide reference