Demand and inventory on hand for five SKUs are presented in Table 2: Given that the demands
Question:
Demand and inventory on hand for five SKUs are presented in Table 2:
Given that the demands are deterministic and in manhours, and the available manhours (Pt) 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. i
ii. 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 Tin conflict with the JIT paradigm where we try to achieve the minimum manufacturing cycle time?
Accounting concepts and applications
ISBN: 978-0538745482
11th Edition
Authors: Albrecht Stice, Stice Swain