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
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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F58462576-e569-4666-84bb-74ca6c587f4f%2F2d1dd387-a8d2-4120-9002-fa8978df18e9%2Fudsdn2_processed.png&w=3840&q=75)
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

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 4 images

Knowledge Booster
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
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education