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.)

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 11, 600 2nd Quarter 12,600 3rd Quarter 14, 600 4th Quarter 13, 600 Budgeted unit sales The selling price of the company's product is $15 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $71,400. The company expects to start the first quarter with 1,740 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,940 units. Required: 1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2.…
A company's sales for the nine months to 30 September are $2.5m. The sales forecast for the next three months is $500,000 in total. The company's budgeted sales for the year are $3.4m The company's CEO has a meeting with the sales manager to discuss plans to close the gap between the forecast and the original budgeted sales for the next quarter. What is this process an example of? Feedback control An activity-based budget A rolling budget Feed-forward control
Vertical Ladder Company (VLC) forecasts its sales for January through April will be $40,000, $60,000, $100,000, and $90,000, respectively. All sales are made on credit, and it is expected that 40 percent of sales will be collected in the month of the sale and the remainder will be collected the month following the sale. Customers who pay in the month of the sale will take the 2 percent cash discount VLC offers for paying early. VLC normally purchases and pays for raw materials, which cost 45 percent of sales, one month prior to selling the finished products. Employees' wages represent 20 percent of sales and rent is $6,000 per month. At the beginning of February, VLC expects to have $4,000 in cash, which is $1,000 greater than its target cash balance. Using the information provided, construct VLC's cash budget for February and March. Round your answers to the nearest dollar. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". February March…
Cloie Boel, financial manager of Swimwear, Inc., is currently forecasting the company's a needs for the first half of next year. Swimwear's sales are highly seasonal, with most of its s occurring in the spring, just prior to the summer swimming season. The firm's marketing purtment forecasts sales as follows: Chapter 7 Business Planning and Short-Term Budgetary Systems November P 50,000 April May June July P925,000 725,000 475,000 300,000 December 75,000 300,000 la January February March 400,000 550,000 000 S 000 a Collection estimates obtained from the credit and collection departments aré as follows 20% of peso sales will be collected in the month of sale; 60% will be collected the mon following the sale; and 20% will be collected two months following the sale. Wages and materials costs related to production, and hence to sales. The production
The Company has two products: A and B. March sales forecast projects 15,000 units of A and 10,000 units of B are going to be sold at prices of $15 and $18, respectively. The desired ending inventory of A is 12% higher than the beginning inventory, which was 2000 units. How much are total March sales for A anticipated to be?
Carlos Cavalas, the manager of Echo Products' Brazilian Division, is trying to set the production schedule for the last quarter of the year. The Brazilian Division had planned to sell 69,850 units during the year, but by September 30 only the following activity had been reported: Inventory, January 1 Production Sales Inventory, September 30 The division can rent warehouse space to store up to 30,700 units. The minimum inventory level that the division should carry is 2,300 units. Mr. Cavalas is aware that production must be at least 5,940 units per quarter in order to retain a nucleus of key employees. Maximum production capacity is 45,700 units per quarter. Demand has been soft, and the sales forecast for the last quarter is only 20,900 units. Due to the nature of the division's operations, fixed manufacturing overhead is a major element of product cost. Required production Required: 1-a. Assume that the division is using variable costing. How many units should be scheduled for…
keep costs down, CGC maintains a warehouse but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year: 1. Expected monthly sales for April, May, June, and July are $180,000, $150,000, $270,000, and $50,000, respectively. 2. Cost of goods sold is 45 percent of expected sales. 3. CGC's desired ending inventory is 55 percent of the following month's cost of goods sold. 4. Monthly operating expenses are estimated to be: . Salaries: $33,000. ° Delivery expense: 8 percent of monthly sales. • Rent expense on the warehouse: $2,500. • Utilities: $500. • Insurance: $330. • Other expenses: $430. Required: 1. Compute the budgeted cost of purchases for each month in the second quarter. 2. Complete the budgeted income statement for each month in the second quarter. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute the budgeted cost of purchases for each month in the second quarter. Total Cost of…
Black Diamond Company produces snow skis. Each ski requires 3 pounds of carbon fiber. The company’s management predicts that 5,500 skis and 6,500 pounds of carbon fiber will be in inventory on June 30 of the current year and that 155,000 skis will be sold during the next (third) quarter. A set of two skis sells for $350. Management wants to end the third quarter with 4,000 skis and 4,500 pounds of carbon fiber in inventory. Carbon fiber can be purchased for $20 per pound. Each ski requires 0.4 hours of direct labor at $25 per hour. Variable overhead is applied at the rate of $13 per direct labor hour. The company budgets fixed overhead of $1,787,000 for the quarter. Prepare the direct labor budget for the third quarter. BLACK DIAMOND COMPANY Direct Labor Budget Third Quarter Units to be produced Total labor hours needed Budgeted direct labor cost
ed GreenThumb Organic Fertilizer Company plans to sell 210,000 units of finished product in July and anticipates a growth rate in sales of 3 percent per month. The desired monthly ending inventory in units of finished product is 90 percent of the next month's estimated sales. There are 189,000 finished units in inventory on June 30. Each unit of finished product requires 5 pounds of raw material at a cost of $1.35 per pound. There are 750,000 pounds of raw material in inventory on June 30. Required: 1. Compute the company's total required production in units of finished product for the entire three-month period ending September 30. Note: Round all intermediate calculations and your final answer to the nearest unit. 2. Independent of your answer to requirement 1, assume the company plans to produce 680,000 units of finished product in the three- month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the…
Net Steels is a steel manufacturing company. It currently orders 180 metric tons of raw material per order. It was observed that the company often faces stockout. To tackle this issue, the company incorporated a fixed-quantity system (FQS) and collected the following data. The lead time is 2 weeks. Demand Order Cost Item Cost Inventory-Holding Cost 10000 metric tons per year $17000 per order $38000 per year 20 percent per year Assuming there are 50 weeks a year, determine the reorder point. Only for non-integer results, round your answer UP to the nearest integer. For example, if your answer is 5.05, type 6; if your answer is 5, type 5. 2DCO Economic Order Quantity (EOQ), Q* = Cn Reorder point, r = demand rate x lead time Your Answer: Answer
GreenThumb Organic Fertilizer Company plans to sell 210,000 units of finished product in July and anticipates a growth rate in sales of 3 percent per month. The desired monthly ending inventory in units of finished product is 85 percent of the next month's estimated sales. There are 178,500 finished units in inventory on June 30. Each unit of finished product requires 4 pounds of raw material at a cost of $1.25 per pound. There are 840,000 pounds of raw material in inventory on June 30. Required: 1. Compute the company's total required production in units of finished product for the entire three-month period ending September 30. Note: Round all intermediate calculations and your final answer to the nearest unit. 2. Independent of your answer to requirement 1, assume the company plans to produce 700,000 units of finished product in the three-month period ending September 30, and to have raw-material inventory on hand at the end of the three-month period equal to 25 percent of the use in…
Iguana, Inc., manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 linear feet of bamboo, which costs $2.50 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. Iguana has the following inventory policies: • Ending finished goods inventory should be 40 percent of next month's sales. Ending direct materials inventory should be 30 percent of next month's production. Expected unit sales (frames) for the upcoming months follow: March April May June July August 315 330 380 480 455 505 Variable manufacturing overhead is incurred at a rate of $0.60 per unit produced. Annual fixed manufacturing overhead is estimated to be $7,200 ($600 per month) for expected production of 3,000 units for the year. Selling and administrative expenses are estimated at $650 per month plus $0.50 per unit sold. Iguana, Inc., had $11,000 cash on hand on April 1. Of its sales, 80 percent is in cash. Of the credit sales, 50 percent is…

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS