3) Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table below. Cost of regular production is $5 per unit, the cost of producing the same unit on overtime is $7, the cost of subcontracting is $8 per unit, and the cost of carrying a unit in inventory from one month to the next is $2. January February March April May Forecast 500 750 1200 650 300 Beginning Inventory 100 Regular Time Overtime Subcontracting Ending Inventory The labor contract at the plant prohibits both overtime and subcontracting output to exceed 300 units in any five month window. The plant capacity is 500 units per month produced using two shifts, regardless of the number of days in a month. By policy, management wants to avoid stockouts. Formulate the aggregate plan using linear programming and solve it using Solver.

3) Gang Aft Agley, a manufacturing company, faces the aggregate planning problem shown in the table below. Cost of regular production is $5 per unit, the cost of producing the same unit on overtime is $7, the cost of subcontracting is $8 per unit, and the cost of carrying a unit in inventory from one month to the next is $2. January February March April May Forecast 500 750 1200 650 300 Beginning Inventory 100 Regular Time Overtime Subcontracting Ending Inventory The labor contract at the plant prohibits both overtime and subcontracting output to exceed 300 units in any five month window. The plant capacity is 500 units per month produced using two shifts, regardless of the number of days in a month. By policy, management wants to avoid stockouts. Formulate the aggregate plan using linear programming and solve it using Solver.

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter19: Pricing Concepts

Section: Chapter Questions

Problem 6DRQ

See similar textbooks

Similar questions

The planner at a company that makes garden tractors is about to prepare an aggregate production plan that will cover the next 6 months. She has collected the following information: Month Demand Forecast Above the available capacity through permanent workforce 1 1,000 2 1,000 3 2,000 4 3,000 5 4,000 6 1,000 Total: 12,000 Production per month = 20 units per worker Initial inventory = 500 units Desired ending inventory (at the end of month 6) = 0 units Cost: Hire cost = $500 per temporary worker Inventory = $10 per tractor per month Backorder = $150 per tractor per month The optimum aggregate plan is: Month 1 2 3 4 5 6 Total Forecast Demand above regular capacity 1,000 1,000 2,000 3,000 4,000 1,000 12,000 # of temporary workers required 50 50 100 150 200 50 Temp. Workers hired 25 25 50 75 0 0 Temp. workers laid off 0…
Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.
Lot sizing A producer with one product faces the following forecasted demand for the next 10 weeks: week 1. 2. 3. 4. 5. 6. 7. 8. 9. 10 Requirement 30 12 72 11 24 42 35 30 75 68 Assume furthermore that the producer faces a Set-up cost (K) equal to 132 each time production takes place and storage costs (h) of 0.6 per unit per week. a) Find the cost of the two extreme strategies Lot - for - lot (produce exactly what is needed in each period) and Produce - once (produce everything needed in the first period).
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
Jose Martinez of El Paso had developed a polished stainless-steel tortilla machine that makes it a “showpiece” for display in Mexican restaurants. He needs to develop a 5-month aggregate plan. His forecast of capacity and demand follows: Month 1 2 3 4 5 Demand 150 160 130 200 210 Regular capacity 150 150 150 150 150 Overtime capacity 20 20 10 10 10 Subcontracting: 100 units available over the 5-month period (NOT 100 units each month) Beginning inventory: 0 units Ending inventory required at the last month (i.e. month 5): 20 units. Costs Regular-time cost per unit $100 Overtime cost per unit $125 Subcontracting cost per unit $135 Inventory holding cost per unit per month $3 Assume that backorders are not permitted. a) Find an aggregate production plan using the intuitive lowest cost approach. (i.e. Develop an aggregate plan using the transportation method). b) State the corresponding…
1. Develop an aggregate plan for the following forecast Period 3 4 5 6 7 Total 1 2 8 Forecast 190 230 260 280 210 170 160 260 180 1,940 There are 20 workers who can produce 10 units per period at a cost of P6.00 per unit. There is no beginning invetory and the cost of carrying inventory is P5.00 per unit per period. Backlog cost is P10.00 per unit per period. Will the present workforce able to produce the forecast? b. What is the total cost of the plan? a.
9/Samsung Company is producing Laptops and Tablets. They are deciding whether to use job-order costing or activity based costing. Based on next year’s budget, two cost pools have been developed with the following information: Particulars Laptops Tablets Overhead Assigned Direct labor hours 5000 10000 Sewing machine hours 500 300 OMR 400,000 Machine set up hours 100 400 OMR 200,000 Find out the pre-determined overhead rate if overhead is applied based on the direct labor hour rate. a. OMR 400 per hour b. OMR 40 per hour c. OMR 4 per hour d. OMR 4000 per hour
7-3. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next eight months. month Apr forecast 4500 May 4400 Jun 6200 Jul 6400 Aug 5800 Sep 6600 Oct 7200 Nov 6900 Use the following information to develop aggregate plans. Regular production cost: $10.00 per case Regular production capacity: 5,000 cases Overtime production cost: $16 per case Subcontracting cost: $20 per case Holding cost: $1 per case per month Beginning inventory: 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? (a) Use level production of 5,000 case per month. Supplement using overtime as needed (b) Use a combination of overtime (500 cases per month for the first five months), inventory, and subcontracting (500 cases per month from September to November, if necessary) to handle variations in demand. Note that suitable amounts of overtime for the last…
Aggregate Planning and Master Scheduling Planners of the company are about to prepare the aggregate plan that will cover 6 months. Assuming that the company identified the following forecast for the next 6 months: Period Jan Feb March April May June Forecast 270000 275000 245000 255000 335000 270000 They now want to evaluate a plan that calls for a steady rate of regular output (250000 boxes/month). Mainly using inventory, regular time and overtime, and backorders. They intend to start with zero inventory on hand in the first period. The maximum amount of overtime output per period is 30,000 box per month. The regular production cost per box is 30 LE while the overtime cost per box is 35 LE. The holding cost is 5 LE per box per month and the backorder cost is 10 LE per box per month. Then, prepare a master schedule to identify the available to promise amounts, knowing that the policy calls for a fixed order quantity of 350000 units, and currently there are 276000 units in inventory. 5…
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…
How does aggregate planning in service differ fromaggregate planning in manufacturing?
5. Formulate a level sales and operations plan for a company with the following predicted demand: Month Demand 6,300 2 9,000 3 6,000 4 9,000 5 15,000 6 6,000 Total 51,300 The beginning workforce is 125 employees. The monthly output per employee is 150 units. The costs to hire and lay off a worker are $2,500 and $4,000, respectively. The cost to carry an item in inventory for one month is estimated at $10, and the stockout cost is $25 per unit. Show the production schedule, the inventory levels, and the changes in workforce from period to period. Compute the plan's cost.