Spreadsheet

Given the information provided below and a budget of $$6,000,000,$ what is the most that Loyola Machining can pay for each mafactured unit? Assume one year is $250$ working days and the order size is $5,700$ units. Use the Total Supply Chain Cost Excel template for your analysis. Do not round intermediate calculations. Round your answer to the nearest cent.

$\backslash$table$[[\backslash$table$[[$Annual$],[$Demand $(D)$