5. A product has an average daily demand of 400 units with standard deviation of 10.0 units. Lead-time is 1 day. If management would like to satisfy all demand in 80% of the cycles, what is the reorder point? 6. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end of the season are salvaged for $7.0. Demand is normally distributed with a mean of 1000 units and standard deviation of 100 units. How many units should the retailer order? 7. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end of the season are salvaged for $9.0. Demand is normally distributed with a mean of 1000 units and standard deviation of 100 units. How many units should the retailer order?

5. A product has an average daily demand of 400 units with standard deviation of 10.0 units. Lead-time is 1 day. If management would like to satisfy all demand in 80% of the cycles, what is the reorder point? 6. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end of the season are salvaged for $7.0. Demand is normally distributed with a mean of 1000 units and standard deviation of 100 units. How many units should the retailer order? 7. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end of the season are salvaged for $9.0. Demand is normally distributed with a mean of 1000 units and standard deviation of 100 units. How many units should the retailer order?

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

Related questions

Q: Question 3. Change your spreadsheet to 'show formulas' - type "show formulas" and Enter key as shown…

A: A linear objective function can be optimized using the linear programming (LP), also known as linear…

Q: The annual dog show is scheduled for arrival at your hotel the first week in April next year. The…

A: As the anticipation builds for the upcoming annual dog show at our hotel in the first week of April…

Q: Q: Model the following business process at a supplier. . After a supplier notifies a retailer of…

A: Introduction Supplier management is the practise of ensuring that an organisation gets the most…

Q: (Use an excel sheet to show formulas used)

A: (a) Volume break even= Fixed cost/(revenue per unit- variable cost per unit) (b) Profit=…

Q: Cakes, the shop includes different areas for mixing, baking, decorating, and packaging. This…

A: Option C is correct. At Jill's Custom Cakes, the shop includes different areas for mixing, baking,…

Q: How to discuss summary.

A: A summary is a brief and condensed form of a longer piece of content, such as an article, book, or a…

Q: (Write your response to the customer as if you were a COp at Monzo who had just picked up a call…

A: Customer queries and concerns should be resolved by the firm at any cost. It enhances goodwill.…

Q: Supply/Demand Info Forecast (demand) Regular production Subcontract production Ending inventory…

Q: Suzanne just received her paycheque and sees that she was paid $750 for producing 50 widgets. Her…

A: The question is related to paymemt system to employees. Employees are motivated with rewards for…

Q: The Pickle Barrel has separate departments in its operation that are designed to turn raw cucumbers…

A: Departmentalization is known as the technique of organizing numerous into different branches. Such…

Q: Industrial Designs has been awarded a contract to design a label for a new wine produced by Lake…

A: Linear programming is a mathematical method used to find the best possible outcome or solution from…

Q: Montreal Hardware Co. is making a make-or-buy decision. The market feedback shows that the optimal…

A: A decision tree refers to the tree that supports tools or equipment that utilizes a tree-like…

Q: The industry in which Morton Company operates is quite sensitive to cyclical movements in the…

A: Answer information:Step 1:Answer 1. Morton CompanyContribution Income Statement Present…

Q: Plan production for the next year. The demand forecast is spring, 20,000; summer, 10,000; fall,…

A: The demand forecast is: Spring= 20,000Summer, 10,000Fall, 15,000winter, 18,000. Workers at the…

Q: 12. How and when would an organization use a: Standing plan Single-use plan 13. Why would a food and…

A: Any organization will attain its goals efficiently and effectively with proper organizational…

Q: CUU is planning to procure an administrative building for its students, and design a contract…

A: Establishing a precise contract agreement that describes the major criteria and expectations for the…

Q: Blossom, Inc. produces a crop of chickens at a total cost of $81,400. The production generates…

A: To calculate the incremental profit or loss if Blossom, Inc. slaughters the chickens, we need to…

Question

100%

please show how to do this in excel thank you! :)

5. A product has an average daily demand of 400 units with standard deviation of 10.0 units.
Lead-time is 1 day. If management would like to satisfy all demand in 80% of the cycles, what
is the reorder point?
6. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end
of the season are salvaged for $7.0. Demand is normally distributed with a mean of 1000
units and standard deviation of 100 units. How many units should the retailer order?
7. A product sells for $24 per unit and costs the retailer $12 per unit, unsold units by the end
of the season are salvaged for $9.0. Demand is normally distributed with a mean of 1000
units and standard deviation of 100 units. How many units should the retailer order?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

SOLUTION:5

SOLUTION:6

SOLUTION:7

FINAL ANSWERS

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Business Name: CV Water Refill Location: 3rd Street Chula Vista, CA 91911 Financial Management: a. Accounting (How will you manage your business accounting?): b. Professional Resources (List all to be used): c. Credit and Financing (List resources for financing your business venture): d. Billable Rate/Break-Even Sales
185. Subject :- Accounting
31 please help me please!A company has a factory that is designed so that it is most efficient (average unit cost is minimized) when producing 19,200 units output each month. However, it has an absolute maximum output capability of 23,000 units per month, and can produce as little 7,000 units per month without corporate headquarters shifting production to another plant. If the factory produces 13,280 units ir October, what is the capacity utilization rate in October for this factory? Note: Round your answer to 1 decimal place.
H1.
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?