Assumptions: 1. Estimated Shipping cost, C, - $3300 (full container) C. $2100 (half container) - • Lead time for Full Container is 13 weeks • Lead time for Half Container is 15 weeks. Inventory holding cost, C, - 18% of the product price Product Price - $90 Assume Service level - 95% The aggregated quantity of products needs to be ordered for the business. Please use sales data from the attached excel file to determine The task: Please determine the best inventory model based on 2 years sales data, select the shipping method (full container vs half container) and calculate annual operating cost.

Assumptions: 1. Estimated Shipping cost, C, - $3300 (full container) C. $2100 (half container) - • Lead time for Full Container is 13 weeks • Lead time for Half Container is 15 weeks. Inventory holding cost, C, - 18% of the product price Product Price - $90 Assume Service level - 95% The aggregated quantity of products needs to be ordered for the business. Please use sales data from the attached excel file to determine The task: Please determine the best inventory model based on 2 years sales data, select the shipping method (full container vs half container) and calculate annual operating cost.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: What does stream value mapping need to be improved?

A: Value stream mapping is a technique that involves using flowcharts to log each stage of a process.

Q: snip

A: WTP has 3 different types of containers of size 1TEU, 2TEU and 2.5 TEU Here, 1 TEU is 1100 cubic…

Q: s not the result of Bullwhip effect?

A: Let's understand the concept of the Bullwhip Effect first: In simple words, the Bullwhip effect can…

Q: How many containers are needed for gadjits? 5 containers. (Enter your response rounded up to the…

A: Given that: Average demand d =2X775 = 1550 Average waiting time per unit w 0.15 Average…

Q: A company using a kanban system has an inefficient machine group. For example, the daily demand for…

A: Total Planned Inventory is the total number of inventory items that a company intends to store or…

Q: true or false Container and pallet pooling systems are utilized in order to minimize the movement…

A: The pallet is a vital advancement in the coordinations industry. Pallets are excessively broadly…

Q: Suppose the Motorboat dealership in part (a) above dealing in costly motorboats follows the policy…

A: Small Introduction about Stock A stock (some of the time called value) could be a budgetary…

Q: Lot-for-lot replenishment is most appropriate for which types of orders? Large, infrequent orders…

A: Ans) Lot for lot orders means ordering the units when needed and only that much which is required.…

Q: WhatYouNeed is an online retailer with operations in Northern Indiana. Their network includes five…

A: Inventory management includes all those activities which are related to managing the stock level in…

Q: WhatYouNeed is an online retailer with operations in Northern Indiana. Their network includes five…

A: Waste is a major blocker in revenue generation for all the firms be it goods or services. Reducing…

Q: The bullwhip effect causes a maximization of supply chain surplus. True or false?

A: A bullwhip effect can be describes as the frequency changes in demand which causes the large…

Q: Characteristics of break-bulk cargo

A: In transportation and shipping when the goods are handled and loaded in specific bags, pallets,…

Q: Strategies for mitigating the bullwhip effect include: O reducing inventory O reducing price O…

A: A well-defined plan or method for achieving particular goals or objectives is called a strategy. It…

Q: The average daily demand for component B is 750 units. The average time for waiting during the…

Q: Inventory reserve is conceptually similar to ?

A: An inventory reserve is a contra asset account on an organization's monetary record made fully…

Q: What is the total annual cost of managing the inventory with this policy.

A: The Total Annual Inventory Cost represents the comprehensive expenses associated with maintaining…

Q: Problem 4: Given the following information, determine the number of Kanban cards required. Demand…

A: Production is the process in which inputs are combined to have the required output. It includes a…

Question

Note: The carrying capacity for Full container is 1400 units

Half container is 700 units

