You are scheduling production of your popular Rustic Coffee Table. The table requires a top, four legs, 1/8 gallon of stain, 1/16 gallon of glue, 2 short braces between the legs and 2 long braces between the legs, and a brass cap that goes on the bottom of each leg. You have 100 gallons of glue in inventory, but none of the other components. All items except the brass caps, stain, and glue are ordered on a lot-for-lot basis. The caps are purchased in quantities of 1,000, stain and glue by the gallon. Lead time is 1 day for ach item. COFFEE TABLE Top Glue Base Assembly Short Logs Long braces braces Brass Caps a) Schedule the order releases necessary to produce 640 coffee tables on days 5 and 6, and 128 on days 7 and 8. (See Appendix A1.) Stain

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

I need detailed answer with appendice A1, thanks a lot 

QUESTION 2 [45 pts]
You are scheduling production of your popular Rustic Coffee Table. The table requires a top, four
legs, 1/8 gallon of stain, 1/16 gallon of glue, 2 short braces between the legs and 2 long braces
between the legs, and a brass cap that goes on the bottom of each leg. You have 100 gallons of
glue in inventory, but none of the other components. All items except the brass caps, stain, and
glue are ordered on a lot-for-lot basis. The caps are purchased in quantities of 1,000, stain and glue
by the gallon. Lead time is 1 day for ach item.
COFFEE TABLE
Top
Glue
Base Assembly
Short
braces
Long Løgs
braces
Brass Caps
a) Schedule the order releases necessary to produce 640 coffee tables on days 5 and 6, and
128 on days 7 and 8. (See Appendix A1.)
Stain
Transcribed Image Text:QUESTION 2 [45 pts] You are scheduling production of your popular Rustic Coffee Table. The table requires a top, four legs, 1/8 gallon of stain, 1/16 gallon of glue, 2 short braces between the legs and 2 long braces between the legs, and a brass cap that goes on the bottom of each leg. You have 100 gallons of glue in inventory, but none of the other components. All items except the brass caps, stain, and glue are ordered on a lot-for-lot basis. The caps are purchased in quantities of 1,000, stain and glue by the gallon. Lead time is 1 day for ach item. COFFEE TABLE Top Glue Base Assembly Short braces Long Løgs braces Brass Caps a) Schedule the order releases necessary to produce 640 coffee tables on days 5 and 6, and 128 on days 7 and 8. (See Appendix A1.) Stain
APPENDICES
A1. Example MRP Form
Lead
Low-
Lot
On Safety Allo-
Level
Size
Time
(of
periods)
Hand Stock cated Code
Item
ID
Gross Requirements.
Scheduled Receipts
Projected On Hand.
Net Requirements
Planned Order Receipts
Planned Order Releases
Gross Requirements
Scheduled Receipts
Projected On Hand
Net Requirements
Planned Order Receipts
Planned Order Releases i
Gross Requirements
Scheduled Receipts.
Projected On Hand
Net Requirements
Planned Order Receipts
Planned Order Releases
Gross Requirements
Scheduled Receipts.
Projected On Hand.
Net Requirements
Planned Order Receipts
Planned Order Releases
Gross Requirements
Scheduled Receipts
Projected On Hand
Net Requirements
Planned Order Receipts
Planned Order Releases
2
3
Period (week, day)
4
5
6
7
8
Transcribed Image Text:APPENDICES A1. Example MRP Form Lead Low- Lot On Safety Allo- Level Size Time (of periods) Hand Stock cated Code Item ID Gross Requirements. Scheduled Receipts Projected On Hand. Net Requirements Planned Order Receipts Planned Order Releases Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases i Gross Requirements Scheduled Receipts. Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases Gross Requirements Scheduled Receipts. Projected On Hand. Net Requirements Planned Order Receipts Planned Order Releases Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases 2 3 Period (week, day) 4 5 6 7 8
Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Probability Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education