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. You must make 4 chairs for every table. Your answer will be the revenue generated by your production plan - rounded to the nearest whole dollar. (The number of tables and chairs must be a whole number.) Use Scenario 2 Large wood per Table Small wood per Table Large wood per Chair Small wood per Chair Revenue per Table Revenue per Chair Large wood inventory Small wood inventory Scenario 1 3 2 1 4 $35 $29 300 500 Scenario 2 4 2 2 4 $42 $29 400 500 Scenario 3 2 2 3 3 $88 $45 880 775 Scenario 4 2 4 3 4 $75 $33 665 1,400 Scenario 5 5 2 2 6 $95 $49 900 4,000
Q: #17 FAVORABLE UNFAVORABLE MARKET MARKET EQUIPMENT ( $)…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: The simple linear regression equation that shows the best relationship between the number of…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In business…
Q: PLEASE I ONLY NEED ANSWERS ON 7 AND 8
A: 2. Naïve methodThe naïve method is the simplest forecasting method and just predicts that the value…
Q: Activity A B Ꭰ E F G H Crashed Activity Time 0.25 0.5 1 0.25 2 1 2 0.5 Cost ($) Normal Cras hing 750…
A: Activity Crashed activity time Normal cost Crashing cost A 0.25 750 1000 B 0.5 250 750 C 1 750…
Q: Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average…
A: Note: - As it is specified to answer 2, 3, and 4, we will answer only those. Given data is
Q: Irwin Textile Mills produces two types of cotton cloth—denim and corduroy. Corduroy is a heavier…
A: Let Denim = D and Corduroy = C Maximize profit = 2.25D + 3.10C subject to 5D + 7.5 C <=…
Q: small project consisting of ten activities has the following characteristics: Determine the…
A: Ans) PERT Table Formula: PERT Table Excel Formula: PERT Table Calculation: Arrow on node…
Q: a) Based on the activity time estimates, the expected times and variance for each of the…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: Write your report on the sensitivity analysis of constraints C2 and C3
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Activity Event Immediate 1 2 3 14 5 |6 17 8 development of a new product in your organization. 19 10…
A: Total expected time = (optimistic time +4*most likely time + pessimistic time)/ 6
Q: Which of the following steps for establishing a performance improvement plan involves seeking…
A: A performance improvement plan often called PIP also called as performance action plan can be stated…
Q: 8.- A small construction company specializes in the construction and sale of family homes. The firm…
A: The firm should build a combination of Model A and Model B that would maximize its profits. In this…
Q: discuss the four steps in strategic sourcing process, highlighting how DHL can apply each step to…
A: Strategic Sourcing:- A order for a firm known as "strategic sourcing" integrates data gathering,…
Q: and uncertainty, with u. 10. Using the weighted factor-rating method, which country should Kanga…
A: Given that Criterion Weight(a) Maxico(b) Panama(c) Costa Rica(d) Peru(e) Trust 0.40 1 2 2 1…
Q: Month 1 2 3 4 5 No. of Cases 105 115 120 120 125 Month 6 7 8 9 10 No. of Cases 125 130 140 145 150…
A: Given data is
Q: Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver,…
A: Let, X1S = Reservations to be accepted for type 1 room and super saver rental class X1D =…
Q: Q-The company has kept at one of its plants 24 months records of the total number of failures…
A: Given data-
Q: What's expected to happen to the total exports and the pattern of exports in the next thirty years?
A: IMPACT ON TOTAL EXPORTS IN NEXT THIRTY YEAR the global trade this year recorded was about $7.7…
Q: Describe each of these systems: lean production and mass production
A: Production can be stated as the process of either producing or manufacturing or mining products or…
Q: How can the information security strategy of a corporation be translated into a project plan for…
A: Business keeps their information secret and inaccessible to anyone without proper authorization.…
Q: Travel Co. specializes in trans-American moves for businesses and individuals through the shipment…
A: Break even point Fixed cost = $5000 Variable cost = $0.40/pound Revenue = $0.68/pound
Q: Describe the operations function and the nature of the operations manager's job. NOTE: please refer…
A: the operations consist of different activities which can be of the following types - producing goods…
Q: Yalena Yale has always been proud of her personal investment strategies and has done very well over…
A:
Q: Susan manages the packaging supplies for the New Zealand distributorship of AllBirds product lines.…
A: Given that Annual demand D = 3900 Ordering cost S = 18 Holding cost H = 25% of 2.25 Lead time L = 7…
Q: Enumerate 10 WORDS that automatically mean QUALITY. NOTE: Positive Quality, no need to discuss.
A: Quality comprises of two basic things when defined by companies i.e. Quality of design and Quality…
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: STAR Co. provides paper to smaller companies whose volumes are not large enough to warrant dealing…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Write a detailed summary of Aristopharma Company Overview.
A: ANSWER : Aristopharma Ltd. is one of the main 10 pharmaceutical companies in Bangladesh. The…
Q: f) Which is the best decision rule based on average completion (flow) time? The best decision rule…
A: Scheduling is the process of arranging production activities in order to complete the manufacturing…
Q: W = jars of Western Foods Salsa M = jars of Mexico City Salsa leads to the formulation (units for…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: a. What is the Economic Order Quantity? b. What are the total annual order and inventory-holding…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: Chiltern Farms “[T]he beautiful valley of Vyeboom nestled between the majestic Franschhoek Mountains…
A: Supply chain and logistics is a popular concept that is an efficient network of people, resources,…
Q: Describe the importance of Transportation.
A: In supply chain and operations transportation is the medium for any process to begin or finish.…
Q: Describe how project management software packages may help with project scheduling. Please respond…
A: Every company involves in some project at some point of time. The duration varies from company to…
Q: We live in a world that is sharing fast information all around the world, where travel is becoming…
A: Business environment:- The word "business environment" refers to the entirety or collection of all…
Q: Revenue generated on both the airside and the landside is effectively based on the same driver -…
A: Revenue generated on both the airside and the landside is effectively based on the same driver -…
Q: Describe how project management software packages can help with project scheduling. Please respond…
A: Project management software:- Resources can be planned, organised, and managed with the aid of…
Q: During each four-hour period, the Smalltown police force requires the following number of on-duty…
A: Given data is Time slot Police officers needed Midnight to 4 a.m. 4 4 a.m. to 8 a.m. 4 8…
Q: A company has observed the following demand during the past 10 months for one of its popular…
A: *As per guidelines for multipart questions first three parts are answerable, please repost the…
Q: new shopping mall is considering setting up an information desk manned by one employee. Based upon…
A: Given data: Arrival rateλ = 20 per hour Service rate μ =1 question2 minute…
Q: Conclude a summary and give 3 recommendation on how the company can be success in the new working
A: In the modern world, to give height, success, and growth to the business, an organization require to…
Q: Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory,…
A: The question stated to use scenario 2.
Q: Explain why earned value management (EVM) is not used more often
A: Earned value management often called EVM can be stated as the project management performance tools…
Q: business location
A: The following factors must be taken into account when choosing a location or area where business…
Q: Name an organization, business, or public service center that is customer-centric. Explain your…
A: Customer-centric often called client-centric can be stated as the strategy of performing business…
Q: A manufacture produces 16 oz bread loaves that must measure within the the specification 16 ±0.860z.…
A: Solution UCL = 16+0.86 = 16.86 LCL = 16-0.86 = 15.14 For 3.2 quality rating use 3 sigma quality…
Q: An assembly department has six jobs waiting to be processed. It is now time zero and all jobs are…
A:
Q: QUESTION 4 a) Assess and discuss the benefits of in-house vs. contracting out maintenance works in…
A: Note: - Since the exact to be answered is not specified, we will answer the first question(a) here.…
Q: You have the following information: Demand Rate = 500 units per hour lead time = 5 hours Container…
A: Demand(D) = 500 units per hour Lead time(L) = 5 hour Container capacity(C) = 60 Safety Factor(S) =…
Q: a) Labor productivity per labor hour for these tires = tires/labor hour (round your response to two…
A: Productivity is the relationship between the volume of the input and output that is calculated in…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?In the cash balance model from Example 11.5, the timing is such that some receipts are delayed by one or two months, and the payments for materials and labor must be made a month in advance. Change the model so that all receipts are received immediately, and payments made this month for materials and labor are 80% of sales this month (not next month). The period of interest is again January through June. Rerun the simulation, and comment on any differences between your outputs and those from the example.