Scatter Diagrams and High-Low Cost EstimationAssume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs.Month Sales Orders Order-Processing Costs3,000$ 165,4001,500100,7504,400241,4002,800163,8002,300139,5501,20086,2002,000125,0001234567Required(a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs.$ 28,000+ $48.5X(b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly order-processing costs. If needed, an Excelworksheet is provided in the following link in order to create the scatter diagram: Scatter_Diagram$ 15,000 X+ $53.14 X X

Here, for each month, I have been given the data for sales orders and order processing costs, I…

Answered: Required (a.) Use information from the…

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

Average daily demand (d) 130 cases Demand Standard deviation (σd) 20 cases Service level 94.0% Service level alternative 86.0% Lead tme, LT 6 days 1. What is the standard deviation of demand during lead time? Round your answer to one decimal place. _______ cases 2. What is the required safety stock at a 94 percent service level? Round your answer to the nearest whole number. _______ cases 3. What is the reorder point? Round your answer to the nearest whole number. _______ cases 4.What is the required safety stock at a 86 percent service level? Round your answer to the nearest whole number. _______ cases 5. What is the safety stock reduction? Round your answer to the nearest whole number. _______ cases
Please answer all parts
Need in Detail (No AI)
Inventory Management You are the store manager at a local branch of DigiLife, a large electronics retail chain. A new version of a popular consumer electronics device called the Amulet is coming out this year. It is your job to sell as many Amulets as you can while minimizing your costs in order to maximize your store's profits. Your Goal Earn $1,000,000 in net profits of Amulet sales.
can you help me with this, show me how to do on excel plz
Your Corporation manufactures four products that use the same raw material and production machine. Your Company is experiencing a shortage of pounds of the raw material. Information related to the four products are shown below. Products A B C D Selling price $40 $32 $35 $65 Variable cots $34 $22 $27 50 Machine hours per unit 6 8 5 7 Pounds per unit 18 20 28 38 To maximize profit next month, in what order would it be best to schedule production (first to last)? a. A, B, C, D b. A, D, B, C c. B, D, A, C d. D, A, C, B
Which are some of the things that drive variability in demand management and forecasting? 1. MOQs 2. Promotional sales on products 3. Supplier contracting 4. Order fulfillment 5. Network planning 6. None of the above Please give me answer ASAP with clear explanation.
2
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
What special procedures should be used to control the most expensive and most frequently used products in inventory? Give one example of a product in your response.
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
Discuss the Pros and Cons of Re-Order Point Control and Re-Order Cycle Control Inventory control Systems. Also mention, the business environment in which one model is preferred over the other business model.

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