Please do this in excel Cobonque Furniture Enterprises is a known maker of fine hand-crafted furniture in Davao del Sur. During the nextproduction period, management is considering producing dining room tables, dining room chairs, and/or bookcases.The time required for each item to go through the two stages of production (assembly and finishing), the amount ofwood required (fine cherry wood), and the corresponding unit profits are given in the following table, along with theamount of each resource available in the upcoming production period.Assembly (minutes)Finishing (minutes)Wood (pounds)Unit Profita.Tablesb.803080P360Chairs402010P125Bookcases503050P300Available810045001. Develop a linear programming model to determine the production levels that would maximize profit.2. Taking the optimal solution obtained, prepare the corresponding sensitivity report and address the following:9000Suppose the profit per chair increases by 100. Will this change the optimal production quantities?Explain the change in total profit.Should the profit per table increase by 100 will this change the optimal production quantities? Whatcan be said about the change in total profit?

Decision Variable:Suppose-T be the no. of units of tables to be producedC be the no. of units of…

Answered: Cobonque Furniture Enterprises is a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Mr. Zulhakim being assigned by his manager to develop their production planning for Year 2022. Table 3 shows the information that he able to obtain from the sales & marketing department. After doing the planning, Mr Zulhakim need to present it to his manager. Factory developed a demand forecast based on Table 3 with supplier charges about RM300.00 per unit. The demand forecast is stated as week but, in this planning, it is being considered as an annual quantity for the operation. Ordering cost is RM150.00. Annual holding cost is 10 percent of a purchased price. (b) Develop the ATP of this plan. Initial inventory on hand is 50 units obtained from Year 2021. Lot size for MPS can be obtained by using EOQ model. Table 3: Demand and Customer confirmed order quantity 8 9 10 2 3 10 40 10 00 30 20 40 20 30 Period (Week) 1 4 5 6 7 Forecast (units) Customer orders (booked) (unit) 20 8. 2
9/Samsung Company is producing Laptops and Tablets. They are deciding whether to use job-order costing or activity based costing. Based on next year’s budget, two cost pools have been developed with the following information: Particulars Laptops Tablets Overhead Assigned Direct labor hours 5000 10000 Sewing machine hours 500 300 OMR 400,000 Machine set up hours 100 400 OMR 200,000 Find out the pre-determined overhead rate if overhead is applied based on the direct labor hour rate. a. OMR 400 per hour b. OMR 40 per hour c. OMR 4 per hour d. OMR 4000 per hour
The current data for five trees that will be analyzed in the exercise are shown in the following table Expected Yearly Demand Quantity For Sale In-Field Quantity 440 74 Trees Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo 81 165 159 49 185 Trees Christmas Palm Washingtonia Std Dev 31 155 35 32 68 Gumbo Limbo Yellow Poinciana The "expected yearly demand" is an estimate of the demand over the next year for the tree. The "std dev" is the standard deviation, a measure of the error, that corresponds to the forecast. For-sale and in-field quantities are given, and finally the total number of trees planted on the farm. The demand forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm. 374 70 42 290 Your first task is to evaluate the inventory "position" of each tree. The farm does not keep any backorder information, so the only data you have is "for-sale" and "in-field" quantities. Think about "for-sale" as on-hand trees, and…
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
Exercise 3 Costs for a month in which it produced 800 units. The production manager was asked to review these costs and provide her best guess as to how they should be categorized. He responded with the following information: Total Costs Variable Costs Fixed Costs Material used in Production OMR 420000 420000 Labour, used in Production 214000 100000 114000 (Assembly and supervisor) Production Facilities cost( rent 115000 90000 250000 „Insurance, Utilities,.) Total production cost 749000 610000 139000 Required: A. Describe the production costs in the equation form Y = f + vX B. Assume Company intends to produce 1200 units next month. Calculate total production costs for the month.
1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…
Please provide me the brief analysis of this - Sheri has been employed as a limo driver in the past but is currently working as a Lyft and DoorDash driver. In discussion with Keon, she grew excited and mentioned she would love to work with him. Since one of the current drivers is retiring, Keon believes he can hire her on a part-time basis for $20,000 a year. Based on current numbers (with no driver on salary), this would be a 8% reduction in operating cost for one limo. However, Keon wants more advice on hiring Sheri on salary versus paying her hourly. Sheri is also quite talented with marketing and using social media. Keon believes she can have the same impact as spending $1,000 a month for advertising. Keon is wondering if he should offer her a business partnership deal. He would give her 40% of the business if she invested $30,000 and worked full-time as a driver/marketer. Keon wants a detailed analysis on this business partnership idea, including general pros and cons of running a…
A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 500 units per month can be used. Backorders are allowed, and they are charged at the rate of $20 per unit per month. Inventory holding costs are $1 per unit per month in ending inventory. Determine the cost of this plan if regular time cost is $10 per unit and beginning inventory is zero. Overtime costs $16 per unit and subcontracting costs $20 per unit. In the 4th month, overtime is not possible. While outsourcing is not possible in the 3rd month. Overtime capacity is 50 units and subcontracting capacity is 50 units. Month Forecast 1 400 2 480 3 560 4 720 5…
A manager has prepared a forecast of expected aggregate demand for the next six months. Develop an aggregate plan to meet this demand given this additional information: A level production rate of 1000 units per month can be used. Backorders are allowed, and they are charged at the rate of $20 per unit per month. Inventory holding costs are $1 per unit per month in ending inventory. Determine the cost of this plan if regular time cost is $10 per unit and beginning inventory is zero. Overtime costs $16 per unit and subcontracting costs $20 per unit. In the 4th month, overtime is not possible. While outsourcing is not allowed in the 3rd month. Overtime capacity is 100 units and subcontracting capacity is 100 units per month. Month Forecast 1 800 2 960 3 1120 4 1440 5…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

SEE MORE TEXTBOOKS