Question

In: Operations Management

After graduation, you decide to go into a partnership in an office supply store that has...

After graduation, you decide to go into a partnership in an office supply store that has existed for a number of years. Walking through the store and stockrooms, you find a great discrepancy in service levels. Some spaces and bins for items are completely empty; others have supplies that are covered with dust and have obviously been there a long time. You decide to take on the project of establishing consistent levels of inventory to meet customer demands. Most of your supplies are purchased from just a few distributors that call on your store once every two weeks.

You choose, as your first item for study, computer printer paper. You examine the sales records and purchase orders and find that demand for the past 12 months was 5,800 boxes. Using your calculator you sample some days' demands and estimate that the standard deviation of daily demand is 7 boxes. You also search out these figures:

Cost per box of paper: $11.

Desired service probability: 99 percent.

Store is open every day.

Salesperson visits every two weeks.

Delivery time following visit is three days.

Using your procedure, how many boxes of paper would be ordered if, on the day the salesperson calls, 75 boxes are on hand? (Use 365 days a year. Use Excel's NORMSINV() function to find the correct critical value for the given ?-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

Solutions

Expert Solution

Given are following data :

Review period ( i.e. frequency of visit of sales person ) = 14 days ( i.e. 2 weeks )

Delivery lead time = 3 days

Therefore , Protection period = Review period + Delivery lead time = 14 + 3 = 17 days

Standard deviation of daily demand = 7 boxes

Therefore ,

Standard deviation of demand during review period

= Standard deviation of daily demand x Square root ( Protection period )

= 7 x Square root ( 17 )

= 7 x 4.123

= 28.86

Z value for 99 percent service probability = NORMSINV ( 0.99 ) =2.326

Safety stock

= Z value x Standard deviation of demand during protection period

= 2.326 x 28.86

= 67.128 ( 67 rounded to nearest whole number )

SAFETY STOCK = 67

Average daily demand = Annual demand/ 365 days = 5800/365

Reorder point = Average daily demand x Protection period + safety stock

= ( 5800/365) x 17 + 67 = 270.13 + 67 =337.13 ( 337 rounded to nearest whole number )

Number of boxes on hand =75 boxes

Number of boxes of papers to be ordered = reorder point – Number of boxes on hand = 337 – 75 = 262

NUMBER OF BOXES OF PAPERS TO BE ORDERED = 262


Related Solutions

After graduation, you go work for a large multi-national organization as an accountant. You have a...
After graduation, you go work for a large multi-national organization as an accountant. You have a loving family, large debts and love to travel. You are approached multiple times by your manager and s/he told you to fudge some numbers on the financial statements to ensure the organization appears profitable.  Explain whether you would move forward with what you have been told to do and explain why or why not.   You love your job and have worked for the organization for...
After graduation, you decide that you can pay $202.89 per month extra on your student loan...
After graduation, you decide that you can pay $202.89 per month extra on your student loan (standard monthly payment is 302.85), which has a balance of $60,000 and 20 years of monthly payments remaining. The annual interest rate on the loan is 4.4% How many years early will you be able to pay off the loan?
You are trying to decide whether to take a job after you graduate or go onto...
You are trying to decide whether to take a job after you graduate or go onto graduate school. Consider the following questions as you make your decision. A. Which of these costs, for the most part, would be relevant (R), and which would be irrelevant (IR)? ◦ Cost of your undergraduate education ◦ Salary with an undergraduate degree ◦ Salary with both an undergraduate degree and a graduate degree ◦ Rent ◦ Car Insurance ◦ Graduate school tuition and fees...
5. In order to diversify your investing strategy, after graduation you decide to also invest annually...
5. In order to diversify your investing strategy, after graduation you decide to also invest annually in Tesla, Inc. You decide to invest $300 every January 1st for 5 years in Tesla and then when you are ready, you will sell this stock and buy your first home. Date Amount Price 2015 300 240 2016 300 213 2017 300 316 2018 300 333 (1 point) If you sell all of your stock today and the share price is $286, how...
Write a memor to an office supply store requesting a quote on chairs for your office....
Write a memor to an office supply store requesting a quote on chairs for your office. you can make up the details!
You are the auditor for Konerko's Office Supply Store, which is opening for business next week....
You are the auditor for Konerko's Office Supply Store, which is opening for business next week. The store owner has established all the controls you have recommended for ensuring that sales and cash are recorded properly and tracked physically. The owner has heard from other small business owners that employees often used returned goods as a means of skimming money from the register. Post your responses to the following questions: How might an employee use returned goods to skim money...
After graduation, four college fraternity brothers decide they want to form a business together. They want...
After graduation, four college fraternity brothers decide they want to form a business together. They want to open a sports bar on some property that recently was put up for sale adjacent to the local stadium. The fraternity brothers are not yet sure whether they want to make equal investments and have equal control over the partnership. However, each brother is able to invest a maximum of $20,000. The fraternity brothers are open to considering any of the different forms...
Mike, Matt, Brooke, and Kellie decide to go into business together. The form a limited partnership...
Mike, Matt, Brooke, and Kellie decide to go into business together. The form a limited partnership where Mike, Matt, and Brooke are the limited partners. They contribute the following amounts: Mike - 25,000 Matt - 10,000 Brooke - 10,000 Kellie - 5,000 Additionally, the partnership agreement states that all profits are to be distributed equally. Mike will perform high level management services for the company and will be paid $130,000 a year for those services. The company will be able...
After ten years on the job, Drew is trying to decide whether to go back to...
After ten years on the job, Drew is trying to decide whether to go back to school and get a masters degree. He performs a cost-benefit analysis to determine whether the cost of attending school will be covered by the increase in salary he will received after he attains his degree. He does research and compiles data on annual salaries in his industry, health care, along with the years of experience for each employee and whether the employee has a...
Scenario: Sports Memorabilia Store Farah and David decide to form a sports memorabilia retail partnership. They...
Scenario: Sports Memorabilia Store Farah and David decide to form a sports memorabilia retail partnership. They have known each other since business graduate school and have always worked well together on various projects. The business is doing well but cash flow is very tight. Farah takes several calls from vendors asking for payment. He believed David had been paying the bills. When he asks about this, David admits to embezzling from the partnership. What liability does Farah face as a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT