QUESTION #2The Kitchen Company manufactures two products: upper Wood cabinets and lower countertops cabinets,which are handled in five departments: cut Wood, cut Stone, sanding, finishing, and assembly. Cabinets aremade of bare Wood. Countertops necessitate the use of Wood and Stone. Adhesive and nails are available andconstitute a very little cost that is factored into operating costs. The table below lists the precise criteria foreach product.Resource or Activity &(Quantity available per month)Required per Upper Cabinets10 board ft @ $10 = $100Wood (4,300 board feet)Stone (2,500 yards)Cut Wood (280 hours)Cut Stone (140 hours)Sand (280 hours)Finish (140 hours)Assemble (700 hours)90 minutesThe Company's operating expenses are $75,000 per month. Based on current demand, the company can sell300 Cabinets and 180 Counters per month. Sales prices are $300 for Cabinets and $500 for Counters.Required:30 minutes30 minutes20 minutesRequired per Counters Cabinets60 minutes7.5 board ft @ $10 = $7510 yards @ 17.50 = $17520 minutes20 minutes10 minutes30 minutes1. Determine Kitchen Company's constraint.2. Determine the throughput per minute of the constrained resource for each product.3. Determine the product mix needed to maximize throughput, i.e., the number of Cabinets andCounters that should be produced per month.4. Determine the maximum net income per month for Kitchen Company.5. Suppose Kitchen Company broke the current constraint resource. What would become the newconstraint?

Assume decision variables as follows: Upper cabinets = X Counters cabinets =Y Given: Operating…

Answered: The Kitchen Company manufactures two…

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

