Midwest Charm, Inc. specializes in selling scented farm equipment. The company has established a policy of reordering inventory once a month. A recently employed MBA has considered Midwest's inventory problem from the EOQ model viewpoint. If the following constitute the relevant data, how does the following current policy compare with the optimal policy? Ordering cost Carrying cost Purchase price Total sales for year Safety stock = $2,525 per order = 35% of purchase price = $15,000 per unit = 660 units = 15 9. At the EOQ, how often would the company need to reorder? a. Once a week b. Every other week c. Once a month d. Once every 2 months e. Once every 3 months

Midwest Charm, Inc. specializes in selling scented farm equipment. The company has established a policy of reordering inventory once a month. A recently employed MBA has considered Midwest's inventory problem from the EOQ model viewpoint. If the following constitute the relevant data, how does the following current policy compare with the optimal policy? Ordering cost Carrying cost Purchase price Total sales for year Safety stock = $2,525 per order = 35% of purchase price = $15,000 per unit = 660 units = 15 9. At the EOQ, how often would the company need to reorder? a. Once a week b. Every other week c. Once a month d. Once every 2 months e. Once every 3 months

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter18: The Management Of Accounts Receivable And Inventories

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and 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 purchase 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? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
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.)
When prices are falling (deflation), which costing method would produce the highest gross margin for the following? Choose first-in, first-out (FIFO); last-in, first-out (LIFO); or weighted average, assuming that B62 Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming B62 sold just one unit of these goods for $400. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)
Based on your research of the market in the previous exercises, you have determined the market price for the items your department purchase is 15% below what you are being charged by department A of Marleys Manufacturing. How would you view this as a manager? What steps could you take to solve this discrepancy? What alternatives would you consider, assuming you had control over purchasing decisions?
Use the following hypothetical data for Walgreens in Years 11 and 12 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Walgreenss Year +1 revenue growth rate, gross profit margin, and inventory turnover will be identical to Year 12. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance.
Bradshaw Company reported sales of 5,000,000 in 20X1. At the end of the fiscal year (June 30, 20X1), the following quality costs were reported: Required: 1. Prepare a quality cost report. 2. Prepare a graph (pie chart or bar graph) that shows the relative distribution of quality costs, and comment on the distribution. 3. Assuming sales of 5,000,000, by how much would profits increase if quality improves so that quality costs are only 3% of sales?
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.
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.
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 60,500 units per year, an ordering cost of $12 per order, and carrying costs of $1.20 per unit.a. What is the economic ordering quantity?___________Units b. How many orders will be placed during the year? __________Orders c. What will the average inventory be? ____________Units d. What is the total cost of ordering and carrying inventory? $____________
The S&OP team at Kansas Furniture, has received thefollowing estimates of demand requirements:July Aug. Sept. Oct. Nov. Dec.1,000 1,200 1,400 1,800 1,800 1,800 Stephanie Klein-Davis/The Roanoke Times/ AP Imagesa) Assuming one-time stockout costs for lost sales of $100 perunit, inventory carrying costs of $25 per unit per month, andzero beginning and ending inventory, evaluate these two planson an incremental cost basis: ◆ Plan A: Produce at a steady rate (equal to minimum require-ments) of 1,000 units per month and subcontract additional units at a $60 per unit premium cost.◆ Plan B: Vary the workforce, to produce the prior month’sdemand. The fi rm produced 1,300 units in June. The cost ofhiring additional workers is $3,000 per 100 units produced.The cost of layoff s is $6,000 per 100 units cut back.