Question

In: Operations Management

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 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. [1 Mark] Optimal order quantity b. [1 Mark] Shortage level (Maximum number of back orders) c. [1 Mark] Total minimum cost. d. [1 Mark] Optimal ordering policy e. [1 Mark] How long will there be stock out?

Solutions

Expert Solution

Solution:

Given that,

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. [1 Mark] Optimal order quantity
b. [1 Mark] Shortage level (Maximum number of backorders)
c. [1 Mark] Total minimum cost.
d. [1 Mark] Optimal ordering policy
e. [1 Mark] How long will there be stock out

Answer:

Annual demand = Working days per year x (Weekly demand / Operating days per week)

= 355 x (25/7)

= 1,268 Units

Below given the Excel Sheet and Excel formula

The Yellow marked boxes represent the formula used in the first box and answers in the second box...

keosha answered 3 months ago
Next > < Previous

Related Solutions

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...
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...
Week 1 Assignment Question 1 Ruddy Lewis operates a bike repair shop operating under the name...
Week 1 Assignment Question 1 Ruddy Lewis operates a bike repair shop operating under the name R.L. Bike Repairs. The balances of his accounts on April 1 of the current year were as follows: The following transactions were incurred for the month of April: Inventory of supplies at end of the month (April 30) was $550                                                 Assets        = Liabilities + Owners Equity Balance April 1 + Cash Ruddy Lewis, Capital $12,400 Transaction Numbers 9 -650 -650 Balance 10 Balance,...
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...
Python Programming Question Bicycle shop. A bicycle shop sells bikes and helmets. Some people already own...
Python Programming Question Bicycle shop. A bicycle shop sells bikes and helmets. Some people already own helmets, so on average the shop sells three helmets for every five bicycles. Helmets cost $50 and bikes cost $250. Write a program that prompts for the number of bikes that the shop expects to sell over the next month and outputs the total amount of expected revenue. You should not be using eval() at all; use int() or float() instead when called for.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT