Question

In: Operations Management

The Always Fresh Grocery Store carries a particular brand of tea that has the following characteristics:...

The Always Fresh Grocery Store carries a particular brand of tea that has the following characteristics:

Sales = 8 cases per week

Ordering cost = $10 per order

Holding cost factor = 20% per unit per year

Unit cost = $80 per case

The Always Fresh Grocery Store is offered a discount by its supplier:

Order size Item cost

0-49 $80

50-99 $76

100+ $74

a. Should the grocery store take the discount offer?

b. If they decide to take the discount offer, how many units they should order at one t

Solutions

Expert Solution

1. Yes, we should take the discount because the total annual cost with the discount is less than the total annual cost without the discount.

2. We should order 100 units at a time.

DEMAND = 416

ORDERING COST = 10

HOLDING COST % = 20 %

EOQ = SQRT(2 * DEMAND * ORDERING COST / HOLDING COST)

ANNUAL HOLDING COST = ADJUSTED EOQ / 2 * HOLDING COST PER UNIT

ANNUAL ORDERING COST = (ANNUAL DEMAND / ADJUSTED EOQ) * ORDERING COST

ANNUAL MATERIAL COST = ANNUAL DEMAND * OFFERED PRICE PER UNIT

TOTAL COST OF INVENTORY = ANNUAL(HOLDING + ORDERING + MATERIAL)

OPTIMAL ORDER QUANTITY = 100

ASSOCIATED COST = 31566


NO.

LOWER LIMIT

UPPER LIMIT

PER UNIT PRICE

ADJUSTED HOLDING COST

EOQ

ADJUSTED QUANTITY

ANNUAL HOLDING COST

ANNUAL ORDER COST

ANNUAL MATERIAL COST

TOTAL COST OF INVENTORY

1

0

49

80

16

23

23

23 / 2 = 184

416 / 23 * 10 = 180.87

416 * 80 = 33280

184 + 180.87 + 33280 = 33645

2

50

99

76

15.2

23

50

50 / 2 = 380

416 / 50 * 10 = 83.2

416 * 76 = 31616

380 + 83.2 + 31616 = 32079

3

100

& more

74

14.8

24

100

100 / 2 = 740

416 / 100 * 10 = 41.6

416 * 74 = 30784

740 + 41.6 + 30784 = 31566

** Leaving a thumbs-up would really help me out. Let me know if you face any problems.


Related Solutions

The Chesapeake Grocery Store is a small local grocery that only carries fresh produce, poultry, and...
The Chesapeake Grocery Store is a small local grocery that only carries fresh produce, poultry, and meat that are grown or raised in the 50-mile radius of the grocery. The store also carries other typical grocery items (such as packaged and canned goods). The owner of the grocery, George Lampe, employs about 35–40 people. You are a local CPA with a small firm in the Chesapeake area, and George has retained you as his independent auditor. You are currently reviewing...
The following are misstatements that have occurred in Fresh Foods Grocery​ Store, a retail and wholesale...
The following are misstatements that have occurred in Fresh Foods Grocery​ Store, a retail and wholesale grocery​ company: 1. On the last day of the​ year, a truckload of beef was set aside for shipment but was not shipped. Because it was still on hand the inventory was counted. The shipping document was dated the last day of the​ year, so it was also included as a​ current ­year sale. 2. The incorrect price was used on sales invoices for...
1) A grocery store carries the following items. There are two main categories of food –...
1) A grocery store carries the following items. There are two main categories of food – conventional and organic ingredients – and four food groups. The data are shown in the following table. Food Groups Food Categories Grains Fruits Vegetables Meat Total Conventional 82 48 276 204 610 Organic 93 77 24 11 205 Total 175 125 300 215 815 If all of the grains and meats were accidentally displayed together without a sticker or label to mark their origin,...
A grocery store was interested in understanding the level of brand loyalty for different products. The...
A grocery store was interested in understanding the level of brand loyalty for different products. The store randomly polled 100 customers who had just purchased milk and found that, of the 100 customers, 53 were loyal to one brand of milk. The store then randomly polled 100 customers who had just purchased bath soap and found that, of the 100 customers, 65 were loyal to one brand of soap. The grocery store would like to know if this shows evidence...
Weekly demand at a grocery store for a brand of breakfast cereal is normally distributed with...
Weekly demand at a grocery store for a brand of breakfast cereal is normally distributed with a mean of 850 boxes and a standard deviation of 80 boxes b) What is the probability that weekly demand is: Less than 900 boxes? More than 1020 boxes? Less than 660 boxes or greater than 980 boxes?
Which of the following economic characteristics is consistent with a grocery store chain? Minimal Competition Extensive...
Which of the following economic characteristics is consistent with a grocery store chain? Minimal Competition Extensive Competition High net Income to Sales Differentiated Product Which of the following assets would appear on the balance sheet at an amount greatly below its fair market value? Inventory Marketable Securities Equipment Brand Name The accrual basis for accounting recognizes Revenue when cash is received from customers Expenses when Paid Revenue when all or a substantial portion is performed Revenue when contracts are signed...
Franz, the owner and manager of Green’s Grocery Store, contracts to buy sixty crates of fresh...
Franz, the owner and manager of Green’s Grocery Store, contracts to buy sixty crates of fresh peaches from Holly, the owner and manager of Ideal Farms. Suppose that Holly dies before she can harvest and deliver the peaches. How does Holly’s death affect their contract? If Holly does not die, but does not deliver, and Franz suffers a loss, is there any limit to the time within which Franz can file a suit against Holly for breach of contract? If...
Your local grocery store claims that on average their fresh caught salmon will weigh 2 pounds....
Your local grocery store claims that on average their fresh caught salmon will weigh 2 pounds. You want to test to see if their claim is correct so you gather a simple random sample of 45 packages of their fresh caught salmon, weigh each package, and find that the average weight of these packages is 1.76 pounds. Based on years of data, the grocery store determined that the standard deviation ? = 0.08 pounds. What is the probability of obtaining...
The following are errors or fraud and other irregularities that have occurred in Fresh Foods Grocery...
The following are errors or fraud and other irregularities that have occurred in Fresh Foods Grocery Store Ltd., a wholesale and retail grocery company. The incorrect price was used on sales invoices for billing shipments to customers because the incorrect price was entered into a computer file. A vendor’s invoice was paid twice for the same shipment. The second payment arose because the vendor sent a duplicate copy of the original two weeks after the payment was due. Employees in...
The distribution of the number of people in line at a grocery store checkout has a...
The distribution of the number of people in line at a grocery store checkout has a mean of 3 and a variance of 9. A sample of the numbers of people in 50 grocery store checkout lines is taken. (a) (3 points) What’s the probability that the sample mean is less than 4.5? Round your answer to four (4) decimal places. (b) (3 points) What’s the probability that the sample mean is more than 2.25? Round your answer to four...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT