# Sierra michaud a04216501 are the calculated total

• 16
• 100% (10) 10 out of 10 people found this document helpful

This preview shows page 12 - 16 out of 16 pages.

Sierra Michaud A04216501 are the calculated total annual cost of printing at various discount levels with the lowest total annual cost highlighted. In this case, the lowest total annual cost of printing is a printing 40,000 programs in 5 batches for a total cost of 357,500.00. Inserts Total Cost 40,000 x 5 times (per game) Range 1 Range 2 Range 3 Range 4 Q* (Square root formula) 29814.2397 30678.5995 5 Order Quantity 40000 40000 Holding cost \$900.00 \$850.00 Setup cost \$500.00 \$500.00 Unit costs \$180,000.0 0 \$170,000.00 Total cost, T c \$181,400.0 0 \$171,350.00 For the inserts, the above table shows the analysis of costs and calculated Annual Total Costs. The highlighted column is the most cost-effective and shows that with 5 orders of 40,000 each there is a total cost of 171,350.00 Summary In summary after calculating Annual Total Costs for various discount levels and order quantities, the most cost-effective options for each order quantity are reflected in the following table. Programs Quality Printing Order Quantity 40000 200000 Annual Cost \$357,500.00 \$400,100.00 Inserts Order Quantity 40000 Annual Cost \$171,350.00
13 Sierra Michaud A04216501 Finally, based on this analysis the printing of 40,000 program and 40,000 inserts 5 times during the year is the most cost-effective approach for Quality Printing. First Printing First Printing, uses the same data as Quality printing with the addition of an additional \$200 cost for trucking and a 10% discount on Quality Printing prices for programs and inserts at the same volume pricing levels. The tables below reflect the same analysis for First Printing as done above for Quality Printing. Programs Total Costs 40,000 x 5 times (per game) Range 1 Range 2 Range 3 Range 4 Q* (Square root formula) 12171.6123 9 12524.4858 2 Order Quantity 40000 40000 Holding cost \$16,200.00 \$15,300.00 Setup cost \$1,500.00 \$1,500.00 Unit costs \$324,000.00 \$306,000.00 Total cost, T c \$341,700.00 \$322,800.00 Total Costs 200,000 x 1 Annual Order Range 1 Range 2 Range 3 Range 4 Q* (Square root formula) 12171.61239 12524.48582 12909.94449 Order Quantity 200000 200000 200000 Holding cost \$81,000.00 \$76,500.00 \$72,000.00 Setup cost \$300.00 \$300.00 \$300.00 Unit costs \$324,000.00 \$306,000.00 \$288,000.00
14 Sierra Michaud A04216501 Total cost, T c \$405,300.00 \$382,800.00 \$360,300.00 The above tables show the results of the analysis for First Printing when printing the programs in a single batch of 200,000 and 5 batches of 40,000 (1 per game). In the above tables are the calculated total annual cost of printing at various discount levels with the lowest total annual cost highlighted. In this case, the lowest total annual cost of printing is a printing 40,000 programs in 5 batches for a total cost of 322,800.00. Inserts Total Costs 40,000 x 5 times (per game) Range 1 Range 2 Range 3 Range 4 Q* (Square root formula) 54433.1054 56011.2033 6 Order Quantity 40000 40000 Holding cost \$4,050.00 \$3,825.00 Setup cost \$1,500.00 \$1,500.00 Unit costs \$162,000.0 0 \$153,000.00 Total cost, T c \$167,550.0 0 \$158,325.00 For the inserts, the above table shows the analysis of costs and calculated Annual Total Costs. The highlighted column is the most cost-effective and shows that with 5 orders of 40,000 each there is a total cost of 158,325.00 Summary
15 Sierra Michaud A04216501 In summary after calculating Annual Total Costs for various discount levels and order quantities, the most cost-effective options for each order quantity are reflected in the following table.
• • • 