Just looking for help calculating At what Quanitity, Q, does the cost to make equal the cost to buy

ZHUOYUE SUPPLIES (SHANGHAI) Current Pricing SCHLECHTE MEDIZIN (GERMANY) Current Pricing Allocation Allocation 125% INFO FOR COST PLUS ANALYSIS Direct Materials Direct Labor Overhead COGS SG&A Total Product Cost Profit (mark-up) Price $ $ $ $ $ $ $ 300.00 700.00 945.00 1,945.00 350.10 2,295.10 229.51 2,524.61 $ $ $ 135% $ $ 18% $ $ 10% $ S $ 200.00 950.00 1,187.50 2,337.50 350.63 2,688.13 15% 188.17 7% $ 2,876.29 2.55 31.1 2,600 2.55 31.1 2,500 80 84 12 12 1020 980 $1.75 3,426 $ $ $ 25% INFO FOR TOTAL COST ANALYSIS Unit conversions Avg cubic ft per unit product Cubic ft per pallet Cubic ft per container Pallets per container* Units per pallet Units per container* Shipping costs Shipping to port of export per cube Cargo shipping costs per container Import duties (% value product) Port handling charges (% value of product) Rail freight charges per container Trucking costs per container per mile Number of miles trucked Total cost per unit Price Shipping to port of export Cargo shipping costs per unit Import duties Port handling charges Rail freight charges Trucking costs Sub total shipping costs Total cost per unit 0.75 2,750 3.7% 8% 0% 1.31 15% $ $ 3,500.00 3.83 177 $ 975 $ $ $ $ 2,524.61 1.75 3.36 631.15 378.69 3.43 2,876.29 0.75 2.81 106.42 $ $ $ $ $ $ $ $ $ $ $ $ 230.10 $ 1.30 0.66 $1,019.05 3,543.66 341.38 3,217.68 $ $ $ Expected increased unit sales Sales revenue per unit Material (per unit) Labor Overhead % of labor) Fixed Costs (for expanded capacity) INTERNAL INFO FOR Care Med 150,000.00 10,000.00 900.00 1,025.00 125% $4,500,000 At what quantity, Q, does the cost to make equal the cost to buy? Q = (FCMake FCBuy) / (VCBuy VC make) Q = ZHUOYUE SUPPLIES (SHANGHAI) Current Pricing SCHLECHTE MEDIZIN (GERMANY) Current Pricing Allocation Allocation 125% INFO FOR COST PLUS ANALYSIS Direct Materials Direct Labor Overhead COGS SG&A Total Product Cost Profit (mark-up) Price $ $ $ $ $ $ $ 300.00 700.00 945.00 1,945.00 350.10 2,295.10 229.51 2,524.61 $ $ $ 135% $ $ 18% $ $ 10% $ S $ 200.00 950.00 1,187.50 2,337.50 350.63 2,688.13 15% 188.17 7% $ 2,876.29 2.55 31.1 2,600 2.55 31.1 2,500 80 84 12 12 1020 980 $1.75 3,426 $ $ $ 25% INFO FOR TOTAL COST ANALYSIS Unit conversions Avg cubic ft per unit product Cubic ft per pallet Cubic ft per container Pallets per container* Units per pallet Units per container* Shipping costs Shipping to port of export per cube Cargo shipping costs per container Import duties (% value product) Port handling charges (% value of product) Rail freight charges per container Trucking costs per container per mile Number of miles trucked Total cost per unit Price Shipping to port of export Cargo shipping costs per unit Import duties Port handling charges Rail freight charges Trucking costs Sub total shipping costs Total cost per unit 0.75 2,750 3.7% 8% 0% 1.31 15% $ $ 3,500.00 3.83 177 $ 975 $ $ $ $ 2,524.61 1.75 3.36 631.15 378.69 3.43 2,876.29 0.75 2.81 106.42 $ $ $ $ $ $ $ $ $ $ $ $ 230.10 $ 1.30 0.66 $1,019.05 3,543.66 341.38 3,217.68 $ $ $ Expected increased unit sales Sales revenue per unit Material (per unit) Labor Overhead % of labor) Fixed Costs (for expanded capacity) INTERNAL INFO FOR Care Med 150,000.00 10,000.00 900.00 1,025.00 125% $4,500,000 At what quantity, Q, does the cost to make equal the cost to buy? Q = (FCMake FCBuy) / (VCBuy VC make) Q =