The Woodworks Company produces a variety of custom-designed wood furniture, made from either cherry or oak. The company knows that wood prices and labor costs are likely to increase in the future. The table below shows the number of board-feet and labor hours required for a bookshelf, the current costs per board-foot and labor hour, and the anticipated annual increases in these costs.Build a spreadsheet model that enables the company to experiment with the growth rates in wood and labor costs so that a manager can see, both numerically and graphically, how the costs of bookshelves vary in the next few years.ResourceCherryOakLaborRequired per Bookshelf303016Current Unit Cost$5.50$4.30$18.50Anticipated Annual Cost Increase2.40%1.70%1.50%

The Vandelay furniture company makes bookshelves and tables.Consider the following Linear Programming Model:          X1 = the number of bookshelves made in a day.          X2 = the number of tables made in a day.          Maximize:  Z = 50X1 +50X2       Profit  ($)          Subject to:                   20X1 + 11X2 <= 100          Labor  (hours)                   7.1X1 + 10X2 <= 50            Lumber  (board-feet)What's the lowest profit on a bookshelf can be, without changing the optimal solution?Another way to ask this is, what's the lower bound on the sensitivity range for C1?(Round your answer to 1 decimal place.)

Mr. Carpenter devotes his working time to producing tables and chairs. An increase in the demand for chairs will result in aan increase in the amount of time he devotes to producing tables ba decrease in his total revenue ca decrease in the price of chairs dan increase in his opportunity cost of producing tables ea decrease in the price of lumber

A craft furniture manufacturer produces round kitchen tables (X1) and matching chairs (X2) in its workshop from 600 board feet of oak.  Each table requires 30 hours of labor and each chair requires 18 hours, and there are 480 hours of labor available.  Each table requires 40 board feet and each chair requires 15 board feet.  A table provides $575 in profit and each chair provides $120 in profit.  In the integer programming model formulation for this problem, if each table requires 6 chairs to go with it, but additional chairs can be made and sold separately, this constraint, in proper form for computer solution, could be written as:Group of answer choices6X1 + X2  0X1 + 6X2  06X1 – X2  0X1 + X2 6

A wholesale furniture company wants to design a data warehouse for the analysis of the company’s situation with respect to the Furniture, Customers and Time. Moreover, the company needs to analyse:• the furniture with respect to its type (chair, table, wardrobe, cabinet. . . ), category (kitchen, living room, bedroom, bathroom, office. . . ) and material (wood, marble. . . )• the customers with respect to their location, by considering at least cities, regions and statesThe main objective of the company is to know at least the quantity, income and discount of its sales.2|Pagea) Identify facts, measures and dimensions to satisfy the main objectives of the company.b) Design a FACT CONSTELLATION schema to analyse the company’s above needs.

Required informationSkip to questionScaling-Up an Up-Scale Customer Furniture Business This activity is important because there are many different types of businesses that must consider how to manage their operations. This activity highlights the challenges faced by a small customer furniture business in trying to produce enough supply to meet the growing customer demand. Supply is defined as the number of products that businesses are willing to sell at different prices at a specific time. Demand represents the number of goods and services that consumers are willing to buy at different prices at a specific time. In this example, the demand for a product has surpassed a company’s ability to supply the product, and the owner must decide how to manage operations to produce more supply. The goal of this exercise is to demonstrate your understanding of operations management, including planning operations systems and managing the supply chain. Read the case and then answer the questions that follow. Bruce could only attribute his company’s success to luck. His business started as a side project to sell handmade dining room sets at a local farmer’s market. He had created a special finish made from a mixture of varnish and oils and finished in a high temperature in a special industrial oven. The furniture had a unique look, and he originally pursued the business in his spare time. Partially due to Bruce’s gregarious personality, and partially due to a featured article in a local design magazine, Bruce’s furniture was in high-demand by regional customers and was starting to get requests from national and international designers. He could charge more and service custom orders for international clients, but he also wanted to be able to provide affordable furniture to local customers. After all, it was the loyalty of local customers and designers that built his business, and he wanted to be able to continue to fulfill their needs. He found himself embarrassingly behind in order fulfillment. That is, during the summer months when there were frequent orders from individuals seeing his work at the Farmer’s Market, he hated to turn down business. He found himself taking as many orders as he could, then being unable to deliver on his estimated times for completion. Bruce hired a team of craftsman so that he could produce more furniture, but still found himself unable to meet demand. The craftsman were in short supply – he needed individuals who were able to lift heavy equipment and pieces, but also able to do the delicate work necessary to complete the furniture. While he was able to find capable people, many of them needed extensive training in carpentry and woodwork, especially to complete the breadth of tasks necessary to see a piece of furniture built from beginning to end. In addition, Bruce felt like he had to have complete oversight of the purchasing process. For the process to work, it was necessary that the right types of varnishes be paired with the accurate types of wood. Bruce had trouble making sure that he had the supplies he needed so that his craftsman could move quickly on fulfilling orders. Bruce was grateful for the popularity of the furniture he produced but struggled with how to create enough supply to meet his customers' demand.Bruce noticed that the new craftsmen were beginning to understand how to do each process but appeared to be unsure of the order of the processes for different types of furniture. Bruce should engage in which of the following components of operations management?Multiple Choiceschedulingstandardizationroutingcustomizationjust-in-time inventory planning