1A manufacturer produces both widgets and gadgets. Widgets generate a profit of $35 each and gadgets have a profit margin of $55each. To produce each item, a setup cost is incurred. This setup cost is $500 for widgets and $300 for gadgets. Widgets consume 2units of raw material A and 3 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Eachday, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities ofwidgets and gadgets.X 01:30:43Set up the problem in Excel and find the optimal solution.a. The manufacturerwidgets andgadgets.Skipped(Leave no cells blank – be certain to enter "0" wherever required. Round your answers to 2 decimal places.)b. The manufacturer will producewidgets andgadgets(Round your answer to 2 decimal places.)McGrawHill< Prev1 of 5Next >ASUS (Round your answer to 2 decimal places.)C.The manufacturer's profit will be< Prev1 of 5Next >ASUS

Answered: Image /qna-images/answer/98d8630f-53ad-489b-97ef-13098b9e3c25.jpg

Answered: A manufacturer produces both widgets…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Compute Lead Time Jackson Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and finishing. Parts are produced in batch sizes of 80 parts. A part requires 2 minutes in milling and 6 minutes in finishing. The move time between the two operations for a complete batch is 7 minutes. Under the lean philosophy, the part is produced in a cell that includes both the milling and finishing operations. The operating time is unchanged; however, the batch size is reduced to 5 parts and the move time is eliminated. Determine the value-added, non-value-added, and total lead times, and the value-added ratio under the traditional and lean manufacturing methods. If reguired, round percentages to one decimal place. Traditional Philosophy Lean Manufacturing Philosophy Value-added time 8 V min 8 V min Non-value-added time 632 X min 48 x min Total lead time 640 x min 56 x min Value-added ratio…
The co-founders of a startup are evaluating two alternative lean canvasses under consideration for the launch of their business model. Alternative A is focused on a market segment that represents a potential to acquire 15,000 customers. Alternative B is focused on a much larger market segment that represents a potential to acquire 75,000 customers. They expect that the revenue from Alternative A customers will be $75 per month over an expected customer lifetime of 18 months. They expect that the revenue from Alternative B customers will be $10 per month over an expected customer lifetime of 24 months. Based on this information alone, which is the preferred alternative target market segment to launch the business model? Alternative A Alternative B
The Northridge Company tends to keep the inventory low. At the same time, it is important to respond to demand quickly, since a customer who wants a product K is very likely to get one from a competitor if Northridge Company doesn’t have one available immediately. Northridge Company’s current policy to produce the product K is to produce 100 per week, which is the average demand. Even this is a problem, as the production manager has pointed out, since the equipment is also used for other products and the lot size of 300 would be much more efficient. He said he is currently set up the production for product K for the next week and states that he has capacity available to produce 300 at a time next week. The following lists the forecasts and actual customer orders for the next 12 weeks. Week 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 90 120 110 80 85 95 100 110 90 90 100 110 Customer Orders 105 97 93 72 98 72 53 21…
Two models of controlling boards. The 1" type has high specification for work from the 2nd type. The better type has a profit of 50S and the other 40$ per board. The 1 type of boards requiring five as much as the 2nd needs for production and the total production are 2000 boards, the first model requires 400 min to be complete and 700 min to the second model. Write this expression with LP equations to have the maximum profit with production of each model.
A company wants to store the following seven SKUs so there is 100% accessibility.Items are stored on pallets that are stored four high.a. How many pallet positions are needed?b. What is the cube utilization? c. If the company bought racking for storing the pallets, how many pallet positionsare needed to give 100% accessibility?
6. As the ratio of the cost of overstocking to the cost of understocking gets smaller, the optimal level of product availability decreases. Is the statement TRUE or FALSE? O TRUE FALSE
Markland First National Bank of Rolla utilizes kanban techniques in its check processing facility. The following information is known about the process. Each kanban container can hold 25 checks and spends 24 minutes a day in processing and 2 hours a day in materials handling and waiting. Finally, the facility operates 24 hours per day and utilizes a policy variable for unforeseen contingencies of 0.20. a. If there are 29 kanban containers in use, the current daily demand of the check processing facility is 6,000 units. (Enter your response rounded to the nearest whole number.) b. If the muda or the waste in the system were eliminated completely, whole number.) containers would then be needed. (Enter your response rounded up to the next
the variable cost will be constant regardless the number of units produced true false
Without using excel
Which of the following would be considered a direct holding cost? (choose all that apply)
7
The life time of a giant loading machine is 10 years and its maintenance costs 4,455 JD per year. If the machine will be maintained starting 3 years after purchase, calculate the equivalent uniform series the owner should put aside to cover these costs at 9% per year

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS