Analysis
MTSULiveHere
Apartment Rental Cost Analysis
As of June 30, 2020
Apartment Rental Contract Terms Customer-related data
Apartment type: 2-Bedroom Number of months renting apartment: 3
Monthly rental amount: $800.00 Estimated number of 100KWh needed: 35
Charge per 100 KWh electricity: $8.00
Pet-releated data
Average pounds of food per week: 10
Average cost per pound of food $2.85
Quote Renter Projected Costs of:
Apartment rental: $ 2,400.00
Electricity charge: 280.00
Pet food expenses: 342.00
Projected housing exp $ 3,022.00
Module 2 Assignment:
Part 1: Estimating Utilities at MTSULiveHere (MO-2.4)
MTSULiveHere is making several apartments available for new leases. Renters will frequently call the staff to receive quotes for rental expenses, including electricity and pets. As pet food prices have been fluctuating the last few years, customers have become more conscious of the price per pound and its impact on their total cost of housing. As a potential service to its renters, MTSULiveHere has modified its Rental workbook to include information on its apartments’ electricity usage and average amount of food the renter’s pets consume. All that remains to be added is a more detailed analysis of the interaction between pet food prices and total cost of housing, and the amount of pet food per week consumed and its impact on the total cost of housing. Complete the following:
1. Open the workbook named Rental.xlsx file and save it as MTSURental(your last name).xlsx.
2. Examine the Apartment worksheet and apply appropriate names to cells D17:D20.
3. Set up the structure of a one-variable data table on the Analysis worksheet that shows the apartment rental price, electricity charge, pet food expense, and projected housing expense given changes in the average price of pet food from $1.50 to $3.10 by increments of $0.20.
4. Instruct Excel to complete the one-variable data table.
HINT: In order to complete the one-variable data table successfully, be sure to select the correct data table range. If you instruct Excel to complete an incorrect range, you cannot just delete any “extra” results that might have appeared at the bottom or right of the intended data table area. When you try to do so, you will receive the “Cannot change part of a data table” error message. You cannot delete only some results from a filled-in data table; you must delete all results values from a one-variable data table if you want to delete any results.
5. Add headings and basic formatting to the data table so it has a more professional appearance.
6. A few rows below the one-variable data table, create the structure for a two-variable data table that shows the total projected housing expense given the interaction between average pet food prices from $1.50 to $3.10 by increments of $0.20 and pounds of food consumed per week from 5 to 25 by increments of 2 pounds per week.
7. Instruct Excel to complete the two-variable data table.
8. Add headings and some basic formatting to the data table so it has a more professional appearance.
9. Save and close the MTSURental.xlsx workbook.
Part 2: Managing Purchases for MTSU Toy Company (MO-2.3, 2.4)
Blue Raider Toy Company is planning a huge promotion for Mighty Toys action figures during the upcoming holiday season. As the company’s purchasing manager, your job is to determine the best way to purchase these toys from the manufacturer at the lowest price.
After contacting the Mighty Toys manufacturer, you learned that volume discounts and discounts for preseason orders are available on the Mighty Toys product line. You need to determine the best product mix based on the following information. The Blue Raider Urban Adventure set is the first item that most people will buy. Customers can also purchase the optional Super Action kit, which can be attached to the Blue Raider Urban Adventure set. Another companion set, the Blue Raider Outdoor set, has an optional Hiking kit that customers can purchase separately.
The marketing director for MTSU Toy Company, Betty Wright, wants to allocate the purchasing budget of $100,000 maximum among the four toys. Since the Super Action kit and the Hiking kit are accessories, Betty does not want to purchase more Super Action kits than Blue Raider Urban Adventure sets and does not want to purchase more Hiking kits than Blue Raider Outdoor sets. She also wants to purchase at least half as many Blue Raider Outdoor sets as Blue Raider Urban Adventure sets. The minimum number of any specific toy to be purchased is 250. She wants you to purchase at least 7,250 total items. All purchases must be for a whole item – no fractions of an item can be purchased.
Since you are purchasing the Mighty Toys early, you must consider the cost of storing the toys in the MTSU Toy warehouse until the holiday sales season begins.
Your objective is to maximize the profit on all four toys.
Complete the following:
1. Open the workbook named Mighty.xlsx and save it as MightyToys(your last name).xlsx.
2. Create a new worksheet called Lookup to the right of Purchase Plan. In the Lookup sheet, create a table that has monetary information on each of the toys:
a. Blue Raider Urban Adventure Set has a retail price of $19.95, a unit cost of $15.36, and a storage cost of $.15.
b. Super Action Kit has a retail price of $14.95, a unit cost of $14.21, and a storage cost of $.10.
c. Blue Raider Outdoor Set has a retail price of $16.95, a unit cost of $13.77, and a storage cost of $.25.
d. Hiking Kit has a retail price of $11.95, a unit cost of $10.03, and a storage cost of $.15.
3. On the Purchase Plan sheet, write the formulas that will populate the retail price, unit cost, and storage cost per unit in their respective cells.
4. Write the formulas that calculate the gross revenue (number purchased multiplied by the retail price), the total unit cost (unit cost multiplied by the number purchased), the total storage cost (storage cost per unit multiplied by the number purchased), the total cost (total unit cost plus total storage cost), and the profit (gross revenue minus the total cost) for each of the toys.
5. Write the formulas to add the total number of toys purchased in cell B8, the total cost in cell I8, and the total profit in cell J8. Check that formulas entered in Step 4 link the objective cell (total profit) with the variable cells. Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results.
6. Create a constraints list in the worksheet that identifies the constraints in this problem.
7. Format all monetary fields as currency with two decimal places.
8. Use Solver to determine the best way to purchase the Mighty Toys sets and kits and maximize the profit.
9. Produce an answer report of your final solution. Use the answer report to recommend additional changes that might maximize the total profit. Place your recommendations in a cell on the answer report worksheet.
10. Save and close the MightyToys.xlsx workbook.
Part 3: Determining Inventory Levels for MTSU Auto (MO-2.1, 2.2)
Another profitable facet of MTSU Auto’s business is supplying parts for auto repairs. The most critical component of the parts supply business is having enough of the right parts on hand so that repair shops can receive same-day delivery. The key to profits is minimizing the number of parts that need to be warehoused while also ensuring that sufficient parts are on hand to meet orders. Since each warehouse distribution center serves a different set of customers with different needs, each center must be considered separately. Distribution centers have a five-day lead time for ordering parts. The lead time must be taken into consideration when determining target inventory levels.
The costs involved in warehousing the parts include the working capital tied up in the inventory (the cost of each part) as well as the space to store the part. These costs can be substantial. On the other hand, alternative “generic” parts are often available from rival suppliers and keeping the auto repair centers supplied and customers satisfied is critical. One of the most problematic items to supply and store are bearings. This part is both high volume and relatively large, taking up considerable warehousing space. A bearing is also relatively expensive. Analyzing bearing needs is a good place for MTSU to start, specifically in one of its largest distribution centers such as Central Pittsburg, which serves 10 major customers. You have been asked to analyze the bearing inventory level requirements for this center, including simulating demand based on 30-day historical extremes, calculating a target inventory level based on this simulation, and then comparing simulated values to actual values from the past five days from the targeted warehouse.
Complete the following:
1. Open the workbook named Parts.xlsx and then save it as MTSU Parts Analysis(your last name).xlsx.
2. Modify the format of the data on the BearingData worksheet so that zero values are displayed with a 0 instead of the default dash, aligned on the right side of the column.
3. On the BearingData worksheet, take the existing 30-day data for these bearings for each customer to calculate the high and low limits of the bearing demand by customer.
4. On a new worksheet named Simulation, use the high and low limits you just calculated to simulate daily requirements for each customer to obtain a combined daily requirement. Assume that the daily requirements will vary for each customer randomly between the high and low limits you have calculated from the existing 30-day data for that customer. Generate the data for 180 instances (days) for each customer, and then copy the results as values (paste special – as values) to another new worksheet names Simulation Data 1. We copy the data over because the function used to create these numbers will run every single time you make a change to your workbook, changing the numbers. By pasting the values in another sheet, we prevent the accidental changing of the values generated.
5. On the Simulation Data 1 worksheet, in an adjacent column to the simulation data, calculate the total demand by day (for all 10 customers). Use this daily demand total data to calculate the overall mean, mode, median, and standard deviation for the combined requirements of all 10 customers. Use cell shading to clearly identify your calculation area.
6. Extend your analysis (on the same worksheet) to include a ranking of the data (1 to 180) so that the day with the least total demand has a rank of 1. (HINT: Use the RANK.EQ formula) Again, use cell shading to clearly identify columns with your calculations.
7. To the right of the data, create a listing of the top and bottom five daily combined demands from the 180 simulated instances (HINT: Use the LARGE and SMALL formulas). Clearly identify this listing using borders and shading.
8. Recommend a target inventory level needed for a five-day period based on the following:
to be on the cautious side, assume each day’s supply will be equal to the average daily demand for all locations combined, plus three standard deviations. Since the mean and standard deviations might not already be integers, round the daily demand up to the nearest whole number. Then, use this calculated daily demand (average plus 3 standard deviations) to calculate demand over a five-day period. Place this recommendation just below the top/bottom analysis, again clearly identifying it. Add the label Bearing Recommended to identify the cell containing the actual value.
9. The warehouse manager has tracked a total of five different parts over the past five days, recording for each shipment the value of the part and the number of days it was in storage. One of these tracked parts is the bearing you have just analyzed. The data has been compiled in a workbook named Demand.xlsx. Each line item represents a single shipment of one item. Copy the data from the Demand.xlsx workbook to your workbook and place it on a worksheet named
Actual Demand.
10. On the same worksheet, summarize the data to determine the number shipped by part, the total values of those shipments by part, and the average number of days that part was stored, using the format shown in the table below
Item Description
# Items Shipped
Total Dollar Value of Items Shipped
Average # Days Held in Inventory
Bearings
blank
blank
blank
Timing Belts
blank
blank
blank
Air Filters
blank
blank
blank
Fan Belt
blank
blank
blank
Electronic Board
blank
blank
blank
In the # Items Shipped column, write a formula to determine the number of bearings shipped. Write the formula so that it can be copied down the column to automatically determine the number of timing belts shipped, the number of air filters shipped, and so on. In the Total Dollar Value of Items Shipped column, write a formula to determine the value of all bearings shipped. Again, write the formula so that it can be copied down the column to automatically determine the value of timing belts, air filters, and so on. In the Average #Days Held in Inventory column, write a formula to determine the average number of days bearings shipped were held in inventory; again, write the formula so that it can be copied down the column.
11. Based on the recommended inventory level you previously calculated for bearings, would you have had enough bearings in the warehouse to cover these orders? Place your answer in a cell below your analysis on the Actual Demand worksheet. Clearly identify this answer and highlight it in yellow.
12. Double-check all values and formulas for correct implementation. Include sufficient formatting and titles to clearly identify the worksheet elements.
13. Save and close the MTSU Parts Analysis.xlsx workbook.
BearingData
Orders for a Sample 30-Day Period
Customer#
Day 2010 2038 2147 2249 2355 2397 2453 2533 2575 2696
1 9 7 6 4 6 9 5 7 13 8
2 6 7 7 4 6 3 1 10 6 4
3 3 8 3 5 18 1 10 2 7 2
4 4 2 – 0 5 7 8 10 10 12 8
5 4 10 4 5 13 – 0 1 9 8 8
6 15 10 – 0 2 14 8 2 8 13 6
7 6 6 2 4 12 1 2 5 9 5
8 12 11 6 7 5 7 5 10 12 2
9 10 6 4 3 12 6 4 3 8 2
10 12 11 1 4 10 – 0 – 0 9 6 2
11 11 2 5 1 11 9 9 1 13 7
12 3 5 6 7 15 – 0 9 5 7 5
13 6 3 6 7 16 5 3 1 8 8
14 8 8 – 0 3 17 6 – 0 7 2 3
15 4 6 1 7 15 5 1 2 13 3
16 7 9 1 7 11 – 0 3 10 10 6
17 3 7 6 4 12 2 5 5 9 7
18 3 3 1 6 9 9 10 9 6 4
19 14 8 2 7 8 9 1 – 0 7 8
20 5 7 4 3 10 – 0 – 0 9 8 5
21 15 2 – 0 3 14 7 7 7 4 12
22 5 11 1 5 14 2 10 4 7 2
23 14 6 5 1 9 1 – 0 9 12 5
24 6 3 1 7 8 1 7 4 13 5
25 11 2 1 3 9 2 6 7 4 2
26 12 11 – 0 1 15 – 0 5 6 2 3
27 15 11 6 4 13 7 – 0 4 13 2
28 13 11 – 0 3 14 6 – 0 7 13 2
29 16 3 – 0 1 14 4 – 0 2 7 8
30 11 3 5 2 16 2 7 3 2 2
Purchase Plan
Mighty Toys Purchasing Plan
Number Purchased Retail Price Gross Revenue Unit Cost Total Unit Cost Storage Cost per Unit Total Storage Cost Total Cost Profit
Blue Raider Urban Adventure Set 1
Super Action Kit 1
Blue Raider Outdoor Set 1
Hiking Kit 0
Total
Constraints
Sheet1
Description Value #Days in Inventory
Timing Belts 34.95 31
Fan Belt 3.59 34
Fan Belt 3.59 23
Fan Belt 3.59 19
Bearings 43.25 35
Bearings 43.25 11
Fan Belt 3.59 19
Bearings 43.25 18
Bearings 135 21
Bearings 135 31
Bearings 43.25 12
Bearings 135 35
Timing Belts 34.95 11
Bearings 135 40
Air Filters 2.25 35
Bearings 135 33
Timing Belts 34.95 35
Bearings 43.25 25
Bearings 43.25 6
Air Filters 2.25 37
Timing Belts 34.95 18
Fan Belt 3.59 8
Bearings 135 18
Bearings 135 32
Air Filters 2.25 36
Fan Belt 3.59 11
Fan Belt 3.59 19
Bearings 43.25 8
Air Filters 2.25 30
Fan Belt 125 35
Bearings 43.25 4
Timing Belts 34.95 19
Fan Belt 3.59 22
Air Filters 2.25 21
Fan Belt 3.59 17
Air Filters 2.25 2
Air Filters 2.25 36
Air Filters 2.25 3
Fan Belt 125 20
Timing Belts 34.95 1
Fan Belt 34.95 38
Bearings 43.25 13
Bearings 34.95 30
Fan Belt 3.59 40
Bearings 135 32
Fan Belt 125 15
Fan Belt 3.59 8
Fan Belt 3.59 31
Air Filters 34.95 33
Air Filters 2.25 6
Air Filters 2.25 19
Timing Belts 34.95 15
Bearings 43.25 1
Fan Belt 3.59 40
Bearings 135 37
Bearings 135 27
Bearings 135 38
Air Filters 2.25 8
Bearings 43.25 38
Air Filters 34.95 26
Bearings 43.25 12
Bearings 43.25 22
Air Filters 2.25 13
Fan Belt 3.59 1
Bearings 43.25 14
Fan Belt 3.59 26
Bearings 43.25 37
Fan Belt 3.59 16
Bearings 135 39
Fan Belt 3.59 33
Fan Belt 3.59 15
Timing Belts 34.95 35
Bearings 43.25 16
Fan Belt 3.59 31
Air Filters 34.95 12
Bearings 43.25 39
Bearings 135 38
Fan Belt 3.59 15
Bearings 135 7
Air Filters 125 17
Fan Belt 3.59 29
Timing Belts 34.95 6
Air Filters 125 36
Fan Belt 3.59 23
Air Filters 2.25 21
Electronic Board 125 10
Timing Belts 34.95 6
Bearings 43.25 28
Air Filters 2.25 27
Timing Belts 34.95 39
Bearings 135 2
Fan Belt 3.59 5
Bearings 43.25 28
Bearings 43.25 10
Bearings 135 9
Timing Belts 34.95 39
Air Filters 125 32
Air Filters 2.25 22
Air Filters 2.25 19
Air Filters 2.25 21
Bearings 43.25 4
Fan Belt 3.59 13
Electronic Board 125 30
Bearings 43.25 40
Air Filters 2.25 39
Bearings 135 12
Timing Belts 34.95 3
Air Filters 2.25 23
Air Filters 2.25 25
Bearings 135 28
Bearings 43.25 3
Air Filters 125 4
Bearings 135 25
Air Filters 2.25 28
Bearings 43.25 21
Bearings 135 4
Air Filters 2.25 29
Air Filters 2.25 4
Air Filters 2.25 36
Air Filters 125 3
Bearings 43.25 12
Bearings 135 15
Fan Belt 3.59 32
Fan Belt 3.59 38
Timing Belts 34.95 14
Bearings 135 1
Fan Belt 3.59 38
Fan Belt 125 1
Fan Belt 3.59 2
Timing Belts 34.95 36
Bearings 135 40
Fan Belt 3.59 14
Bearings 135 2
Air Filters 2.25 1
Bearings 43.25 30
Fan Belt 3.59 27
Air Filters 2.25 36
Timing Belts 34.95 21
Timing Belts 34.95 30
Timing Belts 34.95 35
Air Filters 2.25 36
Bearings 135 24
Bearings 43.25 15
Fan Belt 3.59 13
Fan Belt 125 7
Fan Belt 3.59 17
Bearings 43.25 33
Air Filters 125 1
Bearings 43.25 39
Fan Belt 3.59 36
Timing Belts 34.95 39
Fan Belt 3.59 25
Timing Belts 34.95 9
Air Filters 2.25 13
Timing Belts 34.95 20
Bearings 43.25 12
Fan Belt 3.59 40
Timing Belts 34.95 24
Air Filters 2.25 14
Fan Belt 3.59 37
Fan Belt 3.59 15
Bearings 135 16
Air Filters 2.25 16
Bearings 43.25 13
Fan Belt 3.59 4
Air Filters 2.25 16
Air Filters 2.25 35
Bearings 43.25 25
Air Filters 2.25 21
Timing Belts 34.95 13
Timing Belts 34.95 29
Timing Belts 34.95 38
Air Filters 2.25 8
Air Filters 2.25 26
Air Filters 2.25 36
Timing Belts 34.95 5
Bearings 43.25 11
Bearings 43.25 38
Electronic Board 125 2
Fan Belt 3.59 9
Timing Belts 34.95 19
Timing Belts 34.95 31
Bearings 135 23
Bearings 43.25 4
Fan Belt 3.59 30
Bearings 135 34
Bearings 43.25 36
Timing Belts 34.95 1
Fan Belt 3.59 15
Fan Belt 125 13
Bearings 43.25 30
Bearings 43.25 16
Bearings 135 12
Bearings 43.25 38
Air Filters 2.25 30
Air Filters 2.25 18
Fan Belt 3.59 17
Fan Belt 3.59 31
Bearings 135 37
Fan Belt 3.59 37
Timing Belts 34.95 20
Fan Belt 125 32
Air Filters 2.25 29
Timing Belts 34.95 36
Fan Belt 3.59 10
Electronic Board 125 29
Bearings 43.25 10
Bearings 135 9
Bearings 43.25 16
Fan Belt 3.59 30
Air Filters 2.25 13
Fan Belt 3.59 40
Timing Belts 34.95 36
Bearings 43.25 3
Timing Belts 34.95 19
Fan Belt 3.59 10
Timing Belts 34.95 25
Timing Belts 34.95 6
Timing Belts 34.95 21
Air Filters 125 15
Bearings 43.25 1
Bearings 43.25 25
Air Filters 2.25 27
Fan Belt 3.59 34
Air Filters 2.25 38
Air Filters 2.25 6
Timing Belts 34.95 27
Fan Belt 3.59 8
Bearings 135 27
Bearings 135 7
Fan Belt 3.59 3
Timing Belts 34.95 29
Fan Belt 3.59 28
Bearings 43.25 5
Air Filters 2.25 31
Bearings 135 38
Air Filters 2.25 34
Air Filters 2.25 17
Timing Belts 34.95 39
Bearings 43.25 17
Timing Belts 34.95 13
Air Filters 2.25 22
Air Filters 2.25 21
Timing Belts 34.95 22
Bearings 43.25 29
Air Filters 125 2
Fan Belt 3.59 5
Timing Belts 34.95 25
Fan Belt 3.59 24
Bearings 135 16
Air Filters 2.25 39
Timing Belts 34.95 40
Bearings 135 4
Electronic Board 125 29
Bearings 135 20
Fan Belt 3.59 12
Air Filters 2.25 32
Bearings 43.25 40
Air Filters 2.25 25
Bearings 135 2
Air Filters 2.25 20
Bearings 135 36
Timing Belts 34.95 17
Timing Belts 34.95 19
Fan Belt 3.59 23
Bearings 135 8
Fan Belt 3.59 12
Fan Belt 3.59 13
Air Filters 2.25 7
Air Filters 2.25 38
Air Filters 2.25 4
Timing Belts 34.95 23
Timing Belts 34.95 23
Fan Belt 3.59 38
Fan Belt 3.59 21
Timing Belts 34.95 14
Air Filters 2.25 16
Fan Belt 3.59 10
Fan Belt 3.59 39
Fan Belt 3.59 28
Fan Belt 3.59 8
Timing Belts 34.95 4
Air Filters 2.25 24
Timing Belts 34.95 8
Air Filters 2.25 40
Timing Belts 34.95 8
Timing Belts 34.95 20
Bearings 43.25 25
Bearings 135 14
Fan Belt 3.59 25
Timing Belts 34.95 33
Timing Belts 34.95 39
Timing Belts 34.95 25
Timing Belts 34.95 23
Bearings 135 6
Bearings 43.25 1
Fan Belt 3.59 8
Fan Belt 3.59 6
Fan Belt 3.59 20
Bearings 135 20
Bearings 43.25 39
Timing Belts 34.95 32
Bearings 43.25 4
Fan Belt 3.59 16
Air Filters 2.25 6
Bearings 135 34
Electronic Board 125 24
Fan Belt 3.59 22
Air Filters 2.25 40
Timing Belts 34.95 13
Timing Belts 34.95 6
Bearings 43.25 20
Fan Belt 125 14
Bearings 43.25 29
Air Filters 2.25 11
Timing Belts 34.95 40
Fan Belt 3.59 11
Fan Belt 3.59 3
Air Filters 2.25 37
Timing Belts 34.95 20
Air Filters 2.25 36
Air Filters 2.25 13
Fan Belt 3.59 6
Fan Belt 3.59 24
Bearings 43.25 19
Fan Belt 3.59 39
Bearings 43.25 36
Timing Belts 34.95 40
Bearings 43.25 28
Bearings 43.25 16
Air Filters 2.25 28
Timing Belts 34.95 16
Timing Belts 34.95 36
Bearings 135 28
Bearings 43.25 32
Fan Belt 3.59 28
Timing Belts 34.95 8
Timing Belts 34.95 6
Air Filters 2.25 13
Timing Belts 34.95 32
Fan Belt 3.59 16
Bearings 135 20
Bearings 43.25 22
Bearings 135 25
Timing Belts 34.95 14
Fan Belt 3.59 16
Air Filters 2.25 21
Fan Belt 3.59 9
Bearings 135 4
Bearings 43.25 8
Timing Belts 34.95 5
Timing Belts 34.95 11
Bearings 135 21
Air Filters 2.25 31
Air Filters 125 26
Bearings 43.25 31
Bearings 43.25 12
Fan Belt 3.59 35
Air Filters 2.25 6
Bearings 43.25 38
Air Filters 2.25 19
Air Filters 2.25 9
Air Filters 2.25 22
Fan Belt 125 15
Air Filters 125 9
Air Filters 2.25 9
Timing Belts 34.95 23
Bearings 43.25 12
Fan Belt 3.59 12
Bearings 43.25 6
Fan Belt 3.59 27
Timing Belts 34.95 32
Fan Belt 3.59 40
Bearings 43.25 10
Timing Belts 34.95 10
Bearings 43.25 30
Timing Belts 34.95 9
Air Filters 2.25 30
Bearings 43.25 16
Fan Belt 3.59 35
Bearings 135 13
Air Filters 2.25 7
Bearings 43.25 5
Timing Belts 34.95 27
Bearings 43.25 20
Fan Belt 3.59 17
Fan Belt 3.59 20
Bearings 135 31
Bearings 43.25 21
Bearings 135 36
Timing Belts 34.95 11
Bearings 43.25 7
Bearings 43.25 30
Timing Belts 34.95 17
Bearings 135 6
Air Filters 2.25 15
Fan Belt 3.59 17
Timing Belts 34.95 37
Fan Belt 3.59 35
Bearings 43.25 28
Bearings 135 7
Timing Belts 34.95 36
Timing Belts 34.95 3
Air Filters 2.25 38
Bearings 43.25 8
Fan Belt 3.59 33
Fan Belt 3.59 35
Air Filters 2.25 2
Bearings 135 32
Air Filters 2.25 38
Bearings 135 13
Timing Belts 34.95 19
Fan Belt 125 22
Air Filters 125 14
Air Filters 2.25 40
Bearings 43.25 24
Bearings 135 1
Bearings 135 35
Fan Belt 3.59 1
Bearings 43.25 11
Bearings 43.25 20
Bearings 43.25 5
Bearings 135 36
Bearings 43.25 11
Fan Belt 3.59 39
Air Filters 2.25 15
Bearings 43.25 22
Timing Belts 34.95 28
Bearings 135 37
Bearings 43.25 28
Air Filters 2.25 33
Fan Belt 3.59 12
Bearings 43.25 26
Bearings 135 10
Fan Belt 3.59 12
Air Filters 2.25 12
Timing Belts 34.95 3
Fan Belt 3.59 19
Fan Belt 3.59 5
Fan Belt 125 38
Bearings 43.25 34
Air Filters 2.25 24
Bearings 135 21
Fan Belt 3.59 27
Air Filters 2.25 3
Bearings 135 20
Bearings 43.25 29
Fan Belt 3.59 12
Bearings 135 13
Timing Belts 34.95 26
Air Filters 2.25 25
Fan Belt 3.59 32
Fan Belt 3.59 8
Timing Belts 34.95 36
Air Filters 125 18
Bearings 43.25 26
Timing Belts 34.95 3
Bearings 43.25 30
Bearings 135 35
Timing Belts 34.95 35
Timing Belts 34.95 40
Air Filters 2.25 29
Air Filters 2.25 1
Fan Belt 3.59 31
Air Filters 2.25 11
Timing Belts 34.95 40
Bearings 43.25 1
Timing Belts 34.95 25
Fan Belt 3.59 25
Bearings 135 19
Bearings 43.25 22
Bearings 43.25 33
Timing Belts 34.95 19
Electronic Board 125 40
Timing Belts 34.95 6
Fan Belt 3.59 7
Bearings 135 35
Bearings 135 10
Fan Belt 125 12
Bearings 43.25 35
Bearings 135 2
Bearings 43.25 14
Air Filters 2.25 31
Fan Belt 3.59 6
Timing Belts 34.95 35
Bearings 43.25 6
Fan Belt 3.59 38
Air Filters 2.25 22
Bearings 135 31
Air Filters 2.25 8
Bearings 135 8
Timing Belts 34.95 37
Air Filters 2.25 3
Bearings 135 35
Bearings 135 23
Timing Belts 34.95 19
Air Filters 2.25 6
Air Filters 2.25 17
Air Filters 125 37
Timing Belts 34.95 32
Timing Belts 34.95 13
Timing Belts 34.95 22
Bearings 135 6
Timing Belts 34.95 32
Bearings 43.25 18
Bearings 135 26
Bearings 43.25 16
Fan Belt 3.59 34
Bearings 135 34
Fan Belt 3.59 8
Air Filters 2.25 23
Air Filters 125 34
Air Filters 2.25 40
Timing Belts 34.95 30
Bearings 43.25 38
Bearings 43.25 29
Fan Belt 3.59 38
Air Filters 2.25 40
Air Filters 2.25 7
Fan Belt 3.59 36
Electronic Board 125 13
Bearings 135 19
Fan Belt 3.59 13
Timing Belts 34.95 28
Bearings 135 37
Air Filters 2.25 31
Bearings 43.25 21
Timing Belts 34.95 10
Bearings 135 31
Fan Belt 3.59 32
Timing Belts 34.95 25
Air Filters 2.25 30
Timing Belts 34.95 8
Timing Belts 34.95 28
Timing Belts 34.95 26
Bearings 43.25 12
Timing Belts 34.95 28
Timing Belts 34.95 2
Air Filters 2.25 8
Fan Belt 3.59 31
Bearings 43.25 8
Air Filters 2.25 6
Bearings 43.25 6
Bearings 43.25 2
Fan Belt 125 20
Fan Belt 125 8
Timing Belts 34.95 33
Air Filters 2.25 1
Fan Belt 3.59 10
Bearings 43.25 20
Bearings 135 16
Fan Belt 3.59 9
Timing Belts 34.95 26
Bearings 135 27
Timing Belts 34.95 15
Timing Belts 34.95 1
Bearings 43.25 4
Bearings 135 17
Bearings 43.25 27
Air Filters 2.25 11
Timing Belts 34.95 31
Timing Belts 34.95 10
Air Filters 2.25 31
Bearings 43.25 32
Timing Belts 34.95 32
Air Filters 2.25 20
Air Filters 125 5
Bearings 43.25 33
Bearings 43.25 3
Fan Belt 3.59 3
Bearings 43.25 28
Fan Belt 3.59 26
Timing Belts 34.95 22
Bearings 43.25 9
Timing Belts 34.95 32
Air Filters 2.25 39
Bearings 43.25 30
Bearings 135 15
Air Filters 2.25 11
Fan Belt 3.59 23
Timing Belts 34.95 25
Timing Belts 34.95 34
Timing Belts 34.95 25
Fan Belt 3.59 19
Bearings 135 11
Fan Belt 3.59 38
Air Filters 2.25 4
Bearings 43.25 8
Bearings 135 4
Bearings 43.25 8
Fan Belt 3.59 16
Bearings 43.25 25
Air Filters 125 34
Timing Belts 34.95 3
Air Filters 2.25 25
Air Filters 2.25 24
Fan Belt 3.59 3
Timing Belts 34.95 35
Bearings 135 40
Bearings 135 25
Air Filters 2.25 31
Air Filters 2.25 30
Air Filters 2.25 11
Bearings 43.25 27
Bearings 43.25 36
Fan Belt 3.59 29
Air Filters 2.25 37
Bearings 43.25 2
Air Filters 2.25 21
Fan Belt 3.59 37
Fan Belt 3.59 11
Air Filters 2.25 24
Timing Belts 34.95 4
Bearings 135 39
Timing Belts 34.95 23
Bearings 43.25 29
Fan Belt 3.59 11
Air Filters 125 18
Bearings 135 23
Bearings 135 39
Air Filters 2.25 34
Bearings 135 21
Fan Belt 3.59 20
Bearings 135 30
Air Filters 2.25 3
Bearings 43.25 9
Bearings 135 9
Fan Belt 3.59 11
Air Filters 2.25 30
Air Filters 2.25 12
Fan Belt 3.59 11
Bearings 135 2
Timing Belts 34.95 24
Fan Belt 3.59 17
Air Filters 2.25 37
Air Filters 2.25 39
Fan Belt 3.59 17
Air Filters 2.25 33
Timing Belts 34.95 15
Air Filters 2.25 34
Bearings 43.25 24
Timing Belts 34.95 21
Fan Belt 3.59 3
Bearings 135 22
Fan Belt 3.59 36
Timing Belts 34.95 2
Fan Belt 3.59 31
Bearings 43.25 6
Bearings 135 19
Timing Belts 34.95 15
Air Filters 2.25 9
Fan Belt 3.59 13
Timing Belts 34.95 3
Bearings 43.25 33
Air Filters 125 4
Air Filters 2.25 12
Air Filters 125 30
Fan Belt 3.59 9
Bearings 43.25 33
Timing Belts 34.95 30
Bearings 43.25 27
Fan Belt 3.59 9
Bearings 43.25 5
Bearings 43.25 34
Bearings 43.25 3
Fan Belt 3.59 17
Bearings 43.25 10
Timing Belts 34.95 30
Fan Belt 3.59 19
Timing Belts 34.95 39
Bearings 135 15
Bearings 135 31
Fan Belt 3.59 13
Fan Belt 3.59 6
Timing Belts 34.95 32
Fan Belt 3.59 24
Bearings 43.25 35
Air Filters 2.25 30
Fan Belt 3.59 39
Air Filters 2.25 38
Bearings 43.25 18
Air Filters 2.25 26
Bearings 43.25 26
Fan Belt 3.59 28
Timing Belts 34.95 18
Bearings 135 7
Timing Belts 34.95 9
Fan Belt 3.59 13
Bearings 135 28
Fan Belt 125 7
Fan Belt 3.59 26
Timing Belts 34.95 30
Fan Belt 3.59 35
Air Filters 2.25 35
Timing Belts 34.95 1
Timing Belts 34.95 37
Bearings 135 23
Bearings 135 7
Air Filters 2.25 28
Air Filters 2.25 25
Timing Belts 34.95 21
Fan Belt 3.59 7
Air Filters 2.25 5
Timing Belts 34.95 14
Air Filters 2.25 28
Air Filters 2.25 38
Timing Belts 34.95 35
Fan Belt 3.59 17
Air Filters 2.25 28
Bearings 43.25 36
Bearings 43.25 24
Air Filters 2.25 3
Bearings 135 8
Fan Belt 3.59 34
Electronic Board 125 22
Timing Belts 34.95 19
Air Filters 2.25 36
Fan Belt 125 10
Air Filters 2.25 14
Timing Belts 34.95 14
Fan Belt 3.59 29
Timing Belts 34.95 8
Air Filters 2.25 20
Air Filters 2.25 39
Bearings 135 6
Air Filters 2.25 28
Fan Belt 3.59 26
Timing Belts 34.95 14
Timing Belts 34.95 21
Bearings 43.25 30
Timing Belts 34.95 33
Bearings 135 32
Air Filters 2.25 22
Timing Belts 34.95 15
Bearings 135 2
Air Filters 2.25 11
Bearings 43.25 18
Air Filters 2.25 20
Fan Belt 3.59 10
Air Filters 2.25 16
Fan Belt 3.59 25
Timing Belts 34.95 29
Fan Belt 3.59 25
Bearings 135 3
Bearings 43.25 32
Fan Belt 3.59 29
Air Filters 2.25 22
Bearings 43.25 11
Fan Belt 3.59 7
Air Filters 2.25 28
Air Filters 2.25 33
Timing Belts 34.95 1
Timing Belts 34.95 20
Air Filters 2.25 14
Timing Belts 34.95 32
Bearings 43.25 14
Air Filters 2.25 29
Timing Belts 34.95 28
Fan Belt 3.59 5
Air Filters 2.25 4
Air Filters 2.25 28
Air Filters 2.25 20
Fan Belt 3.59 23
Fan Belt 3.59 30
Fan Belt 3.59 4
Air Filters 2.25 29
Fan Belt 3.59 25
Timing Belts 34.95 23
Fan Belt 3.59 19
Bearings 43.25 13
Air Filters 2.25 20
Timing Belts 34.95 37
Bearings 43.25 30
Timing Belts 34.95 28
Timing Belts 34.95 22
Air Filters 2.25 5
Fan Belt 3.59 4
Fan Belt 125 10
Timing Belts 34.95 19
Bearings 43.25 8
Bearings 43.25 25
Air Filters 2.25 39
Air Filters 2.25 25
Fan Belt 3.59 21
Bearings 43.25 20
Fan Belt 3.59 34
Bearings 43.25 27
Fan Belt 3.59 15
Bearings 43.25 32
Timing Belts 34.95 3
Bearings 43.25 27
Fan Belt 3.59 17
Fan Belt 3.59 30
Bearings 43.25 25
Air Filters 2.25 12
Fan Belt 3.59 21
Bearings 135 10
Air Filters 2.25 31
Bearings 135 17
Timing Belts 34.95 9
Timing Belts 34.95 29
Air Filters 2.25 37
Fan Belt 3.59 38
Bearings 43.25 23
Fan Belt 3.59 12
Fan Belt 3.59 30
Bearings 43.25 3
Air Filters 125 7
Fan Belt 3.59 26
Bearings 43.25 23
Air Filters 2.25 26
Timing Belts 34.95 33
Bearings 135 22
Air Filters 2.25 8
Air Filters 2.25 30
Fan Belt 3.59 35
Bearings 135 30
Fan Belt 3.59 18
Air Filters 125 15
Timing Belts 34.95 16
Electronic Board 125 21
Bearings 135 25
Bearings 135 28
Fan Belt 3.59 18
Bearings 43.25 19
Bearings 43.25 21
Fan Belt 125 20
Timing Belts 34.95 7
Air Filters 2.25 17
Timing Belts 34.95 23
Timing Belts 34.95 23
Fan Belt 3.59 22
Timing Belts 34.95 26
Fan Belt 125 2
Air Filters 2.25 2
Bearings 43.25 27
Bearings 43.25 12
Air Filters 2.25 36
Bearings 43.25 10
Timing Belts 34.95 5
Air Filters 2.25 34
Bearings 135 16
Air Filters 125 5
Timing Belts 34.95 37
Timing Belts 34.95 8
Air Filters 125 22
Timing Belts 34.95 23
Air Filters 2.25 35
Timing Belts 34.95 7
Bearings 43.25 5
Bearings 43.25 12
Bearings 135 9
Timing Belts 34.95 38
Fan Belt 3.59 34
Fan Belt 3.59 16
Timing Belts 34.95 4
Timing Belts 34.95 32
Fan Belt 3.59 10
Bearings 135 40
Bearings 135 6
Bearings 135 14
Bearings 135 37
Air Filters 125 16
Fan Belt 3.59 2
Timing Belts 34.95 35
Fan Belt 3.59 23
Bearings 135 2
Timing Belts 34.95 20
Fan Belt 3.59 27
Bearings 135 18
Fan Belt 125 38
Air Filters 2.25 14
Timing Belts 34.95 3
Bearings 135 34
Bearings 43.25 31
Air Filters 2.25 6
Air Filters 2.25 20
Timing Belts 34.95 19
Timing Belts 34.95 20
Timing Belts 34.95 25
Bearings 43.25 15
Fan Belt 3.59 24
Bearings 135 22
Bearings 43.25 32
Air Filters 2.25 27
Bearings 43.25 2
Fan Belt 3.59 33
Bearings 43.25 6
Bearings 135 29
Bearings 135 35
Air Filters 125 3
Air Filters 2.25 12
Air Filters 125 13
Bearings 43.25 7
Fan Belt 125 8
Air Filters 2.25 18
Bearings 43.25 5
Bearings 135 8
Bearings 43.25 37
Timing Belts 34.95 25
Air Filters 2.25 33
Fan Belt 3.59 19
Bearings 135 11
Fan Belt 3.59 31
Air Filters 2.25 11
Air Filters 2.25 11
Bearings 43.25 30
Fan Belt 3.59 32
Timing Belts 34.95 8
Timing Belts 34.95 38
Bearings 135 1
Air Filters 2.25 22
Fan Belt 3.59 39
Fan Belt 3.59 34
Bearings 135 22
Fan Belt 3.59 30
Bearings 43.25 24
Bearings 43.25 21
Fan Belt 3.59 9
Bearings 43.25 17
Bearings 135 13
Air Filters 2.25 34
Fan Belt 3.59 12
Electronic Board 125 6
Timing Belts 34.95 40
Fan Belt 3.59 12
Fan Belt 3.59 19
Air Filters 2.25 34
Air Filters 2.25 27
Fan Belt 125 3
Bearings 135 36
Bearings 135 4
Air Filters 2.25 36
Timing Belts 34.95 1
Bearings 135 14
Timing Belts 34.95 4
Bearings 43.25 23
Air Filters 125 29
Timing Belts 34.95 32
Air Filters 2.25 36
Timing Belts 34.95 37
Air Filters 125 3
Bearings 135 10
Bearings 43.25 37
Bearings 135 8
Air Filters 125 7
Air Filters 2.25 33
Fan Belt 3.59 18
Bearings 43.25 15
Bearings 43.25 8
Fan Belt 3.59 22
Fan Belt 3.59 4
Bearings 135 18
Bearings 135 2
Timing Belts 34.95 35
Air Filters 2.25 24
Air Filters 2.25 39
Bearings 43.25 29
Air Filters 2.25 9
Fan Belt 125 20
Fan Belt 3.59 23
Bearings 43.25 1
Timing Belts 34.95 12
Air Filters 2.25 7
Bearings 135 1
Bearings 43.25 32
Air Filters 2.25 17
Air Filters 2.25 21
Bearings 135 1
Air Filters 2.25 12
Timing Belts 34.95 32
Air Filters 125 34
Timing Belts 34.95 27
Bearings 135 33
Bearings 43.25 1
Timing Belts 34.95 3
Timing Belts 34.95 8
Bearings 43.25 27
Fan Belt 3.59 27
Timing Belts 34.95 21
Timing Belts 34.95 8
Air Filters 2.25 6
Electronic Board 125 27
Bearings 43.25 14
Air Filters 2.25 25
Timing Belts 34.95 31
Bearings 43.25 27
Fan Belt 3.59 15
Bearings 43.25 32
Bearings 135 4
Timing Belts 34.95 37
