Problem 14-13 (Static) Complete the MRP record for a bicycle seat. Note: Leave no cells blank wherever required. Click here for the Excel Data File - be certain to enter "0" Problem 14-13 (Static) Complete the MRP record for a bicycle seat. Note: Leave no cells blank - be certain to enter "O" wherever required. Click here for the Excel Data File MRP Record Lead time = 1 week On-hand = 40 Safety stock 20 Week 1 scheduled receipt = 100 Order quantity: FOQ = 100 Part Name: Seat Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Gross requirements Scheduled receipts 70 50 80 80 70 60 80 80 100 0 0 0 0 0 0 0 Available inventory Net requirements 0 0 Planned order receipts 0 0 Planned order releases 0 100 100 100 0 100 100 0

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter25: Segment Income Statement (dept)
Section: Chapter Questions
Problem 2R
icon
Related questions
Question
None
Problem 14-13 (Static) Complete the MRP record for a bicycle seat. Note: Leave no cells blank
wherever required. Click here for the Excel Data File
-
be certain to enter "0"
Problem 14-13 (Static)
Complete the MRP record for a bicycle seat.
Note: Leave no cells blank - be certain to enter "O" wherever required.
Click here for the Excel Data File
MRP Record
Lead time = 1 week
On-hand = 40
Safety stock 20
Week 1 scheduled receipt = 100
Order quantity: FOQ = 100
Part Name: Seat
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Gross requirements
Scheduled receipts
70
50
80
80
70
60
80
80
100
0
0
0
0
0
0
0
Available inventory
Net requirements
0
0
Planned order receipts
0
0
Planned order releases
0
100
100
100
0
100
100
0
Transcribed Image Text:Problem 14-13 (Static) Complete the MRP record for a bicycle seat. Note: Leave no cells blank wherever required. Click here for the Excel Data File - be certain to enter "0" Problem 14-13 (Static) Complete the MRP record for a bicycle seat. Note: Leave no cells blank - be certain to enter "O" wherever required. Click here for the Excel Data File MRP Record Lead time = 1 week On-hand = 40 Safety stock 20 Week 1 scheduled receipt = 100 Order quantity: FOQ = 100 Part Name: Seat Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Gross requirements Scheduled receipts 70 50 80 80 70 60 80 80 100 0 0 0 0 0 0 0 Available inventory Net requirements 0 0 Planned order receipts 0 0 Planned order releases 0 100 100 100 0 100 100 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage