Given the following informations annual sales in units 30,000 cost of placing an order $60,00 per unit carrying costs $ 1.50 Existing units of safety stock 300 a what is the EOQ? b. what is the average inventory based on the EOQ and the existing safety stock c. what is the maximum level of inventory? d. how many orders are placed each year?

Given the following informations annual sales in units 30,000 cost of placing an order $60,00 per unit carrying costs $ 1.50 Existing units of safety stock 300 a what is the EOQ? b. what is the average inventory based on the EOQ and the existing safety stock c. what is the maximum level of inventory? d. how many orders are placed each year?

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter10: Inventory

Section: Chapter Questions

Problem 1PA: When prices are rising (inflation), which costing method would produce the highest value for gross...

See similar textbooks

Similar questions

Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
When prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Given the following information: Annual sales in units 40,000 Cost of placing an order $58.00 Per-unit carrying costs $2.30 Existing units of safety stock 600 What is the EOQ? Round your answer to the nearest whole number. units What is the average inventory based on the EOQ and the existing safety stock? Use the rounded value of the EOQ from the previous question in your calculations. Round your answer to the nearest whole number. units What is the maximum level of inventory? Use the rounded value of the EOQ from the previous questions in your calculations. Round your answer to the nearest whole number. units How many orders are placed each year? Use the rounded value of the EOQ from the previous questions in your calculations. Round your answer to the nearest whole number. orders per year
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?
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…
8. XYZ has developed the following data from its Material A Safety stock Average (normally) daily use Maximum daily use Minimum daily use EOQ Cost of placing an order Working days per year Lead time 280 200 240 180 1,000 P20 250 days 6 days What is the normal maximum inventory?
3. The Inventory Company' data are as follows: Average re-order period Optimum number of orders per year Average daily usage Cost to store one unit per year Cost of stock out per unit per time` Usage during re-order period 80 90 100 115 125 150 175 Frequency 4 6 10 35 20 15 10 25 days 10 per year 4 units $5 P20 0
10. XYZ has developed the following data from its Material A Safety stock Average (normally) daily use 280 240 180 1.000 200 Maximum daily use Minimum daily use EOQ Cost of placing an order Working days per year P20 250 days Lead time 6 days What is the average inventory?
The order cost per order of an inventory is OMR. 60 with an annual carrying cost of OMR. 4 per unit. The annual demand is 12000 units. Calculate: Economic Ordering Quantity, Number of Orders per year and Ordering cost per year. a. 500 units, 20 Orders and 1200 OMR b. 480 units, 20 Orders and 1500 OMR c. 400 units, 20 Orders and 1800 OMR d. 600 units, 20 Orders and 1200 OMR
b) Wansam Ltd extracted the following from its records: Monthly demands of Ba Carrying cost per unit Cost of placing an order Minimum usage Maximum usage Re-order period You are required to calculate: Reorder Quantity 2,000units GHC 500 GHC 4,000 50 units per week 150 units per week 5-7 weeks i. ii. Reorder level iii. Minimum Stock level iv. Maximum Stock level V. Average Stock level
= $ 15, Assume that D = 5,000, k = $ 186, c = and five setups (orders) are required per year. What is the percentage per unit per year of the implicit cost of holding inventory? (result in percentage)
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