please help me periodic replenishment of staple merchandise:3. Complete the following grid solving for R and M using the formula for theAnnual TurnoverWeeks of SupplyPlon Sales for a WeekInventory2.0$5,0004.0$8,0008.0$9,10010.0$50016.0$21,000RPDPSRM11$100.5$2501$5023$3,00048$52.2.

As per our policy we will be solving the first question for you .Please post the second one…

Answered: periodic replenishment of staple…

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

Similar questions

The ABC Company is making a production plan for the next year, given the sales forecast for the next year as: Quarter 1 2 3 4 Total Sales Forecast (units) 9,000 12,000 16,000 12,000 49,000 Currently, the ﬁrm has 12 employees, each producing up to 1,000 units per quarter and earning $2,000 per quarter. The ﬁrm estimates its inventory carrying cost to be $2 per unit of ending inventory per quarter and its hiring or layoff costs to be $1,600 per employee. The company currently has an inventory of 2,000 units and wishes to have an ending inventory of at least 1,000 units at the end of each quarter. The company does not plan to incur inventory shortages. Find the optimal production plan that minimizes the total cost by Excel solver
The Pampered Pet Kennels Company provides room and board for dogs and cats. The manager must mix up pet food everyday for the animals; the food must meet the following standards: Protein At least 6% Fat At most 10% Upon checking the supplies, one day, the manager found that he has the following quantities on hand: Protein Fat Cost/ kilogram Beef stock 10% 20% P 6.00 Flour 5% 5% P 2.00 Formulate the linear programming model to determine how much of each ingredient the manager should mix up to feed the guests today.
Please answer the following in an organized way and showing steps. Maxwell Manufacturing makes two models of felt tip marking pens. Requirements and available resources for each lot of pens are given in the following table: Fliptop Model Tiptop Model Available Plastic 3 4 36 Ink Assembly 5 4 40 Molding Time 5 2 30 The profit for either model is $1,000 per lot. a. What is the linear programming model for this problem? b. Using Microsoft Excel's Solver, find the optimal solution. How many Fliptop models and how many Tiptop models should be produced? What is the maximum profit? c. Will there be excess capacity in any resource? Use Excel's Solver and run a sensitivity report to answer the following questions: d. Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called? e. What is the shadow price (dual price) for the plastic constraint and how…
Refer to the Factory-to-Six-Customers problem and start with the original information. Each customer increases demand by 1000 units. This increased demand has to be met. Re-calculate the optimal solution. At the new solution, which of the following statements is true? A. The total shipping costs are $252,900 B. Quantity shipped from Factory 1 to Customer 1 declines by 6000 units C. Both A and B D. Neither A nor
Wine Accessories Inc. (WAI) produces two models of corkscrews, the standard model and a deluxe model. WAI follows a level aggregate plan, producing 20,000 corkscrews per month, or 5000 corkscrews per week. Th e MPS is developed in weekly time periods. Th e forecasts for each model and the projected available are shown in the next two tables. Th e replenishment order quantity is 2000 units for the standard model and 1000 units for the deluxe model. Note that you can place multipleorders if a single order is insuffi cient to cover the forecast (you can produce 4000 units of the standard model if necessary, or 2000 or 3000 units of the deluxe model). Remember that total weekly production is limited to 5000 corkscrews. Develop an MPS for each of the products.
Mary is a sales person for Challenge Furniture. She receives an incremental commission based on the table below. If she sells $26,000 and has already received a draw of $766.15, how much commission is still owed to Mary? level 1 1-11,700 3.7% sales volume 2 11,701-21,200 4.3% commission rate 3 over 21,200 4.7%
I need a detailed assistance to solve this problem in: Operations Analysis. #4) A greengrocer has exactly 1,000 square feet available to display and sells 3 kinds of vegetables. The space consumed by each kind of vegetable is proportional to its cost, and tomatoes consume 0.5 square feet per pound. There is a $100 setup cost for replenishing any of the vegetables, and the interest rate is 25% per annum. The 3 vegetables for sale have the following data: Tomatoes: annual demand is 850 pounds and the cost per pound is $0.29. Lettuce: annual demand is 1280 pounds and the cost per pound is $0.45. Zucchini: annual demand is 630 pounds and the cost per pound is $0.25. a) - What is the optimal quantity for purchasing each vegetable (include all formulas)?
A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 40,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.2 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost
Hot Oven daily requirements of 70 g of protein, 1 g calcium, 12 mg iron, and 3000 calories are needed for a balanced diet. The following foods are available for consumption with the cost and nutrients per 100 g as shown. protien (g) calories calcium(g) iron(mg) cost (ghc) brown bread 12.0 246 0.1 3.2 0.5 cheese 24.9 432 0.2 0.3 20 butter 0.1 793 0.03 0.0 1.0 baked beans 6.0 93 0.05 2.3 0.25 spinach 3.0 26 0.1 2.0 0.25 The objective of the Hot Oven is to find a balanced diet with minimum cost.a) Formulate a linear programming model for this problem. b) Use solver to find optimal solution and sensitivity report. c) Management have asked you to determine the optimal solution. Write your answer in a form of a report to be submitted to the management. d) Advice the management about objective function value corresponding to your answer in (b)
Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are in the table below. This question is interested in maximizing the profit). a) Identify the decision variables, objective function, and constraints in simple verbal statements. b) Mathematically formulate a linear optimization model. Components Required/Unit A B Profit/Unit LaserStop 18 6 $124 SpeedBuster 12 8 $136 Solve this question in Excel by using SOLVER. Please clearly explain what is the optimal solution? What is the resulting output of the objective function at the optimal solution? P.S. please solve in Excel.
All-Natural Coop makes three breakfast ccrcals, A, B, and C, from four ingredients: rolled oats, raisins, shredded coconuts, and slivered almonds. The daily availabilities of the ingredients are 5 tons, 2 tons, 1 ton, and 1 ton, respectively. The corresponding costs per ton are $100, $120, $110, and $200, respectively. Cereal A is a 50:5:2 mix of oats, raisins, and almond. Cercal B is a 60:2:3 mix of oats, coconut, and almond. Cercal C is a 60:3:4:2 mix of oats, raisins, coconul, and almond. The cercals are prodluced in jumbo 5-lb sizes. All-Natural sells A, B, and Cat $2.00, $2.50, and $3.00 per box, respectively. The minimum daily demand for cereals A. B, and C is 500, 600, and 500 boxes, respectively. Develop an LP model to determine the optimal production mix of the cereals and the associated amounts of ingredients, and find the solution using execl Solver

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS