I. A company makes three products the characteristics of which are given below. The resource availability is also shown. a) Use Excel Solver to get the solution. What's your observation about the solution? b) If there is a constant demand of 40 units for product NP1, how will it change the solution? Comment about this solution comparing with (a) above. c) Keeping the demand for NP1 as 40 units, allocate a 10% safety stock for Materials and a 15 minute for Time, find the best solution for Month2. Compare the resources leftover after Month2 with Month1 and comment whether the safety stock is beneficial. Use the same Excel workbook but different worksheets for the 3 cases above. d) As an expert SCA, comment on the applicability of resource allocation. In what areas of different industries do you think these could be applied
Other questions asked by students
increases air in the soil and its ability to 1 Point 14 Obecome part of...
A bond is scheduled to mature in five years. Its coupon rate is 9 percent with...
Suppose you deposited $400 in a savings account 2 years ago. The simple interest rate...
3 Match the function with its graph try wit f x log x f x...
Nines to five, a clothing resale store, employs one salesperson, Dixie Hoopers straight time wage...
Expenses incurred but not yet paid or recorded are called C. interim expenses. a. prepaid...
Due Saturday by 11:59pm Points 40 Submitting a file upload Available Oct 20 at 12am...
bring out the role of central bank as the controller money supply or credit