Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6/20/2016 Industry 1 CORPORATE SOCIAL RESPONSIBILITY Green Materials Recycled Packaging Energy Efficiency Charitable Total Dollars Contrib. % of Profit Ethics Training Workforce Diversity BRANDED SALES
6/20/2016 Industry 1 CORPORATE SOCIAL RESPONSIBILITY Green Materials Recycled Packaging Energy Efficiency Charitable Total Dollars Contrib. % of Profit Ethics Training Workforce Diversity BRANDED SALES FORECAST DECISION HISTORY Y10 No No 0 0 0.0 None No Y11 No Yes 200 0 1.0 All Yes Y12 No Yes 100 0 1.0 Mgt Yes Y13 Yes Yes 100 0 1.0 Mgt Yes Y14 No No 100 0 3.0 Mgt No Y15 Company B Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 Yes Yes 200 0 1.0 All Yes Y10 Y11 Y12 Y13 Y14 Y15 75.00 180 No 75.00 180 None 75.00 52 Yes 75.00 180 None 65.00 173 Yes 72.24 166 Some 75.00 151 Yes 71.40 154 Some 80.00 182 Yes 72.00 158 Some 75.00 187 No 74.42 187 Some 48.00 5 200 7,000 3 3,000 400 3 0 48.00 5 200 7,000 3.0 3,000 400 3.0 6 50.00 5 52 7,500 4 3,000 500 2 0 48.00 5 200 7,000 3.0 3,000 400 3.0 6 55.00 6 200 7,000 4 2,691 500 2 0 49.75 5 167 7,583 4.0 3,022 533 2.3 6 58.00 5 175 20,000 5 2,091 550 1 69 52.42 5 159 8,366 3.8 2,837 508 2.7 3 61.00 7 200 22,000 6 3,045 575 1 130 54.08 6 173 9,708 3.5 2,842 554 2.7 3 65.00 8 196 18,000 6 3,402 1,000 2 500 55.38 6 196 10,208 3.8 3,426 679 2.0 3 48.00 5 200 7,000 3 3,000 400 3 0 48.00 5 200 7,000 3.0 3,000 400 3.0 6 50.00 3 200 7,200 4 3,000 500 2 0 48.00 5 200 7,000 3.0 3,000 400 3.0 6 53.00 5 200 7,000 4 2,693 500 2 0 50.67 5 192 7,267 3.7 2,846 525 2.5 6 55.00 6 160 10,000 5 2,105 550 2 59 52.83 6 175 7,215 3.3 2,891 558 2.7 3 57.00 8 235 10,000 5 2,939 555 2 121 53.17 6 175 7,648 3.0 3,157 608 2.8 3 63.00 10 206 9,000 5 3,707 1,000 2 400 54.86 7 206 7,800 3.0 3,693 726 2.2 3 Factors Affecting Internet Sales Company Retail Price Marketing Models Offered Effort Free Shipping Expected Retail Price Ind Avg Models Offered Effort Free Shipping North America Wholesale Company Wholesale Price Marketing S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Celebrity Appeal Expected Wholesale Price Ind Avg S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Expected Number of Companies EuropeAfrica Wholesale Company Wholesale Price Marketing S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Celebrity Appeal Expected Wholesale Price Ind Avg S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Expected Number of Companies BSG Decision History Report Copyright GLOBUS Software, Inc. Page 1 1/6 6/20/2016 Industry 1 DECISION HISTORY BRANDED SALES FORECAST (concluded) Company B Y10 Y11 Y12 Y13 Y14 Y15 41.00 5 200 3,500 2 1,500 400 3 0 41.00 5 200 3,500 2.0 1,500 400 3.0 6 42.00 3 200 3,600 2 1,500 450 2 0 41.00 5 200 3,500 2.0 1,500 400 3.0 6 45.00 5 200 3,600 3 1,257 450 2 0 43.17 5 192 3,700 3.2 1,580 600 2.7 6 49.00 5 180 8,000 4 1,192 500 2 58 46.17 5 181 4,650 3.2 1,577 558 2.8 4 56.00 7 227 10,000 5 1,494 525 1 120 47.54 6 179 4,892 2.7 1,652 600 3.0 3 58.00 8 227 12,000 5 1,797 1,000 2 300 50.78 7 205 5,542 3.0 1,874 729 2.3 3 42.00 5 200 3,500 2 1,500 400 3 0 42.00 5 200 3,500 2.0 1,500 400 3.0 6 44.00 3 200 3,600 2 1,500 425 2 0 42.00 5 200 3,500 2.0 1,500 400 3.0 6 45.00 5 200 3,600 2 1,211 425 2 0 43.75 5 192 3,683 2.5 1,517 504 2.7 6 49.00 6 151 8,000 3 1,257 475 2 60 47.74 5 178 4,300 1.7 1,370 479 3.0 3 50.00 7 221 6,000 3 1,300 475 3 121 49.58 6 175 4,942 1.8 1,423 521 3.2 3 57.00 10 203 6,000 3 1,441 1,000 2 300 51.52 7 203 4,858 2.7 1,650 654 2.7 3 0% 0% 0% 0% 50% 50% 50% 50% 25% 25% 25% 25% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Y10 Y11 Y12 Y13 Y14 Y15 Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 AsiaPacific Wholesale Company Wholesale Price Marketing S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Celebrity Appeal Expected Wholesale Price Ind Avg S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Expected Number of Companies Latin America Wholesale Company Wholesale Price Marketing S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Celebrity Appeal Expected Wholesale Price Ind Avg S/Q Rating Effort Models Available Advertising Rebate Offer Retail Outlets Retailer Suport Delivery Time Expected Number of Companies Inventory - North America Clearance EuropeAfrica AsiaPacific Latin America PLANT CAPACITY Sale of - North America Existing EuropeAfrica Capacity AsiaPacific Latin America Purchase - North America of Existing EuropeAfrica Capacity AsiaPacific Latin America Construction - North America of New or EuropeAfrica Additional AsiaPacific Capacity Latin America BSG Decision History Report 0 0 0 0 0 0 0 0 0 0 0 0 200 0 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Copyright GLOBUS Software, Inc. Page 2 2/6 6/20/2016 Industry 1 DECISION HISTORY PLANT CAPACITY (concluded) Upgrade - North - Option A Options America Option B Ordered Option C Option D Europe - Option A Africa Option B Option C Option D Asia - Option A Pacific Option B Option C Option D Latin Option A America Option B Option C Option D BRANDED PRODUCTION Y10 No No No No No No No No No No No No No No No No Y10 Y11 No No No Yes No No No No No Yes No No No No No No Y11 Y12 No No Yes No No No No No No No No No No No No No Y12 Y13 No No No No No No No No No No Yes No No No No No Y13 Y14 No No No No No No No No No No No No No No No No Y14 Y15 Company B Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 No No No No No No No No No No No No No No No No Y15 Production Specifications North - Superior Materials America Models Produced Styling/Features TQM / SixSigma Europe - Superior Materials Africa Models Produced Styling/Features TQM / SixSigma Asia - Superior Materials Pacific Models Produced Styling/Features TQM / SixSigma Latin Superior Materials America Models Produced Styling/Features TQM / SixSigma 54% 200 10 0.50 0% 50 0 0.00 54% 200 10 0.50 0% 50 0 0.00 35% 50 16 1.50 0% 50 0 0.00 20% 200 10 0.50 0% 50 0 0.00 24% 200 16 1.70 0% 50 0 0.00 20% 200 10 0.70 0% 50 0 0.00 50% 150 30 2.20 0% 50 0 0.00 50% 150 30 2.00 0% 50 0 0.00 85% 200 40 2.20 0% 50 0 0.00 60% 250 34 2.00 0% 50 0 0.00 90% 200 50 2.00 0% 50 0 0.00 90% 200 50 2.00 0% 50 0 0.00 +1.0% 1.25 1,000 0.0% 0.00 0 +1.0% 0.40 500 0.0% 0.00 0 +2.0% 0.65 1,000 0.0% 0.00 0 +1.0% 0.50 500 0.0% 0.00 0 +1.0% 1.00 800 0.0% 0.00 0 +1.0% 0.70 500 0.0% 0.00 0 +1.0% 1.00 1,000 0.0% 0.00 0 +1.0% 0.80 900 0.0% 0.00 0 +4.0% 2.50 2,900 0.0% 0.00 0 +2.0% 2.00 2,000 0.0% 0.00 0 +1.0% 2.75 3,400 0.0% 0.00 0 +1.0% 1.80 2,900 0.0% 0.00 0 1,766 0 0 0 3,133 0 0 0 1,800 0 0 0 3,800 0 0 0 1,800 360 0 0 3,800 0 0 0 1,800 0 0 0 3,800 760 0 0 1,800 360 0 0 3,800 760 0 0 2,000 0 0 0 3,800 0 0 0 6.00 12.00 6.00 12.00 6.00 12.72 5.82 13.46 5.78 13.80 5.44 16.51 Compenastion and Training North - Wage Change America Incentive Pay Best Practices Europe - Wage Change Africa Incentive Pay Best Practices Asia - Wage Change Pacific Incentive Pay Best Practices Latin Wage Change America Incentive Pay Best Practices Pairs Produced North - America Europe - Africa Asia - Pacific Latin America RegularTime Overtime RegularTime Overtime RegularTime Overtime RegularTime Overtime Materials Price - Standard Superior Projections BSG Decision History Report Copyright GLOBUS Software, Inc. Page 3 3/6 6/20/2016 Industry 1 BRANDED SHIPPING Shipments from N.A. Plant to North America Warehouse EuropeAfrica Warehouse AsiaPacific Warehouse Latin America Warehouse Shipments from EA Plant to North America Warehouse EuropeAfrica Warehouse AsiaPacific Warehouse Latin America Warehouse Shipments from AP Plant to North America Warehouse EuropeAfrica Warehouse AsiaPacific Warehouse Latin America Warehouse Shipments from L.A. Plant to North America Warehouse EuropeAfrica Warehouse AsiaPacific Warehouse Latin America Warehouse DECISION HISTORY Company B Y10 Y11 Y12 Y13 Y14 Y15 1,377 0 0 300 1,733 0 0 0 2,069 0 0 0 1,736 0 0 0 2,101 0 0 0 1,958 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,377 918 618 0 1,607 1,130 800 0 1,300 1,253 1,000 0 1,600 1,253 1,465 0 1,500 2,320 512 0 1,313 1,830 512 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 INTERNET MARKETING Y10 Y11 Y12 Y13 Y14 Y15 Retail Price Models Offered Free Shipping Block Internet - North America Order In EuropeAfrica AsiaPacific Latin America 75.00 180 No No No No No 75.00 52 Yes No No No No 65.00 173 Yes No No No No 75.00 151 Yes No No No No 80.00 182 Yes No No No No 75.00 187 No No No No No WHOLESALE MARKETING Y10 Y11 Y12 Y13 Y14 Y15 48.00 7,000 3 3,000 400 3 50.00 7,500 4 3,000 500 2 55.00 7,000 4 2,691 500 2 58.00 20,000 5 2,091 550 1 61.00 22,000 6 3,045 575 1 65.00 18,000 6 3,402 1,000 2 48.00 7,000 3 3,000 400 3 50.00 7,200 4 3,000 500 2 53.00 7,000 4 2,693 500 2 55.00 10,000 5 2,105 550 2 57.00 10,000 5 2,939 555 2 63.00 9,000 5 3,707 1,000 2 41.00 3,500 2 1,500 400 3 42.00 3,600 2 1,500 450 2 45.00 3,600 3 1,257 450 2 49.00 8,000 4 1,192 500 2 56.00 10,000 5 1,494 525 1 58.00 12,000 5 1,797 1,000 2 42.00 3,500 2 1,500 400 3 44.00 3,600 2 1,500 425 2 45.00 3,600 2 1,211 425 2 49.00 8,000 3 1,257 475 2 50.00 6,000 3 1,300 475 3 57.00 6,000 3 1,441 1,000 2 North America Segment Wholesale Price Advertising Budget Rebate Offer Retail Outlets Utilized Retailer Support Delivery Time to Retailers EuropeAfrica Segment Wholesale Price Advertising Budget Rebate Offer Retail Outlets Utilized Retailer Support Delivery Time to Retailers AsiaPacific Segment Wholesale Price Advertising Budget Rebate Offer Retail Outlets Utilized Retailer Support Delivery Time to Retailers Latin America Segment Wholesale Price Advertising Budget Rebate Offer Retail Outlets Utilized Retailer Support Delivery Time to Retailers BSG Decision History Report Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 Copyright GLOBUS Software, Inc. Page 4 4/6 6/20/2016 Industry 1 CELEBRITY ENDORSEMENTS Cancel Existing Contract Payton Manyon Oprah Beyons Cristiano Romano Tiger Green Jos Montaa Mishell Wii Ace Federar Danica Sebastian Yi Lin Shakira Iglesias Nick Shavan Bronko Mars Contract Offer Payton Manyon Oprah Beyons Cristiano Romano Tiger Green Jos Montaa Mishell Wii Ace Federar Danica Sebastian Yi Lin Shakira Iglesias Nick Shavan Bronko Mars Priority Ranking Payton Manyon Oprah Beyons Cristiano Romano Tiger Green Jos Montaa Mishell Wii Ace Federar Danica Sebastian Yi Lin Shakira Iglesias Nick Shavan Bronko Mars Spending Cap PRIVATELABEL OPERATIONS DECISION HISTORY Y10 Y11 Y12 Y13 Y14 Company B Y15 No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No 0 0 0 0 0 0 0 0 0 0 0 0 0 3,000 700 0 0 0 0 0 0 0 0 0 0 0 0 1,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5,000 0 0 0 0 10,000 0 10,000 0 0 0 0 0 0 10,000 0 0 0 0 0 0 0 0 0 0 8,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 2 0 1 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1,000 1,500 5,000 30,000 8,000 Y11 Y12 Y13 Y14 Y15 Y10 Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 Production Specifications North - Superior Materials America Models Produced Styling/Features Europe - Superior Materials Africa Models Produced Styling/Features Asia - Superior Materials Pacific Models Produced Styling/Features Latin Superior Materials America Models Produced Styling/Features 25% 100 5 0% 100 0 25% 100 5 0% 100 0 25% 100 10 0% 100 0 30% 100 15 0% 100 0 28% 100 12 0% 100 0 35% 100 15 0% 100 0 50% 100 25 0% 100 0 36% 100 20 0% 100 0 50% 100 25 0% 100 0 36% 100 20 0% 100 0 100% 100 25 0% 100 0 100% 100 15 0% 100 0 234 152 0 0 394 0 0 0 0 360 0 0 0 500 0 0 0 0 0 0 0 760 0 0 0 360 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 400 0 0 0 760 0 0 Planned Production (000s of pairs) North - RegularTime America Overtime Europe - RegularTime Africa Overtime Asia - RegularTime Pacific Overtime Latin RegularTime America Overtime BSG Decision History Report Copyright GLOBUS Software, Inc. Page 5 5/6 6/20/2016 Industry 1 PRIVATELABEL OPERATIONS (concluded) DECISION HISTORY Y10 Y11 Y12 Y13 Y14 Company B Y15 Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 Y16 Y17 Y18 Y19 Y20 Planned Shipments (000s of pairs) N.A. Plant N.A. Warehouse EA Warehouse AP Warehouse L.A. Warehouse EA Plant - N.A. Warehouse EA Warehouse AP Warehouse L.A. Warehouse AP Plant - N.A. Warehouse EA Warehouse AP Warehouse L.A. Warehouse L.A. Plant N.A. Warehouse EA Warehouse AP Warehouse L.A. Warehouse 185 0 0 185 0 0 0 0 0 185 185 0 0 0 0 0 344 0 0 0 0 0 0 0 0 200 100 170 0 0 0 0 0 0 0 0 0 0 0 0 0 0 718 0 0 0 0 0 349 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 394 0 0 0 0 0 0 0 0 302 296 140 0 0 0 0 185 185 185 185 35.00 35.00 35.00 35.00 4 4 4 4 344 200 100 170 90.00 78.00 70.00 80.00 4 4 4 4 0 0 718 0 92.00 84.00 75.00 82.00 0 0 4 0 349 0 0 0 92.00 84.00 80.00 82.00 7 0 0 0 0 0 0 0 92.00 84.00 80.00 82.00 0 0 0 0 394 302 296 140 61.00 57.00 57.00 57.00 10 9 9 9 Y10 Y11 Y12 Y13 Y14 Y15 0 0 0 0 15,000 10,000 0 1,000 1,000 1,000 0 1,000 0 0 1,000 0 1,000 0 0 0 0 0 0 0 0 0 1.00 0 2 0 1.00 0 0 0 1.00 0 0 0 0.00 0 0 0 0.00 1,080 0 0 0.00 0 PrivateLabel Bids Pairs Offered - North America for Sale EuropeAfrica AsiaPacific Latin America Bid Price - North America EuropeAfrica AsiaPacific Latin America S/Q Rating of - North America Pairs Offered EuropeAfrica AsiaPacific Latin America FINANCE AND CASH FLOW Sources of Additional Cash 1Year Bank Loan 5Year Bank Loan 10Year Bank Loan Shares of Stock Issued Uses for Available Cash Early Repayment of - Loan # LongTerm Loans Loan # Dividend Per Share Shares of Stock Repurchased BOTTOMLINE PROJECTIONS Y10 Y11 Y12 Y13 Y14 Y15 Projected Sales Revenues 239,147 25,000 2.50 17.3 B+ 70 279,151 62,163 5.65 32.6 A- 66 287,235 58,981 4.92 25.7 A 63 457,529 80,049 6.67 29.0 A+ 78 522,150 97,379 8.92 32.8 A+ 82 626,895 81,581 7.47 26.1 A+ 100 Actual Sales Revenues 0 0 0.00 0.0 n.a. 0 207,568 26,265 2.39 15.2 B 56 231,971 30,076 2.51 14.0 A- 58 288,533 22,933 1.91 9.3 B 66 326,301 35,409 3.24 13.3 B 70 314,273 17,229 1.58 6.5 C- 81 0.0% -41.9% -34.1% -52.6% -47.8% -87.2% Net Profit Earnings Per Share Return On Equity Credit Rating Image Rating Net Profit Earnings Per Share Return On Equity Credit Rating Image Rating Average Variance BSG Decision History Report Copyright GLOBUS Software, Inc. Page 6 6/6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started