The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,200 May 2,100 February 1,500 June 2,300 March April 1,600 1,900 July August 1,700 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement = ☐ units. (Enter your response as a whole number.)

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,200 May 2,100 February 1,500 June 2,300 March April 1,600 1,900 July August 1,700 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement = ☐ units. (Enter your response as a whole number.)

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

If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,200 May February March April 1,500 June 2,100 2,300 1,600 1,900 July August 1,700 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. The average monthly demand requirement = 1700 units. (Enter your response as a whole number.) In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers). Ending Period…
XYZ Company prices its products by adding 30% to its cost. XYZ anticipates sales of $715,000 in March, $728,000 in April, and $624,000 in May. XYZ’s policy is to have on hand enough inventories at the end of the month to cover 25% of the next month’s sales. What will be the cost of the inventory that ABC should budget for purchases in April? Solution: Cost of Inventory = Sales price/1.3 March cost of inventory $715,000/1.3 $550,000 April cost of inventory $728,000/1.3 $560,000 May cost of inventory $624,000/1.3 $480,000 Ending Inventory = Beginning inventory + purchases – cost of goods sold (cogs) April ending inventory $480,000 x 25% $120,000 Beginning inventory $560,000 x 25% $140,000 $120,000 = $140,000 + purchases – cost of goods sold (cogs)
Lee Retailing Company prices its products by adding 30% to its cost. Lee anticipates sales of $1,072,500 in July, $1,092,000 in August, and $936,000 in September. Lee's policy is to have on hard enough invertory at the end of the month to cover 25% of the next month's sales. What will be the cost of the inventory that Lee should budget for purchase in August? Select one: O O O a. $840,000 b. $810,000 c. $1,020,000 d. $764,400
The S&OP team at Kansas Furniture has received the following estimates of demand requirements: Month Expected Demand Jul 1,000 Aug 1,200 Sep 1,400 Oct 1,800 Nov 1,800 Dec 1,800 Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $20 per unit per month, and subcontracting cost of $45 per unit. Evaluate the following plan: keep the current workforce steady at a level producing 1,300 units per month. Subcontract the remainder to meet demand. Assume that 300 units remaining from June are available in July. A) What is the total inventory carrying cost? B) What is the total subcontracting cost? C) What is the stockout cost?
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 240 240 280 300 240 Each month's ending Finished Goods Inventory in units should be 40% of the next month's sales. March 31 Finished Goods inventory is 96 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 200 pounds of direct material B. Each month's ending Raw Materials Inventory should be 30% of the following month's production needs. The budgeted cost of direct material B during May should be:
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,540 May 3,865 June 4,540 July 4,155 August 3,920 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.80 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. Raw materials on hand at March 31 totaled 3,735 pounds. Required:1. Determine budgeted production for April, May, and June. (Do not round your intermediate calculations and round your final answer to the nearest whole number.) 2. Determine the budgeted cost of materials purchased for April, May, and June. (Use rounded Budgeted Production units in intermediate calculations. Round your answers to 2 decimal places.)
Croy Inc. has the following projected sales for the next 5 months: Month Sales in Units April 3,430 May 3,875 June 4,570 July 4,140 August 3,910 Croys finished goods inventory Policy is to have 50 percent of next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,653 pounds. 1. Determine Budgeted production for April, May, and June. April?Beginning inventory. May =4,222.5 June 4,355 2. Determine budgeted cost of materials purchsed for April and May.
Hannon Retailing Company prices its products by adding 30% to its cost. Hannon anticipates sales of $715,000 in July, $728,000 in August, and $624,000 in September. Hannon’s policy is to have on hand enough inventory at the end of the month to cover 25% of the next month’s sales. What will be the cost of the inventory that Hannon should budget for purchase in August?a. $509,600b. $540,000c. $565,000d. $680,000
Croy Incorporated has the following projected sales for the next five months: Month April May June July August Sales in Units 3,530 3,815 4,530 4,120 3,990 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,673 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May
A store sells a product that has the annual demand of 16,156 units. It purchases the product from supplier A for $74.4 per unit. The unit inventory carrying cost per year is 14 percent of the unit purchase cost. The cost to place and process an order from the supplier is $107 per order. Supplier A has a delivery lead time of 7 days. The store operates 300 days a year. Assume EOQ model is appropriate. What is the optimal total annual inventory and purchase cost for the store? Use at least 4 decimal places.