You work for the Brad's Nailer Company which manufactures three types of nailers: apneumatic model, the "ProLine", and a cordless model. You have contracted to supplya national retail chain with all three models of nailers. However, Brad's nailerproduction capability is limited in three departments: production, testing, andpackaging. The goal is to maximize your revenue.Your answer will be the number packaging hours to be produced (The number ofnailers must be a whole number.)Use Scenario 2 Use Scenario 2Scenario 1 Scenario 2 Scenario 3Pneum. Sales Price4659.9938.79Pneum. Prod Hrs0.350.40.25Pneum. Pkg Hrs0.250.20.1Pneum. Sales21,00020,00018,000ProLine Sales Price7279.9569.95ProLine Prod Hrs0.40.40.4ProLine Pkg Hrs0.20.20.1ProLine Sales1,5001,2505,750Cordless Sales5964.9559.50PriceCordless Prod Hrs0.250.20.3Cordless Pkg Hrs0.10.20.1Cordless Sales15,00012,00012,000Prod Hrs max24,50014,00014,000Pkg Hrs max4,8009.0009.000

You work for the Brad's Nailer Company which manufactures three types of nailers: a pneumatic model, the "ProLine", and a cordless model. You have contracted to supply a national retail chain with all three models of nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. The goal is to maximize your revenue. Your answer will be the number packaging hours to be produced (The number of nailers must be a whole number.)

You work for the Brad's Nailer Company which manufactures three types of nailers: a pneumatic model, the "ProLine", and a cordless model. You have contracted to supply a national retail chain with all three models of nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. The goal is to maximize your revenue. Your answer will be the number packaging hours to be produced (The number of nailers must be a whole number.)

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

What are order cycle costs if annual demand is 10,900 units, the order quantity is 1,800 units, and annual order cost is $140? What if the order size changes to 900 units or 10,900 units? Round your answers to the nearest cent. If the order quantity is 1,800 units, the order cycle costs are $ . If the order quantity is 900 units, the order cycle costs are $ . If the order quantity is 10,900 units, the order cycle costs are $ .
Please help me
What are the advantages of a mixed-model line over a batch-model line for producing different product styles?
Please do not give solution in image formate thanku.
You've purchased a 1 liter bottle of Coffee Liqueur for $19.95. You serve the liqueur in 1.5 oz. drinks. 1) How many drinks can be obtained from the bottle? drinks 2) What is the cost per drink? $ 3) If you want the beverage cost percent to be 18%, how much should you be charging for each cocktail? $ per drink
a manufacturer of video cames sells each copy for $21.83. The manufacturing cost of each copy is $14.56. Monthly fixed costs are $8500. During the first month of sales of a new game, how many copies must be sold in order for the manufacturer to break even (that is, in order for the total revenue to equal the total cost)?
A computer company’s yearly inventory cost is 40 percent (which accounts for thecost of capital for financing the inventory, warehouse space, and the cost of obsolescence). Last year, the company had $400 million in inventory and cost of goods sold of$26 billion. What is the company’s total inventory cost for the year (in $ million)?
) (i) An organisation uses a certain type of items to produce their products. As a production manager the organisation requires you to calculate the following with the help of the information given below (i) Maximum level (ii) Minimum level (iii) Re-order level The necessary information is as detailed below Normal usage of the items 100 units per week of 6 days Minimum usage of the items 50 units per week of 6 days Maximum usage of the items 150 units per week of 6 days Re-order quantity of the item 600units Re-order period for the item 4 to 6 weeks