The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:January1,200MayFebruaryMarchApril1,500June2,1002,3001,6001,900JulyAugust1,7001,300Her 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 permonth. 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).EndingPeriod Month0DecemberDemand Production Inventory Stockouts (Units)2001January1,2001,7002February1,5001,7003 March1,6001,7004April1,9001,7005May2,1001,7006June2,3001,7007 July1,7001,7008August1,3001,700

Analysis of Plan C (Constant Production)Average Monthly Demand Requirement:1700 units (as…

Answered: The president of Hill Enterprises,…

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.…
Croy Inc. has the following projected sales for the next five months: Month Salen in Unita 3,850 3,875 4, 260 4,135 3,590 April May June July August 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 materials cost $3.10 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,865 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of materials purchased for April and May.
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 240 280 300 240 Each month's ending Finished Goods Inventory 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 B. Each month's ending Raw Materials Inventory should be 30% of the following month's production needs. The budgeted production for May is: Select one: a. 288 units. b. 400 units. c. 232 units. d. 280 units. e. 168 units. Clear my choice
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
GreenThumb Organic Fertilizer Company plans to sell 240,000 units of finished product in July and anticipates a growth rate in sales of 4 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 216,000 finished units in inventory on June 30. Each unit of finished product requires 4 pounds of raw material at a cost of $1.75 per pound. There are 880,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 600,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…
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…
Blossom Company estimates that unit sales will be 8,000 in quarter 1, 11,200 in quarter 2, 12,000 in quarter 3, and 14,400 in quarter 4. The sales price is $70 per unit. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2022. Expected Unit Sales Add V: Desired Ending Finished Goods Inventory Total Required Units Less V: Beginning Finished Goods Inventory Required Production Units BLOSSOM COMPANY Production Budget For the Six Months Ending June 30, 2022 V 1 8000 2800 10800 Quarter D 11200 3000 14200 Six Months
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…
Beckett Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires four pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month's production on hand at the end of each month. The polypropylene costs $0.10 per pound. Read the requirements. Data table For the Months of January through March January February March Quarter Number of planters to be sold Units to be produced 3,425 3,400 3,525 10,350 January. 3,400 4 Multiply by: Quantity of direct materials needed per unit Quantity needed for production February 3,500…
Trailers Company expects to sell 6,500 units for $155 each for a total of $1,007,500 in January and 2,300 units for $200 each for a total of $460,000 in February. The company expécts cost of goods sold to average 50% of sales revenue, and the company expects to sell 5,000 units in March for $200 each. Trailers' target ending inventory is $20,000 plus 50% of the next month's cost of goods sold. Prepare Trailers' inventory, purchases, and cost of goods sold budget for January and February. Trailers Company Inventory, Purchases, and Cost of Goods Sold Budget Two months Ended January 31 and February 28 January Cost of goods sold Plus: Desired ending merchandise inventory Total merchandise inventory required Less: Beginning merchandise inventory Budgeted purchases 503750 135000 638750 February 230000 520000 750000
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…

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

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