Demand and inventory on hand for five SKUs are presented in Table 2: Supply Chain Analysis and Design Assignment, RMIT, Singapore
University | RMIT University (RMIT) |
Part A (8 marks)
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 (ππ‘) for the period 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)
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
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?
Part B (8 marks)
Suppose we keep the information regarding the demand, inventory on hand, and the total production manhours from Part A. In this section, we want to avoid keeping excess inventory before the production begins. In other words, Renova starts to produce the items only when the inventory on hand is zero. You are required to
i. develop a linear programing model to provide an optimal production schedule for the five SKUs given that production starts when the inventory of an item is zero.
(MS Word)
ii. Solve the problem in Excel.
iii. Discuss your findings (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. Explain in which model (Part A or Part B), the probability of shortages is higher.
Why?. What is your recommendation?
Presentation (4 marks)
Organization, style, structure of sentences, flow of information, presenting the mathematical expressions in right format, citations and referencing, structure of tables and figures and the associated captions, and overall presentation.
Buy Custom Answer of This Assessment & Raise Your Grades
Achieve excellence in your Supply Chain Analysis and Design Assignments with our premier services. Recognized for providing the best assignment help in Singapore and offering top-notch dissertation writing services, we empower students in Singapore to elevate their academic performance. Seamlessly pay our experts for personalized assistance, ensuring a comprehensive understanding of supply chain concepts and delivering exceptional results. Choose us for unparalleled support, simplifying your academic journey for success.
- Final Assignment: Migrating FashionOnline’s Infrastructure to AWS: A Strategy for Enhanced Availability and Data Protection
- HRM331: Talent Management – Strategic Shift from the War for Talent to the Wealth of Talent
- Marginalised Populations – The Structural and Cultural Exclusion of People Experiencing Homelessness in Singapore
- CVEN3501 Assignment 2: Groundwater Modelling of Drawdown from a Pumping Bore
- CSCI312 Assignment 2: Conceptual Modelling and Implementation of a Data Warehouse and Hive Queries
- CH2123 Assignment: Fugacity, VLE Modeling & Applications of Henryβs Law
- BAFI1045 Assignment -Constructing and Evaluating Passive and Active Portfolios Based on the Straits Times Index (STI)
- FIN2210E/FIN2212E Group Assignment: Financial Risk Management Analysis of Bursa Malaysia Companies
- FLM101 Assignment: A Film Analysis: Stylistic Techniques and Their Thematic Importance
- HRM Assignment Answer: Talent Transformation in the Age of AI: Turning Challenges into Opportunities via Ecosystem Innovation
UP TO 15 % DISCOUNT