Home / Business / Management /Linear Programming Problem The Pyrotec Company produces three small kitchen appliances – waffle makers, egg cookers, and toasters. The three products have the following requirements: Resource Requirements Metal Materials/unit Plastic Materials /unit Labor hours/unit Waffle maker 3.1 lb 0.5 lb .7 Egg cooker 1.5 lb 0.7 lb 1 Toaster 2.0 lb 0.3 lb .5 Resource costs are $3 per pound of metal, $2.90 per pound of plastic and $10.00 per hour for labor. Available resources are 200 pounds of metal, 250 pounds of plastic and 350 hours of labor. Based on market research, the company expects the maximum demand for waffle makers is 50 and for egg cookers is 75. The company has a contract to supply 25 toasters to a local department store. Waffle makers will be sold for 24.99, egg cookers will be sold for 19.99 and Toasters will sell for 14.99 The company wants to know the optimal product mix that will maximize profit. Part A. Write the Linear Programming formulation for this problem to help determine the best production mix of the three appliances that will maximize profit. (25 pts) Part B. Set up & run the problem in Excel Solver. Report the optimal solution and profit result (25 pts)

Question Linear Programming Problem The Pyrotec Company produces three small kitchen appliances – waffle makers, egg cookers, and toasters. The three products have the following requirements: Resource Requirements Metal Materials/unit Plastic Materials /unit Labor hours/unit Waffle maker 3.1 lb 0.5 lb .7 Egg cooker 1.5 lb 0.7 lb 1 Toaster 2.0 lb 0.3 lb .5 Resource costs are $3 per pound of metal, $2.90 per pound of plastic and $10.00 per hour for labor. Available resources are 200 pounds of metal, 250 pounds of plastic and 350 hours of labor. Based on market research, the company expects the maximum demand for waffle makers is 50 and for egg cookers is 75. The company has a contract to supply 25 toasters to a local department store. Waffle makers will be sold for 24.99, egg cookers will be sold for 19.99 and Toasters will sell for 14.99 The company wants to know the optimal product mix that will maximize profit. Part A. Write the Linear Programming formulation for this problem to help determine the best production mix of the three appliances that will maximize profit. (25 pts) Part B. Set up & run the problem in Excel Solver. Report the optimal solution and profit result (25 pts)

3YD8AN The Asker · Management

Linear Programming Problem

The Pyrotec Company produces three small kitchen appliances – waffle makers, egg cookers, and toasters. The three products have the following requirements: Resource Requirements Metal Materials/unit Plastic Materials /unit Labor hours/unit Waffle maker 3.1 lb 0.5 lb .7 Egg cooker 1.5 lb 0.7 lb 1 Toaster 2.0 lb 0.3 lb .5 Resource costs are $3 per pound of metal, $2.90 per pound of plastic and $10.00 per hour for labor. Available resources are 200 pounds of metal, 250 pounds of plastic and 350 hours of labor. Based on market research, the company expects the maximum demand for waffle makers is 50 and for egg cookers is 75. The company has a contract to supply 25 toasters to a local department store. Waffle makers will be sold for 24.99, egg cookers will be sold for 19.99 and Toasters will sell for 14.99 The company wants to know the optimal product mix that will maximize profit. Part A. Write the Linear Programming formulation for this problem to help determine the best production mix of the three appliances that will maximize profit. (25 pts) Part B. Set up & run the problem in Excel Solver. Report the optimal solution and profit result (25 pts)

More

Related Questions

If a company pays each camera PAT member a base wage of $20,250, thereby resulting in base wages of $81,000 per 4-person PAT, and if camera PATS work an average of 2,000 hours per year to assemble 3,000 cameras annually, it follows that o the base wage cost for a PAT to assemble a camera would be $28.00 and that the labor cost of assembling a camera at overtime would be $42.00 per PAT the hourly base wage cost for a PAT to assemble a camera would be $10.50 and that the labor cost of assembling a camera at overtime would be $15.75 per PAT. the base wage cost for a PAT to assemble a camera would be $24.00 and that the labor cost of assembling a camera at overtime would be $36.00 per PAT. o the base wage cost for a PAT to assemble a camera would be $27.00 and that the labor cost of assembling a camera at overtime would be $40.50 per PAT. the base wage cost of assembling a camera would be $27.00 and that the labor cost of assembling a camera at overtime cannot be determined from the available information due to the lack of information about compensation payments for assembly quality incentives, perfect attendance bonuses, and the cost of fringe benefit packages. Conving redistributing or website posting is expressly prohibited and constitutes copyright violation
Consider the following diagram: Internet Modem Wireless AP Switch Wireless AP DO Wireless AP Server 2.1 Using a table, compare 4 types of area networks. Consider the size of the network and the transmission media that is most likely to be found in each type of network. (8) 2.2 Based on the information given in 2.1, which type if network is shown in the Consider the following diagram: Internet Modem Wireless AP Switch Wireless AP DO Wireless AP Server 2.1 Using a table, compare 4 types of area networks. Consider the size of the network and the transmission media that is most likely to be found in each type of network. (8) 2.2 Based on the information given in 2.1, which type if network is shown in the diagram? Motivate your (2) answer. 2.3 This network has wireless access points. Compare three modulation techniques, using sketches, that could be used by these access points to transmit data. Use the bit-stream 10000101111. (6)
Biostatistics ESSAY A firm investigates the length of telephone conversations of their office staff. Ten consecutive conversations had lengths, in minutes: 10.7, 9.5, 11.1, 7.8, 11.9, 4.1, 10.0, 9.2, 6.5, 9.2. Derive a 95% confidence interval for the mean conversation length. Test whether the mean length of a conversation is eight minutes.(25 MARKS)
P3.5 The sales revenue, food cost of sales, and guests served for a small fast- food carryout division of a restaurant for the past six months are given below. Sales Month Cost of Revenue Guests Served Sales, Food 1 2. 4 $258,200 274,800 285,600 289,400 298,300 304,600 $ 96,200 104,300 110,500 113,100 118,900 123,700 10,200 10,400 10,300 10,100 10,400 10,500 6 For each of the six months calculate average check and average costs of sales food. Using these averages, calculate an index number. Set the in- dex for month 1 at 100 and complete index numbers for the remaining five months. With the index numbers identified, convert sales revenue and cost of sales food from historic to current dollars.
A cylindrical rock sample has a length of 6 cm, a diameter of 4 cm, and a dry weight of 166.4 g. When fully saturated with an oil of density 0.85 g/cm3, the weight of this sample is 176.9 g. Assuming constant temperature, find: i) The porosity of the sample ii) The pore compressibility of the sample, given that 0.2 cm of oil leaves the sample when a pressure of 3200 psig is applied on it iii) The amount of oil that can be extracted from the sample when a pressure of 2000 psig is applied on it
2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.
About
About
Blog
Sitemap
More
Help Center
Become an Expert
Download App
Legal
Terms of Service
Privacy Policy
Honor Code
Copyright Policy
Contact
contact@studyx.im
Facebook
Instagram
Twitter
YouTube
Copyright © 2023 StudyX Inc