Question: Problem 5-11 (Algo) A manager must decide which type of machine to buy, A, B, or C Machine costs (per Individual machine) are as follows:
Problem 5-11 (Algo) A manager must decide which type of machine to buy, A, B, or C Machine costs (per Individual machine) are as follows: Machine B Cost $60,000 $50,000 $60,000 sk ences Product forecasts and processing times on the machines are as follows: PROCESSING TIME PER UNIT (minutes) Annual 1 Product Demand 1 25,000 2 14,000 20,000 4 6.000 1 6 C 5 3 1 6 4 Click here for the Excel Data file a. Assume that only purchasing costs are being considered. Compute the total processing time required for each mochine 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 8 hours a day, 250 days a year (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) 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 8 hours a day, 250 days a year (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) Total proposing per machen A B B b. Consider this additional Information: The machines differ in terms of hourly operating costs. The A machines have an hourly operating cost of $15 each, B machines have an hourly operating cost of $12 each, and C machines have an hourly operating cost of $14 each. What would be the total cost associated with each machine option, including both the initial purchasing cost and the annual operating cost incurred to satisfy demand?(Use rounded machine quantities from Parta. Do not round any other intermediate calculations, Round your final answers to the nearest whole number.) B Buy