QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 355 Weeks Ago, 5 Days Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 09 Jun 2017 My Price 9.00

TMC Excel Question

Question description

 

 

17. The owner of a diner has summarized the price lists from four potential vendors (see the  following table) who want to supply her with cooking oil.  Monthly usage is 300 gallons, ordering cost is $10 per order, and the monthly carrying cost is $ .50 a gallon. 

  Which vendor should she use, and what order quantity is best if she wants to minimize total annual costs (TMC).

 VENDOR W        VENDOR X           VENDOR Y        VENDOR Z 

Quantity  Price   Quantity  Price   Quantity  Price   Quantity  Price

1-99           $25      1-79       $25        1-25        $27        1-59       $26

100-399      24       80-139     24        26-89        25        60-139     25

400+           22       140-299    23       90-199      24       140-249    24

                              300+         22        200+        23        250+        23

Since demand and carrying costs are both expressed on a monthly basis, you will need to multiply these values by 12 to put into annual terms. You will be using an EXCEL template that has already been created for quantity discount inventory problems and can be found at Stevenson’s online learning center atwww.mhhe.com/stevenson11e. ALL 8 OUTPUT PAGES MUST BE INCLUDED IN ANSWER!

Answers

QuickHelper
(10)
Status NEW Posted 09 Jun 2017 08:06 PM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)