Project #43037 - Ch.13 Solve Problems 13-4 and 13-18

Questions

13.4

The Sofaworld Company purchases upholstery material from Barrett Textiles. The company uses 45,000 yards of material per year to make sofas. The cost of ordering material from the textile company is $1500 per order. It costs Sofaworld $0.70 annually to hold a yard of material in inventory. Determine the optimal number of yards of material Sofaworld should order, the minimum total inventory cost, the optimal number of orders per year, and the optimal time between orders.

13.18

The Olde Town Microbrewery makes Townside beer, which it bottles and sells in its adjoining restaurant and by the case. It costs $1700 to set up, brew, and bottle a batch of the beer. The annual cost to store the beer in inventory is $1.25 per bottle. The annual demand for the beer is 21,000 bottles and the brewery has the capacity to produce 30,000 bottles annually.

a. Determine the optimal order quantity, total annual inventory cost, the number of production runs per year, and the maximum inventory level.

b. If the microbrewery has only enough storage space to hold a maximum of 2500 bottles of beer in inventory, how will that affect total inventory cost.

Please provide your answer on excel spreadsheet.

PLEASE DO NOT CUT AND PASTE ANSWER FROM THE INTERNET. THANKS!

Subject General
Due By (Pacific Time) 10/11/2014 01:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy