Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assignment 3 Instructions Scenario: Olive Roscoe s Luxury Furniture Design LLC is a well - known household brand in Buffalo, New York. The company has
Assignment Instructions
Scenario:
Olive Roscoes Luxury Furniture Design LLC is a wellknown household brand in Buffalo, New York.
The company has experienced great success producing mattresses for distribution via wholesale, retail, and directtoconsumer DC channels.
Olive Roscoes Luxury Furniture Design ORLFD is facing several difficulties.
Retailers expect that suppliers will offer a wide range of products. ORLFD currently offers varieties for retail distribution. This proliferation has created several problems with operations.
a Limited warehouse space and high levels of demand variance have resulted in a significant decline in order fill rates.
b Inventory holding costs are exceptionally high.
The company has decided to hire your team of external consultants and anticipates that you will be able to quickly and accurately answer the following questions based on the data provided.
Based on demand, what is the # best seller? Answer AND Include Bar Chart
What are the Top products in terms of Revenue? Answer AND Include Pie Chart
What are the Top products in terms of Profitability? Answer AND Include Pareto Chart
What is our AVERAGE production cost per unit?
Based on your response to the above questions, please answer the following:
What strategies could ORLFD utilize to reduce inventory holding costs while better serving their customers?
What additional variables would be relevant to this case? In other words, what data is missing or excluded from our Excel document that would have otherwise been helpful if not essential in making these strategic decisions?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started