Question: Everything I have is correct just nothing is working for the total cost with the spreadsheet I'm using so I'm confused. Che Problem 14-4 (LO

Everything I have is correct just nothing isEverything I have is correct just nothing isEverything I have is correct just nothing is working for the total cost with the spreadsheet I'm using so I'm confused.

Che Problem 14-4 (LO 14-4, 14-7) The Always Fresh Grocery... 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 Carrying charge = 20 percent per year Item cost = $80 per case Given the above information, the EOQ and total cost are: EOQ is 23 cases at a total cost of 364 What is the effect on EOQ and total cost of the following types of changes? (Round EOQs up to the nearest integer and total cost up to the next dollar.) (Note: answer each part independently.) a. A 40 percent increase in demand. A 40% increase in demand changes the EOQ to 27 cases at a total cost of $ 432 b. A 20 percent increase in carrying charge. A 20% increase in carrying charges changes the EOQ to 21 cases at a total cost of

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!