Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Master Production Schedule (MPS) An electronic widget manufacturer is about to plan its production of a high selling widget NOX12K678P. The demand for the widget

image text in transcribed

Master Production Schedule (MPS) An electronic widget manufacturer is about to plan its production of a high selling widget NOX12K678P. The demand for the widget for the next 10 weeks has been estimated as follows: Week Demand 1 200 2 180 3 220 4 170 5 160 6 170 7 180 8 190 9 6 Coo 220 10 210 TOTAL 1900 As soon as a widget is produced it is sent to the finished goods (FG) inventory. If it is shipped from the FG inventory the same week it is produced the manufacturer assumes no inventory holding cost for the widget. However, if a widget is not shipped from the inventory the same week it is produced, a holding cost of $1 per widget is incurred for every week in inventory. As of now (end of week 0), there are 300 widgets in the FG inventory. The setup cost to run a batch is assumed to be $1.200. The manufacturer could make all widgets in one week, so capacity is not an issue. Note that setup costs are incurred for the first batch every week independently of whether the same unit was produced in the last run of the previous week. First, formulate a Fixed Order (EOQ) Planning-spreadsheet to find the production plan. Then, formulate a MILP-spreadsheet to find the optimal production plan. Compare the results. Master Production Schedule (MPS) An electronic widget manufacturer is about to plan its production of a high selling widget NOX12K678P. The demand for the widget for the next 10 weeks has been estimated as follows: Week Demand 1 200 2 180 3 220 4 170 5 160 6 170 7 180 8 190 9 6 Coo 220 10 210 TOTAL 1900 As soon as a widget is produced it is sent to the finished goods (FG) inventory. If it is shipped from the FG inventory the same week it is produced the manufacturer assumes no inventory holding cost for the widget. However, if a widget is not shipped from the inventory the same week it is produced, a holding cost of $1 per widget is incurred for every week in inventory. As of now (end of week 0), there are 300 widgets in the FG inventory. The setup cost to run a batch is assumed to be $1.200. The manufacturer could make all widgets in one week, so capacity is not an issue. Note that setup costs are incurred for the first batch every week independently of whether the same unit was produced in the last run of the previous week. First, formulate a Fixed Order (EOQ) Planning-spreadsheet to find the production plan. Then, formulate a MILP-spreadsheet to find the optimal production plan. Compare the results

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

Assurance And Auditing

Authors: Thomas Nelson

1st Edition

0170111342, 978-0170111348

More Books

Students also viewed these Accounting questions

Question

in your own words, describe managerial accounting

Answered: 1 week ago