Use the workheet Vehides for thes peoblem. You will belp a folities depurtment for a university analyze their vehide data for decision upport. Answer the folowing cuestions based on your analysis of the data. 1. The sales manager would the to know the total maintenance costs according to each make, type and year of vehicies. a. Which combination of the three parameters fle. make, type, asd year) has the hichest total malntenance cont and what is that cost? HNT: List cen vehicle. b. Which combination has the lowest total maintenance cost and ahat is thut eost? 2. Which depurtment las the highest number of vehicles akiged? in this department, what appe of vehicle bo found the most and how many? 3. What is the merage price of the ford Truck in the Housines Arsidestial tife departinent? 4. Which wehicle (make/hee/year) has the highest osometer readine? a. What is the veticle maka/type/vear? b. What is the pdometer reading? c. What desartment this vehicle assigred to? Eroblen 2. typer ef profinsional frubee dake. Mice soith, the sparal macager of the congony has created an Intome statement, based on the variour dasa he has, in the wodabert aumed bilas. The Aidvertiline tine Cisel oss capabates, helo Mare atrwar tef foloe ine quatibon. the net incoine for Renglar disks. The isM espenes can vary bertanen 53500 and 55000 (aspame step aise of si). nor Wers docimere. 3130 Pave 2 ats autuiline Income Statement \begin{tabular}{|l|r|r|r|r|r|} \hline Revenue & \multicolumn{1}{|c|}{ Regular } & High Flyer & Tournament & Supreme & Total \\ \hline Units Sold Based on Word of Mouth & 2100 & 2050 & 1750 & 1000 & 6900 \\ \hline Units Sold Based on Advertising & 205 & 205 & 205 & 205 & 822 \\ \hline Total Units Sold & 2305 & 2255 & 1955 & 1205 & 7722 \\ \hline Price per Unit & $12:00 & $20.00 & $24.00 & $32.00 & $22.00 \\ \hline \hline Total & $27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||r|} \hline Variable Expenses & \multicolumn{1}{|c|}{ Regular } & High Flyer & \multicolumn{1}{|c|}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & Total \\ \hline Units Produced To Cover Demand & 2,535.92 & 2,480.92 & 2,150.92 & 1,325.92 & 8,493.69 \\ \hline Cost per Unit & $5.00 & $10.00 & $16.00 & $20.00 & $12.75 \\ \hline \hline Total & $12,679.61 & $24,809.22 & $34,414.75 & $26,518.44 & $98,422.02 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r||r||r|} \hline Fixed Expenses & \multicolumn{1}{|c|}{ Regular } & High Flyer & \multicolumn{1}{|c|}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & \multicolumn{1}{|c|}{ Total } \\ \hline Insurance and maintenance & $3,000.00 & $5,000.00 & $6,000.00 & $10,000.00 & $24,000.00 \\ \hline Other Overhead & $6,000.00 & $8,500.00 & $12,000.00 & $18,000.00 & $44,500.00 \\ \hline Advertising & $1,000.00 & $1,000.00 & $1,000.00 & $1,000.00 & $4,000.00 \\ \hline \hline Total & $10,000.00 & $14,500.00 & $19,000.00 & $29,000.00 & $72,500.00 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||c||c|} \hline Income Summary & Regular & High Fiyer & Tournament & Supreme & Total \\ \hline Total Revenue & $27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline Total Expenses & $22,679.61 & $39,309.22 & $53,414.75 & $55,518.44 & $170,922.02 \\ \hline \hline Net Income & $4,984.99 & $5,798.45 & ($6,485.54) & ($16,946.16) & ($12,648.26) \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline Advertising ($) & increase in Units Sold \\ \hline$0 & 0 \\ \hline$500 & 75 \\ \hline$1,000 & 206 \\ \hline$1,500 & 408 \\ \hline$2,000 & 689 \\ \hline$2,500 & 1,040 \\ \hline$3,000 & 1,432 \\ \hline$3,500 & 1,824 \\ \hline$4,000 & 2,175 \\ \hline$4,500 & 2,456 \\ \hline$5,000 & 2,658 \\ \hline$5,500 & 2,789 \\ \hline$6,000 & 2,864 \\ \hline$6,500 & 2,903 \\ \hline$7,000 & 2,921 \\ \hline$7,500 & 2,928 \\ \hline$8,000 & 2,931 \\ \hline$8,500 & 2,932 \\ \hline$9,000 & 2,932 \\ \hline$9,500 & 2,932 \\ \hline$10,000 & 2,932 \\ \hline \end{tabular} Increase in Sales based on Advertising Advertising Dollars Use the workheet Vehides for thes peoblem. You will belp a folities depurtment for a university analyze their vehide data for decision upport. Answer the folowing cuestions based on your analysis of the data. 1. The sales manager would the to know the total maintenance costs according to each make, type and year of vehicies. a. Which combination of the three parameters fle. make, type, asd year) has the hichest total malntenance cont and what is that cost? HNT: List cen vehicle. b. Which combination has the lowest total maintenance cost and ahat is thut eost? 2. Which depurtment las the highest number of vehicles akiged? in this department, what appe of vehicle bo found the most and how many? 3. What is the merage price of the ford Truck in the Housines Arsidestial tife departinent? 4. Which wehicle (make/hee/year) has the highest osometer readine? a. What is the veticle maka/type/vear? b. What is the pdometer reading? c. What desartment this vehicle assigred to? Eroblen 2. typer ef profinsional frubee dake. Mice soith, the sparal macager of the congony has created an Intome statement, based on the variour dasa he has, in the wodabert aumed bilas. The Aidvertiline tine Cisel oss capabates, helo Mare atrwar tef foloe ine quatibon. the net incoine for Renglar disks. The isM espenes can vary bertanen 53500 and 55000 (aspame step aise of si). nor Wers docimere. 3130 Pave 2 ats autuiline Income Statement \begin{tabular}{|l|r|r|r|r|r|} \hline Revenue & \multicolumn{1}{|c|}{ Regular } & High Flyer & Tournament & Supreme & Total \\ \hline Units Sold Based on Word of Mouth & 2100 & 2050 & 1750 & 1000 & 6900 \\ \hline Units Sold Based on Advertising & 205 & 205 & 205 & 205 & 822 \\ \hline Total Units Sold & 2305 & 2255 & 1955 & 1205 & 7722 \\ \hline Price per Unit & $12:00 & $20.00 & $24.00 & $32.00 & $22.00 \\ \hline \hline Total & $27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||r|} \hline Variable Expenses & \multicolumn{1}{|c|}{ Regular } & High Flyer & \multicolumn{1}{|c|}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & Total \\ \hline Units Produced To Cover Demand & 2,535.92 & 2,480.92 & 2,150.92 & 1,325.92 & 8,493.69 \\ \hline Cost per Unit & $5.00 & $10.00 & $16.00 & $20.00 & $12.75 \\ \hline \hline Total & $12,679.61 & $24,809.22 & $34,414.75 & $26,518.44 & $98,422.02 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|r||r||r|} \hline Fixed Expenses & \multicolumn{1}{|c|}{ Regular } & High Flyer & \multicolumn{1}{|c|}{ Tournament } & \multicolumn{1}{|c|}{ Supreme } & \multicolumn{1}{|c|}{ Total } \\ \hline Insurance and maintenance & $3,000.00 & $5,000.00 & $6,000.00 & $10,000.00 & $24,000.00 \\ \hline Other Overhead & $6,000.00 & $8,500.00 & $12,000.00 & $18,000.00 & $44,500.00 \\ \hline Advertising & $1,000.00 & $1,000.00 & $1,000.00 & $1,000.00 & $4,000.00 \\ \hline \hline Total & $10,000.00 & $14,500.00 & $19,000.00 & $29,000.00 & $72,500.00 \\ \hline \end{tabular} \begin{tabular}{|c|r|r|r|r||c||c|} \hline Income Summary & Regular & High Fiyer & Tournament & Supreme & Total \\ \hline Total Revenue & $27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline Total Expenses & $22,679.61 & $39,309.22 & $53,414.75 & $55,518.44 & $170,922.02 \\ \hline \hline Net Income & $4,984.99 & $5,798.45 & ($6,485.54) & ($16,946.16) & ($12,648.26) \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline Advertising ($) & increase in Units Sold \\ \hline$0 & 0 \\ \hline$500 & 75 \\ \hline$1,000 & 206 \\ \hline$1,500 & 408 \\ \hline$2,000 & 689 \\ \hline$2,500 & 1,040 \\ \hline$3,000 & 1,432 \\ \hline$3,500 & 1,824 \\ \hline$4,000 & 2,175 \\ \hline$4,500 & 2,456 \\ \hline$5,000 & 2,658 \\ \hline$5,500 & 2,789 \\ \hline$6,000 & 2,864 \\ \hline$6,500 & 2,903 \\ \hline$7,000 & 2,921 \\ \hline$7,500 & 2,928 \\ \hline$8,000 & 2,931 \\ \hline$8,500 & 2,932 \\ \hline$9,000 & 2,932 \\ \hline$9,500 & 2,932 \\ \hline$10,000 & 2,932 \\ \hline \end{tabular} Increase in Sales based on Advertising Advertising Dollars
