15. Seher Aydinlatma is manufacturing light bulbs based on three months plan. We have thefollowing demand and total capacity forecasts for the next months. Also we know the unit costsfor inventory carrying, subcontracting capacity, regular and overtime working costs.MarchAprilMayBeginninginventoryRegular timeOvertimeSubcontractOvertimeRegular timeSubcontractDemandCapacityRegularOvertimeOvertime60050Subcontracting100Beginning inventory 50Regular timeOvertimeSubcontractCarrying costRegular timeSALES PERIODMarch650COSTS1545in553April700700100100May1000800100100Unit$/product$/product$/product$/product/monthMarch April May Total Capacity Available (Supply)5060050100700100100800100SubcontractDEMAND650 700 1000Fill the above table using the optimal (transportation) algorithm to generate the aggregate plan thatmatch supply and demand estimates.100

Aggregate planning is a strategic process used by businesses to determine the overall production,…

Answered: 15. Seher Aydinlatma is manufacturing…

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

19. What combination of x and y will yield the optimum for this problem? Maximize $3x + $15y, subject to (1) 2x + 3y ≤ 12 and (2) 5x + 2y ≤ 10 and (3) x, y ≥ 0. Part 2 A. x = 0, y = 3 B. x = 2, y = 0 C. x = 0, y = 0 D. x = 0, y = 4 E. x = 1, y = 5
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
5. Christy Crafty Boat Supplies has 250 yards of canvas to make sails and deck covers. There are205 hours of labor available. The following data apply:Profit Canvas LaborSail $50 35 yards 10 hoursDeck Cover 65 10 15How many of each should be made to maximize profit? 6. KitchenKorp produces three electrical appliances: blenders and can openers. These products havethe following resource requirements.ProductResource RequirementsCost/Unit Labor hours/UnitCan OpenerBlender$172056There is a maximum of 1,000 hours of labor available during the coming period. Maximum customerdemand during this time is 150 for each of the products. Selling prices are $35 for a can opener and$45 for a blender. How many of each should be made to maximize profits?
ABC Cabinets received a contract to produce bookshelf speakers (BS) and floor speakers (FS) over the next 2months. The contract says ABC must deliver 2100 BS and 1500 FS at the end of month 1 and deliver 1200 BS and2600 FS at end of month 2. The time to make a BS is 0.7hr and a FS is 1hr. Raw material costs $10 for each BSand $12 for each FS and there is an unlimited amount available. Labor costs are $22/hr using regular productiontime and $33/hr using overtime. ABS has up to 2400hrs of regular production time each month and up to 1000additional hours of overtime each month. Any cabinets left at the end of month 1 can be stored for $5/cabinet.(a) Formulate an LP to determine the number of units that should be manufactured each month on regular andovertime to minimize total production and storage costs
The topic is about Quantitive analysis and decision making. Problem: A firm just completed a new plant that will producemore than 500 different products, using morethan 50 different production lines and machines.The production scheduling decisions are criticalin that sales will be lost if customer demands arenot meet on time. If no individual in the firmhas experience with this production operationand if new production schedule must begenerated each week, why should the firmconsider a quantitative approach to theproduction scheduling problem?
The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…
A young engineer is considering establishing his own small company.An investment of Php 100,000 will be required which must be recovered in 15years . It is estimated that sales will be Php 150,000 per year and thatoperating expenses will be as follows:Material Php 40,000 per yearLabor Php 70,000 per yearOverhead Php 10,000 + 10% of sales/yearSelling expenses Php 5,000/yearThe young engineer will give up his regular job paying Php 150,000 per yearand devote full time to the operation of the business. This will result indecreasing labor by Php 10,000 per year , material cost by Php 7000 peryear, and overhead cost by Php 8000 per year. If the young engineer expectsto earn at least 20% on his capital, should he invest ?
How much influence can the employee requirements for one, two, or three days have on the weekly sched-ule in the employee scheduling example? Explore this in the following questions:a. Let Monday’s requirements change from 17 to 25in increments of 1. Use SolverTable to see how thetotal number of employees changes.b. Suppose the Monday and Tuesday requirementscan each, independently of one another, increasefrom 1 to 8 in increments of 1. Use a two-waySolverTable to see how the total number ofemployees changes. c. Suppose the Monday, Tuesday, and Wednes-day requirements each increase by the same amount, where this increase can be from 1 to 8in increments of 1. Use a one-way SolverTableto investigate how the total number of employeeschanges.
Exercise 4 a) Write the objective function of this LP.b) Write the constraint of the basic element Y.c) Write the constraint that expresses"the factional contributions from each mine must add up to 1."d) What is the optimal fraction of a ton to be chosen from mine 4?e) To make the optimal fraction of a ton to be chosen from mine 4 non-zero, how should the cost per ton of ore from mine 4 change?f) If the minimum requirement amounts of basic element X increases to 7 tons, how much does the cost of a feasible blend (i.e., the value of the objective function) become?g) If the minimum requirement amount of basic element Z decreases to 25 tons, how much does the cost of a feasible blend (i.e., the value of the objective function) become?
A manager wants to know how many units of each product to produce on a daily basis in order toachieve the highest contribution to profit. Production requirements for the products are shown inthe following table.ProductMaterial 1(pounds)Material 2(pounds)Labor(hours)A 2 3 3.2B 1 5 1.5C 6 — 2.0Material 1 costs $5 a pound, material 2 costs $4 a pound, and labor costs $10 an hour. Product Asells for $80 a unit, product B sells for $90 a unit, and product C sells for $70 a unit. Availableresources each day are 200 pounds of material 1; 300 pounds of material 2; and 150 hours of labor.The manager must satisfy certain output requirements: The output of product A should not bemore than one-third of the total number of units produced; the ratio of units of product A to units ofproduct B should be 3 to 2; and there is a standing order for 5 units of product A each day. Formulate a linear programming model for this problem, and then solve
You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPL
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.

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