Renova's problem is to develop a disaggregate production plan (Economic Lot Schedule) for five SKUs (white,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Renova's 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. Table 1: Notations Parameter/Variable j Indices of set of SKUs, j = {w,b,r.g.p) E D₁ Demand of SKU j 4 Inventory on hand of SKU; P₁ Available manhours for producing SKU; Total available manhours in cycle T P₁ T Cycle length Note: The unit of measurement for D, 1, and P 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 Dj 300 900 600 700 500 200 500 500 300 100 Given that the demands are deterministic and in manhours, and the available manhours (P,) for a cycle is 3000, i. ii. determine the sequence of producing the SKUs and show it in a simple graph. develop a linear programming model (in MS Word) and then solve it in Excel. explain the findings in details (MS Word) iii. 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? Renova's 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. Table 1: Notations Parameter/Variable j Indices of set of SKUs, j = {w,b,r.g.p) E D₁ Demand of SKU j 4 Inventory on hand of SKU; P₁ Available manhours for producing SKU; Total available manhours in cycle T P₁ T Cycle length Note: The unit of measurement for D, 1, and P 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 Dj 300 900 600 700 500 200 500 500 300 100 Given that the demands are deterministic and in manhours, and the available manhours (P,) for a cycle is 3000, i. ii. determine the sequence of producing the SKUs and show it in a simple graph. develop a linear programming model (in MS Word) and then solve it in Excel. explain the findings in details (MS Word) iii. 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?
Expert Answer:
Answer rating: 100% (QA)
Renovas problem is to develop a disaggregate productio... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
Two stocks, A and B. are available on a market. The mean returns and standard deviations of the returns are given as follows: Stock A B Mean return Standard deviation of return 15% 20% 8% 12% The...
-
The objective of this assignment is to develop a script and define a method of communication for obtaining a local business sponsor for your Senior Capstone Project. The script will represent the...
-
Burger King: Your first task is to develop a communications plan for your President/CEO. This communication plan will be for an initiative that your boss has decided your organization will undertake...
-
Q3: Prove: For any sets A and B, Ax B = B A ?
-
In the early 1970s the Environmental Protection Agency announced that lead content would not be allowed in gasoline after a certain date. Prior to that time, three producers had been selling a very...
-
A 25.0-g sample of rock at 250 C is dropped into 100.0 g of water at 19 C. If the water temperature rises to 31 C as the rock cools, what is the specific heat of the rock? Strategy Plan STEP 1: What...
-
Describe some practical physical limitations on the use of the RTM process in fabrication of composite sandwich structures which consist of composite face sheets and foam or honeycomb core.
-
The capital investment committee of Windsor Landscaping Company is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows:...
-
determine the superficial gas velocity VSG at each transition using the correlations provided Water superficial velocity (m/s) Water density (kg/m) Gas density (kg/m) Fluid's properties [0.001-10]...
-
Martha has not made any taxable gifts in her past Check and complete the excel spreadsheet of total assets. ASSUME BENNY DIES ON DECEMBER 31, 2020. Prepare a Reconciliation of Gross Estate to the...
-
Question 3 Evaluate each limit. A. lim 53. 22 (x,y)-(1,2) B. lim 22-y (y)-(3,3) 2-y 1 pts
-
5. Suppose the company Liver Corporation earned $ 1.57 per share in 2010 and after 8 years, in 2018, the company earned $ 3.10. Determine the growth rate of earnings per share (EPS) over the 8 years....
-
You can invest $10,500 today into an investment with a promised constant cash flow growth of 3% per year. Calculate PV of this investment if r = 6.5%.
-
A tank of coefficient of volume expansion 6.0 x10^-5/C filled with 2.0 m^3 of a liquid of coefficient of volume 18 x 10^-5/C is at a temperature of 40 degrees C and is in thermal equilibrium. The...
-
An investor longs a 3 months maturity call option with K = 220, and shorts a half year call with K = 220. Currently, S0 = 220, risk-free rate r = 0.06 (continuously compounded), and = 0.25. The stock...
-
How often should urinalysis be performed to screen for microalbuminuria in the management of a patient with type 2 diabetes?
-
A very special IBM bond is available to be bought in the market for $83.33. This bond pays semi-annual coupons of $2.50 every six months. The next coupon payment will be exactly six months from now....
-
For the following exercises, rewrite the sum as a product of two functions or the product as a sum of two functions. Give your answer in terms of sines and cosines. Then evaluate the final answer...
-
What does the term functional currency mean? How is the functional currency determined under IFRS and under U.S. GAAP?
-
What were the three phases in the life of the IASC?
-
What are the factors that influence the decision regarding the manner in which a particular subsidiary should be treated for purposes of performance evaluation (e.g., as a cost center or a profit...
-
Suppose we wish to estimate the probability of a rare event (such as a default probability). Let the random variable \(X\) be equal to 1 if the event occurs and to zero otherwise. Then...
-
Show that \(\left(\frac{1}{2}, \frac{1}{2} ight)\) is the optimal policy for Example 18.2 . Example 18.2 (Volatility pumping) Suppose there are two assets available for investment. One is a stock...
-
In a certain state lottery, people select eight numbers in advance of a random drawing of six numbers. If someone's selections include the six drawn, they receive a large prize, but this prize is...
Study smarter with the SolutionInn App