Question: The following problems must de done using Excel QM : You can save it as an excel file when complete A.Omar Haaris receives 5,000 tripods

The following problems must de done using Excel QM: You can save it as an excel file when complete

A.Omar Haaris receives 5,000 tripods annually from Top-Grade Suppliers to meet his annual demand. Omar runs a large photographic outlet, and the tripods are used primarily with 35mm cameras. The ordering cost is $15 per order, and the carrying cost is $0.50 per unit per year. Weekly demand is 100 tripods. What is the optimal order quantity?

B.Based on available information, lead time demand for CD-ROM drives averages 250 units (normally distributed), with a standard deviation of 25 drives. Management wants a 98% service level. How many drives should be carried as safety stock? What is the appropriate ROP?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

accounting general ledger ...attached is the information The goal of this graded project is to create the following financial statements for J & L Accounting, Inc.: Balance sheet Income statement...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

help me answer q1, 2, 3, 4, 5 the audit of Alpine Cupcakes, Inc. tasks Audit Case Assignments ng standards ble Introduction: Data Analytics Module e accounts In the Data Analytics Module, instead of...

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

I don't need the answer. All I need is help understanding. I don't know how to deduct taxes and start the sheets. If you could start it out for me or just do one of the sheets it would help me...

Accounting help in making balance sheet, income statement, andpost closing trial balance. Graded Project Ice Cream Systems 1 PROJECT INFORMATION 1 PROJECT INSTRUCTIONS 14 SUBMITTING YOUR PROJECT 26...

I don't need the answer. All I need is help understanding. I don't know how to deduct taxes and start the sheets. If you could start it out for me or just do one of the sheets it would help me...

The 3.25-cm3 volume of air remaining in a water balloon is reduced to 2.75 cm3 upon impact when the air pressure is 48.3 kPa. (a) Is the original pressure more or less than that upon impact? (b) Find...

Use the following structure for problem 1. struct student{ string name; int id; float mark; }; Declare an array named studentArray of the structure type shown above, the size of the array is limited...

Which information is entered in CMS - 1 5 0 0 Blocks 9 9 d on the primary insurance claim? a . billing entity b . employer tax identification number c . supplemental plan d . primary insurance

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.