The table below gives the on-hand inventory and weekly this afternoon. Suppose the DC wants to allocate its current inventory plus the incoming order to the stores with the objective equalizing each store's weeks of supply. How much should be allocated to Store 22 Store 1 Store 2 Store 3 Regional DC Incoming Order O 375 O 399 Inventory 120 70 60 400 500 Weekly Sales 30 45 15 The correct answer is not given.

The table below gives the on-hand inventory and weekly this afternoon. Suppose the DC wants to allocate its current inventory plus the incoming order to the stores with the objective equalizing each store's weeks of supply. How much should be allocated to Store 22 Store 1 Store 2 Store 3 Regional DC Incoming Order O 375 O 399 Inventory 120 70 60 400 500 Weekly Sales 30 45 15 The correct answer is not given.

Name: Subject : Accounting The table below gives the on-hand inventory and w
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Subject : Accounting The table below gives the on-hand inventory and weekly demand for an SKU at three retail stores and a regional distribution center (DC). The DC currently has 400 units in stock, plus a replenishment order of 600 units is duethis

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 6E: Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The...

See similar textbooks

Similar questions

Nowlin Pipe & Steel has projected sales of 19,600 pipes this year, an ordering cost of $5 per order, and carrying costs of $1.60 per pipe. a. What is the economic ordering quantity? Economic ordering quantity b. How many orders will be placed during the year? Number of orders orders c. What will the average inventory be? Average inventory units units
A store sells a product that has the annual demand of 16,156 units. It purchases the product from supplier A for $74.4 per unit. The unit inventory carrying cost per year is 14 percent of the unit purchase cost. The cost to place and process an order from the supplier is $107 per order. Supplier A has a delivery lead time of 7 days. The store operates 300 days a year. Assume EOQ model is appropriate. What is the optimal total annual inventory and purchase cost for the store? Use at least 4 decimal places.
The following inventory date have been established for Warriors Company: Order must be placed in multiples of 100 Annual sales are 338,000 units The purchase price per unit is P6 Carrying cost is 20% of the purchase price of the goods Fixed order costs is P48 Three days are required for delivery. What is the EOQ? How many orders should Warriors placed each year? How many units must be order every time? Calculate the total cost of ordering and carrying cost if the order quantity is 4,000 units 4,800 units 6,000 units At EOQ Thank you so much!
Corey's Campus Store has P50,000 of inventory on hand at the beginning of the month. During the month, the company buys P80,000 of merchandise and sells merchandise that had a cost of P30,000. How much is the unsold inventory? Show your solution.
ABC operates 250 days in a year and sells an average of 500 units each day. On better days, sales may reach 800 units. The supplier delivers the inventory within 3 to 6 days after receiving the purchase orders from ABC but the average time is 4 days. Assuming normal operations, what would the expected minimum inventory level be for ABC?
A company wishes to establish an EOQ for an item for which the annual demandis $800,000, the ordering cost is $32, and the cost of carrying inventory is 20%.Calculate the following:a. The EOQ in dollars.b. Number of orders per year.c. Cost of ordering, cost of carrying inventory, and total cost.d. How do the costs of carrying inventory compare with the costs of ordering?
A book publishing company is planning its inventory. The cost to store one book is $4 per month. The cost for a production run is $8 per run and $0.50 per book. The company sells 3,600 books per month. How many should be in a production run to minimize inventory costs?
Use the following information for the next two questions: ABC Co. bills its branch for merchandise at 140% of cost. At the end of its first month, the branch submitted the following data: Merchandise from home office (at billed price) 98,000 Merchandise purchased locally by branch 40,000 Inventory, December 31 of which 7,000 are of local purchase 28,000 Net sales for the month 180,000 How much is the branch’s ending inventory at cost? a. 92,000 b. 20,000 c. 22,000 d. 23,800 How much is the branch’s gross profit in so far as the home office is concerned? a. 70,000 b. 72,000 c. 90,000 d. 92,000
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,500 May 3,860 June 4,590 July 4,195 August 3,960 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,680 pounds. Required: 1. Determine budgeted production for April, May, and June. I figured out May 4,225 and June 4,393. How do you figure out April without knowing March units?
A retailing company believes it can sell 4 million of its main product within the upcoming financial year. The inventory manager plans to order its main product forty times over the next year. The carrying cost is $0.03 per product per year. The order cost is $600 per order. Calculate the following: i) The annual carrying costs ECM Manufacturing Company Limited has three (3) possible suppliers, all of which offer different credit terms. Apart from the slight differences in credit terms, their products and services are virtually identical. The credit terms offered by these suppliers are shown in table shown on the next page. Supplier Credit Terms Supplier 1 1/10 net 30 EOM Supplier 2 2/20 net 75 EOM Supplier 3 3/10 net 50 EOM Assuming a 365-day year, answer the following. d. What impact, if any, will “stretching” the accounts payable (net period only) of supplier 3 by 30 days, have on your answer to part b with regards to supplier 3. Ans…
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,500 May 3,860 June 4,590 July 4,195 August 3,960 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $2.70 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,680 pounds. Determine budgeted cost of materials purchased for April and May. (Use rounded Budgeted Production units in intermediate calculations. Round your answers to 2 decimal places.) 2. Determine budgeted cost of materials purchased for April and May. April May Budgeted Cost of Material Purchased
Octopus Company provides you with the following information regarding its inventory: Maximum lead time 5 weeks Minimum lead time 2 weeks Normal lead time 3 weeks Normal weekly usage 4 000 units Interest rate 5% Cost price per unit R20 per unit Inventory carrying cost R7 per unit Ordering cost R30 per order Maximum weekly usage 4 000 units Minimum weekly usage 3 000 units Required: a).Calculate EOQ b). safety stock c). total ordering cost