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 |

Tutor | Rating |
---|---|

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.. |