You work for the Brad's Nailer Company which manufactures two types of nailers: apneumatic model and a cordless model. You have contracted to supply a national retailchain with both pneumatic nailers and cordless nailers. However, Brad's nailer productioncapability is limited in three departments: production, testing, and packaging.Your answer will be the production hours needed to execute a production plan thatminimizes costs - rounded to the nearest whole hour. (The number of nailers may not be awhole number, which is acceptable in this chapter.)Use Scenario 2Pneum. CostPneum. Prod HrsPneum. Test HrsPneum. Pkg HrsPneum. SalesCordless CostCordless Prod HrsCordless Test HrsCordless Pkg HrsCordless SalesProd Hrs maxTesting Hrs maxPkg Hrs maxScenario 1 Scenario 2 Scenario 3520.20.30.122,000670.30.40.115,50010,00015,0004,80055.500.40.30.124,50069.750.30.50.115,50020,00018,0004,20038.500.250.40.118,000440.40.40.214,00020,00018,0005,000

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

A20
Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 11,000; winter, 8,000; spring, 6,000; summer, 13,000. Inventory at the beginning of fall is 500 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season. a. What is the total cost for this plan?
Please fill out the simple chart
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. The monthly forecasts for Product X for January, February, and March are 940, 1,520, and 1,230, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 570 units. Manufacturing cost is $170 per unit, storage cost is $5 per unit per month, standard pay rate is $8 per hour, overtime rate is $12 per hour, cost of stock-out is $9 per unit per month, marginal cost of subcontracting is $8 per unit, hiring and training cost is $160 per worker, layoff cost is $260 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 44 workers and that they work 8 hours per day. (Leave the cells blank, whenever zero (0) is required. Input all values as positive values. Round up "Workers Required"…
Market Company’s policy is to have 30% of the next month's sales on hand at the end of the current month. Projected sales for August, September, and October are 26,000 units, 21,000 units, and 31,000 units, respectively. How many units must be purchased in September?
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. Also, evaluate the cost of the schedule. The monthly forecasts for Product X for January, February, and March are 1,000, 1,500, and 1,200, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 500 units. Manufacturing cost is $200 per unit, storage cost is $3 per unit per month (based on expected end-of-month levels), standard pay rate is $6 per hour, overtime rate is $9 per hour, cost of stock-out is $10 per unit per month, marginal cost of subcontracting is $10 per unit, hiring and training cost is $200 per worker, layoff cost is $300 per worker, and worker productivity is 0.1 unit per hour. Assume that you start off with 50 workers and that they work 8 hours per day. Note: Leave the cells blank,…
Fitness Express sells three different types of elliptical machines. They have manufactured 50 of each machine for a special sale. The store already ha orders for 46 of machine A and 16 of machine B. Use the following information to determine how many of machine C the store needs to sell to break even? Show your work on a separate sheet of paper. Manufacturing Cost $105.00 $140.00 $175.00 Elliptical Machine Machine A Machine B Machine C Total costs of all machines: $ Total revenue: $ Number of machine Cs to sell to break even: Retail Cost $250.00 $305.00 $420.00
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: units
1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. At what volume in number of rental transactions would the two options have the same cost?
A company that manufactures laser printers for computers has monthly fixed costs of 177000 and variable costs of 650 per unit produced. The company sells the printers for 1250 per unit. How many printers must be sold each month for the company to break even? please solve
evelop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 9,700; winter, 8,000; spring, 7,000; summer, 11,700. Inventory at the beginning of fall is 485 units. At the beginning of fall you currently have 35 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated with the union an option to use the regular workforce on overtime during winter or spring only if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $80 for each temp; layoff, $160 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season. In each quarter, produce to the full output of your regular workforce, even if that…
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 revenue for a production plan that maximizes revenue - rounded to the nearest whole dollar. (The number of nailers may not be a whole number, which is acceptable in this chapter.) Use Scenario 2 Pneum. Revenue Pneum. Prod Hrs Pneum. Test Hrs Pneum. Pkg Hrs Pneum. Sales Cordless Revenue Cordless Prod Hrs Cordless Test Hrs Cordless Pkg Hrs Cordless Sales Prod Hrs max Testing Hrs max Pkg Hrs max Scenario 1 Scenario 2 Scenario 3 42 0.3 0.3 0.1 21,000 67 0.3 0.4 0.1 15,000 11,000 15,000 4,800 55.50 0.4 0.3 0.1 24,500 69.75 0.3 0.5 0.1 12,000 14,000 15,000 4,800 38.50 0.25 0.4 0.1 18,000 44 0.4 0.4 0.2 14,000 14,000 15,000 4,800

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