The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:January1,400MayFebruary1,500June2,2002,200MarchApril1,8001,700JulyAugust1,7001,500Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $100 per unit. Inventory holding cost is$25 per unit per month. Ignore any idle-time costs. The plan is called plan B.Plan B: Produce at a constant rate of 1,400 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $80 per unit. Subcontractingcapacity is limited to 800 units per month. Evaluate this plan by computing the costs for January through August.In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers).Period MonthDemandProduction0DecemberEndingInventory200SubcontractUnits1January1,4001,4002February1,5001,4003March1,8001,4004April1,7001,4005May2,2001,4006June2,2001,4007July1,7001,4008August1,5001,400

PeriodMonthDemand Production0December--1January140014002February150014003March…

Answered: The president of Hill Enterprises,…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 160 units per month. There are 10 units backlogged from before. Overtime cost is $30 per unit, backorder cost is $20 per unit, inventory holding cost is $5 per unit, regular time cost of $20 per unit, and beginning inventory is zero. Month Forecast 1 180 2 170 3 140 4 150 5 130 6 150 a. Prepare an aggregate plan with inventory and backlog allowed. Overtime and subcontracting are not allowed.b. Prepare an aggregate plan if the management decided to switch to…
Planners for a company that makes several models of skateboards are about to prepare the aggregate plan that will cover six periods. They have assembled the following information. Period 1 2 3 4 5 6 Total Forecast 200 200 300 400 500 200 1,800 Costs Output Regular time=$2 per skateboard Overtime =$3 per skateboard Subcontract =$6 per skateboard Inventory =$1 per skateboard per period on average inventory Back orders =$5 per skateboard per period They now want to evaluate a plan that calls for a steady rate of regular-time output, mainly using inventory to absorb the uneven demand but allowing some backlog. Prepare an aggregate plan and determine its cost using the preceding information.
A linear programming computer package is needed. Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large over the next two months, with the following delivery schedule Model Month 1 Month 2 Small 2,100 1,200 Large 1,500 2,600 Greenville estimates that the production time for each small cabinet is 0.7 hours and the production time for each large cabinet is 1 hour. The raw material costs are $10 for each small cabinet and $12 for each large cabinet. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2,400 hours of regular production time available each month and up to 1,000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be…
A manager is attempting to put together an aggregate production plan for the coming nine months. She has obtained forecasts of aggregate demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in months 3 and 4, and again in month 8, as can be seen below: The company has 20 permanent employees, each of whom can produce 10 units of output per month at a cost of $6 per unit. Inventory holding cost is $5 per unit per month, and back-order cost is $10 per unit per month. The manager is considering a plan that would involve hiring two people to start working in month 1, one on a temporary basis who would work until the end of month 5. The hiring of these two would cost $500. Beginning inventory is 0.Start with 20 permanent workers. Prepare a minimum cost plan that may use some combination of hiring ($250 per worker), subcontracting ($8 per unit, maximum of 20 units per month, must use for at least three consecutive months), and overtime…
Supertronics, Inc., would like to know how the firm’s profit-ability is altered by product mix. Currently, product mix isdetermined by giving priority to the product with the highestper-unit contribution margin (defined as the difference be-tween price and material cost). Details on the Supertronicsproduct line, including processing time at each workstation,follow:a. Assume that Supertronics has 5,500 minutes of capacityavailable at each workstation each week. Develop a linearprogram to define the production mix that maximizescontribution margin.b. Solve your formulation using a computer package such asPOM for Windows. c. Given your solution for part (b), which machine is thebottleneck?d. How would your formulation and solution in part(b) change if 50 units of each product were alreadycommitted to customers and thereby had to beproduced?
Kim Davis has decided to purchase a cellular phone, but she is unsure about which rate plan to select. The “regular” plan charges a fixed fee of $55 per month for 1,000 minutes of airtime plus $0.33 per minute for any time over 1,000 minutes. The “executive” plan charges a fixed fee of$100 per month for 1,200 minutes of airtime plus $0.25 per minute over 1,200 minutes.a. If Kim expects to use the phone for 21 hours per month, which plan should she select?b. At what level of use would Kim be indifferent between the two plans?
Prepare a Master Production Schedule (MPS) for an Agri-Chemical company in Malawi given the following information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory.
The Donald Fertilizer Company produces industrial chemical fertilizers. The projected manufacturing requirements (in thousands of gallons) for the next four quarters are 80, 50, 80, and 130, respectively. A level workforce is desired, relying only on anticipation inventory as a supply option. Stockouts and backorders are to be avoided, as are overtime and undertime.a. Determine the quarterly production rate required to meet total demand for the year, and minimize the anticipation inventory that would be left over at the end of the year. Beginning inventory is zero.b. Specify the anticipation inventory that will be produced.c. Suppose that the requirements for the next four quarters are revised to 80, 130, 50, and 80, respectively. If total demand is the same, what level of production rate is needed now, using the same strategy as part (a)?
Formulate a chase sales and operations plan for a company with the following predicted demand: Month 1 2 3 4 5 6 Total Demand 55,200 49,600 12,800 24,800 50,400 25,600 218,400 The beginning workforce is 160 employees. The monthly output per employee is 400 units. The cost to hire and lay off a worker are $2,500 and $3,500, respectively. The cost to carry an item in inventory for one month is estimated at $14, and the stockout cost is $25 per unit. Show the production schedule, the inventory levels, and the changes in the workforce…
evelop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 9,700; winter, 8,000; spring, 7,000; summer, 11,700. Inventory at the beginning of fall is 485 units. At the beginning of fall you currently have 35 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring only if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $80 for each temp; layoff, $160 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season. In each quarter, produce to the full output of your regular workforce, even if that…
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 70,070 units during the year, but by September 30 only the following activity had been reported: Units Inventory, January 1 0 Production 71,100 Sales 63,700 Inventory, September 30 7,400 The division can rent warehouse space to store up to 30,500 units. The minimum inventory level that the division should carry is 2,800 units. Mr. Cavalas is aware that production must be at least 4,440 units per quarter in order to retain a nucleus of key employees. Maximum production capacity is 44,200 units per quarter. Demand has been soft, and the sales forecast for the last quarter is only 19,500 units. Due to the nature of the division’s operations, fixed manufacturing overhead is a major element of product cost. Required: 1a. Assume that the division is using variable costing. How many…
The manufacturing plant of Carilla Ltd. specializes in crafting specialized pieces for carnival. With a monthly production capacity of 15,000 pieces, the company currently manufactures and sells 11,000 pieces per month. Typically priced at $200 per piece, the company's cost breakdown for the ongoing production level is outlined below: Variable costs that vary with number of units producedDirect materials $ 440,000Direct manufacturing labor 495,000Variable costs (for setups, materials handling, quality control, etc.)that vary with number of batches, 220 batches * $500 per batch 110,000 Fixed CostsFixed manufacturing costs 300,000Fixed marketing costs 200,000Total costs $1,545,000Carilla has just received a special one-time-only order for 4,000 pieces at $150 per piece. Accepting the special order would not affect the company’s regular business. Carilla makes pieces for its existing customers in batch sizes of 50 pieces (220 batches 50 pieces per batch = 11,000 pieces). The special…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS