Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Renovas problem is to develop a disaggregate production plan (Economic Lot Schedule) for five SKUs (white, blue, red, green, and pink) of a product to

Renovas problem is to develop a disaggregate production plan (Economic Lot Schedule) for five SKUs (white, blue, red, green, and pink) of a product to determine the optimal cycle length in order to minimize the total cost (or equivalent objective). The notations are presented in Table 1. However, you need to define new variables if required.Parameter/Variable Indices of set of SKUs, {,,,,} Demand of SKU Inventory on hand of SKU Available manhours for producing SKU Total available manhours in cycle Cycle length Note: The unit of measurement for ,, is manhours.

Part A (8 marks) Demand and inventory on hand for five SKUs are presented in Table 2: Table 2: SKU's demand and inventory on hand for Part A. White Blue Red Green Pink 300 900 600 700 500 200 500 500 300 100 Given that the demands are deterministic and in manhours, and the available manhours () for a cycle is 3000, i. determine the sequence of producing the SKUs and show it in a simple graph. ii. develop a linear programming model (in MS Word) and then solve it in Excel. iii. explain the findings in details (MS Word)

iv. develop a table in which inventory position of all SKUs is presented for periods of switching the production for each SKU (MS Word and MS Excel). For inventory positions, round to the nearest integer and compute the sum of inventory on hand for each period. v. Is maximization of T in conflict with the JIT paradigm where we try to achieve the minimum manufacturing cycle time?

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

Relational Database Design With Microcomputer Applications

Authors: Glenn A. Jackson

1st Edition

0137718411, 978-0137718412

More Books

Students also viewed these Databases questions

Question

What do you think of the MBO program developed by Drucker?

Answered: 1 week ago