Alan Industries is expanding its product line to include three new products: A, B, and C. These are to beproduced on the same production equipment, and the objective is to meet the demands for the threeproducts using overtime where necessary. The demand forecast for the next four months, in hoursrequired to make each product is:PRODUCTABCAPRIL900700800Regular timeOvertimeMAY700800600APRIL1,600800JUNE9001,000800Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carryingcost when a product is made and carried in inventory to meet future demand. Each hour's productioncarried into future months costs $3 per production hour for A, $4 for B, and $5 for C.Production can take place either during regular working hours or during overtime. Regular time is paid at$4 when working on A, $5 for B, and $6 for C. The overtime premium is 50 percent of the regular timecost per hour.The number of production hours available for regular time and overtime isJULY1,3001,100950MAY1,500750Calculate the objective value using Excel Solver.Note: Do not round intermediate calculations.JUNE1,9001,130JULY2,140990

Given Details:ProductAprilMayJuneJulyA9007009001300B70080010001100C800600800950Regular…

Answered: Alan Industries is expanding its…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 69P: The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon...

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
This process is used in business or manufacturing to predict their future requirements Select one: a. Plant Layout b. Capacity Study c. Forecast d. Scheduling
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
Northwest Pipe (NP) makes water pipe. NP is planningproduction for the next seven months, March through September.Th e forecast demands (in thousands of feet) are, respectively, 40,60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe permonth using regular-time production, at a cost of $1.25 per foot.Th ey can make up to an additional 15,000 feet using overtimeproduction at a cost of $1.50 per foot. Any pipe made in onemonth and sold in a later month incurs an inventory holding costof $0.15 per foot, per month. NP expects to end February with5000 feet of pipe and would like to plan to end September with10,000 feet in inventory. NP would like to plan their productionschedule to minimize total cost during the next seven months. (a) Formulate an LP to minimize total costs.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution
opm
) The following data have been prepared for master production scheduling purposes in IKEA Australia: End product A: Beginning inventory of 60, Period forecast of 10, Lot size of 30, and 30 hours in lot size. End product B: Beginning inventory of 20, Period forecast of 5, Lot size of 20, and 20 hours in lot size. End product C: Beginning inventory of 30, Period forecast of 15, Lot size of 50, and 50 hours in lot size. Capacity: 38 hours/ week (i) Prepare the master production schedule for these items during the next four periods using the Ethan Allen master production scheduling method. (ii) Suppose that the master production schedule is frozen for the next three periods. What specific impact would the policy have on the IKEA's performance?
Job Costing Johnson Inc. is a job-order manufacturing company that uses a predetermined overhead ratebased on direct labor hours to apply overhead to individual jobs. For the current year, estimated direct laborhours are 95,000 and estimated factory overhead is $617,500. The following information is for Septemberof the current year. Job A was completed during September, and Job B was started but not finished.[LO 4-3, 4-4, 4-5]September 1, InventoriesMaterials Inventory $ 7,500Work-in-Process Inventory (All Job A) 31,200Finished Goods Inventory 67,000Material purchases 104,000Direct materials requisitionedJob A 65,000Job B 33,500Direct labor hoursJob A 4,200Job B 3,500Labor costs incurredDirect labor ($8.50/hour) 65,450Indirect labor 13,500Supervisory salaries 6,000Rental costsFactory 7,000Administrative offices 1,800Total equipment depreciation costsFactory 7,500Administrative offices 1,600Indirect materials used 12,000Required1. What is the total cost of Job A?2. What is the total…
The Ace Manufacturing Company has orders for three similar products. Product A Min B C 1 2 Machine 3 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. A A B B Ic C Product 1 12 3 Orders (units) 1,900 500 1,100 Capacity (units) 1,300 1,600 800 1 Machine 2 3 $1.00 $1.30 $1.10 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 (a) Develop the linear programming formulation of this problem. (Let XA1 be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.)
s Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product is: PRODUCT APRIL 870 670 770 Regular time Overtime MAY 670 770 570 JUNE 870 970 770 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high carrying cost when a product is made and carried in inventory to meet future demand. Each hour's production carried into future months costs $3 per production hour for A. $4 for B, and $5 for C APRIL 1,570 770 Production can take place either during regular working hours or during overtime. Regular time is paid at $4 when working on A. $5 for B, and S6 for C. The overtime premium is 50 percent of the regular time cost per hour The number of production hours available for regular…
A small Tennessee company makes fused magnesia and silica. To prepare input for the planning software, the company first uses a spreadsheet to determine the capacity requirements for the main equipment (the fusion furnaces) and the production schedule for main products. Product#3050 had the following forecasted sales and outstanding orders (all in thousand pounds): The initial inventory is 40,000 pounds and 30,000 pounds are desired as the minimum safety stock at the end of each week. Considering the holding and setup costs with EPQ, the company has found that the optimum production quantity is around 40,000 units in each run. Use this production quantity to determine the production schedule (MPS) and Available to Promise inventory for the next 7 weeks.
Define the decision variables ,Formulate the objective function, Formulate the constraints Sears Investment has $250,000 available to invest in a 12-month commitment. The money can be placed in Treasury notes yielding an 8% return or in municipal bonds at an average rate of return of 9%. Bank regulations require diversification to the extent that a t least 50% of the investment be placed in Treasury notes. Because of defaults in such municipalities as California and Texas, it is decided that no more than 40% of the investment be placed in bonds. How much should Sears Investment invest in each security so as to maximize its return on investment?
At a hydrocarbon processing factory, process control involves the periodic analysis of samples for a certain process quality parameter. The analytic procedure currently used is costly and time-consuming. A faster and more economical alternative procedure has been proposed. However, the numbers for the quality parameter given by the alternative procedureare somewhat different from those given by the current procedure, not because of any inherent errors but because of changes in the nature of the chemical analysis. Management believes that if the numbers from the new procedure can be used to forecast reliably the corresponding numbers from the current procedure, switching to the new procedure would be reasonable and cost-effective. The following data were obtained for the quality parameter by analyzing samples using both procedures: a. Use linear regression to find a relation to forecast Y, which is the quality parameter from the current procedure, using the values from the proposed…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS