Supply Chain Analysis and Design - Engineering Assignment Help

Assignment Task:

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.
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?
1. Given aggregate decisions on output and capacity, allocate manpower and other resources to specific operations over the time horizon (sometimes referred to as the staff sizing problem).
2. Given the allocation of resources to specific operations, determine the shift schedules and crew assignments of employees.
3. Given the shift schedule assignments, determine short-term adaptations, reallocations between operations, and priorities of the service requirements.

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)
The organization, style, the structure of sentences, flow of information, presenting the mathematical expressions in the right format, citations and referencing, the structure of tables and figures and the associated captions, and overall presentation.

This Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.