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: 352 Weeks Ago, 4 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 04 Sep 2017 My Price 11.00

Solve Inventory Models. Solve problems in excel, assignment help

Question description

 

The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 40 cars per month. The cars cost $60 each, and ordering costs are approximately $15 per order, regardless of the order size. The annual holding cost rate is 20%.

a. Determine the economic order quantity and total annual cost under the assumption that no backorders are permitted.

b. Using a $45 per-unit per-year backorder cost, determine the minimum cost inventory policy and total annual cost for the model racing cars.

c. What is the maximum number of days a customer would have to wait for a backorder under the policy in part (b)? Assume that the Hobby Shop is open for business 300 days per year.

d. Would you recommend a no-backorder or a backorder inventory policy for this product? Explain. e. If the lead time is six days, what is the reorder point for both the no-backorder and backorder inventory policies?

If you accept to do this I will send sample of what the spreadsheet should look like.

Answers

QuickHelper
(10)
Status NEW Posted 04 Sep 2017 07:09 AM My Price 11.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)