The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and...

The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and Eid- Ul -Adah (this gives 355 working days in a year). The shop pays SAR 600 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle is estimated to be 25% of the SAR value of inventory. The shop sells an average of 25 bikes per week. Frequently, the dealer does not have a bike in stock when a customer purchases it, and the bike is back ordered. The dealer estimates his shortage cost per unit back-ordered, on an annual basis, to be SAR 400 due to lost future sales (and profits) and the lead time is 2 weeks. The ordering cost for each order is SAR 300. Determine the following

a. Optimal order quantity

b.Shortage level (Maximum number of back orders)

c. Total minimum cost.

d. Optimal ordering policy

e. How long will there be stock out?

Expert Solution

Weekly demand = 25 bikes

Operating days per week = 7

Working days per year = 355

Annual demand, D = 355*25/7 = 1268 units

EXCEL FORMULA:

keosha answered 4 months ago

QUESTION 1 The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for...

QUESTION 1 The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and Eid- Ul -Adah (this gives 355 working days in a year). The shop pays SAR 600 for a particular bicycle purchased from the manufacturer. The annual holding cost per bicycle is estimated to be 25% of the SAR value of inventory. The shop sells an average of 25 bikes per week. Frequently, the dealer does not have a bike in stock when...

Sam's Cat Hotel operates 52 weeks per year, 7 days per week

Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.75 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. >Demand 95 bags/week >Order cost $56/order >Annual holding cost = 30 percent of cost >Desired cycle-service level = 99 percent >Lead time = 4 week(s) (28 working days) >Standard deviation of weekly demand = 20 bags >Current on-hand inventory is 325 bags, with no...

A process makes two products. A and B. and operates 5 days per week. 8 hours...

A process makes two products. A and B. and operates 5 days per week. 8 hours per day. Demand for the two products for the next week is as follows: Day 1: A: 20; B:26 Day 2: A: 10: B:15 Day 3: A: 20; B:19 Day 4: A: 18; B:20 Day 5: A: 12; B: 20 What is the takt time of the process? What would a level production schedule look like?

Sam's Cat Hotel operates 52 weeks per? year, 5 days per? week, and uses a continuous...

Sam's Cat Hotel operates 52 weeks per? year, 5 days per? week, and uses a continuous review inventory system. It purchases kitty litter for ?$11.50 per bag. The following information is available about these bags. Refer to the standard normal table LOADING... for? z-values. Demand ?= 80 ?bags/week Order cost? = ?$58?/order Annual holding cost? = 30 percent of cost Desired ?cycle-service levelequals90 percent Lead time? = 2 ?week(s) ?(10 working? days) Standard deviation of weekly demand? = 16 bags...

MW is a large discount store that operates seven days per week. The store needs the...

MW is a large discount store that operates seven days per week. The store needs the following number of full-time employees working each day of the week. Sunday Monday Tuesday Wednesday Thursday Friday Saturday # of Employees 188 88 112 140 136 172 212 Each employee must work five consecutive days each week and then have two days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. The store currently has a total of...

The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime...

The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime rate fluctuates with the day of week, so the number of the police officers required each day depends on which day of the week it is: Monday, 11; Tuesday, 12; Wednesday, 14; Thursday, 15; Friday, 14; Saturday, 18; Sunday;8. The Police Station wants to schedule police officers to maximize the number of the officers whose days off are consecutive. Formulate LP and solve the...

The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime...

The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime rate fluctuates with the day of week, so the number of the police officers required each day depends on which day of the week it is: Monday, 11; Tuesday, 12; Wednesday, 14; Thursday, 15; Friday, 14; Saturday, 18; Sunday;8. The Police Station wants to schedule police officers to maximize the number of the officers whose days off are consecutive. Formulate LP and solve the...

Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous...

Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous review inventory system. It purchases kitty litter for ?$10.7510.75 per bag. The following information is available about these bags. Refer to the standard normal table LOADING... for? z-values. Demand = 100 bags/weeks Order cost = $56/order Annual Holding Cost = 30 percent of cost Desired cycle-service level =99 percent Lead time = 2 weeks (14 working days) Standard deviation of weekly demand = 10...

20 police officers work at Kadıköy Police Station. Each officer works for 5 days per week....

20 police officers work at Kadıköy Police Station. Each officer works for 5 days per week. The crime rate fluctuates with the day of week, so the number of the police officers required each day depends on which day of the week it is: Monday, 10; Tuesday, 13; Wednesday, 14; Thursday, 16; Friday, 14; Saturday, 18; Sunday, 10. The Police Station wants to schedule police officers to maximize the number of the officers whose days off are consecutive. Formulate an...

Problem 13: Sam's Cat Hotel operates 52 weeks per year, 6 days per week, and uses...

Problem 13: Sam's Cat Hotel operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.70 per bag. The following information is available about these bags. Demand = 90 bags/week Order Cost= $54/0rder Annual Holding cost = 27% of cost Desired cycle-service level = 80% Lead time = 3 weeks (18 working days) Standard deviation of weekly demand = 15 bags Current on-hand inventory is 320 bags, with no...

Question

The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for Eid-ul-Fitr and...

Solutions

Expert Solution

Related Solutions

QUESTION 1 The Jubail Bicycle Shop operates 7 days per week, closing 5 days each for...

Sam's Cat Hotel operates 52 weeks per year, 7 days per week

A process makes two products. A and B. and operates 5 days per week. 8 hours...

Sam's Cat Hotel operates 52 weeks per? year, 5 days per? week, and uses a continuous...

MW is a large discount store that operates seven days per week. The store needs the...

The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime...

The NYPD employs 20 police officers. Each officer works for 5 days per week. The crime...

Sam's Cat Hotel operates 5252 weeks per? year, 77 days per? week, and uses a continuous...

20 police officers work at Kadıköy Police Station. Each officer works for 5 days per week....

Problem 13: Sam's Cat Hotel operates 52 weeks per year, 6 days per week, and uses...