Question

In: Operations Management

Wooden Stuff is a furniture retailer operating in Cambridge, Boston. It mainly commercializes wooden desks in...

Wooden Stuff is a furniture retailer operating in Cambridge, Boston. It mainly commercializes wooden desks in various sizes and shapes, and they have become very popular among MIT and Harvard students that need to furnish their rental apartments. To date, they have been managing their inventory with a simple Base Stock Policy: one item sold, one item ordered. This has worked well for a few years, but now they would like to switch to a more sophisticated policy. Their flagship product is SKU 6197OT, the Lifting Table, a table that can be adjusted to different heights to allow working in seated or standing position. This product accounts for one third of their sales and they would like to ensure a Cycle Service Level of 95% for this item. You have been asked to analyze this item and propose an inventory management policy that fits the company’s needs. After doing a little bit of research, you have estimated that the annual holding charge for the Lifting Table is 25%. The demand planner has given you some interesting data: the demand for the Lifting Table follows a normal distribution with a mean of 1762 units per year and a standard deviation of 211 units. The purchasing department informs you that the cost of each desk is $120 and the estimated ordering costs are $100 per order. It usually takes 10 days for the ordered items to arrive to the Wooden Stuff facilities. Every Lifting Table is sold at a price of $300. (Assume that there are 365 days in one year, and 30 days in a month.) After analyzing all the available information and interviewing some key stakeholders in the company, you have decided to explore a Continuous Review Policy (s, Q).

1. What would be the replenishment order quantity Q?

2. What would be the reorder point s?

3. If this policy was to be implemented, what would be the Item Fill Rate?

Solutions

Expert Solution

1. The Replenishment order quantity Q is 119 units.

Explanation:

Replenishment order quantity Q:

Z value for service level 0.95 = 1.64485 or 1.65

The z value is derived from the z value table or online z value calculator.

Safety stock (SS) = 1,101 units

2. The reorder point s is 1,149 units.

Explanation:

The reorder point s:

3. If this policy was to be implemented, then the Item fill rate would be 65%.

Explanation:

Item Fill rate is defined as the measurement of company's stock against customer orders. Fill rate does not consider stock-out or back-orders, because they may bring negative fill rates for items.

Item fill rate = Goods purchased by the the company / units ordered by the customers.

However, in the given question the formula for item fill rate = Reorder point / D

This is because annual demand (D) depicts the unit ordered by customers and the reorder point is the minimum amount of stock that the company should purchase to avoid stock-outs.

Item fill rate = 1149 / 1762

= 0.652 or 65%.

keosha answered 1 year ago
Next > < Previous

Related Solutions

Dave's Desks produces wooden desks. Their desks are designed for elementary and middle schools, and therefore,...
Dave's Desks produces wooden desks. Their desks are designed for elementary and middle schools, and therefore, schools are their largest customers. The cost of manufacturing and marketing their desks, at their normal factory volume of 300 desks per month, is shown in the table below. these desks sell for $99 each. Dave's Desks is making a small profit, but would prefer to increase profitability. Unit Manufacturing costs: Variable Material: $15 Variable Labor: $30 Variable Overhead: $20 Fixed Overhead: $15 Total...
Fine Oak Furniture manufactures high-quality wooden desks and uses a standard cost system. A standard cost...
Fine Oak Furniture manufactures high-quality wooden desks and uses a standard cost system. A standard cost card for one model of desk, the “heritage”, developed for 2019, is shown below: Standard Cost per Unit: Model: Heritage Standard Standard Standard Quantity Price/Rate Cost Direct Materials 75 BF x $ 0.45 per BF = $33.75 Direct Labour 1.25 Hrs x $18.00 per Hr = $22.50 Variable Manufacturing Overhead 1.25 Hrs x $4.00 per Hr = $5.00 Fixed Manufacturing Overhead 1.25 Hrs x...
Fine Oak Furniture manufactures high-quality wooden desks and uses a standard cost system. A standard cost...
Fine Oak Furniture manufactures high-quality wooden desks and uses a standard cost system. A standard cost card for one model of desk, the “heritage”, developed for 2019, is shown below: Standard Cost per Unit: Model: Heritage Standard Standard Standard Quantity Price/Rate Cost Direct Materials 75 BF x $ 0.45 per BF = $33.75 Direct Labour 1.25 Hrs x $18.00 per Hr = $22.50 Variable Manufacturing Overhead 1.25 Hrs x $4.00 per Hr = $5.00 Fixed Manufacturing Overhead 1.25 Hrs x...
ine Oak Furniture manufactures high-quality wooden desks and uses a standard cost system. A standard cost...
ine Oak Furniture manufactures high-quality wooden desks and uses a standard cost system. A standard cost card for one model of desk, the “heritage”, developed for 2019, is shown below: Standard Cost per Unit: Model: Heritage Standard Standard Standard Quantity Price/Rate Cost Direct Materials 75 BF x $ 0.45 per BF = $33.75 Direct Labour 1.25 Hrs x $18.00 per Hr = $22.50 Variable Manufacturing Overhead 1.25 Hrs x $4.00 per Hr = $5.00 Fixed Manufacturing Overhead 1.25 Hrs x...
Problem 4 Frank’s Fine Furniture makes tables, desks, bookcases, and other office furniture. At the North...
Problem 4 Frank’s Fine Furniture makes tables, desks, bookcases, and other office furniture. At the North California facility, they make tables. All parts of the table are purchased except for the tabletop that is fabricated at the plant. Tables are made to order for dealers who FAX orders into the sales department. Orders are processed from the order database on FIFO basis. The first step in the process is to cut the top ¾ pressboard. It takes one worker 20...
The Hickory Company manufactures wooden desks. Management schedules overtime every weekend to reduce the backlog on...
The Hickory Company manufactures wooden desks. Management schedules overtime every weekend to reduce the backlog on the most popular models. The automatic routing machine is used to cut certain types of edges on the desktops. The following orders need to be scheduled for the routing​ machine: order time arrived hours estimated machine hours   due date hours 1 1 9 20 2 0 7 21 3 6 8 12 4 5 3 8 5 3 12 18 The due dates reflect...
Table 8.4 The Furniture Super Mart is a furniture retailer in Evansville, Indiana. The Marketing Manager...
Table 8.4 The Furniture Super Mart is a furniture retailer in Evansville, Indiana. The Marketing Manager wants to prepare a media budget based on the next quarter's business plan. The manager wants to decide the mix of radio advertising and newspaper advertising needed to generate varying levels of Weekly Gross Revenue. The manager has collected data for the past five weeks, and has recorded the following average Weekly Gross Revenues and expenditures for Weekly Radio (X1) and Newspaper (X2) advertising:...
Watson Co. is a specialty fabrics manufacturer and retailer who operates mainly in the Carolinas. A...
Watson Co. is a specialty fabrics manufacturer and retailer who operates mainly in the Carolinas. A partial trial balance showing Watson’s equity, revenue and expense balances as of its December 31, 2019 year-end follows:     Debits              Credits Dividends                                                                     $   321,960 Retained earnings (1/1/19)                                                                     $   859,265 Unrealized holding loss – ECM bonds (1/1/19)                      53,710 Interest revenue                                                                                         17,805 Sales revenue                                                                                        9,147,540 Advertising expense                                                           116,385 Cost of goods sold                                ...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc. manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold...
Scholastic Furniture, Inc., manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company’s Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division’s sales manager. April 10,000 desk-and-chair sets May 12,000 desk-and-chair sets June 15,000 desk-and-chair sets Each desk-and-chair set requires 10 board feet of pine planks and 1.5 hours of...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT