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

Mary hopes to sell 10,000 pieces of chrysanthemum last November but she was able to sell 15,000 chrysanthemum. Her chrysanthemum is sold at 20 pesos each. Her total expenses was 150,000, hence, cost per unit is 15.00. What was her sales volume? * 300,000 150,000 10,000 O 25,000 O 15,000
A company manufactures dog leashes that sell for $18.64, including shipping and handling. The monthly fixed costs (advertising, rent, etc.) are $24,131 and the variable costs (materials, shipping, etc.) are $9.18 per leash. How many leashes must be produced and sold each month for the company to break even? leashes. Round to the nearest leash.
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?
Rainbow Inc's products are given below. If the company's total labor capacity is 3200 hours/week, which of the products should be produced in a week? Regarding with this plan what will be the total sales and total variable costs of the firm per week? Total Labor Hour Demand Product / Unit Price / Unit vC / Unit (unit) XC610 2,500 1,000 300 XD740 4 3,100 1,500 250 ZS650 3 1,850 750 400 ST340 2 2,250 975 500

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