Below is the bill of material for a skate board. Indented BOM-Skate Board Plannin Part Description Board Level 1 Wheels 1 Axles

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter28: Statistics And Linear Regression (stats)
Section: Chapter Questions
Problem 2R
icon
Related questions
Question

can you explain how to do this? what do I need to keep an eye on?

Below is the bill of material for a skate board.
Indented BOM-Skate Board
Part Description
Board
Level
1
Planning Factor
1
1
Wheels
Axles
Hardware kit
Sticker set
1
1
1
The master production schedule for Skate Boards for the next 6 weeks is shown below (and the
MRP planned order releases for Skate Boards have been completed for you.)
Skate Boards-Level 0
Gross Requirements
Projected on-hand inventory=150
Net Requirements
Planned Order Releases
Q=100; LT=1; SS=0
Week 5
Week 6
Week 1
100
Week 2
Week 3 Week 4
150
75
200
200
Fill in the gross requirements based on the BOM and the planned order releases for Skate Boards.
Next calculate the projected on-hand inventory and the net requirements for axles. Finally, based on
the order policy and lead time for axles, determine the Planned Order Releases for axles.
Below is the MRP report for Axles.
Axles-Level 1
Gross Requirements
Projected on-hand inventory=325
Net Requirements
Planned Order Releases
Q=100; LT=1: SS=0
Week 1 Week 2 Week 3
Week 4
Week 5
Week 6
Transcribed Image Text:Below is the bill of material for a skate board. Indented BOM-Skate Board Part Description Board Level 1 Planning Factor 1 1 Wheels Axles Hardware kit Sticker set 1 1 1 The master production schedule for Skate Boards for the next 6 weeks is shown below (and the MRP planned order releases for Skate Boards have been completed for you.) Skate Boards-Level 0 Gross Requirements Projected on-hand inventory=150 Net Requirements Planned Order Releases Q=100; LT=1; SS=0 Week 5 Week 6 Week 1 100 Week 2 Week 3 Week 4 150 75 200 200 Fill in the gross requirements based on the BOM and the planned order releases for Skate Boards. Next calculate the projected on-hand inventory and the net requirements for axles. Finally, based on the order policy and lead time for axles, determine the Planned Order Releases for axles. Below is the MRP report for Axles. Axles-Level 1 Gross Requirements Projected on-hand inventory=325 Net Requirements Planned Order Releases Q=100; LT=1: SS=0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Introduction to Data analytics for accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
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