Determine a complete material requirements plan

Assignment Help Operation Management

Reference no: EM13752924

Use the following information and the attached editable MRP tableau worksheet to determine a complete material requirements plan for the 5 week planning horizon. A garden equipment manufacturer has a product that it makes which is represented by the following product structure tree along with other pertinent data:

ABC-51

--------------------------------------------------------------

l l l

W X (3 L

l l

l --------------------------------

P (4 l l

l l

P R (2

Inventory Records File
Item	Lead Time	On Hand	Lot Size	Safety Stock	Sched. Receipt
ABC-51	1	15	L4L	0	---
L	1	12	L4L	0	---
P	1	53	100	10	140 in wk 1
R	1	30	L4L	10	28 wk 1
W	1	10	20	0	---
X	2	25	40	0	---

Master Production Schedule (Weeks)

Product 1 2 3 4 5

ABC-51 0 0 50 0 75

Horizon Period

Item:

Lot Size:

LT:

SS:

Gross Requirements

Scheduled Receipts

Projected On Hand

Net Requirements

Planned-Order Receipts

Planned-Order Releases

Item:

Lot Size:

LT:

SS:

Gross Requirements

Scheduled Receipts

Projected On Hand

Net Requirements

Planned-Order Receipts

Planned-Order Releases

Item:

Lot Size:

LT:

SS:

Gross Requirements

Scheduled Receipts

Projected On Hand

Net Requirements

Planned-Order Receipts

Planned-Order Releases

Item:

Lot Size:

LT:

SS:

Gross Requirements

Scheduled Receipts

Projected On Hand

Net Requirements

Planned-Order Receipts

Planned-Order Releases

Horizon Period

Item:

Lot Size:

LT:

SS:

Gross Requirements

Scheduled Receipts

Projected On Hand

Net Requirements

Planned-Order Receipts

Planned-Order Releases

Item:

Lot Size:

LT:

SS:

Gross Requirements

Scheduled Receipts

Projected On Hand

Net Requirements

Planned-Order Receipts

Planned-Order Releases

Reference no: EM13752924

Questions Cloud

Write a brief paper on discovery of a time capsule : write a brief paper on Discovery of a Time Capsule. Explain why each of these is especially important in defining the era of the 1960s.

Prepare a production budget and a direct materials budget : Each unit sells for $25. Each unit requires 2 yards of fabric, which is estimated to cost $3.50 per yard. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. Cling..

Total value and allocating available capital to the projects : The process of identifying the bundle of projects that creates the greatest total value and allocating the available capital to the projects is known as

Prepare journal entries and financial statement for year end : Prepare journal entries and financial statement for the year ended December 31, 2014. No adjusting entries have been made since December 31, 2013. Company A rented idle office space to Company B on February 1, 2014, at a rate of $1300 per month. on t..

Determine a complete material requirements plan : Use the following information and the attached editable MRP tableau worksheet to determine a complete material requirements plan for the 5 week planning horizon.

Fixed and variable cost behavior : Killy and a key supplier have entered into an arrangement that will result in a per-unit decrease in Killy's variable cost of $0.50 next year. Rental space will also be reduced, thereby decreasing fixed costs by 10 percent. Given the new cost equatio..

Projected return on investment : Develop a three- to four-page analysis (excluding the title and reference pages) on the projected return on investment for your college education and projected future employment. This analysis will consist of two parts:

Assuming that the company uses variable costing : McIntyre Manufacturing produces a single product. Last year, the company produced 20,000 units, out of which 18,000 were sold. There were no units in beginning inventory. Calculate McIntyre's product cost per unit, assuming that the company uses vari..

What other concern are presented by professors woodworth-ney : what other concerns are presented by Professors Kuhlman, Woodworth-Ney and Foner? Were these concerns answered with suffrage? Why, or why not?

User Account

All Pages