Please answer in MS Excel's SOLVER, thank you!

DIRECTIONS 1 Using the College of Business Computer tab and/or supporting Rottware Mxcele SOLVER O DO), complete the following problem, 2 Turn-in an electronic copy of your Model. Outpat salysis. Drawinga and Discono wth Cover Sheet catalsing your Name, Student T.D. Humber. Date Course and Section Number You will not receive credit for work turned-in without a Cover Sheet 3. at you proceed with the computer st. oct work often on USB toge device and uploads with electronic copy of your assignment. THE PROBLEM Bell Kadare, ina, nanofactures and stributes hand-held tal television. The company has three planta and the distribution facilities. The plants are located in Austin, TX Seattle and St. Louis, MO. The distribution facilities are located into X Salt Lake City, UTI and Kansas City, MO. Manufacturing coote differ between the company production plants. The cost of each try produced at the st. toute plant is 525.00. The Austin and Soattie plants utilized and more efficient equipment: as reult. atracturing coate se 54.00 and 55,30 per DTV less than the cost at the St. Louis plant respectively, Over time, not much attention has been paid to the efficiency the distribution system. However to the company's rapid demund growth and higher taxe for holding the in distribution facilities, Bell's management has it that it Ls time to address theme. The cost of shipping treach plant to each distribution facility and quarterly plantities are shown below. PLANTS DISTRIBUTION FACILITIES CAPACITY Houston It take city anal city St. Lou 56 35,000 Rusti $3 $6 36 55.000 Boattle 14 30.000 OMIS 425 Section 1 Computer Assignment (Continued Fall 2021 Holding costs pet unit for the distribution facilities are $2.06 to the Salt Lake City tacity: 54.00 for the city Lality and $4.50 for the Houston facility The company serves tour customer zones from the distribution facilities. The castoner zones served include Chicago, IL: Dates TX Denver, CO and Los Angeles, Ch. The forecast for the trumber of DTV needed in each customer one for the next quartet is so below. CUSTOMER ZONE Chicago Dallas Denver Los Angeles PORECASTED DEMAND in TV 32,000 35,000 18.500 24,500 Shipping costs per DTV from each distribution taclity to customer zone are shown below. DISTRIBUTION YACILITIES Chicago Houston 88 Salt Lake City $6 Kansas City 53 CUSTOOGER ZONES Dallas Terver 52 55 52 54 55 SITUATION I (Base Case) If the company continues to elect to follow a teadssonal transhipment modeling approach to talling costs DO demand, what will it distribution plan and cost be for the following quarter? DIRECTIONS 1 Using the College of Business Computer tab and/or supporting Rottware Mxcele SOLVER O DO), complete the following problem, 2 Turn-in an electronic copy of your Model. Outpat salysis. Drawinga and Discono wth Cover Sheet catalsing your Name, Student T.D. Humber. Date Course and Section Number You will not receive credit for work turned-in without a Cover Sheet 3. at you proceed with the computer st. oct work often on USB toge device and uploads with electronic copy of your assignment. THE PROBLEM Bell Kadare, ina, nanofactures and stributes hand-held tal television. The company has three planta and the distribution facilities. The plants are located in Austin, TX Seattle and St. Louis, MO. The distribution facilities are located into X Salt Lake City, UTI and Kansas City, MO. Manufacturing coote differ between the company production plants. The cost of each try produced at the st. toute plant is 525.00. The Austin and Soattie plants utilized and more efficient equipment: as reult. atracturing coate se 54.00 and 55,30 per DTV less than the cost at the St. Louis plant respectively, Over time, not much attention has been paid to the efficiency the distribution system. However to the company's rapid demund growth and higher taxe for holding the in distribution facilities, Bell's management has it that it Ls time to address theme. The cost of shipping treach plant to each distribution facility and quarterly plantities are shown below. PLANTS DISTRIBUTION FACILITIES CAPACITY Houston It take city anal city St. Lou 56 35,000 Rusti $3 $6 36 55.000 Boattle 14 30.000 OMIS 425 Section 1 Computer Assignment (Continued Fall 2021 Holding costs pet unit for the distribution facilities are $2.06 to the Salt Lake City tacity: 54.00 for the city Lality and $4.50 for the Houston facility The company serves tour customer zones from the distribution facilities. The castoner zones served include Chicago, IL: Dates TX Denver, CO and Los Angeles, Ch. The forecast for the trumber of DTV needed in each customer one for the next quartet is so below. CUSTOMER ZONE Chicago Dallas Denver Los Angeles PORECASTED DEMAND in TV 32,000 35,000 18.500 24,500 Shipping costs per DTV from each distribution taclity to customer zone are shown below. DISTRIBUTION YACILITIES Chicago Houston 88 Salt Lake City $6 Kansas City 53 CUSTOOGER ZONES Dallas Terver 52 55 52 54 55 SITUATION I (Base Case) If the company continues to elect to follow a teadssonal transhipment modeling approach to talling costs DO demand, what will it distribution plan and cost be for the following quarter