A wood products firm uses available time at the end of each week to make goods for stock. Cur- rently, two products on the list of items are produced for stock: a chopping board and a knife holder. Both items require three operations: cutting, gluing, and finishing. The manager of the firm has collected the following data on these products: TIME PER UNIT (minutes) Item Chopping board Knife holder Profit/Unit $2 $6 Cutting 1.4 0.8 Gluing 5 13 Finishing 12 3 The manager has also determined that, during each week, 56 minutes are available for cutting, 650 minutes are available for gluing, and 360 minutes are available for finishing. a. Determine the optimal quantities of the decision variables. b. Which resources are not completely used by your solution? How much of each resource is unused?

A wood products firm uses available time at the end of each week to make goods for stock. Cur- rently, two products on the list of items are produced for stock: a chopping board and a knife holder. Both items require three operations: cutting, gluing, and finishing. The manager of the firm has collected the following data on these products: TIME PER UNIT (minutes) Item Chopping board Knife holder Profit/Unit $2 $6 Cutting 1.4 0.8 Gluing 5 13 Finishing 12 3 The manager has also determined that, during each week, 56 minutes are available for cutting, 650 minutes are available for gluing, and 360 minutes are available for finishing. a. Determine the optimal quantities of the decision variables. b. Which resources are not completely used by your solution? How much of each resource is unused?

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

Related questions

