Quick-Copy Duplicating Company uses 110,000 reams of standard-size paper a year at its various duplicating centers. Its current paper supplier charges $2.00 per ream. Annual inventory carrying costs are 15 percent of inventory value. The costs of placing and receiving an order of paper are $41.25. Assuming that inventory replenishment occurs virtually instantaneously, determine the following: a. The firm's EOQ b. The total annual inventory costs of this policy c. The optimal ordering frequency d. Compute and plot ordering costs, carrying costs, and total inventory costs for order quantities of 2,000, 4,000, 5,000, 5,500, 6,000, 7,000, and 9,000 reams. Connect the points on each function with a smooth curve, and determine the EOQ from the graph (and the table used in constructing the graph).

Quick-Copy Duplicating Company uses 110,000 reams of standard-size paper a year at its various duplicating centers. Its current paper supplier charges $2.00 per ream. Annual inventory carrying costs are 15 percent of inventory value. The costs of placing and receiving an order of paper are $41.25. Assuming that inventory replenishment occurs virtually instantaneously, determine the following: a. The firm's EOQ b. The total annual inventory costs of this policy c. The optimal ordering frequency d. Compute and plot ordering costs, carrying costs, and total inventory costs for order quantities of 2,000, 4,000, 5,000, 5,500, 6,000, 7,000, and 9,000 reams. Connect the points on each function with a smooth curve, and determine the EOQ from the graph (and the table used in constructing the graph).

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter18: The Management Of Accounts Receivable And Inventories

Section: Chapter Questions

Problem 17P

See similar textbooks

Similar questions

Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the annual ordering cost. 2. Compute the annual carrying cost. 3. Compute the cost of Ottiss current inventory policy. Is this the minimum cost? Why or why not?
Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the economic order quantity. 2. Compute the ordering, carrying, and total costs for the EOQ. 3. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?
Sterling Corporation has an EOQ of 5,000 units. The company uses an average of 500 units per day. An order to replenish the part requires a lead time of five days. Required: 1. Calculate the reorder point, using Equation 20.3. 2. Graphically display the reorder point, where the vertical axis is inventory (units) and the horizontal axis is time (days). Show two replenishments, beginning at time zero with the economic order quantity in inventory. 3. What if the average usage per day of the part is 500 units but a daily maximum usage of 575 units is possible? What is the reorder point when this demand uncertainty exists?
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.
Chassen Company, a cracker and cookie manufacturer, has the following unit costs for the month of June: A total of 100,000 units were manufactured during June, of which 10,000 remain in ending inventory. Chassen uses the first-in, first-out (FIFO) inventory method, and the 10,000 units are the only finished goods inventory at June 30. Under the absorption costing concept, the value of Chassens June 30 finished goods inventory would be: a. 50,000. b. 70,000. c. 85,000. d. 145,000.
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.
Pietro expects to produce 50,000 units and sell 49,300 units. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Required: 1. Prepare a statement of cost of goods sold in good form. 2. What if the beginning inventory of finished goods decreased by 5,000? What would be the effect on the cost of goods sold?
Denali Company manufactures household products such as windows, light fixtures, ladders, and work tables. During the year it produced 10,000 Model 10X windows but only sold 5,000 units at $40 each. The remaining units cannot be sold through normal channels. Cost for inventory purposes on December 31 included the following data on the unsold units: Denali can sell the 5,000 windows at a liquidation price of $20.00 per window, but it will incur a packaging and shipping charge of $7.50 per window. Required: Identify the relevant costs and revenues for the liquidation sale alternative. Is Denali better off accepting the liquidation price rather than doing nothing? Assume that Model 10X can be reprocessed to another size window, Model 20X, which will require the same amount of labor and overhead as was required to initially produce, but sells for only $33. Determine the most profitable course of action—liquidate or reprocess.
Crescent Company produces stuffed toy animals; one of these is Arabeau the Cow. Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and eight ounces of polyfiberfill. Fabric costs 3.50 per yard and polyfiberfill is 0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: Inventory policy requires that sufficient fabric be in ending monthly inventory to satisfy 20 percent of the following months production needs and sufficient polyfiberfill be in inventory to satisfy 40 percent of the following months production needs. Inventory of fabric and polyfiberfill at the beginning of October equals exactly the amount needed to satisfy the inventory policy. Each Arabeau produced requires (on average) 0.10 direct labor hour. The average cost of direct labor is 15 per hour. Required: 1. Prepare a direct materials purchases budget of fabric for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 2. Prepare a direct materials purchases budget of polyfiberfill for the last quarter of the year showing purchases in units and in dollars for each month and for the quarter in total. 3. Prepare a direct labor budget for the last quarter of the year showing the hours needed and the direct labor cost for each month and for the quarter in total.
For each of the following independent situations, calculate the missing values: 1. The Belen plant purchased 78,300 of direct materials during June. Beginning direct materials inventory was 2,500, and direct materials used in production were 73,500. What is ending direct materials inventory? 2. Forster Company produced 14,000 units at an average cost of 5.90 each. The beginning inventory of finished goods was 3,422. (The average unit cost was 5.90.) Forster sold 14,120 units. How many units remain in ending finished goods inventory? 3. Beginning work in process (WIP) was 116,000, and ending WIP was 117,300. If total manufacturing costs were 349,000, what was the cost of goods manufactured? 4. If the conversion cost is 84 per unit, the prime cost is 55, and the manufacturing cost per unit is 105, what is the direct materials cost per unit? 5. Total manufacturing costs for August were 412,000. Prime cost was 64,000, and beginning WIP was 76,000. The cost of goods manufactured was 434,000. Calculate the cost of overhead for August and the cost of ending WIP.
Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of 52 per case (a case contains 24 cans of nuts). Kaune sold 150,000 cases last year to the following three classes of customer: The supermarkets require special labeling on each can costing 0.04 per can. They order through electronic data interchange (EDI), which costs Kaune about 61,000 annually in operating expenses and depreciation. Kaune delivers the nuts to the stores and stocks them on the shelves. This distribution costs 45,000 per year. The small grocers order in smaller lots that require special picking and packing in the factory; the special handling adds 25 to the cost of each case sold. Sales commissions to the independent jobbers who sell Kaune products to the grocers average 8 percent of sales. Bad debts expense amounts to 9 percent of sales. Convenience stores also require special handling that costs 30 per case. In addition, Kaune is required to co-pay advertising costs with the convenience stores at a cost of 15,000 per year. Frequent stops are made to each convenience store by Kaune delivery trucks at a cost of 30,000 per year. Required: 1. Calculate the total cost per case for each of the three customer classes. (Round unit costs to four significant digits.) 2. Using the costs from Requirement 1, calculate the profit per case per customer class. Does the cost analysis support the charging of different prices? Why or why not? 3. What if Kaune charged the average price per case to all customer classes? How would that affect the profit percentages?
Langstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?