Question: PLEASE USE EXCEL AND SHOW FORMULAS NO HANDWRITTING PLEASE 8.* Super K Beverage Company distributes a soft drink that has a constant annual demand rate

PLEASE USE EXCEL AND SHOW FORMULAS NO

PLEASE USE EXCEL AND SHOW FORMULAS NO HANDWRITTING PLEASE

8.* Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 4,600 cases. A 12-pack case of the soft drink costs Super K $2.25. Ordering costs are $20 per order, and inventory- holding costs are charged at 25 percent of the cost per unit. There are 250 working days per year, and the lead time is 4 days. Find the economic order quantity and total annual cost, and compute the reorder point

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Chapter 1 1 8 . Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 4 , 6 0 0 cases. A 1 2 - pack case of the soft drink costs Super K $ 2 . 2 5 . Ordering...

1 1 . 4 ) MamaMia s Pizza purchases its pizza delivery boxes from a printing supplier. MamaMia s delivers on average 2 4 5 pizzas each month ( assume deterministic demand ) . Boxes cost 5 6 cents...

Problem #1 (10 points): Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 5,500 cases. A 12-pack case of the soft drink costs Super K $3.00. Ordering costs...

Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 5,000 cases. A 12-pack case of the soft drink costs Super K $2.50. Ordering costs are $35 per order, and...

eBook Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 3,800 cases. A 12-pack case of the soft drink costs Super K $1.50. Ordering costs are $21 per order,...

uwage Company is so that we voo 4.200 A 13 case of the insta Super 150. Ordering costs are 13 perder and in colare pret of the count. The working day, and the lead time a day, the content and ulcow,...

Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 5,000 cases. A 12-pack case of the soft drink costs Super K $2.25. Ordering costs are $35 per order, and...

Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 4, 600 cases. A 12-pack case of the soft drink costs Super K $2.25. Ordering costs are $20 per order, and...

What key areas or functions of a bank or other financial firm are regulated today?

Consider the following one-commodity market model 0500=a-bP a,b>0 Q = -c+dP c.d>0 a. Derive the reduced-form equations for this model. b. How many comparative-static derivatives can be found? What...

Function: SUM: Formula: Nultiply, DWide, Add; Cell Referencing Whing Excel to Account For a Partnershly Uguldation PROBLEM The partners of MIT Company hawe decided to liquidate their partnership....

What is an example of constructive feedback? provide reference