Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory, selling price, and Bill of Materials (recipe, or construction requirements). You are to determine the number of Tables and Chairs to be built to maximize revenue. Your answer will be the amount of small wood pieces used by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.) Use Scenario 5 Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Large wood per Table 1 Small wood per Table 3 Large wood per Chair 1 Small wood per Chair 4 Revenue per Table $27 Revenue per Chair $17 Large wood inventory 85 Small wood inventory 80 2 3₂ 2 4 $23 $16 90 50 223 3 $29 $19 100 50 333 4 $18 $21 80 130 552 1 6 $48 $43 200 190
Q: The Ace Manufacturing Company has orders for three similar products. Orders (units) Product Min A…
A: Given data is
Q: Dave's latest start (LS) and latest finish (LF) are: Activity H LS 13 LF
A: Steps to find LS and LF: Start from the end and take LF same as EF of the ending activity, that is,…
Q: Why would demand forecasting make sense in a “make to stock” situation?
A: Make to stock is a strategy in production where most of the companies employ to match the consumer…
Q: A firm is considering a product launch. It will do so if the expected total revenue is in excess of…
A: The expected value is the sum of all possible values weighted by their probability.
Q: Draw BOTH the arrow and node networks for the project given in the table. Activity IPA H C, D I D J…
A: The path with the longest duration is the critical path.
Q: s defined as that complex wholewhich includes knowledge, beliefs, arts, morals, law, customs, and…
A: A man in a society acquires knowledge, beliefs, art, morals and customs from its culture. Morality…
Q: How would you determine which orders have not yet been shipped to the customer?
A: To find out which orders haven't been delivered to the client yet, we can see the Order table. The…
Q: What are some examples of code of conduct?
A: The term code of conduct can be understood as a couple of principals which are laid down by the…
Q: A linear programming computer package is needed. Epsilon Airlines services predominately the eastern…
A: Decision Variable: Suppose-Xi be the no. of call-center employees who start work on day i where i…
Q: Calculate the inventory carrying cost if weekly demand is 150 units, the value of the item is $70…
A: Inventory carrying cost identify the all unsold expense of the company. Weekly demand = 150 units…
Q: Coordination is a process to achieve unity of action. In light of this statement discuss the…
A: Coordination is simply the sync between different employees and groups to work together in harmony…
Q: The following is a table of activities associated with a project at Ratay Ishfaq's software firm in…
A: Given data:
Q: MI’s Pulse of the Profession Reportin 2016states that Organizations waste $97 million for every $1…
A: Formed in 1969, Project Management Institute (PMI) is not-for-profit professional organization…
Q: A group is planning to back the production of a new musical at Lusaka Playhouse. It would cost K100…
A: One can calculate the expected value for a decision tree by multiplying each node's probability and…
Q: mplications of safety stock and reorder poin
A: Safety stock is a concept that has been around for a few decades. It was first introduced as…
Q: Identify the two ways for reducing product costs to a predetermined level. Which is more widespread…
A: Two ways for reducing product cost: Obviously, the objective of costing approaches is to eliminate…
Q: The following table lists the components needed to assemble an end item, lead times (in weeks), and…
A: An MRP plan helps to keep the inventory levels optimal. Optimal inventory level helps to reduce the…
Q: What are dimensions of a product quality?
A: Note - Hi! Thank you for the question As per the honour code, We’ll answer the first question since…
Q: salary compared to putting up your own business with uncertainty of being successful.
A: Some people stereotype business owners as leaders and staff as followers. However, there are…
Q: Which one is a typical social/economic benefit for transport infrastructure development plans?…
A: Introduction :Transport infrastructure development plans is an essential part of the transport…
Q: A.) Compute the 3-period simple moving average forecasts. Compute the MAD and MSE for the 4-period…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: A bicycle component manufacturer produces hubs for bike wheels. Two processes are possible for…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Provide an example to distinguish strategy from strategic plan.
A: The strategy is not so very different from a strategic plan. A strategy is when the expert team…
Q: What advantages can project management collaboration tools offer?
A: Project management collaboration tool is a software system which facilitate the effective…
Q: Dave Fletcher was able to determine the activity times for constructing h ser scanning machine.…
A: 1. During forward pass in case of more than two preceding activities the early start will be…
Q: a. What is the alternative that provides the factory the greatest expected value and what is the EV…
A: Here, from the table, we could see that there are three approaches, Increased capacity, used…
Q: Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory,…
A: Let Table = T and Chair = C For scenrio 3 maximize revenue = 19 T + 19 C subject to 2T +…
Q: The manager of Perrotti's Pizza collects data concerning customer complaints about pizza delivery.…
A: Introduction: Pareto charts are used to plot the data, which is recorded in descending order using…
Q: What is a supply chain? In your view, why did supply chains become global?
A: Operation management often called OM can be stated as the governance of the business practices to…
Q: time-series trend equation is 25.3 + 21x. What is your forecast for period 7? Part 2 A. 172.3…
A: Ans) y = 25.3 + 21x Forecast for period x=7 : x = 7 , y = 25.3+21*7 = 25.3+147 = 172.3
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Given, Appearances Demand 4 4 4 6 6 7 6 5 8 10 6 8
Q: The measure of production that considers historical and estimated future production levels and…
A: Capacity can be stated as the term that defines the production amount that can be authorized to…
Q: How do project management and software development, for instance, differ from one another?
A: Operation management is nothing but the approach of planning and organizing the practices associated…
Q: Do you feel the current system of global supply chains is sustainable? Why or why not?
A: Supply chain sustainability can be stated as the efforts of the organizations to consider the…
Q: Maximize eamings = $0.80xX₁ + $0.40X₂ + $1.20X3 - $0.10X4 subject to X₁ + 2X₂ + X3 +5X = 150 X₂ 4X₂…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Among the various knowledge disciplines, which one presents a sense of fear to a knowledge worker…
A: ‘Knowledge workers’ are employees whose chief capital is knowledge. Examples include GPs,…
Q: Globalization is not without risks. When companies undertake international business, they are…
A: In general, firms engaged in international investments may face substantially higher levels of…
Q: (a) What is the optimal solution and the total profit contribution (in $)? DRB DRW total profit…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: Course: Human resource management Who should be responsible for the selection and evaluation of the…
A: Human resource management often called HRM can be stated as the approach of hiring or employing…
Q: Which one of the following lists contains one measure of central location and one measure of…
A: A descriptive statistic can be stated as the summary type of quantitative data set. Descriptive…
Q: Give an explanation of risk management ideas.
A: A risk management strategy is a planned method of tackling hazards that may be applied to businesses…
Q: The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this…
A: MAD is the average value of absolute errors and absolute value of the positive values identified in…
Q: Given: Year Demand 1 7 2 9 3 5 4 9 5…
A: Note: - As we can answer only up to three subparts, we will answer the first three(1, 2, and 3)…
Q: Exponential smoothing, =0.2 and forecast for Year 1 = 5 Linear trend Which forecast method has the…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. Business…
Q: Critically discuss early project termination within a project organisation.
A: Within a project organization, both the project team and the stakeholders making the decision find…
Q: A company has prepared a design for a new product which it can either sale for K100 000 or develop…
A: The given case is about selecting the course of action from available alternatives. The company has…
Q: GENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 3. The Wisham family lives on…
A: Given data is Selling price($) Baking time Packaging time Unshelled pecans in ounces Pies 5…
Q: Suppose an assignment problem, where there are 3 employees who must perform 3 different tasks. The…
A: Assignment problems are usually solved by assigning man, material, and machine to each job in such a…
Q: On part D, the $600 was wrong. Is there another possible solution?
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Thanks for the answer, but what is the simplest way of calculating and drawing the PERT network…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Step by step
Solved in 4 steps with 5 images
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
- The Big Bang Theory Assume the hours needed to cook a meal or done a basket of laundry are different, and they are described below: 1 MEAL 1 BASKET SHELDON 2 1 LEONARD 1/2 2 1. What is the maximum number of meals Sheldon can produce in 12 hours? What is the maximum number of laundry baskets Sheldon can complete in 12 hours? 2. Plot in a graph: Sheldon’s production possibility frontier. 3: Plot in a graph: Leonard’s production possibility frontier. 4. What is Sheldon’s opportunity cost of one meal (in terms of baskets given up)? What is his opportunity cost of one basket (in terms of meals given up)? 5. Does Leonard have an absolute advantage in producing both meals and baskets? 6. Who has a comparative advantage in cooking? 7. Suppose each person has 12 hours for the two tasks in a week, and suppose both Sheldon and Leonard each spend 6 hours on cooking and 6 hours on laundry. Consider an offer from Leonard to Sheldon: do 3 baskets of laundry for me each week, and I’ll cook you 2…Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. City wants to further develop the model to include the weather conditions of rainy, cloudy, or sunny. Pool Attendance Temperature (°F) Weather Condition 150 89 Sunny 100 82 Rainy 125 81 Cloudy 130 86 Cloudy 155 93 Cloudy 170 98 Sunny 200 99 Sunny 180 87 Sunny 190 88 Sunny 140 83 Sunny 120 82 Cloudy 90 81 Rainy 130 87 Rainy 120 93 Rainy Should you keep weather condition in the model?Calculate the weighted average cost of capital for Foggy Futures Weather Forecasters.The firm is in the 25% tax bracket. The optimal capital structure is listed below:SOURCE OF CAPITAL WEIGHTDebt 20%Preferred Stock 30%Common Stock 50% DebtThe firm can issue $1000 par value, 9% coupon interest bond with a 15 year maturity date. The bond has an average discount of $20 and flotation costs of $30 per bond. The selling price is $1,000Preferred Stock The firm can sell preferred stock with a dividend that is 10% of the current price of $95. The cost of issuing and selling the stock is expected to be $7 per shareCommon Stock The firm's common stock is currently selling for $100 per share. The firm expects to pay cash dividends of $12 per share next year. The dividends have been growing at 8%. The stock was discounted by $7, and the flotation costs amounted to $5 per share.
- Can you show how to put it in Excel? XYZ store sells regular and premium nut mixes. Premium mix contains three quarters pound of cashews and one quarter of peanuts, and the regular mix has half pound of cashews and half pound peanuts per bag. The shop has 200 pounds of cashews and 300 pounds of peanuts to work with. Cashews cost $1.50 per pound, and peanuts cost 60 cents per pound. Premium mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner esimtes that no more than 200 bags of one types can be sold. What is the best combinations of products that maximizes profits? Make sure to create a feasible solution with countable number of products (no partials)Finally, due to budget constraint, your inititial budget of $100,000 has been reduced to $75,000. SET YOUR CONSTRAINTS, DECIDE WHICH AREAS/TASKS BUDGET TO BE ADJUSTED AND USE EXCEL SOLVER TO CREATE YOUR FINAL BUDGET. Submit your plan and your reasoning behind the decisions and why your plan will make the event a success. Excel spreadsheet must show the distribution of your initial budget of $100,000 and your final budget of $75,000 with the constraints you set. Use the the excel spreadsheet image and show constraints.Show cells in excel with step by step using solver and the sum product function show how to calculate weighted risk Wall Street firms commonly use linear programming models to select their bond portfolios. A firm is considering the following 5 bonds: Bond Annual Return rate (%) Risk measure Bond 9.2 5 Bond 5 3 Bond 6.1 2 Bond 3.5 4 Bond 1.2 1 In the table above, “risk measure” has a value between 1 and 5 with 5 indicating the riskiest bond and 1 the least risky bond. The firm has a budget of 1 million dollars for this investment. The firm wants to decide its investments in the 5 bonds to maximize the expected return of the portfolio, subject to constraints listed below: The weighted average risk of the portfolio should not exceed 4. At least 30% of the total investment can be invested in bond 3. To diversify the portfolio, the investment on each bond should be at least 10% of the total investment. The sum of investments made in…
- Assume the maximum demand for Super is 600,000 barrels. What is the optimal maximum profit? Hints: There are six decision variables are as follows: R1: # of barrels of ingredient 1 used in Regular fuel R2: # of barrels of ingredient 2 used in Regular fuel R3: # of barrels of ingredient 3 used in Regular fuel S1: # of barrels of ingredient 1 used in Super fuel S2: # of barrels of ingredient 2 used in Super fuel S3: # of barrels of ingredient 3 used in Super fuel Some calculations you would need in the constraints: The total # of barrels for Regular would be R1+R2+R3. The total # of barrels for Super would be S1+S2+S3. The total # of barrels of Ingredient 1 would be R1+S1. The total # of barrels of Ingredient 2 would be R2+S2. The total # of barrels of Ingredient 3 would be R3+S3.One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. What are three recommendations you have to the VP of operations based on the attached optimal production plan? These three options must be based only on information present in the excel production plan and components of LP modeling [decision variables, objective function (prices and variable cost), and resource constraints].A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.