A manufacturer produces both widgets and gadgets. Widgets generate a profit of $45 each and gadgets have a profit margin of $55each. To produce each item, a setup cost is incurred. This setup cost is $300 for widgets and $600 for gadgets. Widgets consume 4units of raw material A and 7 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.Set up the problem in Excel and find the optimal solution.a. The manufacturerwidgets andgadgets.(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.)C.The manufacturer's profit will be

Given, Profit Margin widgets-$45 Profit Margin gadgets-$55 Set-up cost Margin widgets-$300 Set-up…

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 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

30) 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. Assume the XYZ company orders 9,000 handles at a time (not necessarily the economic order quantity). The order receipt period = _____ days. Group of answer choices a) 6.0 b) 5.8 c) 30.0 d) 51.4 e) 50.0
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
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…
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
A manufacturer has been shipping his product (moderately heavy machines), mounted only on skids withoutcomplete crating. To avoid crating he must ship in freight cars which contain only his machines. To do thishe must pay freight on a car capacity load of 42 tons regardless of whether or not the car is completely full.In the past he actually has shipped only 30 tons in each car. The carload freight rate is P4.10 per hundredpounds. If the machine is crated so that they can be shipped in mixed car lots, along with other merchandise,they can be shipped at a rate of P4.20 per hundred pounds with the freight bill computed only on the actualweight shipped. The cost of crating would be P25 per machine and would increase the shipping weight from1,200 to 1,220 pounds per machine. Which procedure should be followed? (1 ton = 2,200 lbs)
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 firm produces three products. Product A sells for $60; its variable costs are $20. Product B sells for $200; its variable costs are $120. Product C sells for $25; its variable costs are $10. Last year, the firm sold 1000 units of A 2000 units of B, and 10,000 units of C The firm has fixed costs of $320,000 per year. Calculate the break-even point of the firm.
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
A wallpaper company estimates the demand for a certain pattern to be 925 rolls per year. It costs $750 to set up the presses to print the pattern, plus $150 to print each roll. If the company can store a roll of wallpaper for a year at a cost of $4, how many rolls should it print at a time and how many printing runs on average will it need in a year to minimize production costs? (Assume the wallpaper sells steadily throughout the year, and the company reorders more whenever the stock runs out. Round the number of rolls per print to the nearest whole number and the average number of printing runs per year to two decimal places.) rolls per print rolls print runs per year runs
A manufacturer has a production facility that requires 15,604 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 7 days. The unit purchase cost is $25.6 per unit. The cost to place and process an order from the supplier is $121 per order. The unit inventory carrying cost per year is 10.5 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 2,640 units per order, what is the annual holding cost? Use at least 4 decimal places.
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…
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)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS