Periodic review system, You work for a retailer that uses a

Periodic review system

Assignment Help Finance Basics

Reference no: EM13749554

Problem 1: Periodic Review System

You work for a retailer that uses a monthly periodic system to maintain the inventory of water heaters it sells. Below is the sales data for the last 5 months.

Month	Jan	Feb	Mar	Apr	May
Units Sold	265	227	239	238	213

What is the company's average monthly demand for water heaters?

Assume the standard deviation of demand is 19.1 water heaters and the company wants to be in stock at least 95% of the time. What is the appropriate restocking level?

If there are currently 42 water heaters on hand when the order is placed for June, how many water heaters should be ordered?

Problem 2: Economic Order Quantity

A chemical plant orders barrels of chlorine that is used at the rate of 2,440 barrels per year. Each order that is placed with the supplier costs $24 to process and the annual cost to hold inventory is $150 per barrel. Delivery lead time of the barrelshas averaged 5 days and the plant manager has set a safety stock level of 40 barrels.

What is the economic order quantity?

What is the total holding cost for the year?

What is the total ordering cost for the year?

How many orders will be placed each year? You can leave this answer as a decimal.

The next order should be placed when chlorine inventory drops to what amount? (assume 365 days in one year for converting annual demand to daily demand)

Problem 3: Quantity Discounts

The UWM Bookstore orders keychains out of a catalog from a supplier. The demand for these keychains is 5,982 per year. There is a $15 charge for placing an order and a $9 cost per keychain to hold it in inventory for the year.

What is the economic order quantity?

For part b) assume prices for the keychains are based on the quantity purchased with each order, so if less than 400 are ordered, the unit price is $1.35, if 400 to 599 are ordered the unit price is $1.25, and if 600 or more are ordered the unit price is $1.10.

What is the total annual cost (holding + ordering + purchase price) at the economic order quantity?

What order quantity will result in the lowest total annual cost (holding + ordering + purchase price) to the UWM Bookstore? Be sure to show your work for full credit.

Extra Credit: Single-Period Inventory System

The restaurant you are working at makes one massive batch of soup each day. If you run out before the end of the day, the last few customers are less than satisfied, but if you make too much, it can be sold to the local farmer for animal food.Every serving costs $0.22 to make and can be sold for $2.50 to customers. You have to pay $0.02 per serving to transport the extra servings to the farmer, but the farmer will pay you $0.16 per serving. The average daily demand is 191 servings with a standard deviation of 19 servings.

What is the Shortage Cost?

What is the Overage Cost?

What is the target service level?

How many servings of soup should your restaurant make each day to meet this service level?

Reference no: EM13749554

Questions Cloud

Studying and presenting a real dbms administration process : Studying and presenting a real DBMS administration process for a real company o How the backup is performed at a given company and why

Main types of trading systems : What are the main types of trading systems? What is a forward, futures, and options market for foreign currencies?

What about your project led you to choose this methodology? : What about your project led you to choose this methodology?What other development methodologies did you consider?What methodologies were your major candidates, and why?

The transportation director of your company : Write a proposal of 500 words to the transportation director of your company on your first and second suggested modes of transportation to deliver this product.

Periodic review system : You work for a retailer that uses a monthly periodic system to maintain the inventory of water heaters it sells. Below is the sales data for the last 5 months.

Define the various types of validity : Evaluating the Validity of Statements-Define the various types of validity and apply them to the movie selection

What kind of evidence might indicate that a company''s board : Review the Discussion Questions and User Checklist at the end of Chapter 6, the Board of Directors and Major Projects, in your text Project Management: Strategic Design and Implementation. What kind of evidence might indicate that a company's b..

Advantages and disadvantages of using personal health record : Demonstrate effective communication by composing writing that communicates ideas, meaning and/or argument in a format that broadly follows conventions in the information systems field. What are the advantages and disadvantages of using a Personal ..

Start your paper by giving a brief summary of the scenario : Start your paper by giving a brief summary of the scenario. Then identify the problem at hand. Write a couple of paragraphs that critically evaluate the three possible solutions describe advantages and disadvantages of each. Doing this will help y..

User Account

All Pages