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.
- ECE316 ECA: Classroom Inquiry and Action Research: A Research-Based Assessment
- BPM115 TMA02: Sustainable Materials Feasibility Study for a Cross-Country Bridge
- BSC203 Assignment: Project Management Portfolio: Key Deliverables and Lessons Learned
- SOC367 ECA: Impact on Gender Equality in the Philippines and Southeast Asia
- HBC251 ECA: Religion in Contemporary Societies Semester 2025 SUSS
- HRM335 ECA: Analysis of Thought Leadership: Influence, Impact, and Competency Framework
- HBC101 TMA01: Understanding Contemporary Society: The Social and Behavioural Sciences
- HRM358 ECA: Diversity and Inclusion in the Workplace Semester 2025
- BUS356 Group Assignment: Contemporary Financial Accounting
- BUS357 ECA: Starting and Managing a Business Semester 2025
UP TO 15 % DISCOUNT