Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the Chairs BOM, represented in Question #1, the Master Production Schedule (MPS) is given. The MPS is based on the companys estimation of Chair

image text in transcribedFor the Chairs BOM, represented in Question #1, the Master Production Schedule (MPS) is given. The MPS is based on the companys estimation of Chair demand for weeks 1 through 7.

image text in transcribedimage text in transcribed

Question #1: Based on the following Chair's Bill Of Materials (BOM): level Chair (1) 0 Back Cushion (1) Seat Cushion (1) Chair Frame (1) Fasteners (8) 1 Adjuster Mechanism (1) Wheels (6) Base Units (1) Fasteners (3) 2 Question #2: For the Chair's BOM, represented in Question #1, the Master Production Schedule (MPS) is given. The MPS is based on the company's estimation of Chair demand for weeks 1 through 7. MPS (includes GR) Week 1 2 3 4 5 6 7 Chair 0 0 0 100 225 0 45 Inventory Records Item Description SS Lot Size Rule LT SR OH Chair Independent demand 40 EOQ = 100 2 wks 50 in week 3 50 Chair Independent demand 40 FOQ = 100 2 wks 50 in week 3 50 a. Do the MRP Calculations for Chair based on lot size rule of Economic Order Quantity (EOQ) = 100 Item: Chair Description: Independent Product Level: 0 Weeks SS= 40 Lot Size Rule: EOQ = 100 LT = 2 weeks 1 3 4 5 6 7 2 0 GR 0 0 100 225 0 45 SR 50 NR 50 OH PORec PORel Zoom b. What is total inventory cost over 7 weeks based on the above material requirement plan, if ordering cost is $850 per order and holding cost is $10 per order? (hint: total inventory cost of 7 weeks is the sum of total order cost over 7 weeks and total holding cost over 7 weeks). C. Do the MRP Calculations for Chair based on lot size rule of Fixed Order Quantity (FOQ) = 100 SS= 40 Lot Size Rule: FOQ = 100 LT = 2 weeks 3 4 0 100 50 5 6 2 0 7 45 225 Item: Chair Description: Independent Product Level: 0 Weeks 1 GR 0 SR NR OH 50 PORec PORel 0 d. What is total inventory cost over 7 weeks based on the above material requirement plan, if ordering cost is $800 per order and holding cost is $10 per order? (hint: total inventory cost of 7 weeks is the sum of total order cost over 7 weeks and total holding cost over 7 weeks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting Information Systems

Authors: Marshall B. Romney, Paul J. Steinbart

13th edition

133428532, 978-0133428537

More Books

Students also viewed these Accounting questions