You work for the Brad's Nailer Company which manufactures two types of nailers: apneumatic model and a cordless model. You have contracted to supply a national retailchain with both pneumatic nailers and cordless nailers. However, Brad's nailer productioncapability is limited in three departments: production, testing, and packaging.Your answer will be the revenue for a production plan that maximizes revenue - rounded tothe nearest whole dollar. (The number of nailers may not be a whole number, which isacceptable in this chapter.)Use Scenario 2Pneum. RevenuePneum. Prod HrsPneum. Test HrsPneum. Pkg HrsPneum. SalesCordless RevenueCordless Prod HrsCordless Test HrsCordless Pkg HrsCordless SalesProd Hrs maxTesting Hrs maxPkg Hrs maxScenario 1 Scenario 2 Scenario 3420.30.30.121,000670.30.40.115,00011,00015,0004,80055.500.40.30.124,50069.750.30.50.112,00014,00015,0004,80038.500.250.40.118,000440.40.40.214,00014,00015,0004,800

Here, we would use scenario 2. We want to know how much to produce while trying to meet sales…

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

Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) (p) $7.15 $7,15 Annual Supplier Bradley Alexander 10,000 25,000 $40.000 $26.000 50,000 $18.000 Cost/Unit (H) (wks) Administrative Cost $15.000 $1.43 $1.43 $30,000 $25,000 $17,000 6 $10,000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using V and a shipping…
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
A manufacturer procures a subassembly from a supplier. The annual demand is 145,000 units, the cost per unit is $4, the inventory-carrying charge is 12 percent, and the order cost is $225. For orders between 10,000 but less than 30,000, a five percent discount is applied, and for orders exceeding 30,000, a eight percent discount is applied. What is the optimal order quantity? Use the Quantity Discount Excel template to find your answer.
Need help! A-1 is incorrect.
What special procedures should be used to control the most expensive and most frequently used products in inventory? Give one example of a product in your response.
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…
If annual demand = 2500, order cost = $50, annual holding cost rate = 15%, and the purchase price = $120 for orders of less than 10,000 units, or $105 for orders of 10,000 units or more, should you take the discount? Also, what is the minimum total cost? ? a. No--$116,280 b. Yes--$208.477 c. No--$341,263 d. Yes--$302,120
What would be the relationship (either one-to-one, one-to-many or many-to-many) between: Customer and Sales Order and Sales Order and Inventory Inventory and Sales Please explain this in detail so I can understand thanks!
Kaniri Global Imports (a retail store) sells artisan greeting cards. The owners search for localartists from around the world from whom to buy their greeting card inventory. The followinginformation is available to you for this problem:Demand/Sales = 110 cases of cards per yearOrdering or Setup Cost = $25 per orderCarrying Charge = 18% per yearUnit Cost = $150 per caseAnswer the following questions and be sure to show your computations. You can use whateversymbol you need for square root, if typing in Word.1. How many cases should be ordered at a time? (This number will be the EOQ). Computeto two decimal places. In reality they would round, but for this problem keep the twodecimal places.2. How many times should Kaniri order in a year? Do not answer in terms of how manydays or months, but rather how many times per year. Round your answer up to the nexthighest whole number.3. Answer all three:a. What is the annual cost of ordering the cards?b. What is the annual cost of carrying the…
As manager of the St. Cloud Theatre Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus far. Item % of Revenue Selling Price $1.20 $2.00 $1.00 $1.00 Variable Cost Soft Drink $0.60 24 25 $0.90 $0.30 Wine Coffee 31 Candy $0.35 20 Last year's manager, Scott Ellis, has advised you to be sure to add 10% of variable cost as a waste allowance for all categories. You ostimate labor cost to be $260.00 (5 booths with 2 people each) Even if nothing is sold, your labor cost will be $280.00, so you decide to consider this a fixed cost Booth rental, which is a contractual cost at $80.00 for each booth per night, is also a fixed cost. a) Based on the information available, the per night break-oven point in dollars for the St. Cloud Theatre Company = $(round your response to two decimal places).

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