Zee Bhd practices proper inventory control to maintain its inventory at the optimum level.Material A is one of the inventory items purchased by the company. The re-order level ofMaterial A is 1,500 kilograms and the re-order quantity is 1,300 kilograms. The lead time andusage are as follows:Lead time:Usage:Minimum1 weekMinimum600 kilograms per weekMaximum 800 kilograms per weekAverage1.5 weeksMaximum2 weeksRequired to calculate for Material A:a. Minimum stock levelb. Maximum stock level, andc. Average stock level.

solution minimum stock level =reorder level – (average usage * average lead time)…

ee Bhd practices proper inventory control to maintain its inventory at the optimum leve laterial A is one of the inventory items purchased by the company. The re-order level o laterial A is 1,500 kilograms and the re-order quantity is 1,300 kilograms. The lead time an sage are as follows: ead time: Usage: Minimum 1 week Minimum 600 kilograms per week 800 kilograms per week Average 1.5 weeks Maximum Maximum 2 weeks Required to calculate for Material A: 1. Minimum stock level Maximum stock lovol and

ee Bhd practices proper inventory control to maintain its inventory at the optimum leve laterial A is one of the inventory items purchased by the company. The re-order level o laterial A is 1,500 kilograms and the re-order quantity is 1,300 kilograms. The lead time an sage are as follows: ead time: Usage: Minimum 1 week Minimum 600 kilograms per week 800 kilograms per week Average 1.5 weeks Maximum Maximum 2 weeks Required to calculate for Material A: 1. Minimum stock level Maximum stock lovol and

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter10: Inventory

Section: Chapter Questions

Problem 5EB: Bleistine Company had the following transactions for the month. Calculate the ending inventory...

See similar textbooks

Similar questions

DeForest Company 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. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Bleistine Company had the following transactions for the month. Calculate the ending inventory dollar value for each of the following cost allocation methods, using periodic inventory updating. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. Item cost Order cost Annual holding cost (N) Annual demand Average demand $ 11.00 $257.00 33 26,600 532 Standard deviation of weekly denand Lead time Service probability 30 units /order % of item cost units /week 2 week 98% 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 whole number.) Optimal order quantity units units Reorder point b. Determine the annual holding and order costs. (Do not round any intermediate calculations. Round your final answers to 2 decimal places.) Holding cost Ordering cost C. Assume a price break of $60 per order was offered for purchase quantities of 2,000 units per order. If you took advantage of this price break, how much would you save annually? (Do…
A single inventory item is ordered from an outside supplier. The anticipated demand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5, 12. Current inventory of this item is 4, and ending inventory should be 8. Assume a holding cost of $1 per period and a setup cost of $40. Determine the order policy for this item based on b. Least unit cost
• The following time-phasing chart is available for a single item within an MRP system. Complete this chart by estimating inventory on hand and planned order release values. Lead time is 2 weeks, and order policy is 100 units, which means this part can be ordered only in 100-unit batches. Inventory replenishment is JIT lead times ar negligible. Week Number Gross Requirements Scheduled Receipt Inventory on Hand Planned Order Release 1 100 80 05 5 110 9 50 10
Akira Company had the following transactions for the month. Sales for the month are $25 per unit. # of Units Cost per Unit Beginning Inventory 150 $10 Purchased Mar. 31 160 $12 Purchased Oct. 15 130 $15 Ending Inventory 50 ? In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using periodic inventory updating. PLEASE NOTE: All dollar amounts will be rounded to whole dollars using "$" with commas as needed (i.e. $12,345), except for the Weighted Average cost per unit, which will be rounded to two decimal places and include "$". Weighted average cost per unit = ___?_____ per unit Cost Allocation Method Cost of Goods Available Cost of Goods Sold Ending Inventory Sales Gross Margin First-in, First-out (FIFO) Last-in, First-out (LIFO) Weighted Average (AVG)
Week 3. 4. 6. Gross Requirements Scheduled Receipts Projected Ending Inventory: 100 Net Requirements Planned Receipts Planned Orders 400 400 400 400 Lead Time =1 week 100 Minimum Order = 500 Consider the above incomplete Material Requirements Planning (MRP) record. There are 100 units in inventory at the start of week 1, production has a one-week lead time, and the minimum order quantity is 500 units. What are the Week 2 values (in order) for Projected Ending Inventory (PEI), Net Requirements (NR), Planned Receipts (PR), and Planned Orders (PO)? Note: Don't forget to account for the Scheduled Receipts in Week 1. O PEI - 300; NR = 200; PR = 500; PO = 500 O PEI - 100; NR - 200; PR = 500; PO = 500 O PEI - 300; NR - 200; PR = 500; PO = 100 O PEI - 300; NR - 400; PR -500; PO - 500 505
Akira Company had the following transactions for the month. Number of units Cost per Unit Beginning inventory 150 $ 10 Purchased Mar. 31 160 12 Purchased Oct. 15 130 15 Ending inventory 50 ? 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 (AVG)
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
The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows. Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar. 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Total sales $_______________ Total cost of goods sold $_______________ Gross profit $_______________ 3. Determine the ending inventory cost as of March 31.$___________
Akira Company had the following transactions for the month. Number Cost of Units per Unit Beginning Inventory 140 $10 Purchased Mar. 31 160 13 Purchased Oct. 15 140 16 Ending Inventory 70 ? Calculate the ending inventory dollar value for the period for each of the following cost allocation methods, using periodic inventory updating. Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar amount. Ending Inventory A. First-in, First-out (FIFO) $4 B. Last-in, First-out (LIFO) $4 C. Weighted Average (AVG)
ACTIVITY 3- ACCOUNTING FOR MATERIALS 1. Krissy operates its factory 300 days per year. Its annual used of Material Y is 300,000 gallons. It carries a 2,500 gallon safety stock of material and its lead time is 3 business days. What is the order point for Material Y? 2. The EOQ for Material is 7,500 gallons, and the carrying cost per gallon per year is P.25. What is the total annual carrying cost for Material? 3. Peter's order quantity for tocino is 5,000 kilos. Peter maintains a safety stock of Tocino at 500 kilos, and its order point is 1,500 kilos. What is the lead time, assuming daily usage is 50 kilos? 4. Peter's order quantity for tocino is 5,000 kilos. Peter maintains a safety stock of Tocino at 500 kilos, and its order point is 1,500 kilos. What would be the total annual carrying costs, assuming the carrying cost per unit is P.80 5. The following are data of materials inventory for the year 2020 of Mars Corp: Number of pounds required annually Cost of placing an order Annual…