a)
Annual demand (D) = 14110 units
Ordering cost (S) = $150
Holding cost (H) = 20% of cost = 20% of $10 = $2
Lead time (L) = 4 weeks
Safety stock = 55 units
Average weekly demand(d) = D/52 weeks = 14110/52 = 271.35 units
Order Quantity Q
Q = 1454.82 or 1455 UNITS
Reorder point R = dL + Safety stock = (271.35*4) + 55 = 1140.4
b) For Widget we use fixed time periodic inventory model
Annual demand (D) = 5000 units
Ordering cost (S) = $25
Holding cost (H) = 20% of cost = 20% of $2 = $0.4
Lead time (L) = 1 weeks
Safety stock = 5 units
Average weekly demand(d) = D/52 weeks = 5000/52 = 96.15 units
Review period T = 3 weeks
Order Quantity Q = d(L+T) + Safety stock - on hand inventory = 96.15*(1+3)+5 -0 = 389.6 units or 390 units
Explanation: | |||
Item | Tegdiw | Widget | |
Annual Demand | D | 10000 | 5000 |
Avg. daily demand | d | 27.47 | 13.74 |
Order cost ($) | S | 150 | 25 |
Holding cost (% of item cost) | H | 20 | 20 |
Lead time (weeks:days) | L | 28 | 7 |
Cost per unit($) | C | 10 | 2 |
Safety Stock (units) | SS | 55 | 5 |
Tegdiw | |||
a) EOQ= sqrt(2DS/H)= | 1225 | Units | |
H=10*20%=2 | |||
R=(D/364 days)L)+SS= | 824 | Units | |
Widget | |||
b) For widgets we use the fixed time periodic inventory model | |||
D= | 5000 | Units | |
S= | 25 | $ | |
H= | 0.4 | $ | |
L= | 1 | week | |
SS= | 5 | Units | |
Avg weekly demand | d= | 96.15 | Units |
T= | 3 | weeks | |
Order Quantity Q= d(L+T)+SS-on hand inventory= | 390 | Units |
2) Jill Job Shop (3 points) JAll's Job shop buys two parts (Tegdiws and Widgets) for...
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every five weeks. Data for both products are as follows: ITEM TEGDIW WIDGET Annual demand 14,000 9,000 Holding cost (% of item cost)...
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every two weeks. Data for both products are as follows: ITEM TEGDIW WIDGET Annual demand 9,000 9,000 Holding cost (% of item cost)...
* Week5 2521/activity Saved Help Save & Exit Su Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every two weeks. Data for both products are as follows: ITEM Annual defand Holding,...
Again Agame Inventory System The Again Agame Company produces a game with plastic injection molded parts (along with many other game parts). They receive the demand orders for their shop for the following week and then set up the plastic molding machine to make the parts. The average demand is 20 units per week, Each time they set up the machine (i.e., order parts), they incur a cost of $9, If they do not have enough parts on hand to...
(8 points) A coffee shop sells bags of roasted coffee beans to customers to make into coffee at home. The demand for these bags is quite predictable (and can be treated as deterministic for our purposes). The shop sells 3,500 bags of coffee beans per year. Each time the shop places an order for these bags with its coffee supplier, it incurs an administrative cost of $15, independent of the quantity ordered. The company values each bag at $12.50 (this...
Sam's Cat Hotel operates 52 weeks per year and uses a continuous review inventory system. It purchases kitty litter for $10.75 per bag. The following information is available about these bags. Demand = 85 bags/week Order cost = $57/order Annual holding cost = 26% of cost per bag Desired cycle-service level = 90% Lead-time = 2 weeks Standard deviation of weekly demand = 18 bags What is the economic order quantity (EOQ) for kitty litter? What would be the average...
For questions 1-4, please use the following scenario: Rocky Mountain Power (RMP) maintains an inventory of spare parts that is valued at nearly $8 million. This inventory is composed of thousands of different stock-keeping units (SKUs) used for power generation and utility line maintenance, and the inventory balances are updated on a computerized information system. Glass insulators (i.e., SKU 1341) have a relatively stable usage rate, averaging 20 items per week. RMP purchases these insulators from the manufacturer at a...
Please answer question 2 and 3. Q2 (33 points) A manufacturer produces and sells bottled drinks. Their production capacity is 570 units daily, but their sales at the moment are estimated at 400 units per day. The manufacturer produces Mondays through Fridays. The variable cost for production is $1.5. The manufacturer incurs about $250 labor cost per production order for setups. Accounting estimates annual holding costs as $0.30 per unit. a) Determine the optimal production quantity for the bottled drinks....
M2-3 (Static) Matching Terms in Job Order Costing (LO2-1, 2-2, 2-3, 2-4, 2-5) Match each term on the left with the best definition on the right. Note: Not all definitions will be used a. A detailed record of costs incurred to complete a specific job b. A source document that shows how a worker spent time each week. c. An accounting system used by companies to make standardized or homogeneous products or services d. An accounting system used by companies...
please answer 14.17 - Data Table for Problems 14.17 through 14.19* Period 1 2 3 4 5 6 7 8 9 10 11 12 requirements 30 40 30 70 20 10 80 50 8 "Holding cost $2.50/unit/week; setup cost $150; lead time 1 week; beginning n Gross inventory 40 m14.17 Develop a lot-for-lot solution and calculate total rel- s evant costs for the data in the table for Problems 14.17 through d 14.19. Px 14.18 Develop an EOQ solution and...