ImportHome LLC
Revisit: Company Background
▪ Family business: self-financed, home as office, garage as warchouse, self-maintained
online store
.
Annual revenue around $600,000
B2C online retailer of kitchen-ware: soymilk maker, pressure cooker, frying pan, etc.
Target at the Chinese community in North America
.
Gourmet
soy milk maker
.
Gourmet Automatic
Pressure Cooker
Joyoung
soy milk maker
ID
Fuji
WoK/Frying Pan
±
Joyoung soy milk
maker w/Case
Assumptions:
1. Estimated Shipping cost, C, $3300 (full container)
C, = $2100 (half container)
Karaoke Machine
BOLUW
Boluw
■ Lead time for Full Container is 13 weeks.
• Lead time for Half Container is 15 weeks.
Inventory holding cost, C₂ = 18% of the product price
Product Price = $90
Assume Service level 95%
The aggregated quantity of products needs to be ordered for the business.
Please use sales data from the attached excel file to determine
DVD PLAYER
DVP
fa
Gourmet Automatic
Water Heater
Car wireless
Phone Receiver
The task:
Please determine the best inventory model based on 2 years sales data, select the shipping
method (full container vs half container) and calculate annual operating cost.

Week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
21
22
23
24
25
26
27
28
09
29
30
31
44
33
34
35
36
37
38
34
40
41
43
ZA
44
45
46
47
48
49
50
51
52
53
54
24
55
56
DA
57
58
59
60
61
62
63
64
65
66
67
68
69
70
31
31
72
73
74
75
76
77
78
79
80
81
82
83
84
84
86
87
88
89
00
90
91
07
92
93
94
95
96
97
Aggregated
Sales Data
Weekly in Units
236
235
136
129
173
212
185
98
99
90
100
101
102
103
180
133
144
132
כגון
97
191
179
26
76
121
50
=
154
209
139
750
116
75
249
159
154
96
112
125
237
149
188
136
100
117
172
180
142
141
69
204
78
213
227
179
72
154
146
72
85
218
123
199
56
240
112
126
235
106
139
170
217
169
93
94
60
22
162
102
191
90
91
77
68
69
71
60
65
59
71
21
104
100
105
70
75
22
68
100
122
100
98
50
100
102
96
87
82
53
96
105
88
241

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Given information

VIEW

Step 2: Calculations

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Problem 5: You have the following information:Demand rate = 250 units per hourLead time = 15 hourscontainer capacity = 300 units per hourSafety Stock = 20%a Determine the number of Kanban cards required.b Convert these Kanban cards into the number of hoursof demand they represent.c. If the container size is reduce from 300 to 150 units,what impacts, if any, will it have on inventory levels?
29 Meritor is so pleased with the outcome from previous suggestions that the consultants are invited back for more work. The consultants now suggest a more complete robotic automation of the making of muffler assemblies and also a reduction in container size to five per container. Meritor implements these suggestions and the result is that the muffler assembly fabrication cell now averages approximately 20 assemblies per hour, and the catalytic converter assembly cell can now respond to an order for a batch of catalytic converters in one hour. The safety stock remains at 11.5 percent. How many kanban cards are needed? Note: Round up your answer to the next whole number.
The Ostrya Virginiana furniture company produces wooden chairs. The demand for chairs is 500 units per month. The setup cost for production is $300, and the holding cost is $12 per chair per year. The production rate is 100 chairs per day. Assume 30 working days per month. Determine the following: a) D, S, H, p, u b) EPQ c) Run time
True or False? Containers protect and secure material to allow for efficient transport.
Inventory Problem at Three Spoons Market Randy is the owner of Three Spoons Market. Three Spoons Market is an upscale tapas restaurant in a town of about 200,000 people. According to both Yelp and Trip Advisory, it is the highest restaurant in town. Randy had been having trouble with inventory management (he runs out some items while others go bad) and has brought you in as a consultant to help, due your background in inventory management. The menu at the restaurant changes monthly, and there are daily specials. Randy follows what other restaurant Owners are doing to improve their bottom line-he reads trade publication and online blogs. He also tries to keep up with trends in other industries that may help him manage better. He recently read about the success small-jobs have had with many managing inventory as A,B or C. As Randy thinks about his business, it is really a job shop, since food is prepared after the consumer orders from the menu. The food is prepared to customer tastes and…
What Companies Use JIT Inventory Management?
When are Reduced setup times are particularly useful?