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 anational 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 production costs needed to execute your production plan - rounded to the nearest whole dollar. (The number of nailers may not be a wholenumber, which is acceptable in this chapter.)Use Scenario 3Scenario 1Scenario 2Scenario 3Pneum. Cost38.50Pneum. Prod Hrs0.25Pneum. Test Hrs0.4Pneum. Pkg Hrs0.1Pneum. Sales18,000Cordless Cost44Cordless Prod Hrs0.4Cordless Test Hrs0.4Cordless Pkg Hrs0.2Cordless Sales14,000Prod Hrs max14,000Testing Hrs max15,000Pkg Hrs max4,800420.30.30.121,000670.30.40.115,00011.00015,0004,80055.500.40.30.124,50069.750.30.50.112,00014,00015,0004,800

Decision variables: X1 = Units of Pneum. model X2 = Units of Cordless model Objective function:…

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

You create your own start-up company that supply bowl directly to a number of customers. You receive a number of tentative orders and you now have to tell your customers which orders you are going to take. Before embarking on this journey, you first want to allocate your production capabilities in order to devise a feasible daily production plan that maximizes your profit.There are only three different grades of bowls that you order at this early stage of the company: Bowl #1, Bowl #2 and Bowl #3.Each type of bowl has to be processed, packaged and delivered. Each operation is run by yourself. Since your company only operates for 8 hours per day, the total number of available bowl processing hours is 4, the total number of packaging hours is 2, and the total number of delivery hours is 2.Processing 10 units of Bowl #1 requires 1 hour of time, packaging is done at the rate of 20 units per hour, and delivery at the rate of 30 units per hour. The cost of the raw materials for 1 unit is…
You create your own start-up company that supply bowl directly to a number of customers. You receive a number of tentative orders and you now have to tell your customers which orders you are going to take. Before embarking on this journey, you first want to allocate your production capabilities in order to devise a feasible daily production plan that maximizes your profit.There are only three different grades of bowls that you order at this early stage of the company: Bowl #1, Bowl #2 and Bowl #3.Each type of bowl has to be processed, packaged and delivered. Each operation is run by yourself. Since your company only operates for 8 hours per day, the total number of available bowl processing hours is 4, the total number of packaging hours is 2, and the total number of delivery hours is 2.Processing 10 units of Bowl #1 requires 1 hour of time, packaging is done at the rate of 20 units per hour, and delivery at the rate of 30 units per hour. The cost of the raw materials for 1 unit is…
A company wants to develop a level production plan. The beginning inventory is zero. Demand for the next four periods is given in what follows. What production rate per period will give a zero inventory at the end of period 4? When and in what quantities will back orders occur? What level production rate per period will avoid back orders? What will be the ending inventory in period 4? Period 1 2 3 4 Total Forecast demand 9 5 9 9 Planned production Planned inventory 0
Williams Inc. produces fluorescent lightbulbs for commercial use. The accounting manager isattempting to estimate the total cost for the next quarter using the high-low method. He has compileddata and found the high and low costs are $10,000 and $6,000, respectively, and the associated costdrivers are 7,000 and 3,000 packs, respectively. What is the value for b (the variable cost per unit)?What is the value for a (the fixed quantity)?
The Ace Company sells a single product at a budgeted selling price per unit of $20. Budgeted fixedmanufacturing costs for the coming period are $10,000, while budgeted fixed marketing expenses forthe period are $24,000. Budgeted variable costs per unit include $2 of selling expenses (commission)and $4 of manufacturing costs. What is the budgeted operating income if the anticipated sales volumefor the period is (1) 10,000 units, and (2) 15,000 units? (Round answers to the nearest whole number.)
Max the Tailor is going to sell custom suits. He was able to rent a garage from his Uncle Ed for $2,000 a month, which includes utilities, and he already owns the equipment he needs. He anticipates being able to sell his suits for $500 each. The raw materials (fabric, buttons, zippers, thread, etc.) will cost an average of $75 for each suit, and he plans to spend $25 per suit to advertise them. Assuming these are all the costs and revenues, what will be Max’s monthly break-even point in units? Does this seem like a reasonable amount for him to produce and sell every month? Please show your calculations.
an Shields Communications, Inc., a cellular communications provider based in Michigan, charges $86 per month for an all you can talk service plan. The company plans to increase marketing expenditure next year, but wants to determine the current CLV before making this decision. Variable costs before marketing are $28 per account per month and monthly retention expenditures are $12 per account. Ian Shields Communication's annual attrition rate is 17%, with an annual discount rate of 15%.
Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600
The SCOR model consists of ________. Group of answer choices Bill, deliver, make, plan, source and return Coordinate, deliver, enable, make, source and return Deliver, enable, make, plan, source and return Deliver, finance, make, plan, source and return
Please do not give solution in image formate thanku. Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,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 stock outs 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.
Please help me solve this table. Rockit Electronics manufactures a line of digital blue ray players. The player is made from one subassembly of B and one subassembly of C. B is made of three units of D and two of E. C is made of two units of F and two of E.The blue ray has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks.As the production manager, you need to figure out the MRP planning schedule. 1. What is the bill of materials (product structure tree)?2. If 1,000 units of blue ray players are required in week 10, what is the MRP schedule? Specifically, when items are to be ordered and received. Assume we have no units of inventory on hand.
You are selling a new line of T-shirts on the boardwalk. The selling price will be $25 per shirt. The labor cost is $5 per shirt. The administrative costs of operating the company are estimated to be $60,000 annually, and the sales and marketing expenses are $20,000 a year. Additionally, the cost of materials will be $10 per shirt. What is the break-even quantity? Multiple Choice 2,000 shirts 3,200 shirts 5,334 shirts 8,000 shirts 16,000 shirts

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