This quantitative problem requires you to do significant calculations using the information provided below, and to answer relevant questions based on the results of your calculations and other information presented in the course. You can do your calculations and show your answers in an MS- Excel spreadsheet, an MS-Word document, or in a handwritten worksheet with free-form calculations. For best grading results, be sure to show your calculations or otherwise indicate how you determined your calculated values. Your solution is to be submitted in a single electronic file that can be an Excel document, a Word document, a .pdf file, or a legible.png file from a mobile phone camera. Frozen Aire Trucking You have just been hired as the sales manager of FrozenAire Trucking Company, which operates from a terminal location in Anaheim, California. You are evaluating a proposal presented by a member of your sales team that would involve ongoing service to Caddo Produce LLC, which distributes fruits and vegetables to restaurants. The proposal involves hauling 10 truckloads of banana squash (not to be confused with squashed bananas) each month from the receiving port at Long Beach, California to the Caddo Produce distribution center in Phoenix for $1,200 per truckload. Each truck would depart from the FrozenAire terminal in Anaheim, which is 25 miles from the seaport. The distance from Long Beach to Phoenix is 379 miles. Upon unloading at Phoenix, trucks would return empty to the Frozen Aire terminal which is 355 miles from the DC. Part A If it costs FrozenAire an average of $1.60 per mile to operate a truck should you accept the proposal at the negotiated rate? Show any calculations you must do to answer this question in good form. Part B. Is it possible that your answer to the accept/reject question in part a. might be different if you TOR AN The proposal involves hauling 10 truckloads of banana squash (not to be confused with squashed bananas) each month from the receiving port at Long Beach, California to the Caddo Produce distribution center in Phoenix for $1,200 per truckload. Each truck would depart from the FrozenAire terminal in Anaheim, which is 25 miles from the seaport. The distance from Long Beach to Phoenix is 379 miles. Upon unloading at Phoenix, trucks would return empty to the FrozenAire terminal which is 355 miles from the DC. Part A. If it costs FrozenAire an average of $1.60 per mile to operate a truck, should you accept the proposal at the negotiated rate? Show any calculations you must do to answer this question in good form. Part B. Is it possible that your answer to the accept/reject question in part a. might be different if you are wrestling with a severe shortage of qualified truck drivers? Part C. Being the astute logistics manager that you are, you have identified an opportunity involving back-haul moves for the Caddo Produce shipments with TechTools Electronic Games of Flagstaff, Arizona. TechTools ships electronic games on Blu-Ray DVD's by the truckload from its plant in Flagstaff to the port in Long Beach for export to Asia. TechTools requires that their electronic media be shipped in refrigerated trailers to avoid heat damage under that smoking-hot Arizona sun. Each Caddo Produce shipment will be paired with a return shipment from TechTools (10 truckloads/month) to the port of Long Beach. FrozenAire will charge TechTools $1.50 per mile. Flagstaff is 479 miles from the port of Long Beach. The distance from Phoenix to Flagstaff is 144 miles. Trucks must return to the terminal in Anaheim upon delivering product from the back-haul. The terms of the Caddo Produce agreement outlined in part (a) remain intact. How much operating income (or loss) would FrozenAire generate per trip from the new arrangement, including both shipments? Show your calculations in good form. This quantitative problem requires you to do significant calculations using the information provided below, and to answer relevant questions based on the results of your calculations and other information presented in the course. You can do your calculations and show your answers in an MS- Excel spreadsheet, an MS-Word document, or in a handwritten worksheet with free-form calculations. For best grading results, be sure to show your calculations or otherwise indicate how you determined your calculated values. Your solution is to be submitted in a single electronic file that can be an Excel document, a Word document, a .pdf file, or a legible.png file from a mobile phone camera. Frozen Aire Trucking You have just been hired as the sales manager of FrozenAire Trucking Company, which operates from a terminal location in Anaheim, California. You are evaluating a proposal presented by a member of your sales team that would involve ongoing service to Caddo Produce LLC, which distributes fruits and vegetables to restaurants. The proposal involves hauling 10 truckloads of banana squash (not to be confused with squashed bananas) each month from the receiving port at Long Beach, California to the Caddo Produce distribution center in Phoenix for $1,200 per truckload. Each truck would depart from the FrozenAire terminal in Anaheim, which is 25 miles from the seaport. The distance from Long Beach to Phoenix is 379 miles. Upon unloading at Phoenix, trucks would return empty to the Frozen Aire terminal which is 355 miles from the DC. Part A If it costs FrozenAire an average of $1.60 per mile to operate a truck should you accept the proposal at the negotiated rate? Show any calculations you must do to answer this question in good form. Part B. Is it possible that your answer to the accept/reject question in part a. might be different if you TOR AN The proposal involves hauling 10 truckloads of banana squash (not to be confused with squashed bananas) each month from the receiving port at Long Beach, California to the Caddo Produce distribution center in Phoenix for $1,200 per truckload. Each truck would depart from the FrozenAire terminal in Anaheim, which is 25 miles from the seaport. The distance from Long Beach to Phoenix is 379 miles. Upon unloading at Phoenix, trucks would return empty to the FrozenAire terminal which is 355 miles from the DC. Part A. If it costs FrozenAire an average of $1.60 per mile to operate a truck, should you accept the proposal at the negotiated rate? Show any calculations you must do to answer this question in good form. Part B. Is it possible that your answer to the accept/reject question in part a. might be different if you are wrestling with a severe shortage of qualified truck drivers? Part C. Being the astute logistics manager that you are, you have identified an opportunity involving back-haul moves for the Caddo Produce shipments with TechTools Electronic Games of Flagstaff, Arizona. TechTools ships electronic games on Blu-Ray DVD's by the truckload from its plant in Flagstaff to the port in Long Beach for export to Asia. TechTools requires that their electronic media be shipped in refrigerated trailers to avoid heat damage under that smoking-hot Arizona sun. Each Caddo Produce shipment will be paired with a return shipment from TechTools (10 truckloads/month) to the port of Long Beach. FrozenAire will charge TechTools $1.50 per mile. Flagstaff is 479 miles from the port of Long Beach. The distance from Phoenix to Flagstaff is 144 miles. Trucks must return to the terminal in Anaheim upon delivering product from the back-haul. The terms of the Caddo Produce agreement outlined in part (a) remain intact. How much operating income (or loss) would FrozenAire generate per trip from the new arrangement, including both shipments? Show your calculations in good form