1. A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgetshave a profit margin of $55 each. To produce each item, a setup cost is incurred. This setup cost is $300for widgets and $600 for gadgets. Widgets consume 4 units of raw material A and 7 units of raw materialB. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturerhas 400 units of each raw material available. Assume that it is possible to produce fractional quantities ofwidgets and gadgets.Set up the problem in Excel and find the optimal solution.Max P = 45 x + 55 x2 - 300 y - 600 Y2s.t. 4x + 6x25 400 {Raw material A}7x1 + 2x2 < 400 {Raw material B}9999y 2 x {Widget Setup Cost}9999y2 > x2 {Gadget Setup Cost}X1 , X2 2 0 and yjv Y2 = 0,1 (Binary)Set up the problem in Excel and find the optimal solution.a. The manufacturer+ widgets and+ gadgets.(Leave no cells blank – be certain to enter "0" wherever required. Round your answers to 2 decimalplaces.)b. The manufacturer will producewidgets andgadgets(Round your answer to 2 decimal places.)c. The manufacturer's profit will be

Converting last 2 constraints so that the variables stay on the LHS, 9999y1 - x1 >= 0 9999y2 - x2…

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

A manufacturer of Blu-ray Discs (BDs) estimates the yearly demand for a BD to be 10,000. It costs $400 to set up the machinery to burn the BDs, plus $3 for each one produced. If it costs the company $2 to store a BD for a year, how many should be burned at a time and how many production runs will be needed to minimize costs? BDs burned at a time production runs
Lisa makes two sorts of jewelry- Type A and Type B. Type A requires 90 minutes of curving and 1hours of assembly time. On the other hand, Type B requires 45 minutes of curving and 2 hours of assembly time. Lisa can sell Type A for $12 and Type B for $55. Given that Lisa has only 1000 hours of curving 500 hours of assembly time. How many of each type of Jewelry Lisa should make to maximize revenue? Keep in mind that Type A jewelry has to be at least twice the number of Type B jewelry. (Possible Answer: $9875) (Suggestion: Convert all the hours to minutes so that you do not end up mixing hours and minutes) CAN YOU DO THIS QUESTION IN THIS TEMPLATE ? Data Curving Assembly Price A 1.5 1 $ 12.00 B 0.75 2 $ 55.00 Model Decision Variables A 0 X B 0 Y…
Joint Products Choi Company manufactures two skin care lotions, Smooth Skin and Silken Skin,from a joint process. The joint costs incurred are $420,000 for a standard production run that generates 180,000 pints of Smooth Skin and 120,000 pints of Silken Skin. Smooth Skin sells for $2.40 perpint, while Silken Skin sells for $3.90 per pint.Required1. Assuming that both products are sold at the split-off point, how much of the joint cost of each production run is allocated to Smooth Skin using the relative sales value method?2. If no separable costs are incurred after the split-off point, how much of the joint cost of each productionrun is allocated to Silken Skin using the physical measure method method?3. If separable processing costs beyond the split-off point are $1.40 per pint for Smooth Skin and $0.90 perpint for Silken Skin, how much of the joint cost of each production run is allocated to Silken Skin usinga net realizable value method?4. If separable processing costs beyond the…
Lisa makes two sorts of jewelry- Type A and Type B. Type A requires 90 minutes of curving and 1hours of assembly time. On the other hand, Type B requires 45 minutes of curving and 2 hours of assembly time. Lisa can sell Type A for $12 and Type B for $55. Given that Lisa has only 1000 hours of curving 500 hours of assembly time. How many of each type of Jewelry Lisa should make to maximize revenue? Keep in mind that Type A jewelry has to be at least twice the number of Type B jewelry. (Possible Answer: $9875). Do it in Exvel with solver (linear programming) (Suggestion: Convert all the hours to minutes so that you do not end up mixing hours and minutes)
LENILOVESBATO Co. produces various types of floor rugs with many different designs. They typically produce at least 200 rugs with a single machine setup. A cost incurred each time a new rug design is developed is called a(n) a. Unit-level cost b. Batch-level cost c. Product-level cost d. Facility-level cost
A producer of electronic parts wants to take account of both production rate and demand rate in deciding on its lot sizes. A particular $50 part can be produced at a rate of 1000 units per month, and the demand rate is 200 units per month. The firm uses a carrying charge of 24 percent a year, and the setup cost is $200 each time the part is produced.a. What lot size should be produced?b. If the production rate is ignored, what would the lot size be? How much does this smaller lot size cost the firm on an annual basis?c. Draw a graph of on-hand inventory versus time
A plastic canister manufacturing company maintains an annual safety stock of 500 units of plastic caps. If the company places an annual purchase order for 1,800 units of these caps, its average annual inventory, in units, is between: ( )1,500 and 1,300 ( )3,200 and 3,000 ( )2,400 and 2,200 ( )1,200 and 1,000 ( )1,900 and 1,700
3) A company produces a part that is used in its production process. The company produces the part at a rate of 300 units per day. The daily demand for the product is 180 units. The annual demand for the part is 54,000 units and occurs consistently over the 300 days that the company operates yearly. The company incurs a setup cost of $300 each time the item is produced. The cost of carrying the item in inventory is estimated to be 25 percent of the item's $100 cost. How many units should the company produce each production run to minimize its inventory- associated costs?
A company manufactures hair dryers. It buys some of the components, but it makes the heating elements, which it can produce at the rate of 800 per day. Hair dryers are assembled daily, 250 days a year, at a rate of 300 per day. Because of the disparity between the production and usage rates, the heating elements are periodically produced in batches of 2,000 units. Approximately how many batches of heating elements are produced annually? If production on a batch begins when there is no inventory of heating elements on hand, how much inventory will be on hand two days later? The same equipment that is used to make the heating elements could also be used to make a component for another of the firm’s products. That job would require four days, including setup. Setup time for making a batch of heating elements is a half day. Is there enough time to do this job between productions of batches of heating elements? Explain.
Mazoon Company sells 500 units resulting in $150,000 of sales revenue, $50,000 of variable costs, and $36,000 of :fixed costs. The number of units that must be sold to achieve $40,000 of operating income is units 380 a O None of the given answers b O units 200 .c O units 152 d O units 390 .e O
29) XYZ Company The XYZ Company uses 175 handles per day. The company operates 300 days per year. It costs $2.00 to carry one handle in inventory for one year. When handle inventory is low, an order is sent to the fabrication department to manufacture more handles. Fabrication can produce handles at a rate of 1500 per day and send the handles over to assembly while production is in progress. The setup for each production run costs $500. In order to calculate the EOQ, the XYZ company utilizes the __________ model. Group of answer choices a) Basic EOQ b) Production Quantity c) Optimal Production
PA machine shop manufactures custom brake disks for high performance cars. The shop needs to meet a demand of 1200 units per year. For each production run there is a setup cost of 1200 dollars, and there is a cost of 90 dollars per unit for materials and supplies. Storage of unsold units costs the shop 18 dollars per year. How many units should the shop produce on each production run in order to minimize inventory costs (setup plus storage)? Round your answer to the nearest integer. Answer: 90 units per production run

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