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 tosupply a national retail chain with all three models of nailers. However, Brad's nailer production capability is limited in three departments: production, testing, andpackaging. The goal is to maximize your revenue.Your answer will be the number of ProLine nailers to be produced (The number of nailers may not be a whole number, which is acceptable in this chapter.)Use Scenario 3Scenario 1Scenario 2Scenario 3Pneum. Sales Price38.50Pneum. Prod Hrs0.25Pneum. Test Hrs0.4Pneum. Pkg Hrs0.1Pneum. Sales18,000ProLine Sales Price59.95ProLine Prod Hrs0.4ProLine Test Hrs0.5ProLine Pkg Hrs0.1ProLine Sales5,750Cordless Sales Price49.50Cordless Prod Hrs0.3Cordless Test Hrs0.4Cordless Pkg Hrs0.1Cordless Sales12,000Prod Hrs max14,000Testing Hrs max19,000Pkg Hrs max4,500460.250.40.121,000710.30.50.21,500590.250.40.115,00024,50016,0004,80055.500.40.30.120,00079.950.40.50.21,25064.950.250.40.112,00014,00016,0005,000

Decision variables: A = Units of Pneum to be produced B = Units of ProLine to be produced C = Units…

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

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
Need help! A-1 is incorrect.
Kofio & Sons Ltd is a small family business located in Suhum. They have a pineapple juice processing factory. They have never kept detailed inventory or sales records. The owners use their own judgment in identifying items that need to be reordered. Invoices from suppliers are only kept for tax purposes. When an item is sold, the item number and price are rung up at the cash register. What is the business impact of this situation? How could information systems help Kofio & Sons run their business? What data should these systems capture? What decisions could the systems improve? NOTE NO PLAGIARISM
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
"Nordlund Boat Company has been repairing, refitting, and building custom boats. for over 60 years in the Pacific Northwest." The company is located in Tacoma, Washington. One of the engine's most critical components is the exhaust manifolds. The company purchases this item from the best manufacturers in the world. TJ is the buyer in charge of managing this item. TJ's purchasing agent currently submits an order release for this item every 4 weeks. The company's annual demand is 400 units (2 units per working day). Nordlund's relatively low volume and quality focus, rather than volume focus, means the company cannot take advantage of quantity discounts. The supplier has agreed to deliver this item within 1 week following an order release. For this reason, Nordlund has never had a shortage of exhaust manifolds. The total time between the release date and date of receipt is 1 week or 5 working days. The accounting has generated the following inventory-related costs. Procurement costs…
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)?
As a part of its procurement strategy, a company is evaluating whether it should switch to a new supplier. A part of the evaluation will focus on the price schedules that the two suppliers are offering. The annual demand for the product is 270,000units. The cost of placing an order, independent of the supplier or the order quantity, is $200, and the carrying charge is estimated to be 18% of the item's price. Which supplier and what order quantity should the company use if its objective is to minimize its total related inventory costs? Order Quantity Price per Unit 0–3,999 $24 4,000–8,999 $23 9,000 or more $22 Order Quantity Price per Unit 0–3,999 $24 4,000–7,999 $23 8,000 –11,999 $21 12,000 or more $19 The company should order _____ units from the Supplier ________ (Enter your response rounded to the nearest whole number.)
International Data Systems' information on revenue and costs is relevant only up to a sales volume of 120,000 units. After 120,000 units, the market becomes saturated and the price per unit falls from $8.00 to $5.80. Also, there are cost overruns at a production volume of over 120,000 units, and variable cost per unit goes up from $4.00 to $4.50. Fixed costs remain the same at $70,000. a. Compute operating income at 120,000 units. b. Compute operating income at 220,000 units.
Under the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product EndingInventory Beginning Ending A 500 0.15 0.19 B 50 1.40 1.80 C 100 4.50 4.20 D 60 12.00 13.60 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = ?? What type of weighted aggregate price index must be developed for the LIFO inventory valuation? -Paasche index -Laspeyres Index
Windmire Company manufactures and sells to local wholesalers approximately 300,000 units per month at a sales price of $4 per unit. Monthly costs for the production and sale of this quantity follow.

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