You work for the Brad's Nailer Company which manufactures three types of nailers: a pneumatic model, the "ProLine", and a cordless model. You havecontracted to supply a national retail chain with all three models of nailers. However, Brad's nailer production capability is limited in two departments:production and packaging. The goal is to maximize your revenue. (The number of nailers must be a whole number, and the total number of Pneumaticplus Cordless nailers must be at least twice the number of Proline nailers.)Your answer will be the number of ProLine nailers to be producedUse Scenario 1Pneum. Sales PricePneum. Prod HrsPneum. Pkg HrsPneum. SalesProLine Sales PriceProLine Prod HrsProLine Pkg HrsProLine SalesCordless Sales PriceCordless Prod HrsCordless Pkg HrsCordless SalesProd Hrs maxPkg Hrs maxScenario 1460.250.121,000710.30.21,500590.250.115,00024,5004,800Scenario 255.500.40.120,00079.950.40.21,25064.950.250.112,00014,0005,000Scenario 338.500.250.118,00059.950.40.15,75049.500.30.112,00014,0004,500

A = Number of Pneumatic models to be produced B = Number of Proline models to be produced C = Numbre…

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

Little Caesars Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every four weeks to take orders. Because the orders are shipped directly from Italy, they take three weeks to arrive. Little Caesars Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Little Caesars prides itself on offering only the best quality ingredients and a high level of service, so it wants to ensure a 98 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? What is the standard deviation of demand during the review period and lead-time? How many pounds of pepperoni would you order?
The grocery store has bulk pecans on sale, which is great since you're planning on making 8 pecan pies for a wedding. Bulk pecans can be bought in increments of a tenth of a pound. How many pounds of pecans should you buy?
9. A company uses 8000 wheels per year in its manufacture of golf carts. The wheel cost $15 each and is purchased from an outside supplier. The money invested in the inventory cost 10% per year and the warehousing cost amounts to an additional 2% per year. It cost $150 to process each purchase order. Find the quantity of wheels that should be ordered each time an order is placed.
Charlie’s Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops every four weeks to take orders. Because the orders are shipped directly from Italy, they take three weeks to arrive. Charlie’s Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Charlie’s prides itself on offering only the best quality ingredientsand a high level of service, so it wants to ensure a 98 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? (Answer in Appendix D)
This is a comprehensive case. This covers most of the essential concepts we have covered and other materials you will obtain independently. Volta Apparel Inc. is contemplating constructing a new facility to manufacture ladies' apparel (shirts) at Keta. Mr. Kwaku Kobla is the newly appointed Plant Manager, who will oversee the Keta plant. You have been appointed as the Operations Consultant to advise him and assist him. Volta has another similar facility in Accra. The actual demand for shirts (manufactured in the Accra plant for the last 4 years) is presented below: Season and Year Actual Demand Quarter1 and 2005 482 Quarter2 and 2005 213 Quarter 3 and 2005 116 Quarter 4 and 2005 335 Quarter 1 and 2006 499 Quarter 2 and 2006 225 Quarter 3 and 2006 122 Quarter 4 and 2006 344 Quarter 1 and 2007 503 Quarter 2 and 2007/237 Quarter 3 and 2007 127 Quarter 4 and 2007 349 Quarter 1 and 2008 518 Quarter 2 and 2008 244 Quarter 3 and 2008 133 Quarter 4 and 2008 353 A. Based on the information…
10.8 The local fire department uses 10,000 alkaline flashlight batteries per year, which costs $4 each. The cost of ordering batteries is estimated to be $50. The current interest rate suggested by the city council is 25%. The sales rep has recently suggested that you could get a discount of 2% for orders of 2000 batteries at a time. Should you take advantage of this special offer?
Cecil Green sells golf shirts. He knows that people will not pay more than $40 for a golf shirt. Cecil needs a 35% markup on cost. What is the maximum Cecil should pay for his golf shirts?
Prior to accepting a customer’s order, a company should verify the amount of inventory on hand. Which of the following is not a reason to do this? Determine whether inventory records are accurate. Ensure accuracy of inventory records by reducing the amount by items order. Identify which products should be ordered from suppliers. Communicate to the customer when shipment will be sent.
You are the executive chef at a large wedding facility, and a wedding with a confirmed count of 168 is scheduled for tomorrow at noon. Everything has been ordered except the shrimp, which was missing from the last purchase order. It will have to be a last-minute rush order, and only one supplier can get it to you in time. The purchase order will be for frozen raw, U 16-20, shrimp peeled, de-veined, tail-on, in 5-pound boxes (according to your spec for the product). You’ve dealt with this supplier before, and made a note to yourself on the jumbo shrimp spec that this vendor’s product averages 19 to 20 shrimp per pound and has a 96% yield. Catering policy dictates that a 10% buffer be provided for unexpected guests, and the catering menu states that 5 shrimp are to be served per person. If you have 4 pounds of good jumbo shrimp on hand, how much will you order for the wedding? Will there be any leftover product? How much?
Tyrelle's T-shirts purchases shirts for $4. If a markup of $5 per shirt is applied, the selling price for each shirt is $9. True False
You are in charge of inventory control of a highly successful product retailed by your firm. Weekly demand for this item varies, with an average of 200 units and a standard deviation of 16 units. It is purchased from a wholesaler at a cost of $12.50 per unit. You are using a continuous review system to control this inventory. The supply lead time is 4 weeks. Placingan order costs $50, and the inventory carrying rate per year is 20 percent of the item’s cost. Your firm operates 5 days per week, 50 weeks per year.a. What is the optimal ordering quantity for this item?b. How many units of the item should be maintained as safety stock for 99 percent protection against stockouts during an order cycle?c. If supply lead time can be reduced to 2 weeks, what is the percent reduction in the number of units maintained as safety stock for the same 99 percent stockout protection?d. If through appropriate sales promotions, the demand variability is reduced so that the standard deviation of weekly…
I only need help with part C please.... The Metropolitan Bus Company (MBC) purchases diesel fuel from American Petroleum Supply. In addition to the fuel cost, American Petroleum Supply charges MBC $225 per order to cover the expenses of delivering and transferring the fuel to MBC's storage tanks. The lead time for a new shipment from American Petroleum is 10 days; the cost of holding a gallon of fuel in the storage tanks is $0.03 per month, or $0.36 per year; and annual fuel usage is 180,000 gallons. MBC buses operate 288 days a year. (a) What is the optimal order quantity for MBC? (b) How frequently should MBC order to replenish the gasoline supply? per (c) The MBC storage tanks have a capacity of 17,500 gallons. Should MBC consider expanding the capacity of its storage tanks? The maximum inventory is ? what is max inventory? . MBC does or doest not need? to expand its storage tanks. (d) What is the reorder point (in gallons)? gallons

SEE MORE QUESTIONS

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