The production planning period for the flat-screen monitors an electronic manufacturing. Regular time cost per monitor Overtime cost per monitor Subcontract cost per monitor Back order cost Carrying cost per monitor per month Demand Capacity Regular Overtime Subcontract Month 1 2,000 1,600 400 600 Month 2 2,500 1,700 400 600 $85 $100 $110 $10 $5 Month 3 2,300 850 200 600 Month 4 2,100 1,450 400 800 The electronics manufacturing expects to enter the planning period with 500 monitors in stock. Develop a production plan that minimizes the cost. Management wants to prioritize filling in months of demand immediately.

The production planning period for the flat-screen monitors an electronic manufacturing. Regular time cost per monitor Overtime cost per monitor Subcontract cost per monitor Back order cost Carrying cost per monitor per month Demand Capacity Regular Overtime Subcontract Month 1 2,000 1,600 400 600 Month 2 2,500 1,700 400 600 $85 $100 $110 $10 $5 Month 3 2,300 850 200 600 Month 4 2,100 1,450 400 800 The electronics manufacturing expects to enter the planning period with 500 monitors in stock. Develop a production plan that minimizes the cost. Management wants to prioritize filling in months of demand immediately.

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

Demand(box) 10 11 12 13 14 15 and and more less Possibility 0.1 0.18 0.26 0.24 0.12 0.1 A business that will open a gift shop in Los Angeles is considering making and selling love- themed magnets. It is thought that it will not be possible to order new magnets during the fair period, and magnets that are not sold during the fair period will not be sold later. A box of magnets costs the business $100 and generates $460 from its sale. The table includes predictions about demand probabilities. a-) What is the overstocking cost of the business in dollars/box? b-) How many dollars/box is the missing stocking cost?
Answer 12.7a-c Please show detailed calculations or software output
Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
Please do not give solution in image format thanku Opening Stock: 120 units Desired Closing Stock : 1200 units Back order Costs : $ 100/ unit In-house production costs : $ 60 per unit Subcontract Production costs : $ 81 per unit Inventory Holding costs : $ 15 / unit/ month Production Capacity: 30 units per month per worker There are currently 150 workers employed Hiring Costs 500$ per worker Firing Costs 1000$ per worker Month 1 2 3 4 5 6 Demand forecast 3780 5040 6720 5460 5040 4200 What is the cost for following Level, Chase and Subcontract strategies?
Grouping revenue by different classifications is an effective method for managers to use the information to plan and to control. What term is described as "tend to occur most often in special programs where volume is critical to survival of the program"?
at is the inventory turnover for last year? is at is is oved More Info Sales Cost of goods sold Gross margin Other expenses Net income Finished goods inventory Work-in-process inventory Raw material inventory Total inventory (average for year) Other current assets Other assets Total assets LAST YEAR $244,000 118,000 126,000 Done 51,000 75,000 0 2,000 9,500 4,000 15,500 90,000. 200,000 305,500 . THIS YEAR $257,000 130,000 127,000 51,000 76,000 4,500 12,000 5,500 22,000 109,000 244,000 375,000 - X
Which of the following terms describes: "the flow of goods, services, and information from the initial sources of materials and services to the delivery of products to consumers"? a. enterprise resource planning (ERP). b. customer list. c. supply chain. d. material requirements planning (MRP).
Supply/Demand Info Predicted Sales Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/ton Subcontracting costiton Holding cost ton/month Hiring cost employee Firing cost/employee Beginning Apr May 4,200 531 $20 $32 $25 $10 $3.700 $4.000 Jun 51,500 50.300 61,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) Max overtime production (tons/month) Max subcontractor production (tons/month) 3 100 56,700 3,700 6,000 Jul Aug Sep 45,400 56.600 62,800 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular…
Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
1.The managers of Kai’s Catering want to increase the number of events booked by 20%. To accomplish this, a(n) ________ was established to include clear weekly targets for number of deposits received. Multiple Choice means-end chain operating plan strategic plan scenario analysis 2. Prior to Apple’s debut of the iPhone, Microsoft was also working on a revolutionary smart phone. Microsoft was already one of the world’s leading technology companies with thousands of engineers and designers with hundreds of millions of dollars for their R&D budget. Despite having a solid strategy and adequate resources, Microsoft derailed cross-departmental cooperation, perpetuated unhealthy competition among its employees, and ultimately Multiple Choice closed the business due to a labor strike. failed to implement its strategy. developed a competitive advantage in smart phones. fired Bill Gates. 3. You receive a memo that reads as follows: “In recent months, our customer evaluations have…
Well water inc. wants to produce and sell a new flavored water in order topenetrate the market, the product will have to sell at 2.60 per 12 oz bottle thefollowing data has been collected: Annual sales 50,000 bottlesProjected selling and administrative costs 8,000Desired profit 80,000The target cost per bottle is _____ per bottle (2 decimal places)
Inventory Management You are the store manager at a local branch of DigiLife, a large electronics retail chain. A new version of a popular consumer electronics device called the Amulet is coming out this year. It is your job to sell as many Amulets as you can while minimizing your costs in order to maximize your store's profits. Your Goal Earn $1,000,000 in net profits of Amulet sales.