Aggregate Planning and Master SchedulingPlanners of the company are about to prepare the aggregate plan that will cover6 months. Assuming that the company identified the following forecast for the next6 months:PeriodJanFebMarchAprilMayJuneForecast270000275000245000255000335000270000They 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, andbackorders. 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. Theregular 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 perbox 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, andcurrently there are 276000 units in inventory.53350007Week12275000 245000342550006Forecast8275000270000270000270000Orders27010027400025500025600030000040000276000277000

Find the Aggregate plan below: The required total cost is 51100000 LE.

Answered: Aggregate Planning and Master…

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

3) AGGREGATE PLANNING Mark Tuan, Operations Manager at GOT7 Furniture, has received the following estimates of demand requirements: January 1,100 February 1,200 March 1,400 April 1,800 May 1,800 June 1,600 Assuming stockout costs for lost sales of RM100 per unit, inventory carrying costs of RM25 per unit per month, and a zero beginning and ending inventory. Analyze the extra cost if the company vary the workforce, which performs at a current production level of 1,300 units per month. The cost of hiring additional workers is RM3,000 per 100 units produced. The cost of layoffs is RM6,000 per 100 units cut back.
Silver Star Bicycle Company will be manufacturing both men’s and women’s models of its Easy-Pedal bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men’s and 125 women’s models to be shipped during the first month and 200 men’s and 150 women’s models to be shipped during the second month. Additional data are shown: Model Production Costs Current Inventory Men’s $120 20 Women’s 90 30 The company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this problem as a linear programming model so that a production schedule can be established in order to minimize production and inventory costs and satisfies the labor-smoothing,…
Felix & Company reports the following information. Period 1 567698AWNH 2 3 4 10 Units Produced 0 Cost equation = 460 860 1,260 1,660 2,060 2,460 2,860 3,260 3,660 Total Costs $ 4,560 3,860 4,260 4,860 3,960 4,160 8,660 16,060 4,860 10,782 Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost amounts. per unit
Lights Incorporated calculates cost for an equivalent unit of production using the weighted-average method. Data for July: Work-in-process inventory, July 1 (35,000 units): Direct materials (97% completed) Conversion (46% completed) Balance in work in process inventory, July 1 Units started during July Units completed and transferred Work-in-process inventory, July 31: Direct materials (97% completed) Conversion (46% completed) Cost incurred during July: Direct materials Conversion costs $ 122,950 77,400 $ 200,350 86,000 95,900 25,100 $ 185,500 266,000 The cost of goods completed and transferred out under the weighted-average method is calculated to be: (Round your Intermediate calculations to 2 decimal places and final answer to the nearest whole dollar amount.) Multiple Choice $627,740. $553,343. $578,840. $102,946. $569,680.
How is it possible for you to solve the Aggregate Planning problem?
A large St. Louis feed mill, Robert Orwig Processing,prepares its 6-month aggregate plan by forecasting demand for50-pound bags of cattle feed as follows: Ja nuary, 1,000 bags;February, I ,200; March, I ,250; April, 1,450; May, I ,400; and June,I ,400. The feed mill plans to begin the new year with no inventoryleft over from the previous year, and backorders a re not permitted.It projects that capacity (during regular hours) for p roducingbags of feed will remain constant at 800 until the end of April, andthen increase to 1,100 bags per month when a planned expansionis completed on May I. Overtime capacity is set at 300 bags permonth until the expansion, at which time it will increase to 400bags per month. A friendly competitor in Sioux City, Iowa, is a lsoavailable as a backup source to meet demand but can provideonly 500 bags total during the 6-month period. Develop a 6-monthproduction plan for the feed mill using the transportation method.
Develop a chase aggregate plan for Draper using apermanent workforce of 12 employees supplemented by overtime.All demand must be met each period.(a) Show what would happen if this plan were implemented.(b) Calculate the costs associated with this plan.(c) Evaluate the plan in terms of cost, customer service,operations, and human resources.
I don't understand the chart for C why is the gross requirement for week 3 is 50, week 5 is 190, and week 6 is 300. We don't use the formulas for my class so I'm confused please use simple math to explai n
12
degree nozzle sprinklers, 180-degree nozzle sprinklers, and 360-degree nozzle sprinklers. Management has forecast demand for the next four years as follows: Plastic 90 Plastic 180 Plastic 360 Bronze 90 Bronze 180 Bronze 360 1 (IN 000s) 33 15 46 4 5 7 Plastic Demand for plastic sprinklers Percentage of capacity used Machine requirements Labor requirements Bronze YEARLY DEMAND 2 (IN 000s) 45 16 55 9 5 11 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require three operators and can produce up to 11,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires three operators and can produce up to 180,000 sprinklers. Three bronze machines and only one injection molding machine are available. Demand for bronze sprinklers Percentage of capacity used Machine requirements Labor requirements What are the capacity requirements for the next four years? (Assume that there is no…
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…
Situation: The Palangdao Supply company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates. Required: Proposed at least 3-5 recommendations regarding the case

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