Search This Blog

Showing posts with label Moving Average. Show all posts
Showing posts with label Moving Average. Show all posts

Wednesday, February 9, 2011

Inventory Management

Solution is available here for U$15

31. A restaurant currently uses 62,500 boxes of napkins each year at a constant daily rate. If the cost to order napkins is $200.00 per order and the annual carrying cost for one box of napkins is $1.00, then the optimal order quantity (EOQ) for napkins would be
a. 62,500 boxes
b. 10,000 boxes
c. 5,000 boxes
d. 2,500 boxes

32. A company that produces specialized video equipment had cost of goods sold last year of $127,000,000. The average value of inventory for raw materials, work-in-process, and finished goods are shown in the table below: Raw Materials $6,189,000 Work-In-Process $2,541,000 Finished Goods $3,710,000 If the company operates 50 weeks per year then the weeks of supply in inventory would be
a. 4.898
b. 0.098
c. 10.209
d. 35.75

33. A forecasting model has produced the following forecasts: Period Demand Forecast Error January 120 110 February 110 115 March 115 120 April 125 115 May 130 125 The mean absolute deviation (MAD) for the end of May is
a. 7.0
b. 7.5
c. 10.0
d. 3.0

Friday, February 4, 2011

SCOM305 Week 4 Homework Problems

Solution is available here for U$25.00

1. Click on the "Problems tab" to review the 5 homework problems.  These are due on Saturday. 
2. Create a new work sheet tab for each problem.
3. Solve your problem on the worksheet.  Some problems have auxiliary questions to be answered.
Highlight your answers in RED. 

4. Post to your Assignments Link. 

1. An analysis of customer complaints at a large mail order house revealed the following data:
Billing Errors
4500
Picking Errors
9800
Long Delays
1353
Unclear Charges
1800
Delivery Errors
900
Shipping Errors
7300
Out of Stock
2700
Construct a Pareto Diagram in Excel to show this data.  What area(s) should the focus be on?