Question: please help me with the formula for cell B11 The Lone Wild Boar Corporation manufactures a crucial component internally using the most advanced technology. The

The Lone Wild Boar Corporation manufactures a crucial component internally using the most advanced technology. The operations manager wants to determine the economic manufacturing quantity to ensure that the total annual inventory cost is minimized. The daily production rate (P) for the component is 1,470 units, annual demand (R) is 88,200 units, setup cost (S) is $100 per setup, and the annual holding rate (k) is 25 percent. The manager estimotes that the total cost (C) of a finished component is $120. It is assumed that the plant operates year-round and there are 360 days per year. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Open spreadsheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
