Your answer will be the packaging hours needed to execute your production plan - rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this problem.)
Your answer will be the packaging hours needed to execute your production plan - rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this problem.)
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...
Related questions
Question
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 a national 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 packaging hours needed to execute your production plan - rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this problem.)
Use Scenario 2
Scenario 1 | Scenario 2 | Scenario 3 | |
Pneum. Cost | 87 | 89.50 | 127.50 |
Pneum. Prod Hrs | 0.7 | 0.6 | 0.45 |
Pneum. Test Hrs | 0.5 | 0.2 | 0.4 |
Pneum. Pkg Hrs | 0.2 | 0.3 | 0.3 |
Pneum. Sales | 85,000 | 44,500 | 29,000 |
Cordless Cost | 97 | 99.75 | 146 |
Cordless Prod Hrs | 0.4 | 0.8 | 0.5 |
Cordless Test Hrs | 0.6 | 0.4 | 0.5 |
Cordless Pkg Hrs | 0.2 | 0.4 | 0.4 |
Cordless Sales | 35,500 | 45,000 | 63,000 |
Prod Hrs max | 95,000 | 95,000 | 95,000 |
Testing Hrs max | 70,000 | 70,000 | 70,000 |
Pkg Hrs max | 35,000 | 35,000 | 35,000 |
Thanks
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
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
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
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.