Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. The profit for either model is $1000 per lot. Plastic Ink Assembly Molding Time Fliptop Model 3 5 Formulate a LP Model for this problem. Tiptop Model 4 4 2 Available 36 40 30
Q: A Given the decision tree below, solve the decision-making problem. -1,125 EMV 2 crash EMV 3 normal…
A: EMV is an estimation of expected value based on proportionate values with payoff values. The…
Q: Agan Interior Design provides home and office decorating assistance to its customers. In normal…
A: Find the calculations when arrival is 2.2 customers per hour and service time is 10 minutes:
Q: PUC Enterprise has annual demand for corporate finance textbook of 500. The cost of the textbook is…
A: Annual Demand (D)= 500unit cost=$40Holding cost (H)=20% of unit costHolding cost (H)= (20%*40)=…
Q: How far has technology come in the last several decades, and what kinds of technical infrastructure…
A: The technical infrastructure is a critical component of modern businesses, as it provides the…
Q: explore project management strategies to determine suitability for a given project
A: Project management strategies is a several approaches,that can be used and the suitability of each…
Q: Every PC maker struggles to meet consumer demand for high-quality, fast-processing machines at…
A: However, there are a few general strategies that PC makers use to try to meet consumer demand to…
Q: Which department has a primary responsibility to select and monitor performance measures that…
A: In the context of a business or any other organization, strategy refers to a long-term plan of…
Q: In..........people tend to do one task at a time.
A: Human beings have ability to perform multiple tasks simultaneously, but there are situations where…
Q: Consider the following forecast results. Calculate MFE, MAD, and MAPE, using the data for the months…
A: Given: The actual demand and forecast for the month January to June. Formula used: The expression…
Q: A manager needs to decide how to distribute bonus money to her employees . Which of the following…
A: The equity approach to bonus distribution is founded on the principle of fairness. It entails…
Q: These four elements make up a machine cycle, often known as a process loop. Which parts of machine…
A: In modern times, machines have turned into an integral piece of our regular routines. We depend on…
Q: Using Apple for example: List one idea for your marketing plan project. Include the following…
A: Below is the detailed explanation for the given questions:
Q: Describe how you would randomise observations and why it is important that the service user is…
A: In the below discussion first, we are going to discuss what randomise observations are and how one…
Q: 6-42 A snack company packages and sells three differ- ent 1-pound canned party mixes: Plain Nuts,…
A: Decision Variables: Suppose-X be the no. of cans of plain nuts to be soldY be the no. of cans of…
Q: What are some of the telltale signals that a system's useful life is nearing to an end, and how may…
A: Business management includes all those activities that help the business in taking good or…
Q: How are project scheduling models defined?
A: Project scheduling models are methods and techniques used to plan, organize, and manage the…
Q: A production process consists of a three-step operation. The scrap rate is 14 percent for the first…
A: The production process is a series of steps or activities that are involved in the manufacturing of…
Q: Analyse the inputs to your operations transformation process.
A: Operations transformation is the process of using resources to transform inputs into outputs that…
Q: How would Value chain analysis look for Amazon?
A: Operations management controls the procedures that convert inputs into outputs to provide value to…
Q: The City of Boston is taking bids on four construction projects. Four companies have made the bids…
A: Find the Given details below: Given details: Company Bids Project 1 Project 2 Project 3…
Q: Here are the actual tabulated demands for an item for a nine-month period (January through…
A: Moving average is a forecasting model which considering the average values of previous specific…
Q: Mueller & Associates is a urban planning firm that is designing a new public park in an Omaha…
A: Activity Optimistic (O) Most Probable (M) Pessimistic (P) A 4 8 12 B 6 7 8 C 6 12 18 D 3 5 7…
Q: Question 1 “The COVID-19 pandemic has had an unprecedented impact on the aviation industry, with the…
A: Singapore Airlines (SIA) is Singapore's flag carrier and one of the world's largest airlines. SIA…
Q: The following tabulations are actual sales of units for six months. (assume F1 = A1) a. Calculate…
A: Exponential smoothing is determined with following formula: Current forecast = α * Actual cost of…
Q: a) Draw a project network. A project network with 11 activities and 13 directed arcs is shown.…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: Find an alternative optimal solution for the above problem. If required, round your answer to…
A: Here, For this transportation problem, I would formulate an LP first, Decision variables: The…
Q: Jill wants to have immediate access to wide-scale distribution. The strategy which is best is to…
A: To be determined: The strategy which would be best for Jill to have access to wide-scale…
Q: What kind of decisions do supervisory management make? a. Unscheduled and far-ranging decisions. b.…
A: Supervisory management can be defined as the level of management in charge of managing a company's…
Q: Required information Milford Industries provides medical equipment to oncology and surgical units in…
A: Indirect costs (IDC) are expenses that are not directly traceable to a specific product or service…
Q: (a) Construct the project network. (Submit a file with a maximum size of 1 MB.) This answer has not…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: Figure out the core responsibilities and organizational objectives that are common to all TPSs.
A: Transaction Processing Systems (TPSs) are designed to support the core operations of an organisation…
Q: To determine how inventory management affects hospital supply chain performance and profitability?
A: Planning, regulating, and optimizing the movement and storage of items and resources inside an…
Q: Explain project schedule. What factors should estimate timetables?
A: The actions, events, and milestones that must be accomplished to meet a project's goals within a…
Q: 2. Consider a society with three people (Aretha, Melanie, and Salvador) who use majority rule to…
A: Answer a: We can look at the preferences of each voter for the two choices being considered to see…
Q: Services for managing processes?
A: Designing, running, and enhancing the systems and procedures that produce and provide goods and…
Q: Key performance indicators (KPIs) for static and path testing, as well as possible cost savings for…
A: Key performance indicators (KPIs) are essential for gauging how well a project or process is…
Q: Searching for ways to cut costs and increase profit, one of the industrial engineers at Home Comfort…
A: To determine: The most cost-effective option, we need to calculate the equivalent annual worth (EAW)…
Q: Identify each of the following examples as a programmed or nonprogrammed decision. Example…
A: The process of choosing a strategy from among different options to accomplish an ideal result or…
Q: 8-2 (Investment decision problem) The Heinlein and Krampf Brokerage firm has just been instructed by…
A: Suppose-X1 = Funds invested in Los Angeles municipal bondsX2 = Funds invested in Thompson…
Q: Describe Patagonia's business model. Does this business model have a virtuous cycle? How important…
A: Patagonia's business strategy is based on creating mutual benefit between the company and its…
Q: Is it feasible to provide an example that describes the steps involved in project management? In…
A: Project management is the act of organizing, directing, and controlling resources to achieve a…
Q: 1) Mr. Perez wants to invest up to $20,000 in two stocks, Cal Computers and Texas Tools. The Cal…
A: Inventory management includes all those activities that help the inventory manager to manage the…
Q: Conduct a price comparison of several hotels or restaurants in the same class. What price…
A: Tourism pricing is a strategy used by businesses in the tourism industry to set prices for their…
Q: What are the most important stages involved in the process of putting in place and analysing a…
A: The process of putting in place and analyzing a system can handle many stage which depend on…
Q: DOGGE Ltd has annual demand of 50,000 desks and the purchase price of each desk is K250. There are…
A: Annual demand (D)= 50,000 desksPurchase price (P)= K250Ordering costs (S)= K200Holding costs=10% of…
Q: Incorrect Communication has a relational dimension and a content dimension. Sami was talking with…
A: Communication is two-way process. It has to be dealt with a message going from one medium :-…
Q: Explain task deadline planning and briefly describe the information required for it.
A: Setting deadlines for completing tasks or projects is a crucial component of task deadline planning…
Q: The director of continuing education at Bluebird University just approved the planning for a sales…
A: A network diagram shows the sequence of the task that is done to complete a project. It usually…
Q: A well-known plastic mould and die manufacturer in Toronto intends to expand internationally in…
A: Payoff table-
Q: Complete the material requirements plan (enter your responses as whole numbers). Week ***83***…
A: Material requirements planning is the vital system followed and implemented by the manufacturing…
Step by step
Solved in 3 steps
- Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?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?The Big Bang Novelty Company (BBNC) makes 3 types of noise?makers: Toot, Wheet, and Honk. A Toot can be made in 30 minutes and has a feather attached to it. A Wheet requires 20 minutes, has two feathers, and is sprinkled with 0.5 ounces of sequin powder. The Honk requires 30 minutes, three feathers, and 1 ounce of sequin powder. The unit profits are $0.45 per Toot, $0.55 per Wheet, and $0.70 per Honk. The following resources are available: 80 hours of labor, 360 feathers, and 90 ounces of sequin powder. BBNC would like to maximize the overall profit from the noise-makers. (a) Write the linear programming model. Express labor time in minutes in LP formulationb) Solve using Excel Solver. How much of the resources (labor, feathers, and sequin powder) will be used by the optimal solution? If the availability of labor increases by 10 hours, what is the optimal total profit? If the unit profit of Wheet is actually only $0.30 instead of $0.55, will this change the solution? How many of each…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.
- JasNav Design Inc. sells three types of heat sensitive products: Cool, Warm and Hot. Estimated sales demand, unit selling prices and production requirements are as follows: Cool Warm Hot Estimated sales demand 600 500 400 Unit sales price $16 $18 $14 Production requirements per unit: Material Y9 (in kilograms) 8 5 2 Heat sensitive paint (in litres) 6 12 18 The company has existing stocks of 300 units of Cool and 200 units of Hot, but is adopting just-in-time inventory management and expects to reduce inventory to zero by the end of next year. All three products use the same direct materials. In the next year, the available supply of materials will be restricted to 5,000 kilograms of material Y9 and 12,000 litres of heat sensitive paint. Material Y9 costs $0.95 per kilogram and the heat sensitive paint costs…A Garment Company manufactures blue jeans. Three designs are considered: A, B, and C. The manufacture of design A requires 5 minutes machine time, 20 minutes labor and costs P325. Design B requires 8 minutes machine time, 30 minutes labor and costs P350 to produce. Finally, design C, the top of the line requires 10 minutes machine time, 1 labor hour, and costs P425 to produce. Brand A sells for P650, brand B for P750, and brand C for P875. The company works on a weekly schedule of five days, with two shifts of 7.5 hours (net time) each. It has six machines available for production and 36 workers on each shift. Its weekly manufacturing budget is P1,750,000. Based on previous demand, they can sell at least 500 units of design B and minimum of 200 units of brand C. Formulate the complete LP model.Please no written by hand and no emage Kindly create a spreadsheet from the problem description. Find the optimal solution using Excel Solver (Please show working with steps on a spreadsheet) : The Heinrich Company manufactures two types of plastic hangerracks (Foldaways and Straightaways) especially suited for mountingnear clothes dryers. Because permanent press clothing must be hungon hangers immediately after removal from the dryer, these items havebeen especially popular. However, there is some concern that thePreppie movement (popularized by its own handbook) will extinguishpolyester clothing; Heinrich is terribly interested in doing the best withthe resources it has while its products are still in demand. The firsttype of hanger rack, the Foldaway, requires 10 ounces of plasticmaterial and 0.3 hours of labor. Plastic costs Heinrich 10 cents anounce; labor costs Heinrich $20 per hour. The second type of hangerrack, the Straightaway, requires 15 ounces of plastic and 0.175…
- What combination of x and y will yield the optimum for this problem? Maximize $10x + $4y, subject to (1) 5x + 3y ≤ 15 and (2) 3x + 6y ≤ 18 and (3) x, y ≥ 0.Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? A. Product_2 B. Product_1 C. Product_3 Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 13 5 $B$3 Product_2 175 0 25 8 9 $B$4 Product_3 0 −1.5 25 11 3 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700Patz Company produces two types of machine parts: Part A and Part B, with unit contribution margins of $400 and $800, respectively. Assume initially that Patz can sell all that is produced of either component. Part A requires two hours of assembly, and B requires five hours of assembly. The firm has 400 assembly hours per week. What if market conditions are such that Patz can sell at most 100 units of Part A and 80 units of Part B? Express the objective function with its associated constraints for this case. Objective function: Max Z = $400 A + $800 B Assembly-hour constraint fill in the blank 7 A + fill in the blank 8 B ≤ fill in the blank 9 Demand constraint for Part A A ≤ fill in the blank 10 Demand constraint for Part B B ≤ fill in the blank 11 Identify the optimal mix and its associated total contribution margin.Component A $fill in the blank 12 units Component B $fill in the blank 13 units Total contribution $fill in the blank 14