University | Singapore University of Social Science (SUSS) |
Subject | LOG307: Optimization and Simulation for Decision-Making Assignment |
LOG307: Optimization and Simulation for Decision-Making Assignment, SUSS, Singapore: John is the store manager at Challenger in Changi City Point. He is evaluating inventory policies for Samsung
Question 2
John is the store manager at Challenger in Changi City Point. He is evaluating inventory policies for Samsung TVs for the next two years.
The monthly demand for Samsung TVs follows a triangular distribution with a minimum of 100, a maximum of 500, and a most likely value of 340. Challenger incurs $980 for purchasing these TVs from Samsung and sells them to customers for $1,950. In addition, the holding cost is $20 per TV per month, and the ordering cost is $120.
Consider the following assumptions:
• Beginning inventory is 410 units.
• Current inventory policy is to order 900 TVs whenever the inventory at the end of a month falls below 200 units.
• Orders placed at the end of one month arrive at the beginning of the next month.
• Unmet demand in any month is considered as lost sales.
Buy Custom Answer of This Assessment & Raise Your Grades
Question 2a
Construct a spreadsheet model to determine the average profit Challenger will earn from Samsung TVs over the next two years.
Comment on your findings.
Question 2b
Suppose John has the option to place an emergency order when demand exceeds the on-hand inventory. These orders will arrive instantaneously but cost $50 per TV.
Analyse whether he should opt for such an option.
Question 2c
Suppose John wants to find the best reorder point and order quantity that results in the highest profit over the next two years. The following table illustrates the options available:
Adjust the spreadsheet model you constructed for Q2b and find the best inventory policy for Samsung TVs for the next two years.
Comment on your findings.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Unlock your potential in LOG307 Optimization and Simulation for Decision-Making Assignment with our unparalleled Report Writing Help. Tailored to meet the needs of Singapore students, our service offers the best online assignment help Singapore has to offer. Trust our experts to guide you through the intricacies of optimization and simulation, ensuring your assignments stand out with precision and excellence. Let us be your partner in academic success.
Tags:-
- ELG101: Discovering Language Assignment, SUSS, Singapore: Speakers are creative users of the languages they speak. In our everyday interaction
- ELG101: Discovering Language Assignment, SUSS, Singapore: Demonstrate the articulation of the words in the above data set using the International Phonetic
- Principles of Project Management Individual Assignment, SUSS, Singapore: You are appointed a Project Manager in charge of organising and planning a project
- COR2223: Frontiers of Modern Computing Final Written Assignment, SMU, Singapore: Write a short story imagining a future scenario and how one or more of the modern computing technologies
- AC2101: Accounting Recognition and Measurement Assignment, NTU, Singapore: If NTU-C were to record the abovementioned transactions on 31 January, 28 February and 15 March 20×2
- BSE217: Motor Development, Control and Learning Assignment, SUSS, Singapore: Create a rating scale or categories of differentiation to rate the movement proficiencies of the individual
- BSE217: Motor Development, Control and Learning Assignment, SUSS, Singapore: Discuss the main theoretical foundations of Ecological Dynamics Theory
- NCO201: Learn To Learn, Learn For Life Tutor-Marked Assignment 2, SUSS, Singapore: Create a learning plan. Use this template to create your learning plan
- NCO201: Learn To Learn, Learn For Life Tutor-Marked Assignment 2, SUSS, Singapore: Self-reflection is a critical part of learning. By looking back at your process and analysing
- BPM301: LCC and Sustainable Design and Construction Assignment, SUSS, Singapore: A developer is building a new 3-storey sports complex on a 10-year leasehold land
UP TO 15 % DISCOUNT