158 INTRODUCTION TO INFORMATION SYSTEMS APPLICATION EXERCISES 5-13. EXCEL APPLICATION: average imentory (units, based on 150% of propted daily sales multiplied by the number of shipping days from the sup- plier. The average inventory value equals the per unit delivered cost multiplied by the average inventory (units) Performance Bicycle Parts Ted Stevens owns an Internes -based bicycle accessorics web- p site that sells bicycle tires, tubes, chains, sprockets, and seats as putting way well as helmets and water boeles. The bicycle parts aftermar Inventory carrying costs include the cost of stock and moving material within the warchouse, rent and utils shipnine r ties for warchouse space, insurance and taxes on imventory, and supply chain and relies imentory shrinkage. Ted calculates his total inventory cary- ket is very competitive. and Ted realizes that having both a low critical to his success. He has a global relies ry oe many different supplier sources for the quality products his Lng o customers demand. average inventory value. The average per unit carrying cost equals the total iventory canying cos costs at 24% of the divided by the total nomber of units sold per year (144,000. Ted sells more replacement tubes than any other product For this item, customers expect high quality at a competitive Which supplier source requires the highest investment of working capital or cash for average inventory? Which supplier spent several months evaluating the quality and soarce provides Ted with the highest percentage of gross prott performance of six potential suppliers for the most popular replacement tube, the 29" x 1.85"-2.20 presta tube. These suppliers manufacture replacement tubes of comparable quality and performance. With the right price, quality, and availability Ted expects to sell an average of 12.000 tubes per month, or 400 tubes per day, for $6.50 each. However, he is concermed about VSI Consultants Group, Inc, is a professional IT consulting the amount of cash or working capital required to suppot the firm that provides business and noeprofit organizations with level of inventory he needs to provide same-day shipping. the highly skilled IT professionals they need to complete IT on the presta r on the presta replacement tube? 5-14. ACCESS APPLICATION: VSI Consultants Using e staffing problems. VSI matches employ spreadsheet to analyze the replacement tube cost structure for six ees with client projects based on employee education, skills, potential suppliers. Per unit import duty cost equals the import and experience. Emily Loftus, the HR manager, has asked you duty rate multiplied by the sum of per unit base cost and the per to use the information provided in the spreadsbeet shown in unit shipping cost. The per unit warehouse cost is the sum of the Figures S-23, 5-24, and 5-25 to create an Access database to per unit base cost and the per unit shipping cost and the per unit manage employees and projects. You can download the Excel import duty cost. The per unit total cost is the sum of the per unit file ChOSEx02 and import the worksheets to tables in your database. Emily wants you to create two queries. The first Required inventory levels are based on projected daily sales query identifies the best candidates for three client projects imes the number of shipping days required for delivery from U.S. Brokerage, Helen's Clothiers, and Solar Systems. The sec- he supplier to Ted's warehouse. A longer delivery time requires ond query matches employees with projects. Specifically, she Ted to maintain a higher level of inventory. Thus, he wants to wants to match projects for two employees: Y326 and T871 warehouse cost and the average per unit carrying cost. nclude inventory carrying costs in the analysis. Ted maintains What other queries may be useful to Emily FIGURE 5-22 Suppies for Pertormance Boycle Parts Souee Microsoft Excel, Microsoft Corporation. Reprinned wich peniss 158 INTRODUCTION TO INFORMATION SYSTEMS APPLICATION EXERCISES 5-13. EXCEL APPLICATION: average imentory (units, based on 150% of propted daily sales multiplied by the number of shipping days from the sup- plier. The average inventory value equals the per unit delivered cost multiplied by the average inventory (units) Performance Bicycle Parts Ted Stevens owns an Internes -based bicycle accessorics web- p site that sells bicycle tires, tubes, chains, sprockets, and seats as putting way well as helmets and water boeles. The bicycle parts aftermar Inventory carrying costs include the cost of stock and moving material within the warchouse, rent and utils shipnine r ties for warchouse space, insurance and taxes on imventory, and supply chain and relies imentory shrinkage. Ted calculates his total inventory cary- ket is very competitive. and Ted realizes that having both a low critical to his success. He has a global relies ry oe many different supplier sources for the quality products his Lng o customers demand. average inventory value. The average per unit carrying cost equals the total iventory canying cos costs at 24% of the divided by the total nomber of units sold per year (144,000. Ted sells more replacement tubes than any other product For this item, customers expect high quality at a competitive Which supplier source requires the highest investment of working capital or cash for average inventory? Which supplier spent several months evaluating the quality and soarce provides Ted with the highest percentage of gross prott performance of six potential suppliers for the most popular replacement tube, the 29" x 1.85"-2.20 presta tube. These suppliers manufacture replacement tubes of comparable quality and performance. With the right price, quality, and availability Ted expects to sell an average of 12.000 tubes per month, or 400 tubes per day, for $6.50 each. However, he is concermed about VSI Consultants Group, Inc, is a professional IT consulting the amount of cash or working capital required to suppot the firm that provides business and noeprofit organizations with level of inventory he needs to provide same-day shipping. the highly skilled IT professionals they need to complete IT on the presta r on the presta replacement tube? 5-14. ACCESS APPLICATION: VSI Consultants Using e staffing problems. VSI matches employ spreadsheet to analyze the replacement tube cost structure for six ees with client projects based on employee education, skills, potential suppliers. Per unit import duty cost equals the import and experience. Emily Loftus, the HR manager, has asked you duty rate multiplied by the sum of per unit base cost and the per to use the information provided in the spreadsbeet shown in unit shipping cost. The per unit warehouse cost is the sum of the Figures S-23, 5-24, and 5-25 to create an Access database to per unit base cost and the per unit shipping cost and the per unit manage employees and projects. You can download the Excel import duty cost. The per unit total cost is the sum of the per unit file ChOSEx02 and import the worksheets to tables in your database. Emily wants you to create two queries. The first Required inventory levels are based on projected daily sales query identifies the best candidates for three client projects imes the number of shipping days required for delivery from U.S. Brokerage, Helen's Clothiers, and Solar Systems. The sec- he supplier to Ted's warehouse. A longer delivery time requires ond query matches employees with projects. Specifically, she Ted to maintain a higher level of inventory. Thus, he wants to wants to match projects for two employees: Y326 and T871 warehouse cost and the average per unit carrying cost. nclude inventory carrying costs in the analysis. Ted maintains What other queries may be useful to Emily FIGURE 5-22 Suppies for Pertormance Boycle Parts Souee Microsoft Excel, Microsoft Corporation. Reprinned wich peniss