The XYZ company has traditionally ordered ink refills 80 units at a time. This company estimates that carrying cost is $ 5 /unit/year; and that annual demand is about 400 units per year. Question: for what valuo of the ordering cost (i,o., cost/order) would the curront order quantity be optimal? Show all the details of your calculations to get full marks.

The XYZ company has traditionally ordered ink refills 80 units at a time. This company estimates that carrying cost is $ 5 /unit/year; and that annual demand is about 400 units per year. Question: for what valuo of the ordering cost (i,o., cost/order) would the curront order quantity be optimal? Show all the details of your calculations to get full marks.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 9EB: The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method,...

See similar textbooks

Similar questions

The annual demand for a particular chemical product is 1,200 units. Suppose that the annualholding cost is $24 per unit, and the ordering cost is $100.Part A: Find the optimal order quantity based on EOQ analysis, and calculate the combinedannual ordering and holding cost.Part B: Now suppose that the store manager finds out that the demand has been underestimated.Specifically, the correct annual demand is 1,500 units. On the other hand, due to operationalrestrictions she cannot change the order quantity and thus use the same order size from part A.How much this error cost the store? (This can also be considered as a penalty for parametermisestimation).
Draw and explain EOQ chart with the following data: Requirements per year = 1600 units, Ordering cost = Rs. 100/- per order, Carrying cost = Rs. 5/- per unit, Purchase cost = Rs. 80/- per cost. Assume the missing data.
2. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order. 3. Find out the ordering cost from the following information, Annual demand is 240 units, holding cost RO 4 per unit for a year and EOQ is 60 units. 4. If the price of the material is RO 15 per unit and the annual consumption is 4000 units, the interest and store keeping charges are 20% of the value and the cost of placing of an order and receiving the goods is RO 60, how much material should be ordered at one time? 5. Alexander pump LLC uses about 75000 valves per year and the usage is fairly constant at 6250 units per month. The valve cost of RO 1.50 per unit when bought in large quantities, and the carrying cost is estimated to be 20% of average inventory investment on an annual basis. The cost to place an order and process the delivery is RO18. It takes 45 days to receive…
Compute the EOQ given the following information.The annual consumption is 6000 units, ordering cost is RO 60 per order and carrying cost is 20% of the price.The supplier quotes the following prices for the component.No of units bought at timePrice per unitLess then 1000OMR 101000 to 2999OMR 9.53000 and aboveOMR 9What is the optimal order quantity?
In the process of finding the optimum order quantity the following costs are obtained per order or per unit annually. Inspection Cost = SR 4 Cost of Interest = SR 4 Insurance Cost = SR 2 Administration Cost = SR 4 Obsolescence = SR 3 Depreciation Cost = SR 2 Breakage Cost = SR 2 Given that the annual Demand is 500,000. Number of order?
The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
Compute the EOQ given the following information. The annual consumption is 6000 units, ordering cost is RO 60 per order and carrying cost is 20% of the price. The supplier quotes the following prices for the component. No of units bought at time Price per unit Less then 1000 OMR 10 1000 to 2999 OMR 9.5 3000 and above OMR 9 What is the optimal order quantity?
Suppose the relevant carrying cost per unit per year was $20 and the relevant ordering cost per purchase order was $200. Suppose further that Alpha calculates EOQ after incorrectly estimating relevant carrying cost per unit per year to be $10 and relevant ordering cost per purchase order to be $400. Calculate the actual annual relevant total costs of Alpha’s EOQ decision. Compare this cost to the annual relevant total costs that Alpha would have incurred if it had correctly estimated the relevant carrying cost per unit per year of $20 and the relevant ordering cost per purchase order of $200 Calculate and comment on the cost of the prediction error.
Tony uses EOQ logic to determine the order quantity for its various components and is planning its orders. The Annual consumption is 80,000 units, Cost to place one order is P1,200, Cost per unit is P 50 and carrying cost is 6% of Unit cost. Find EOQ, No. of order per year, Ordering Cost and Carrying Cost and Total Cost . Prepare a table of validation.
K Suppose that a company offers quantity discounts. If up to 1,000 units are purchased, the unit price is $12; if more than 1,000 and up to 5,000 units are purchased, the unit price is $8.00; and if more than 5,000 units are purchased, the unit price is $7.50. Develop an Excel template using the VLOOKUP function to find the unit price associated with any order quantity and compute the total cost of the order. Complete the formulas in the spreadsheet below. Select the correct VLOOKUP function in cell C8 to find the unit price for the order quantity. (Type integers or decimals rounded to two decimal places as needed.) 1 2 3 5 6 7 8 6 A B C Purchase Quantity 1 to 1000 1001 to 5000 5001 or more Quantity Ordered Unit Price Total Cost 2400 D Unit Price $ $ $
My Kitchen Delights (MKD) is considering two newsuppliers for the jars used in the production process. Th e qualityat both suppliers is equal. Assume that the annual holding costis 30 percent of the unit price. Monthly demand averages 20,000jars. Ordering cost with these two suppliers is $30 per order. Th eprice lists for the suppliers are as follows: (a) Determine the optimal order quantity when usingSupplier A.(b) Determine the optimal order quantity when usingSupplier B.(c) Given MKD’s lack of space, which supplier do yourecommend be used? Justify your answer.
Please explain each anwer with formula. Regarding the following information, how many machines would be needed to handle the required volume? Processing time per unit (minute) product demand A B C 1 16000 3 4 2 2 12000 4 4 3 3 6000 5 6 4 4 30000 2 2 1 In order to meet annual demand for all products, how many machines in each type are needed? Based on fixed annual cost (Alternative A with $40,000, B with $30,000 and C with $80,000), which type of machine and how many will cost least to satisfy the demand? Consider the operation of machines 10 hours per day and 200 days a year.