Excel Data File

Machine	Cost
A	$80,000
B	$70,000
C	$40,000
		Processing Times (Per Unit) - Minutes
Product	Annual Demand	A	B	C
1	24,000	1	4	6
2	8,000	1	3	5
3	30,000	6	4	3
4	18,000	6	5	1

A manager must decide which type of machine to buy, A. B, or C. Machine cosas iper individual machinel are as followk: Product forecasts and processing tirtes on the machines are as follows: Slick here for he Evicildate Fis a. Assume that ony purchasing costs are being considered Compure the tote processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resuting total purchasing cost for eoch machine type. The machines will operate 10 hours a day, 240 days a year, (Enter totel processing thet as whole numbers. Round up machine qusntities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the retulting total purchasing cost as a whele number.) b. Consider this add tonal infarmabion The machines differ in terths of hourty operating costs. The A machines have an hourfy operating cost of $12 each, B muchines have an houly operating cost of $ sy esch. and C machines have an hourly operating cost of 515 each. What would be the total cost associsted with each mach ne opoon including both the initial purchosing cost and the arnual opersting cost incurred to satitfy demandifuse rounded mechine quthtities from Port a Do not round any other linterniediate celculavions. Peund your final onswers to the nesest whole numbec) 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 o. 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 quantities to the next hlgher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) b. Consider this additional information: The machines differ in terms of hourly operating costs: The A machines have an hourly operating cost of $12 each, B machines have an hourly operating cost of $14 each, and C machines have an hourly operating cost of $15 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 Part a. Do not round any other Intermedlate calculatlons. Round your final answers to the nearest whole number.)