Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.Item costOrder costAnnual holding cost (N)Annual demandAverage demand$ 11.00$257.003326,600532Standard deviation of weekly denandLead timeService probability30 units/order% of item costunits/week2 week98%a. Determine the order quantity and reorder point. (Use Excel's NORMSINV( ) function to find your z-value and then round that z-value to 2 decimal places. Do not round any other intermediate calculations. Round your final answers to the nearest wholenumber.)Optimal order quantityunitsunitsReorder pointb. Determine the annual holding and order costs. (Do not round any intermediate calculations. Round your final answers to 2decimal places.)Holding costOrdering costC. Assume a price break of $60 per order was offered for purchase quantities of 2,000 units per order. If you took advantage of thisprice break, how much would you save annually? (Do not round any intermediate calculations (including number of setups peryear). Round your final answer to 2 decimal places.)Annual savings

Economic Order Quantity (EOQ) - It is a technique used to identify the optimal amount of inventory…

Answered: Given the following information,…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Beginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units @ $10 11 Purchase 26 units @ $12 14 Sale 36 units 21 Purchase 18 units @ $15 25 Sale 20 units Assuming the business maintains a periodic inventory system; calculate the cost of merchandise sold and ending inventory under the following assumptions: FIFO LIFO Average cost In your computations, round the average cost per unit to two decimal places and round your final answers to the nearest dollar.
UMET's Stores had the following inventory transactions in 2020: Transaction Units Cost per unit 1/1 Balance 50 $6 2/14 Sale 25 5/23 Purchase 100 8 8/21 Sale 50 11/5 Purchase 25 12 11/18 Sale 95 Required: Compute tge cost of goods sold and the ending inventory using the periodic inventory system for each of the following cost flow assumptions: a. FIFO b. LIFO c. Weighted average
Solve for the missing information designated by "?" in the following table. (Use 365 days in a year. Round the inventory turnover ratio to one decimal place before computing days to sell. Round days to sell to one decimal place.) Case Beginning Inventory Purchases Cost of Goods Sold Ending Inventory Inventory Turnover Ratio Days to Sell a. $ 130 $ 730 $ 690 b $ 230 $ 1,320 C $ 1,120 $ 135 6.6 32.6
Balamb Corporation had the following transactions for the month: Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. first-in, first-out (FIFO) last-in, first-out (LIFO) weighted average
Question: Langley Inc. inventory records for a particular development program show the following at October 31, 2020: At October 31, ten of these programs are on hand. Langley uses the perpetual inventory system. 1. Journalize for Langley: a. Total October purchases in one summary entry. All purchases were on credit. b. Total October sales and cost of goods sold in two summary entries. The selling price was $500 per unit, and all sales were on credit. Langley uses the FIFO inventory method. (Please show the calculations/where the number is from) Ex: I didn't understand the part of the answer for the entry Cost of Goods Sold & Inventory 1,710. 2. Under FIFO, how much gross profit would Langley earn on these transactions? What is the FIFO cost of Langley’s ending inventory?
You are provided with the following data: inventory - to -sale conversion period = 100days Sale - to - cash conversionperiod = 46 days Purchase - to -payment conversion period30 days What is the operatingcycle?
Opening and closing inventory balances and purchases for the month of October 2020 for Haadiyah Hearing Ltd are as follows: Units Per unit Inventory, 1 October 7,000 $4.00 Purchase, 3 October 8,000 $4.10 Purchase, 15 October 11,000 $4.20 Purchase, 20 October 15,000 $4.25 Inventory, 31 October 20,000 - Required: Determine the cost of goods sold for October under each of the following cost flow assumptions: FIFO Weighted average LIFO
Beginning Inventory at FIFO: 15 Units @ $16 = $240 Beginning Inventory at LIFO: 15 Units @ $12 = $1801. Compute the inventory turnover ratio for the month of January under the FIFO and LIFO inventory costing methods. 2. Which costing method is the more accurate indicator of the efficiency of inventory management?
You have the following information for Bramble Inc. for the month ended June 30, 2022. Bramble uses a periodic inventory system. Date Description Quantity Unit Cost orSelling Price June 1 Beginning inventory 40 $31 June 4 Purchase 135 34 June 10 Sale 110 61 June 11 Sale return 15 61 June 18 Purchase 55 37 June 18 Purchase return 10 37 June 25 Sale 65 67 June 28 Purchase 35 41
The inventory records of TC show the following purchases:Month Units CostJanuary 15,000 190,500February 20,000 240,000March 12,500 165,00A physical count on March 31 shows 22,500 units on hand. What amount of inventory should be reported as of March 31, using FIFO method of costing?a. 120,000 b. 225,000 c. 280,500 d. 285,000
Calculate Inventory Carrying Cost (ICC) using the information below. annual demand ordering cost per order inventory carrying cost percentage leadtime unit value #days in the period. EOQ 1000 $75 20% 3 days $30 360 158
Arrow Distributing Corp. likes to track inventory by using weeks of supply as well as by inventory turnover. Arrow Distributing Corp. Net Revenue Cost of sales Inventory Total assets a) What is its weeks of supply? weeks (round your response to two decimal places). b) What is Arrow's inventory turnover? times per year (round your response to two decimal places). $16,830 $14,240 $920 $9,270 c) Suppose a manufacturer has an inventory turnover of 13.5 times per year. Arrow's supply chain performance relative to the manufacturer's, as measured by inventory turnover, is

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS