For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required a) What is the economic order quantity for Andrews Company?

For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required a) What is the economic order quantity for Andrews Company?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 5CE: Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and...

See similar textbooks

Similar questions

The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Multiple regression was run on the above data; the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 total purchase orders and 45 nonstandard orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders and 580 nonstandard orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 2? (Round your answers to the nearest dollar.)
Refer to the information for Farnsworth Company (p. 139) for the first 10 months of data on receiving orders and receiving cost. Now suppose that Tracy has gathered 2 more months of data: Note: For the following requirements, round the intercept terms to the nearest dollar, round the variable rates to the nearest cent, and R2 to two decimal places. Required: 1. Run two regressions using a computer spreadsheet program such as Excel. First, use the method of least squares on the first 10 months of data. Then, use the method of least squares on all 12 months of data. Write down the results for the intercept, slope, and R2 for each regression. Compare the results. 2. CONCEPTUAL CONNECTION Prepare a scattergraph using all 12 months of data. Do any points appear to be outliers? Suppose Tracy has learned that the factory suffered severe storm damage during Month 11 that required extensive repairs to the receiving areaincluding major repairs on a forklift. These expenses, included in Month 11 receiving costs, are not expected to recur. What step might Tracy, using her judgment, take to amend the results from the method of least squares? 3. CONCEPTUAL CONNECTION Rerun the method of least squares, using all the data except for Month 11. (You should now have 11 months of data.) Prepare a cost formula for receiving based on these results, and calculate the predicted receiving cost for a month with 1,450 receiving orders. Discuss the results from this regression versus those from the regression for 12 months of data.
For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required a) What is the economic order quantity for Andrews Company? b) How many deliveries will be made during each year at the recommended economic order quantity?
A new purchasing agent has been hired by company XYZ who wants to start using EOQ method And its supporting decision elements. The following information has been gathered Annual demand in units 260,000 units Working days per year Lead time in days 260 12 Ordering cost per purchase order Annual unit carrying cost 160 30 Required: (5pts each) a) Find the EOQ b) Number of orders to be made per year c) Average daily demand d) Total ordering cost e) Total carrying cost What is the total relevant cost with the EOQ g) Select a ordering amount ABOVE the EOQ, what is the total relevant ordering and total relevant carrving cost and grand total of both h) IF the company has been ordering in quantity of 1000 units, what is the S savings by now using the EOQ
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).
G http... apter Review i Pro... Tra... 0 P a. Number of units b. Sales price c. Advertising cost Man...... M Questio... per unit $90,000 Expected sales commission Expected annual fixed administrative costs $45,000 The manager has decided that any new product must at least break even in the first year. Stuart Company is considering adding a new product. The cost accountant has provided the following data: Expected variable cost of manufacturing $44 per unit Expected annual fixed manufacturing costs The administrative vice president has provided the following estimates: Required Use the equation method and consider each requirement separately. b Que... $8 per unit Bes... ezto.mheducation.com Saved wire
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?
Barbara Flynn's company has compiled the data below on a small set of products. Based on the percentages of dollar volume, perform an ABC analysis on her data by completing the table below. Assume that class A items represent about 70% of the total dollar usage, class B-about 25%, class C-less than 5% (round your responses to the nearest whole number). Item A В C D E Annual Demand 200 50 160 150 300 Unit Cost $200 $150 $160 $150 $300 Annual Dollar Volume Classification $40,000 $7,500
multiple choice Luster Corporation presents the following data: Usage is 400 units per month, cost per order is P20, and carrying cost per unit is P6. Given these data, answer the following questions: (A) What is the economic order quantity? (B) How many orders are required each month? A. (A) 32 and (B) 6B. (A) 32 and (B) 8C. (A) 52 and (B) 6D. (A) 52 and (B) 8E. (A) 62 and (B) 10
Company D is planning to perform an ABC analysis for its products. An information table is given below. Item Annual Demand Unit Cost 180 $100 130 $140 C 600 $220 D. 60 $70 50 $80 Assuming that class A items represent about 75% of the total dollar usage, class B about 20%, class C less than 5%, what is the annual dollar volume of Item D? a. 132000 b. 4200 C. 18200 d. 4000 e. 18000
/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress-false McCallen Company expects to produce and sell 500 units in the next month. The data on costs are as follows: Per-unit costs: Selling price $8.00 Variable manufacturing costs 2.75 Variable selling costs 0.25 Total costs: Fixed manufacturing costs $1,000 Fixed selling costs 125 Required: A. What is the variable cost per unit? B. What is the contribution margin per unit? C. What is the variable cost ratio? Round your answer to one decimal place. % D. What is the contribution margin ratio? Round your answer to one decimal place.
A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows Machine Cost $50,00e $40,000 $70,000 A. Product forecasts and processing times on the machines are as follows: PROCCESSING TIME PER UNIT (minutes) Annua) Product Demand 12,000 21,000 11,000 25,000 A. 2. 1. 2. 2 2. 2. a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, end the resulting total purchasing cost for each machine type. The machines will operate 10 hours a day, 230 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quentities. Enter the resulting total purchasing cost as a whole number.) Total processing time in minutes per machine B. C. Number of each machine needed and total purchasing cost A.…