Question: please show with excel formuals Problem 12-4 (Algo) A toy manufacturer uses 52,140 rubber wheels per year for its popular dump truck series. The firm

please show with excel formuals

Problem 12-4 (Algo) A toy manufacturer uses 52,140 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 700 per day. The toy trucks are assembled uniformly over the entire year. Carrying cost is $1.70 per wheel per year. Setup cost for a production run is $51. The firm operates 237 days per year. Determine the following: a. Optimal run size (Round your answer to a whole number, following normal rules of rounding.) es EPO b. Use your final answer from part a to determine minimum total annual cost for carrying and setup. (Round your answer to a whole number.) Total Annual Inventory Cost b. Use your final answer from part a to determine minimum total annual cost for carrying and setup. (Round your answer to a whole number.) Total Annual Inventory Cost c. Cycle time for the optimal run size (Round your answer to two decimal points.) Cycle Time d. Run time (Round your answer to two decimal points.) Run Time 3.00

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!

31 A toy manufacturer uses 44 840 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 800 per day. The toy trucks are assembled...

A toy manufacturer uses 48,000 rubber wheels per year forits popular dump truck series. The firm makes its ownwheels, which it can produce at a rate of 800 per day. Thetoy trucks are assembled...

Problem 12-4 (Algo) A toy manufacturer uses 42,660 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 700 per day. The toy...

Problem 12-4 (Algo) A toy manufacturer uses 47.400 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 1,000 per day. The toy...

Problem 12-4 (Algo) A toy manufacturer uses 42,840 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 900 per day. The toy...

Soved Problem 12.4 (Algo) A toy manufacturer uses 42,840 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 900 per day. The...

help please Problem 12.4 (Algo) A toy manufacturer uses 43,740 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 900 per day....

Problem 12-4 (Algo) A toy manufacturer uses 45,600 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 800 per day. The toy...

Problem 12-4 (Algo) A toy manufacturer uses 52,580 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 700 per day. The toy...

Check my work Problem 12-4 (Algo) A toy manufacturer uses 51,450 rubber wheels per year for its popular dump truck series. The firm makes its own wheels, which it can produce at a rate of 800 per...

Which of the following amounts paidby an employer to an employee is not subject to withholding?(Points : 1) Commissions Travel expensereimbursements from an accountable plan Salary Bonus All of the...

A biologist is studying plant growth and wants to simulate a gravitational field twice as strong as Earth's. She places the plants on a horizontal rotating table in her laboratory on Earth at a...

On July 1 , Shady Creek Resort borrowed $ 4 6 0 , 0 0 0 cash by signing a 1 0 - yeac, 9 . 5 % installment note requiring equal payments each June 3 0 of $ 7 3 . 2 6 2 . What amount of interest...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...