Question: needs done ASAP! Please use a clear excel spreadsheet, using PARAMETERS, MODEL, and CONSTRAINTS Disney Manufacturing produces machine tools. Their lead planner overseas production of

needs done ASAP!

Please use a clear excel spreadsheet, using PARAMETERS, MODEL, and CONSTRAINTS

Disney Manufacturing produces machine tools. Their lead planner overseas production of two machines and needs to determine how many of each to produce this month. The two machines are the ToolMate and Bench Mate. These two machines use a rubber grommet as one of the raw materials. ToolMate needs 10 of these grommets and BenchMate uses 7 of this grommet. The sales department requires that the manufacturing department must produce at least 5 products in total per month (the sum of both machines). The profit for the ToolMate is $50,000 and $34,000 for the BenchMate. Additionally, there are only 49 grommets available Objective: Determine the number of ToolMate and BenchMate machines to build in order to maximize profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Disney Manufacturing produces machine tools. Their lead planner overseas production of two machines and needs to determine how many of each to produce this month. The two machines are the ToolMate...

I have been receiving a multitude of different answers ranging from a maximized profit of 234,000 244,666 and 238,000. This is making it extremely difficult to understand so it would be appreciated...

Disney Manufacturing produces machine tools. Their lead planner overseas production of two machines and needs to determine how many of each to produce this month. The two machines are the ToolMate...

NEEDS ANSWERED ASAP! please use excel spreadsheets for the parameters, model, and constraint. also, please provide formulas to help me see where numbers are coming from Disney Manufacturing produces...

ABC Manufacturing produces machine tools. their lead planner oversees production two machines and needs to determine how many of each to produce this month. The two machines are the toolmate and...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

ISYE 251- Operations Research I- Spring 2022 Semester Project and Instructions Notes: 1. Formulate the LP models carefully, considering all the information provided 2. The implementation of the model...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Given the two boxplots below, which box plot exhibits a wider ranger? -- , 20 30 40 50 60 70 80 90 100 a. Boxplot above b. Boxplot below c. Both boxplots d. None of the above

a. Interpret the flowchart by writing up a narrative of the Shipping and Billing business process. b. Based on the Shipping and Billing process, identify a few strengths and weaknesses in the...

Exercise 7.16 Assume we want to execute the DAXP loop show on page 651 in MIPS assembly on the NVIDIA 8800 GTX GPU described in this chapter. In this problem, we will assume that all math operations...

5. The amount of nicotine in a cigarette produced by a tobacco company is a random variable with mean 2.2 mg and standard deviation 0.3 mg. Taking 100 randomly chosen cigarettes, let. Xi denote the...