I need help working out the business excel workbook problem. I had help on Level two. I have been able to complete level one from the book, but I need help with level three. Attachment 1 Attachment 2 Attachment 3 Attachment 4 Attachment 5 ATTACHMENT PREVIEW Download attachment CKG Operating Costs.xlsx CKG Auto Car Model Information Model # 1 2 3 4 5 6 7 8 9 Car Model Voltage Voltage Wagon Mia Mia XL Tiaf Dorf Sport Supra-V Nexus RunAbout Zemb Description Compact sedan Compact hatchback Mid-size sedan Mid-size luxury sedan SUV Compact sports car Mid-size sports car Full-size van Mid-size truck Maintenance Cost Base Weight Class 1st Year 2nd Year 3rd Year 4 1 $ 275 $ 325 $ 475 4, 6 1 275 325 475 4, 6 2 275 325 475 6, 8 2 50 50 50 6, 8, turbo 3 0 0 0 6, 8, turbo 1 325 375 500 8, turbo 2 325 375 500 8, turbo 3 50 50 500 8, turbo 3 375 425 500 Engine Oil Change Information: Number of Miles per Oil Change: 3500 $ 39 Cost per Oil Change Highway Driving: Miles per Gallon Weight Class 1 2 3 4 40.7 41.0 NA Engine 6 34.1 30.8 26.4 8 turbo 31.9 29.7 27.5 26.4 24.2 23.1 Engine 6 29.7 26.4 23.1 8 turbo 26.4 25.3 22.0 20.9 19.8 18.7 Engine 6 27.3 24.2 21.2 8 turbo 24.2 27.8 20.2 23.0 18.2 20.6 Mixed Driving: Miles per Gallon Weight Class 1 2 3 4 36.3 36.0 NA City Driving: Miles per Gallon Weight Class 1 2 3 4 33.3 37.3 NA Name ALABAMA ALASKA ARIZONA ARKANSAS CALIFORNIA COLORADO CONNECTICUT DELAWARE DISTRICT OF COLUMBIA FLORIDA GEORGIA HAWAII IDAHO ILLINOIS INDIANA IOWA KANSAS KENTUCKY LOUISIANA MAINE MARYLAND MASSACHUSETTS MICHIGAN MINNESOTA MISSISSIPPI MISSOURI MONTANA NEBRASKA NEVADA NEW HAMPSHIRE NEW JERSEY NEW MEXICO NEW YORK NORTH CAROLINA NORTH DAKOTA OHIO OKLAHOMA OREGON PENNSYLVANIA RHODE ISLAND SOUTH CAROLINA SOUTH DAKOTA TENNESSEE TEXAS UTAH VERMONT VIRGINIA WASHINGTON WEST VIRGINIA WISCONSIN WYOMING Abbreviation AL AK AZ AR CA CO CT DE DC FL GA HI ID IL IN IA KS KY LA ME MD MA MI MN MS MO MT NE NV NH NJ NM NY NC ND OH OK OR PA RI SC SD TN TX UT VT VA WA WV WI WY Region Region# SE 2 W 5 SW 4 SE 2 W 5 W 5 NE 1 NE 1 NE SE SE W W MW MW MW MW 1 2 2 5 5 3 3 3 3 SE SE NE NE NE MW MW SE MW W MW W NE NE SW NE SE MW MW SW W NE NE SE MW SE SW W NE SE W SE MW W 2 2 1 1 1 3 3 2 3 5 3 5 1 1 4 1 2 3 3 4 5 1 1 2 3 2 4 5 1 2 5 2 3 5 Region Listing SE W SW NE MW 2 5 4 1 3 Insurance Estimate Calculator Region Base Cost 1 $ 2,200 2 1,750 3 1,425 4 1,120 5 2,650 Deduction for Addition Excellent for Poor Driver Driver $ 350 $ 550 325 475 300 450 300 450 350 625 Addition for City Residence $ 415 415 415 415 415 Deduction for Rural Residence $ 400 220 200 100 500 Average Gas Prices Region Average price per gallon 1 $4.00 2 3.59 3 3.69 4 3.39 5 4.12 ATTACHMENT PREVIEW Download attachment FullSizeRender-1.jpg ATTACHMENT PREVIEW Download attachment FullSizeRender-2.jpg ATTACHMENT PREVIEW Download attachment FullSizeRender-3.jpg ATTACHMENT PREVIEW Download attachment FullSizeRender.jpg
POETRY ARCHIVE FOUNDATION
Where Words Inspire, Connect, and Transform
CKG Auto Car Model Information Model # 1 2 3 4 5 6 7 8 9 Car Model Voltage Voltage Wagon Mia Mia XL Tiaf Dorf Sport Supra-V Nexus RunAbout Zemb
POETRY ARCHIVE

Welcome to a world where words dance and emotions take flight. Each poem here is a reflection of life’s beauty, struggles, and mysteries. Read, feel, and let the verses speak to you.