Q: d) Cost of the fifth unit = ? (round your response to the nearaest whole number. (How do I find…

A: Given-Time taken for the Third plane = 20000 hoursLearning curve = 80%Labor charge (Per Hour) = $40

Q: POP displays, without text catalogs, leaflets, cloth banners, brochures, electronic hoardings,…

A: Advertising is a promotional tool or a marketing communication !means wherein an organization…

Q: Problem 12-3 (Static) A large bakery buys flour In 25-pound bags. The bakery uses an average of…

A: Annual Demand = D = 1215 bags Ordering Cost = S = $10 Annual carrying cost per bag = $75

Q: Question 1 Rangaswamy owns 50 acres of land in the Hassan district of Karnataka on which he grows…

A: From the given data, the following excel model can be formulated. Excel model:

Q: . Which of the following is correct?

A: Decision making is a process of choosing optimal alternative of action from a list using all…

Q: (Write your response to the customer as if you were a COp at Monzo who had just picked up a call…

A: Customer queries and concerns should be resolved by the firm at any cost. It enhances goodwill.…

Q: Describe each component. What are the five functions that these components provide

A: The five components of an m-commerce system are: Mobile device: This is the device that customers…

Q: Cornell method example

A: Taking notes is of the best practices followed by people at various stages for various purposes.…

Q: Use Visio to make flow chart for a Amazon Web Ordering System

A: Please find the attached flowchart of Amazon web based order.

Q: 11) Jackson Sheds has four different warehouse configurations under study, ranging from four…

A: 4 warehouse configurations are available = 4 ,5 ,6 and 7Capacity of each warehouse = 300…

Q: 8. The Surgery Unit of Piedmont has determined that the annual demand for surgical gloves is 25,000…

A: Note: - Since we can answer only one specific question at a time we will answer question 8 here.…

Q: based on type, major appliances have life spans of 7 to 15 years, with refrigerators having the…

A: * Yes it is truly mentioned that most of the Major appliances have a life span of 7 to 15 years ,…

Q: 36. Describe how a well-planned receiving and storage program contributes to cost and quality…

A: Inventory management is the art of overseeing the flow of goods and materials within a business. It…

Q: *5. BagBoy makes a popular model pull cart for golfers. The company wants to determine the upcoming…

A: Now, let's solve this problem using Excel Solver. (a) **Interpretation of the solution:** The…

Q: "Standard tickets for Beyonce’s Renaissance tour went on sale in the UK for a price of £56 in…

A: The statement by the Ticketmaster spokesperson suggests that the demand for Beyonce’s Renaissance…

Q: C&A Pens produces three kinds of ink pens: red, black, and blue. The data on these products are…

A: The effectiveness and efficiency with which a business or organization uses its resources and…

Q: To finance a vacation in 4 years, Elsie saves $410 at the beginning of every six months in an…

A: Compound interest is a concept in finance that refers to the interest calculated on the initial…

Q: For managers to make decisions, they need to look at data over a long period of time. This type of…

A: We all know that in order to make a decision, the managers need knowledge. In case of massive data…

Q: Safety stock and service levels are positively correlated. True False

A: The correct answer is False

Q: The Johnsons are celebrating their honeymoon at your hotel and have the honeymoon suite with…

A: In the hospitality industry, providing personalized services and amenities can significantly enhance…

Q: racy and precision of classificatio

A: The logistic regression model comprises output probabilities, it is necessary to choose a cutoff…

Q: What are the 4vs of Sainsbury and Sainsbury local

A: Sainsbury's and Sainsbury Local, they both are one of the most famous supermarket chains in the UK.…

Question

Need a and b

II. A wood products firm uses available time at the end of each week to make goods for stock. Cur-
rently, two products on the list of items are produced for stock: a chopping board and a knife holder.
Both items require three operations: cutting, gluing, and finishing. The manager of the firm has
collected the following data on these products:
TIME PER UNIT (minutes)
Item
Chopping board
Knife holder
Profit/Unit
$2
$6
Cutting
1.4
0.8
Gluing
5
13
Finishing
12
3
The manager has also determined that, during each week, 56 minutes are available for cutting,
650 minutes are available for gluing, and 360 minutes are available for finishing.
a. Determine the optimal quantities of the decision variables.
b. Which resources are not completely used by your solution? How much of each resource is
unused?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Formulate linear program

VIEW

Step 2: Solve using excel

VIEW

Step 3: Find unused hrs

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

19 Examples of this include golf clubs, skis, beverages, auto parts, and services sold by the firm. Multiple Choice Information Explicit services Facilitating goods Supporting facility Implicit services
its not graded assignment question
Required Information [The following information applies to the questions displayed below.] Professor John Morton has just been appointed chairperson of the Finance Department at Westland University. In reviewing the department's cost records, Professor Morton found the following total cost associated with Finance 101 over the last five terms: Term Fall, last year winter, last year Summer, last year Fall, this year winter, this year Professor Morton knows there are some variable costs, such as amounts paid to graduate assistants, associated with the course. He would like to have the variable and fixed costs separated for planning purposes. Total Cost (in dollars) 16,000 14,000 12,000 10,000 Required: 1. Prepare a scattergraph plot. (Plot total cost on the vertical axis and number of sections offered on the horizontal axis.) Instructions: 1. On the graph below, use the point tool (Fall last year) to plot number of sections offered on the horizontal axis and total cost on the vertical…
56 Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every five weeks to take orders. Because the orders are shipped directly from Italy, they take four weeks to arrive. Charlie's Pizza uses an average of 250 pounds of pepperoni each week, with a standard deviation of 10 pounds. Charlie's prides itself on offering only the best-quality ingredients and a high level of service, so it wants to ensure a 99 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 490 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would vou order? Note: Use Excel's NORM.S.INV( function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.
5. (Scenario Based Question) Your response to Simeon's phonecall: Hello, I need to speak to a manager now! Netflix has taken money out of my account when I cancelled the subscription ages ago. They have still charged me for their services. This has left me with no money. This is fraud! I need this money refunded straight away otherwise I will not be able to afford groceries for my kids this week. Please refund this money now! * (Write your response to the customer as if you were a COP at Monzo talking to Simeon, for example "Hi Simeon....". Show us your empathy and analytical problem solving skills, and how by being customer centric you'd help get the customer to a logical solution in this scenario
A refrigerator is classified as which type of product? Question 3 options: a) Convenience b) Shopping c) Specialty d) Unsought
WindCo Inc. owns several delivery vans that could be sold very quickly in the event that the company runs into financial trouble. These delivery vans should be considered ______. Question 38 options: A) long-term assets B) fixed assets C) current assets D) current liabilities E) accounts receivable
true or false 3 The same person requires different combinations of products and service depending on the occasion.
Pls help ASAP
Ultimately, _________ was replaced by the _________ on January 1st 1995. Question 2Answer a. GATS, WTO b. WTO, GATT c. IMF, GATT d. GATT, WTO
(Revenue Mgmt) Donut Shop Donna's Delicious Donuts (DDD) produces 380 donuts each morning. There are 3 flavors of glaze Donna coats the donuts with: Regular Glaze, Chocolate Glaze, and Blueberry Glaze. Tommy of Tommy's Terrific Tours (TTT) called Donna and said he wants to bring his tour bus by DDD at 11:00am tomorrow. Normally, DDD has sold out of donuts by 11:00am, but Donna told Tommy she would hold back at least 30% of all donuts made that morning until the tour bus arrived. In addition, she said she would give tour customers a 20% discount off of the regular price. Donna has only enough blueberry glaze on hand to make 90 blueberry glaze donuts.lq 100 The table below shows the prices and maximum demand for the different options. Develop and solve an LP model to maximize revenues for DDD on the day the tour bus arrives. (Include Ranges.) What is her maximized amount of revenues? How many total regular glaze, chocolate glaze, and blueberry glaze donuts will she make? How many regular…
Please answer all parts