Question: please show work in excel. Problem 12 - Using the information provided below answer the 4 questions under the diagram. PRODUCT X S.P. = $3000

please show work in excel.

Problem 12 - Using the information provided below answer the 4 questions under the diagram. PRODUCT X S.P. = $3000 D - 100/WK PRODUCT Y S.P. - S2000 D=200/WK ASSEMBLY 10 minutes/unit ASSEMBLY 5 minutes/unit GENERAL INFORMATION Machine 1 ==> 1 Set-Up 240 minutes Machine 2 ==> 1 Set-Up 30 minutes Machine 31 Set-up 180 minutes Assembly Set-up - 0 MACHINE 3 3 minutes/unit MACHINE 3 10 minutes/unit MACHINE 2 3 minutes/unit MACHINE 1 15 minutes/unit MACHINE 2 5 minutes/unit MACHINE 1 10 minutes/unit The facility operates 2400 minutes/week. R.M. 1 $500/UNIT R.M. 2 $500/UNIT R.M.3 $100/UNIT Weekly operating expense for this operation, not including material purchases is $35000. 1. Identify the system constraint for this operation 2. Determine the best product mix. 3. Calculate the profit generated by the optimal product mix 4. Using the optimal product mix recalculate the utilization of each resource

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!

please show work in excel. Problem 9 - Economic Order Quantity The manufacturer of a large comercial product has forecast demand for the next year to be 24,000 units (i.e. 2000 a month). The company...

Supply Management Please show work on excel. Solve question 5 Transportation Information Similar to the changes that have been contemplated with regard to product sourcing, Throx would like to use a...

-Please show work on excel. Thanks :) R. Saltzman DS 412 LP Excel Assignment Operations Management Name Due Date: March 12, 2020 In this assignment, you'll enter the Media Selection Problem below...

please show work in excel for problems 4,5,6 Walton Clothing, Inc. David decided to purchase the following equipment as of January 1, 2013. Cost The Business Situation Useful Life $7,500 5 yrs. After...

Q This document has all of the instruction in it. please contact me if you have any questions. Download Attachment: (1) On October 5, Narveson Company buys merchandise on account from Rossi Company....

7Project Evaluation: Tortuga Fishing Equipment Company Judson W. Russell Abstract This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy....

This document has all of the instruction in it. please contact me if you have any questions. (1) On October 5, Narveson Company buys merchandise on account from Rossi Company. The selling price of...

Please use the provided template to solve the problem and please show work / formula of working cell. Please use the provided template to solve the problem and please show work / formula of working...

please show work, i will leave a thumbs up PRODUCT X S.P. = $180 D = 200/WK PRODUCT Y S.P. = $210 D = 100/WK GENERAL INFORMATION Machine 1 ==> 1 Set-Up 45 minutes ASSEMBLY 5 minutes/unit ASSEMBLY 3...

The Western blot assay is a blood test for the presence of HIV. It has been found that this test sometimes gives false positive results for HIV. A medical researcher claims that the rate of false...

The beta of company As stock is estimated to be 1.2 according to the regression analysis. Assume that the prevailing risk-free rate is 6 percent, and the market risk premium is estimated to be 7...

Hancock Inc. retains most of its earnings. The company currently has earnings per share of $ 1 1 . Hancock expects its earnings to grow at a constant rate of 2 percent per year. Furthermore, the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...