Answered: Your answer will be the packaging hours…

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

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