Question: 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

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 NEEDS ANSWERED ASAP! please use excel

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 BenchMate. 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!

NEEDS ANSWERED ASAP! Please use excel spreadsheet for the parameters, model, and constraints. also, please provide formulas to help understanding Paragraph Styles New Foundations Real Estate has to...

Please see attachment. Please use excel. Also, under the "Requirements"seperate part A and part B on excel. Thank you. Budgeting Project TO THE STUDENT Fantastic, Inc. is a case study which allows...

QUESTION: Based on the analysis in these three pictures, make recommendations about the production processes and pricing of Orchid Relief. (Preferably a full paragraph). Thank you! t 297 1 2 3 4 5 6...

I need help making recommendation. I attached the necessary info below 20% Based on the analysis in P1 - P3, make recommendations about the production processes and pricing of Orchid Relief. [Write...

I need help calculating the shortage. This is page 2 for reference : 20% Consider a possible shortage of ingredients in the following week. What would the optimized production process look like if...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Answer the following question based on the case facts below: (NOT MISSING ANYTHING) 1) What are major issues/problems? 2) What are the decision-makers goals and objectives? 3) Are there other...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Please help! i have provided a template, check figs, instructions and what i have completed so far. Please double check mysheet to see if there's anything i'm missing from the entries i have...

I am having trouble getting my trial balance to match the balancing from my instructor. I will attach both the problem, the excel document I have been working on as well as the trail balance...

1. How did Whirlpool use capabilities of text analytics to better understand their customers and improve product offerings? 2. What were the challenges, the proposed solution, and the obtained...

State the four Maxwell's equations in point form and explain the significance of each in electromagnetic theory. (4 marks)

Which of the following funds should use the acorual baris of accounting? a ) Enterprise and private purpose trust funds. b ) Permunent funds and internal service funds. c ) Special reverne and...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...