Question: please solve this using excel and thank you Home Work Due September 19th, 2021 An order for 15 custom-designed castings has been received. The casting

please solve this using excel and thank you

Home Work Due September 19th, 2021 An order for 15 custom-designed castings has been received. The casting process costs $1500 per unit scheduled. If a casting is not sold it has a recycle value of $300. The customer has indicated a willingness of to pay $2000 per casting for acceptable casting no more no less! If number of good casts is less than 15 then the customer does not accept For only one casting if we have the 5% chance probability of having defective How many casting should be scheduled for production in order to maximize profit? Submit Your Excel File

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!

I need the functions as you would put them on excel. Please show the excel formula in the cell. A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per...

Please show how to do on excel. I know the formulas but I don't know how to write it on excel. A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per unit...

Can you help me to solve this on excel? And show me the formulas you used. Question 1. A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per unit...

Please show formulas used in excel and where to put them, thanks Reject Allowance A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per unit scheduled....

A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per unit scheduled. If a casting is good, then it is machined to specifications at an added cost of...

Can you help me please to solve this by hand Question 1. A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per unit scheduled. If a casting is good, then...

Please see attached picture. Work by hand Question 1. A foundry has received an order for 20 custom-designed castings. The casting process costs $700 per unit scheduled. If a casting is good, then it...

Home Work Due February 5 t h , 2 0 2 4 An order for 1 8 custom - designed castings has been receired. The casting process costs $ 1 5 0 0 per unit scheduled. If a casting is not sold it has a recrcle...

Based on the information given in the case study, Share brief answers to below Supplier Financial Analysis Worksheet Purchasers assess supplier financial health for several reasons. The most...

I want answers to the case study below CASE STUDY The Rise, Fall, and Resurrection of Iridium: A Project Management Perspective The Iridium Project was designed to create a worldwide wireless...

Consider the following example. A company that makes industrial pumps wants to prepare a master production schedule for June and July. Marketing has forecasted demand of 120 pumps for June and 160...

Why are managers important to organizations?

Question 4 All of the following are purposes served by identifying steps to a goal EXCEPT N deciding when to end work with the client. providing a roadmap to reach a MAPS goal. providing an important...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...