A company makes three products the characteristics of which are given below. The resource availability...

50.1K

Verified Solution

Question

Accounting

imageA company makes three products the characteristics of which are given below. The resource availability is also shown. Table 1 Problem 1 Data Product NP1 NP2 NP3 - Resources - - - Availability Material 1 (units) 2 6 3 650 Material 2 (units) 3 4 3 575 Material 3 (units) 5 6 5 850 Material 4 (units) 4 5 2 600 Time in Manufacturing Department (mins) 20 20 10 2175 Time in Assembly Department (mins) 15 20 25 3500 Time in Packaging Department (mins) 2 2.5 3 450 Profit ($) 5 7 6 - 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

1. 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. 1. 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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students