Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Production planning/MRP scenario analysis 1. Exercises with the MRP spreadsheets i. Assume that the standard costs are as follows: i. UsingMRP. Spreadsheet.xls, Material Standard cost

image text in transcribed

image text in transcribed

Production planning/MRP scenario analysis 1. Exercises with the MRP spreadsheets i. Assume that the standard costs are as follows: i. Using"MRP. Spreadsheet.xls", Material Standard cost $25 B $15 $5 X $50 ii. Assume that inventory holding costs are 2% per month. As+me an MPS schedule for X as follows: Period MPS plan 0 10 1 15 2 30 3 25 4 30 5 50 6 60 7 60 8 20 9 30 10 40 iv. V. Calculate the average invent for each item over periods 1-10. Assume for simplicity, that the 10-month average is roughly equivalent to the 12-month average inventory level. Calculate the annualized inventory holding cost for each item, and for all materials in total. Do not forget that 2% per month is NOT 24% per year -- you have to compound the interest. vi. vii. What is the impact on production planning and on holding costs for each of the independent scenarios indicated below. Not only should you be considering holding costs, but also any other issues that you may encounter with the various plans. Consider feasibility, smoothness (or lack thereof) of the schedule, setup issues, storage issues. 1. Double the lot size for all items 2. Double safety stock levels for all items 3. Reduce safety stock to zero (O) for all items Reduce the lot size in all components by a significant amount. Do this in three stops for all items: Item Original lot size Reduce to #1 Reduce to #2 Reduce to #3 4. X 15 10 5 1 A 33 20 10 1 B 40 20 10 1 100 75 50 1 Production planning/MRP scenario analysis 1. Exercises with the MRP spreadsheets i. Assume that the standard costs are as follows: i. Using"MRP. Spreadsheet.xls", Material Standard cost $25 B $15 $5 X $50 ii. Assume that inventory holding costs are 2% per month. As+me an MPS schedule for X as follows: Period MPS plan 0 10 1 15 2 30 3 25 4 30 5 50 6 60 7 60 8 20 9 30 10 40 iv. V. Calculate the average invent for each item over periods 1-10. Assume for simplicity, that the 10-month average is roughly equivalent to the 12-month average inventory level. Calculate the annualized inventory holding cost for each item, and for all materials in total. Do not forget that 2% per month is NOT 24% per year -- you have to compound the interest. vi. vii. What is the impact on production planning and on holding costs for each of the independent scenarios indicated below. Not only should you be considering holding costs, but also any other issues that you may encounter with the various plans. Consider feasibility, smoothness (or lack thereof) of the schedule, setup issues, storage issues. 1. Double the lot size for all items 2. Double safety stock levels for all items 3. Reduce safety stock to zero (O) for all items Reduce the lot size in all components by a significant amount. Do this in three stops for all items: Item Original lot size Reduce to #1 Reduce to #2 Reduce to #3 4. X 15 10 5 1 A 33 20 10 1 B 40 20 10 1 100 75 50 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Financial Accounting Longman Modular Texts In Business And Economics

Authors: Christopher Waterston, Anne Britton

2nd Edition

058238169X, 978-0582381698

More Books

Students also viewed these Accounting questions

Question

Define Decision making

Answered: 1 week ago

Question

What are the major social responsibilities of business managers ?

Answered: 1 week ago

Question

What are the skills of management ?

Answered: 1 week ago

Question

Define human resource management.

Answered: 1 week ago