Question: please show work in excel. P301 - Problem 10 A Pete's Premium Printing business operates 245 days a year. The company uses a lot of

please show work in excel.

P301 - Problem 10 A Pete's Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost information. Using this information answer the 3 questions below, Inventory Information for Shower Cleanser The Cost of a Case of Paper $25.00 Annual Holding Cost (as a % of Cost) 12% H=$25*.12 = $3.00 Cost to Place an Order $12.00 Average Daily Demand (in cases) D=400*245 98000 Standard deviation of Daily demand 75 Lead time to receive an order (in days) 400 10 1. If the company wanted a 90% Customer Service Level how much safety stock would it need to carry? 2. Based on a 90% CSL, what would the Reorder Point be for paper? 3. Assume the company's order quantity (Q) was 885. How many stock outs would it experience in a year

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 General Management Questions!

PLEASE SHOW WORK!!! P301 - Problem 10 A Pete's Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand...

A Petes Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost information. Using this...

please help!!! A Pete's Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost information....

A Petes Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost information. Using this...

please help and show work!!! A Pete's Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost...

I am having trouble with this. A Pete's Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost...

A Pete's Premium Printing business operates 245 days a year. The company uses a lot of paper in its daily operations. The table below provides relevant demand and cost information. Using this...

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

Averell Cabinetry Case Overview This case is presented as close as possible to the way you may encounter it in working life. Your role is that of a newly hired HR manager. You will learn about the...

(a) Explain to Mark and Kelly why their policy might have been canceled. (b) Use the box on page 306 to give Mark and Kelly some pointers on how to save money when shopping for a new auto insurance...

Respond that the following statement is True or False: In accounting for permanent funds only the income can be spent; the principal must be preserved intact

Which lifestyle scheme creates 6 8 segments based on where a person lives and what they are like, including family / household life cycle stage, income, and the kind of area they live in ? ELM PRIZM...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...