Analyse inventory management issues

Assignment Help Case Study

Reference no: EM133049915

Canvas assignments

Learning Outcome 1: Analyse inventory management issues, controls, practices, costs and data to contribute to decision making for the strategic and competitive advantage for the business individually and/or in a group.

Learning Outcome 2: Evaluate the relationship between stock levels and customer service alongside competitive advantages for businesses

Assignment Tasks:

Northcutt Bikes: The forecasting Problem

Jan Northcutt, the owner of Northcutt Bikes, started business in 1995. The following shows the monthly demand for one major product line: the standard 26-inch 10-speed street bike. Although it is only one of Jan's products, it is representative of most of the major product lines currently being produced by Northcutt Bikes. If Jan can find a way to use this data to understand her demand more constructively, she feels she can probably use the same methodologies to project demand for other major product families. Such knowledge can allow her to plan more effectively and continue to be responsive while still controlling costs.

Period	Previous Year	Current Year
1	11155	12500
2	4593	5200
3	2866	3600
4	3095	4800
5	7487	6000
6	7580	8500
7	3221	4700
8	1947	3200
9	2104	3200
10	7184	7600
11	2968	3300
12	1845	2400
13	1994
14	5190
15	1845
16	2222
17	2400
18	8723
19	4489
20	2800
21	3026
22	5855
23	13118
24	5400

Assignment

1. Plot the data in Excel.
2. Discuss the pattern and justify how would you use this information to develop a forecast.
2. Use two different methodologies to develop as accurate a forecast as possible for the demand. Use each of those methods to project the next four months demand.
3. Compare the two chosen methods and justify which is better.
4. Calculate the recommended safety stock level for the business and justify the reasons behind.
5. Discuss the trade-offs between customer service level and stock level.

The assignment will be marked in the following criteria:

1. Plot the data in Excel
2. Discuss the pattern and justify how would you use this information to develop a forecast?
3. Use two different methodologies to develop an accurate forecast for the next four months demand
4. Compare the two chosen methods and justify which is better
5. Calculate the recommended safety stock level for the business and justify the reasons behind
6. Discuss the trade-offs between customer service level and stock level

Attachment:- Case study briefing sheet.rar

Reference no: EM133049915

Questions Cloud

Importance of the six-step problem-solving model : As a contracting professional you will be required to make much decision that can and will affect the outcome of the acquisition, as well as the organizational

What is the actual hours worked : Standard quantity allowed for actual production, 1,500 hours. Labor efficiency variance, P600 unfavorable. What is the actual hours worked

Determine whether the threat truly impairs his independence : Using the AICPA Conceptual Framework for Independence Standards, describe how Royce can determine whether the threat truly impairs his independence

Australian banking and finance industry : Evaluate the ethical challenges facing organisations when employing AI systems. Please provide specific examples related to the Australian banking

Analyse inventory management issues : Evaluate the relationship between stock levels and customer service alongside competitive advantages for businesses - contribute to decision making

How many units must be sold : JCH Sports plans to market a new product for the upcoming college season. How many units must be sold in order to reach a before-tax income

Find a city with multiple sports teams : Who are the key sponsors of your favorite team? How are they promoting their association with the team?

Develop a new use for old sport product : For this assignment, you are to develop a new use for an old sport product that people are familiar with.

Iddr approach and unconditional promise : ?Carlos Pardo signed a note to obtain $627,500 to buy a house in Stamford, Connecticut. The note was secured by a mortgage.

Reviews

len3049915

12/18/2021 12:49:58 AM

The assignment will be marked in the following criteria: 1. Plot the data in Excel (10 pts) 2. Discuss the pattern and justify how would you use this information to develop a forecast? (10 pts) 3. Use two different methodologies to develop an accurate forecast for the next four months demand (20 pts) 4. Compare the two chosen methods and justify which is better (20 pts) 5. Calculate the recommended safety stock level for the business and justify the reasons behind (20pts) 6. Discuss the trade-offs between customer service level and stock level (20pts)

Write a Review

Required(*) Message

User Account

All Pages