Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets Using the Lambert's strategic profit model forms below, calculate the ROA for each case. Refer to the strategic profit model from your notes to figure out how to make the calculations required. Place your answers in the forms below, and be sure to specify the change in ROA for each. Use the Canvas site to upload your completed assignment no later than 2:40 PM, 19 February. Late submissions for this assignment will not be accepted. The Scenario: You work for a firm that makes microchips. You are trying to convince your manager that small changes in the way your company handles its logistic and supply chain practices can improve the firm's financial performance. You've decided to postulate five different cases of changes and need to calculate their expected effect on ROA for the firm. The way your firm currently does business is identified in the Base Case below. Each case describes how the firm might change its practices. The Base Case: ● Price of microchips: $9.50 • Quantity of Microchips the firm sells at $10 under current logistics practices: 1,200 • Cost of Goods (to produce a microchip): $7.50 ●. Variable Costs . o Transportation: 5% of sales revenue o Handling: 2% of sales revenue o Storage: 2% of sales revenue o Promotions: 3% of sales revenue . • Inventory Costs: 25% of Sales revenue ● Accounts Receivable: 20% of Sales revenue Other Current Assets: $1,000 Fixed Assets: $6,500 · Fixed Expenses: $840.00 Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. Case 1: Starting from the Base Case, you recommend the firm partner with a smaller number of transportation providers who will provide the same level of service for less money, reducing the cost of transportation from 5% to 4%. Case 2: Starting from the Base Case, you recommend the firm segment its customers and set different payment expectations with Class II-Class V customers, allowing the firm to reduce accounts receivable from 20% of sales to 15% of sales. Case3: Starting from the Base Case, you recommend better logistics operations practices, allowing you to keep less work-in-progress and raw material inventory, reducing Cost of Goods from $7.50 to $7.25 per unit with no change in service to your customers. Case 4: Starting from the Base Case, you recommend closer relationships with your Class I and Class II customers so you have a better sense of customer demand, allowing you to set higher fill rates for them, increasing quantity sold from 1,200 to 1,400. I Case 5: Starting from the Base Case, you recommend making changes to all of the areas listed in Cases 1-4, but suggest putting less effort into each, resulting in smaller outcome changes, plus closer relationships with your customers allowing you to keep lower amounts of inventory. Those expected changes are: Quantity Sold: increase from 1,200 to 1,300 Cost of Goods: decrease from $7.50 to $7.40 . • Transportation: decrease from 5% to 4.75% • Inventory: decrease from 25% to 22% of sales revenue • Accounts Receivable: decrease from 20% to 18% of sales. The Base Case % Net Margin % Return on Assets $ Asset Tumover Net Profit Sales Sales $ $ Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 1: Increase Transportation Efficiency | Change in ROA % Net Margin % Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ Gross Margin $ Total Assets $ Sales $ S $ Total Expenses 5 Current Assets $ Fixed Assets $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 4.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable $1,000 Other Current Assets Case 2: Increase Account Receivable Collection Efficiency | Change in ROA % Net Margin Return on Assets $ Asset Turnover $ Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ $ Total Expenses $ Current Assets $ Fixed Assets Sales $9.50 Price 1,200 Quantity $7.50 Cost of Goods Cost of Goods Sold 1,200 Quantity Variable Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions $840 Fixed Expenses Inventory Accounts Receivable (15%) $1,000 Other Current Assets Case 3: Reduce Cost of Goods Sold | Change in ROA Return on Assets Net Margin Asset Turnover Net Profit Sales Sales $ $ 5 Total Assets Gross Margin $ 5. $ Total Expenses Current Assets 5 Fixed Assets Sales $9.50 Price 1,200 Quantity $7.25 Cost of Goods Cost of Goods Sold Inventory 1,200 Quantity Variable Expenses $840 Fixed Expenses 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Accounts Receivable $1,000 Other Current Assets Case 4: Increase Quantity Sold | Change in ROA Return on Assets Net Margin $ Asset Turnover Net Profit Sales Sales $ 5 Gross Margin $ Total Assets $ $ Total Expenses Current Assets Fleed Assets Sales $9.50 Price 1,400 Quantity $7.50 Cost of Goods Sold 1,400 Quantity Variable Expenses $840 Fixed Expenses Cost of Goods 5.00% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory Accounts Receivable $1,000 Other Current Assets ber Case 5: Improve Multiple Areas of the Firm Change in ROA % Net Margin % Return on Assets Asset Turnover Net Profit Sales Sales S Total Assets $ Gross Margin $ $ Total Expenses $ Current Assets Fixed Assets Sales $1,000 $9.50 Price 1,300 Quantity $7.40 Cost of Goods Cost of Goods Sold 1,300 Quantity Variable Expenses 5840 Fixed Expenses 4.75% Transportation 2.00% Handling 2.00% Storage 3.00% Promotions Inventory (22% of sales rev) Accounts Receivable (18% of sales rev) Other Current Assets
Expert Answer:
Related Book For
An Introduction to Management Science Quantitative Approach to Decision Making
ISBN: 978-1337406529
15th edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Posted Date:
Students also viewed these general management questions
-
You work for a firm that manufactures childrens toys. Despite little international experience, management wants to start exporting. Your boss understands the importance of using strong distributors...
-
You work for a firm that has limited access to capital markets. As a consequence, it has only $20 million available for new investments this year. The firm does have a ready supply of good projects,...
-
Suppose you work for a firm that holds valuable intellectual property and is contemplating various international business projects. What strategies would you recommend to management for protecting...
-
The director of cost management for Odessa Company uses a statistical control chart to help management determine when to investigate variances. The critical value is 1 standard deviation. The company...
-
A hiker stands on a mountain peak near sunset and observes a rainbow caused by water droplets in the air about 8.00 km away. The valley is 2.00 km below the mountain peak and entirely flat. What...
-
What effect places a lower limit on the size of an object that can be clearly seen with the best optical microscope?
-
Free cash flow is the cash flow actually available for distribution to investors after the company has made all the investments in fixed assets and working capital necessary to sustain ongoing...
-
The Mound Gazette is a local newspaper that is published Monday through Friday. It sells 90,000 copies daily. The paper is currently in a profit squeeze, and the publisher, Harley Hews, is looking...
-
Question 1 A Kite 60 feet above the ground moves horizontally at a speed of 5 ft/s. At what rate is the angle between the string and the ground decreasing when 160 feet of string is out?Two sides of...
-
The dependency diagram in Figure indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the...
-
Which statement accurately describes Socrates' position? Those who lack wisdom are not obligated to seek it, because this search may not yield concrete results. Those who lack wisdom are not...
-
Select three state math standards for kindergarten related to number sense (counting and cardinality) for the selected grade level. Using the "Number Sense Standards Table," create one math activity...
-
Let = a) (3 pts) Show that f'(x) = 1 COS X 1 In f(x) = n ( 2 1 + sin x 1 - - sin x (You have to show all your steps and calculations). b) (3 pts) Use that to show that the value of C/4 1 co cos(x)...
-
Kora Johnson, the Marketing Manager of your Company, went through the sales budget prepared in Section B and suggested that if Bradley Motorcycle Manufacturing Company spent $10,000 on advertising...
-
A consumer chooses between a public good X and a private good Y . The utility function that characterizes the preferences of this consumer is U = X 3/4 Y 1/4. What is the relative price of X if the...
-
In early days, the Xerox Corporation faced the following pricing problem for its copying machines (there was hardly any competition then). There were two segments of potential users, the large users...
-
Components are not similar to one another and are in continual process of change is involved in cell 4 of the environmental uncertainty matrix
-
Draw two scatterplots, one for which r = 1 and a second for which r = 21.
-
Preliminary plans are under way for the construction of a new stadium for a major league baseball team. City officials have questioned the number and profitability of the luxury corporate boxes...
-
The Corporate Average Fuel Economy (CAFE) regulations were put into law by Congress in 1975 to promote the sale of fuel-efficient automobiles and light trucks. The law requires automakers to boost...
-
Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63, $95, and $135, respectively. The production...
-
Given that the approximate frequency of \(\mathrm{G}_{4}{ }^{\#}=349 \mathrm{~Hz}\), what is the approximate frequency of \(\mathrm{G}_{3}{ }^{\#}\), rounded to the nearest whole number?
-
Given that the approximate frequency of \(\mathrm{D}_{4}=294 \mathrm{~Hz}\), what is the approximate frequency of \(D_{2}\), rounded to the nearest whole number?
-
Court plc has a defined benefits pension scheme for all its employees. Based on actuarial advice the company has previously made contributions of \( 2\) million per annum to the pension fund, being...
Study smarter with the SolutionInn App