Lens Junction sells lenses for $43 each and is estimating sales of 15,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $14 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods 4,300 4,900 4,900 Direct materials: silicon 8,400 9.100 9,300 Direct materials: solution 11,000 11,800 12,900

Lens Junction sells lenses for $43 each and is estimating sales of 15,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $14 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods 4,300 4,900 4,900 Direct materials: silicon 8,400 9.100 9,300 Direct materials: solution 11,000 11,800 12,900

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 15PROB

See similar textbooks

Similar questions

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?
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?
Logo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement shows cost of goods sold of $2,000. What was the beginning inventory if the ending inventory was $1,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.
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?
A company began January with 6,000 units of its principal product. The cost of each unit is $8. Inventory transactions fo the month of January are as follows: Date of Purchase January 10 January 18 Totals Total Date of Sale January 5 January 12 January 20 Total Sales Units * Includes purchase price and cost of freight. Average Cost Beginning Inventory Purchases: 5,000 6,000 11,000 Problem 8-5 (Static) Part 4 January 10 January 18 Units 3,000 2,000 4,000 9,000 8,000 units were on hand at the end of the month. 4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system. Unit Cost* Purchases Number Unit of units Cost $9 10 Cost of Goods Available for Sale Cost of Goods Available for Sale 48,000 6,000 $8.00 $ 5,000 $9.00 6,000 $10.00 17,000 $ Total Cost $ 45,000 60,000 $ 105,000 45,000 60,000 153,000 Cost of Goods Sold - Average Cost Average Cost per Unit Number of units sold Cost of Goods Sold 0 Ending Inventory - Average Cost Number of…
DeForest Company had the following transactions for the month. Sales for the month are $85 per unit. Number of Units Cost per Unit Total Beginning inventory Purchased Apr. 30 Purchased Aug. 15 500 $40 $20,000 27,000 26,000 24,500 97,500 600 45 650 40 Purchased Dec. 10 700 35 Totals (goods available) Ending inventory 2,450 550 In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using periodic inventory updating. PLEASE NOTE: All dollar amounts will be rounded to whole dollars using "$" with commas as needed (i.e. $12,345), except for the Weighted Average cost per unit, which will be rounded to two decimal places and include "$" (i.e. $12,345.67).
A company began January with 6,000 units of its principal product. The cost of each unit is $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Units 5,000 6,000 11,000 * Includes purchase price and cost of freight. Date of Sale January 5 January 12 January 20 Total Total Sales Problem 8-5 (Static) Part 3 Perpetual FIFO: Beginning Inventory Purchases: Units 3,000 2,000 4,000 9,000 January 10 January 18 8,000 units were on hand at the end of the month. 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system. Number of units Purchases Unit Cost* Cost of Goods Available for Sale Cost of Goods Available for Sale Unit Cost 6,000 $8.00 5,000 6,000 17,000 $9 10 9.00 10.00 Total Cost $ 45,000 60,000 $ 105,000 $ 48,000 45,000 60,000 $ 153,000 Cost of Goods Sold - January 5 Number of units sold 0 Cost per unit $ Cost of Goods Sold 8.00 $ 9.00 10.00 $ 0 0 0 0 Cost of Goods Sold -…
Assume a merchandising company’s estimated sales for January, February, and March are $101,000, $121,000, and $111,000, respectively. Its cost of goods sold is always 30% of its sales. The company always maintains ending merchandise inventory equal to 10% of next month’s cost of goods sold. What are the required merchandise purchases for January? Multiple Choice $29,700 $33,740 $36,300 $30,900
Assume Ava Co. has the following purchases of inventory during the first month of operations Number of Units Cost per unit First Purchase 140 2.4 Second Purchase 105 4.7 Assuming Ava Co sells 120 units at $14 each, what is the cost of goods sold if they use LIFO?
A company began January with 6,000 units of its principal product. The cost of each unit is $7. Inventory transactions for the month of January are as follows: Date of Purchase Purchases Units Unit Cost*Footnote asterisk Total Cost January 10 5,000 $ 8 $ 40,000 January 18 6,000 9 54,000 Totals 11,000 $ 94,000 *Footnote asterisk Includes purchase price and cost of freight. Sales Date of Sale Units January 5 3,000 January 12 2,000 January 20 4,000 Total 9,000 8,000 units were on hand at the end of the month. 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system.
A company began January with 6,000 units of its principal product. The cost of each unit is $7. Inventory transactions for the month of January are as follows: Date of Purchase Purchases Units Unit Cost*Footnote asterisk Total Cost January 10 5,000 $ 8 $ 40,000 January 18 6,000 9 54,000 Totals 11,000 $ 94,000 *Footnote asterisk Includes purchase price and cost of freight. Sales Date of Sale Units January 5 3,000 January 12 2,000 January 20 4,000 Total 9,000 8,000 units were on hand at the end of the month. 3. Calculate January's ending inventory and cost of goods sold for the month using FIFO, perpetual system.