Bambino Sporting Goods makes baseball gloves that are very popular in the spring and early summer season. Units sold are anticipated as follows: Monthly Unit Sales 3,200 7,200 March April May 11,400 June 9,400 31,200 Total units sold If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup. The production manager thinks the preceding assumption is too optimistic and decides to go with level production to avoid being out of merchandise. He will produce the 31,200 units over four months at a level of 7,800 per month. a. What is the ending inventory at the end of each month? Compare the unit sales to the units produced and keep a running total.

Bambino Sporting Goods makes baseball gloves that are very popular in the spring and early summer season. Units sold are anticipated as follows: Monthly Unit Sales 3,200 7,200 March April May 11,400 June 9,400 31,200 Total units sold If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup. The production manager thinks the preceding assumption is too optimistic and decides to go with level production to avoid being out of merchandise. He will produce the 31,200 units over four months at a level of 7,800 per month. a. What is the ending inventory at the end of each month? Compare the unit sales to the units produced and keep a running total.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 6E: Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The...

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?
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?
Kimball Company has developed the following cost formulas: Materialusage:Ym=80X;r=0.95Laborusage(direct):Yl=20X;r=0.96Overheadactivity:Yo=350,000+100X;r=0.75Sellingactivity:Ys=50,000+10X;r=0.93 where X=Directlaborhours The company has a policy of producing on demand and keeps very little, if any, finished goods inventory (thus, units produced equals units sold). Each unit uses one direct labor hour for production. The president of Kimball Company has recently implemented a policy that any special orders will be accepted if they cover the costs that the orders cause. This policy was implemented because Kimballs industry is in a recession and the company is producing well below capacity (and expects to continue doing so for the coming year). The president is willing to accept orders that minimally cover their variable costs so that the company can keep its employees and avoid layoffs. Also, any orders above variable costs will increase overall profitability of the company. Required: 1. Compute the total unit variable cost. Suppose that Kimball has an opportunity to accept an order for 20,000 units at 220 per unit. Should Kimball accept the order? (The order would not displace any of Kimballs regular orders.) 2. Explain the significance of the coefficient of correlation measures for the cost formulas. Did these measures have a bearing on your answer in Requirement 1? Should they have a bearing? Why or why not? 3. Suppose that a multiple regression equation is developed for overhead costs: Y = 100,000 + 100X1 + 5,000X2 + 300X3, where X1 = direct labor hours, X2 = number of setups, and X3 = engineering hours. The coefficient of determination for the equation is 0.94. Assume that the order of 20,000 units requires 12 setups and 600 engineering hours. Given this new information, should the company accept the special order referred to in Requirement 1? Is there any other information about cost behavior that you would like to have? Explain.
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?
Lowell Manufacturing Inc. has a normal selling price of 20 per unit and has been selling 125,000 units per month. In November, Lowell Manufacturing decided to lower its price to 19 per unit expecting it can increase the units sold by 16%. a. Compute the normal revenue with a 20 selling price. b. Compute the planned revenue with a 19 selling price. c. Compute the actual revenue for November, assuming 135,000 units were sold in November at 19 per unit. d. Compute the revenue price variance, assuming 135,000 units were sold in November at 19 per unit. e. Compute the revenue volume variance, assuming 135,000 units were sold in November at 19 per unit. f. Analyze and interpret the lowering of the price to 19.
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?
Total Pops data show the following information: New machinery will be added in April. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next months requirements. Direct material requires 2 pounds per unit at a cost of $3 per pound. The ending inventory required for direct materials is 15% of the next months needs. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.
Saginaw Company is a garden products wholesale firm. In December, Saginaw Company expects to sell 30,000 bags of vegetable fertilizer at an average price of 5.30 per bag. Actual results are 30,600 bags sold at an average price of 5.20 per bag. Required: 1. Calculate the sales price variance for December. 2. Calculate the sales volume variance for December. 3. Calculate the overall sales variance for December. Explain why it is favorable or unfavorable. 4. What if December sales were actually 29,800 bags? How would that affect the sales price variance? The sales volume variance? The overall sales variance?
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.
Deuce Sporting Goods manufactures a high-end model tennis racket. The company’s forecasted income statement for the year, before any special orders, is as follows: Fixed costs included in the forecasted income statement are $400,000 in manufacturing cost of goods sold and $200,000 in selling expenses. A new client placed a special order with Deuce, offering to buy 1,000 tennis rackets for $100.00 each. The company will incur no additional selling expenses if it accepts the special order. Assuming that Deuce has sufficient capacity to manufacture 1,000 more tennis rackets, by what amount would differential income increase (decrease) as a result of accepting the special order? (Hint: First compute the variable cost per unit relevant to this decision.)
Antonio Banderos & Scarves makes headwear that is very popular in the fall-winter season. Units sold are anticipated as: Monthly Unit Sales October 1,250 November 2,250 December 4,500 January 3,500 11,500 Total units sold If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory buildup. However, Antonio decides to go with level production to avoid being out of merchandise. He will produce the 11,500 items over four months at a level of 2,875 per month. a. What is the ending inventory at the end of each month? Compare the units sales to the units produced and keep a running total. b. If the inventory costs $8 per unit and will be financed at the bank at a cost of 12 percent, what is the monthly financing cost and the total for the four months? (Use 1 percent as the monthly rate.)
Cherboneau Novelties produces drink coasters (among many other products). During the current year (year 0), the company sold 530,000 units (packages of 6 coasters). In the coming year (year 1), the company expects to sell 560,000 units, and, in year 2, it expects to sell 744,000 units. The target ending finished goods inventory for each month is equal to the next month's sales. However, because of production issues, the ending inventory in the current year is expected to be only 17,000 units. Each unit requires 0.5 pound of cork. At the end of the current year, management expects to have 21,250 pounds of cork in inventory. Management has set a target to have cork on hand equal to one half of next month's sales requirements. Sales and production take place evenly throughout the year. Required: 8. Compute the total targeted production of the finished coaster for the coming year. b. Compute the required amount of cork to be purchased for the coming year. a. Total targeted production in…