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.
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…
Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 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 1 2 3 Customer Orders 54 38 25 20 Use a production lot size of 73 units and no beginning inventory. (In the ATP row, enter a value of 0 (zero) In any perlods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required.) June July MPS ATP Forecast Customer Orders Projected On-Hand Inventory 60 54 2 60 38 3 60 25 4 60 20 5 60 0 6 60 0 7 60 0 8 60 0
Shoney Video Concepts produces a line of video streaming servers that are linked to personal computers for storing movies. These devices have very fast access and large storage capacity. Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to cause any adverse feelings with the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is Month Demand Forecast January 600 February 800 March 900 April 600 May 400 June 300 July 200 August 200 September 300…
Three point estimates and bottom up estimating are used in developing: (select one correct answer) Schedules Risks Cost estimates Scope

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