Strategic Capacity Q$5$

A manager must decide which type of machine to buy, $A,B,$ or $C.$ Machine costs $($per Individual machine$)$ are as follows:

Product forecasts and processing times on the machines are as follows:

Click here for the Excel Data File

a$.$ Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to

meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The

machines will operate $10$ hours a day, $240$ days a year. $($Enter total processing times as whole numbers. Round up machine

quantitles to the next higher whole number. Compute total purchasing costs using these rounded machine quantitles. Enter the

resulting total purchasing cost as a whole number.$)$