You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model and a cordless model. You have contracted to supply anational retail chain with both pneumatic nailers and cordless nailers. However, Brad's nailer production capability is limited in three departments: production,testing, and packaging.Your answer will be the production costs needed to execute your production plan - rounded to the nearest whole dollar. (The number of nailers may not be a wholenumber, which is acceptable in this chapter.)Use Scenario 3Scenario 1Scenario 2Scenario 3Pneum. Cost38.50Pneum. Prod Hrs0.25Pneum. Test Hrs0.4Pneum. Pkg Hrs0.1Pneum. Sales18,000Cordless Cost44Cordless Prod Hrs0.4Cordless Test Hrs0.4Cordless Pkg Hrs0.2Cordless Sales14,000Prod Hrs max14,000Testing Hrs max15,000Pkg Hrs max4,800420.30.30.121,000670.30.40.115,00011.00015,0004,80055.500.40.30.124,50069.750.30.50.112,00014,00015,0004,800

Decision variables: X1 = Units of Pneum. model X2 = Units of Cordless model Objective function:…

Answered: You work for the Brad's Nailer Company…

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

You are thinking about opening an oil change shop. Your fixed costs will be $14,500 per month. You will charge customers $30 for a lube-oil-filter. The cost of materials is in addition to your fixed costs and is estimated at $10 per customer. How many customers must you have each month in order to break even?
In preparing for the upcoming holiday season, Fresh Toy Company (FTC) designed a new doll called The Dougle that teaches children how to dance. The fixed cost to produce the doll is $100,000. The variable cost, which includes material, labor, and shipping costs, is $29 per doll. During the holiday selling season, FTC will sell the dolls for $37 each. If FTC overproduces the dolls, the excess dolls will be sold in January through a distributor who has agreed to pay FTC $10 per doll. Demand for new toys during the holiday selling season is extremely uncertain. Forecasts are for expected sales of 60,000 dolls with a standar deviation of 15,000. The normal probability distribution is assumed to be a good description of the demand. FTC has tentatively decided to produce 60,000 units (the same as average demand), but it wants to conduct an analysis regarding this production quantity before finalizing the decision. unit production quantity and a more conservative 50,000-unit production…
Dr. Good wants to help his patients be healthy. In the past, he has allowed them to comeinto the office for free healthcare screenings and tests. He now has the opportunity toprovide free full-body CT scans and full gene mapping. The CT scan would normally costabout $4,000 and the gene mapping about $10,000. He is not certain whether he shouldoffer these new services. Most of the preventive tests and immunizations that headministered in the past were inexpensive but produced significant benefits. He thinks manyof his patients would take advantage of the new tests, but is it the right thing to do?Discussion Questions 1. How is this an example of diminishing returns in healthcare?
answer both parts
A20
QUESITON 26 Calculate the percentage of assets committed to inventory, where Panda lnc has $44,000,000 in total assets and 11,400,000 of inventory. QUESITON 27 Supply chain management is ... A.a set of procedures connecting suppliers to customers B.Design, operation and improvement of productive systems C.A sequence of activities across organizations that are involved in producing and delivering a product or service D.a series of activities from suppliers to customers that add value to a product or service QUESITON 28 SCOR stands for A.Supply Chain Operations Reference model B.Supply Chain Operations Resilience C.Supply Chain Organsational Resources D.
Use Excel formulas to complete the calculations and then answer the short-answer questions in the following spreadsheet: Inventory Analysis at Walmart Click for more options Hint: When calculating retail price {RP} based on cost {C} and markup percentage {M%} on RP, use the Cost Complement formula we have discussed previously in class: RP = [(C)/(100% - M%)] x 100
Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 12 and changing the objective function coefficient for Product 3 to 18?
The fixed and the variable costs to produce an item are given along with the price at which an item is sold. How many items must be sold to breal-even? Fixed cost: $330,000 Variable cost per item: $5 Price at which the item is sold: $60
Widgets cost $20/unit to produce and are sold at 40$/unit. The firm has fixed operating costs of $60,000. If the fixed operating costs are increased 15%, then what percentage increase in sales revenue is required to break-even?
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
The lease cost for a specialized highway design software package is estimated to be $13,000 for each of years 1, 2, and 3 (future dollars). (a) Calculate the CV amount today (year 0) of each future cost estimate at the inflation rate of 6% per year. (b) Develop a spreadsheet and graph for inflation rates of 3%, 6%, and 8% per year that show the CV today.

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