Question 3: A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Use Excel Solver to solve the problem (provide exact values for all variables and the optimal objective function).
Question 1: A company that runs a chain of beauty parlours across India and also retails make-up, has defined its core competencies as value creation for the customer, commitment to product quality and professionalism. Identify at least 3 micro competencies under each of the above, which all employees need to exhibit and explain the relevance of each. Question: 2 Tarun is the Business Head for a hardware manufacturing company. Som is the Production Head, in the same salary band as Tarun. How do their roles differ? What are the similarities in their roles?
Question: Develop a problem statement for the scenario given below by considering the variables involved? Suppose you are a manager of a beverage company. You have recently witnessed a sudden decrease in sales. It has been widely accepted that due to Covid-19, the purchasing power of consumers has been declined. On the other hand in such situations, sales personnel avoid roaming for selling to avoid contact. The sudden decrease in the number of hours work and alternate shifts due to Covid-19 SOPs also resulted in a low-profit margin. You have to figure out the actual reason for the decline in sales as a manager.
Question 4An investor is to purchase one of three types of real estate, as illustrated in Figure below. Theinvestor must decide among an apartment building, an office building, and a warehouse. Thefuture states of nature that will determine how much profit the investor will make are goodeconomic conditions and poor economic conditions. The profits that will result from eachdecision in the event of each state of nature are shown in Table below: a) Find the optimal act using Maxi-Max criteriab) Find the optimal act using Mini-Max criteria c) Find the optimal act using Maxi-Min criteria d) Find the optimal act using Min-Max regret table
Question: A renowned multinational shipping company is opening its new branch office in Lahore. You are working in the company as IT Manager. Your Chief Information Officer (CIO) have nominated you as the project manager for deploying IT infrastructure in the new office. During the project, you need to procure 20 boxes (1000 feet each) of Cat 6 Network Cables, 150 Information Outlets (I/O’s), 150 faceplates, 150 back boxes, 4 Patch panels (24 ports each), 4 Cable Managers and One communication rack. The company you are working for is a multinational company and has a very strict procurement procedure and procurement audit is mandatory at the end of the project. What steps you should follow for procurement of these items for your project. You also need to develop the Bill of Quantity (BOQ) of the products that you want to procure. Also develop a Purchase order for the same.
QUESTION THREEa) Zambia Breweries has a backlog of 250 crates of Fanta drinks at the end of December. The demand of Fanta drinks is expected to be 400 crates in January, 500 crates in February and 550 crates in March. Each worker can produce 50 crates of drinks per month with regular wage costing the company K10 000 per worker per month. Hiring cost has been calculated to be K25 000 per. Hiring cost has also been calculated to be K50 000 per worker. Backlog cost have been determined to cost the company K250 per worker. There are no cost associated with carrying the inventory. Develop a level of production plan (aggregate plan) and determine the cost. b) Explain why aggregate planning is necessary in production and operation management.c) Define the meaning and what happens at each of these aggregate capacity planning;i) Matching Demand approachii) Level Capacity approach.
Question 2 Mike is a first year university student who is trying to understand his financial situation. Mike currently lives 1.5 miles away from campus. He works part time in a retail centre that pays him £800 per month. Mike saves £200 out of the part time job pay for his further education plan. a). As to the below Travel Expenses table published by the Students’ Union, 185 students were randomly selected to help understand the travel expenses and distance to campus. What’s the probability for Mike to spend over £10 on journeys to campus? Distance to Campus (miles) Amount spent, £ 0.1 to 0.25 0.26 to 1.0 Over 1.0 0 – 4.99 35 26 10 5.00 – 9.99 18 39 20 10.00+ 4 14 19 b). How much is the frequency for students living over 1 mile away from the campus? c). As to the category of Amount Spent, £, what is the modal group? d). Assuming Mike is saving the same amount per month in the next 3 years. How much does Mike get for his saving…
Question 1 A company manufactures two types of boxes, corrugated and ordinary cartons. The boxes undergo two major processes: cutting and pinning operations. The profits per unit are $6 and $4 respectively. Each corrugated box requires 2 minutes for cutting and each carton requires 3 minutes for cutting, whereas each corrugated box requires 2 minutes for pinning and each carton requires 1 minute for pinning. The available cutting time is 120 minutes and total pinning time is 60 minutes. Determine the optimum quantities of the two boxes to maximize the profits. a. Formulate a linear programming model that can be used to determine the quantities of the two boxes that should be produced in order to maximize total profit contribution.b. Graph the feasible region.c. Determine the coordinates of each extreme point.
Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. • The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts.• The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts.The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it.
Question #4 - Jerry Smith is thinking about opening a bicycle shop in his hometown. Jerry loves to take his own bike on 50-mile trips with his friends, but he believes that any small business should be started only if there is a good chance of making a profit. Jerry can open a small shop, a large shop, or no shop at all. The profits will depend on the size of the shop and whether the market is favorable or unfavorable for his products. Because there will be a 5-year lease on the building that Jerry is thinking about using, he wants to make sure that he makes the correct decision. Jerry is also thinking about hiring his old marketing professor to conduct a marketing research study. If the study is conducted, the study could be favorable (i.e., predicting a favorable market) or unfavorable (i.e., predicting an unfavorable market). Develop a decision tree for Jerry.
Question 2: Mr. K’s is a very popular hair salon. It offers high-quality hairstyling and physical relaxation services at a reasonable price, so it always has unlimited demand. The service process includes five activities that are conducted in the sequence described next (the time required for each activity is shown in parentheses):● Activity 1: Welcome a guest and offer homemade herb tea (13 minutes).● Activity 2: Wash and condition hair (13 minutes).● Activity 3: Neck, shoulder, and back stress-release massage (13 minutes).● Activity 4: Design the hairstyle and do the hair (28 minutes).● Activity 5: Check out the guest (12 minutes).Three servers (S1, S2, and S3) offer the services in a worker-paced line. The assignment of tasks to servers is the following: S1 does Activity 1, S2 does activities 2 and 3, and S3 does activities 4 and 5.
Question: Courtesy Calls makes telephone calls for businesses and charities. A profit of $0.50 is made for each business call and $0.40 for each charity call. It takes 4 min (on average) to make a business call and 6 min (on average) to make a charity call. If there are 240 min of calling time to be distributed each day, how should that time be spent so that Courtesy Calls makes a maximum profit? What changes, if any, occur in the maximum profit and optimal production policy if they must make at least 12 business and 10 charity calls every day?

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