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.50per 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. 31Beginning inventoryFinished goods4,3004,9004,900Direct materials: silicon8,4009,1009,300Direct materials: solution 11,000 11,800 12,900 Prepare direct materials budget for silicon.Lens JunctionDirect Materials Budget for SiliconFor the Two Months Ending February 28, 20XXJanuary FebruaryUnits to be ProducedDirect Material per UnitTotal Ounces Needed for ProductionAdd: Desired Ending Inventory vTotal Material RequiredLess: Beginning Inventory vOunces of Direct Material Purchase RequirementsCost per OunceTotal Cost of Direct Material PurchaseTotal Direct Materials Silicon for Two Months Ending February 28, 20XX

Direct material purchase budget reports the estimated amount of material that is required to be…

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

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?
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?
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?
Q1: Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 ounces of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Jan. Feb. Mar. Beginning Inventory: Finished Goods 4,500 4,900 5,000 DM - Silicon 8,500 9,100 9,200 DM - Solution 11,200 12,000 13,000 PLEASE NOTE: Units are rounded to whole numbers with commas as needed (i.e. 1,234). All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Budgeted Costs Desired Ending Inventory Sales Price per Unit Expected Sales (units) Required Production Purchases Required Beginning Inventory Total Sales Revenue Total Required Units Using the information above, along with the terms above, prepare a sales budget and a production budget for the first two months of 2019…
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 -…
Akira Company had the following transactions for the month. Sales for the month are $25 per unit. # of Units Cost per Unit Beginning Inventory 150 $10 Purchased Mar. 31 160 $12 Purchased Oct. 15 130 $15 Ending Inventory 50 ? 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 "$". Weighted average cost per unit = ___?_____ per unit Cost Allocation Method Cost of Goods Available Cost of Goods Sold Ending Inventory Sales Gross Margin First-in, First-out (FIFO) Last-in, First-out (LIFO) Weighted Average (AVG)
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 $8. Inventory transactions for the month of January are as follows: Date of Purchase January 10 January 18 Totals Date of Sale January 5 January 12 January 20 Total Sales Perpetual Average * Includes purchase price and cost of freight. Units Beginning Inventory Sale - January 5 Subtotal Average Cost 5,000 6,000 11,000 Purchase - January 10 Subtotal Average Cost Sale - January 12 Subtotal Average Cost Purchase - January 18 Subtotal Average Cost Sale - January 20 Total Purchases Units 3,000 2,000 4,000 9,000 Unit Cost* 8,000 units were on hand at the end of the month. $9 10 Problem 8-5 (Static) Part 5 5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. Note: Round average cost per unit to 4 decimal places. Enter sales with a negative sign. Total Cost $ 45,000 60,000 $ 105,000 Inventory on hand Number Cost per Inventory of units unit…