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...
-
The arrangement in the drawing shows a block (mass = 15.0 kg) that is held in position on a frictionless incline by a cord (length = 0.600 m). The mass per unit length of the cord is 1.20 10-2 kg/m,...
-
According to the author of this piece, what is meant by speaking vaguely, and what are its benefits?
-
Onstar Communication issued \(\$ 100,000\) of \(6 \%, 10\)-year bonds payable on October 1, 2008, at par value. Onstar's accounting year ends on December 31. Journalize the following transactions....
-
According to its directional distribution, solar radiation incident on the earth's surface may be divided into two components. The direct component consists of parallel rays incident at a fixed...
-
if you left 4,000 dollars on a deposit with a bank promising to pay you a percent compound annual rate of interest, then after 75 years your deposit would be worth approximately
-
Saratoga Ltd. was having difculty in raising nance for expansion. Kingsh Ltd. was interested in achieving economies by marketing a wider range of products. The following shows the nancial positions...
-
Which of the following might trigger erythropoiesis? A) moving from a high altitude to a low altitude B) an increased number of RBCs OC) decreased tissue demand for oxygen D) increased tissue demand...
-
What factors cause measurement errors in the BOP accounts?
-
Identify the different types of balance of payments surpluses and deficits.
-
Did the key role that the dollar played in the Bretton Woods system benefit or hurt the United States?
-
Under what conditions might a country devalue its currency today?
-
For what types of goods does the law of one price hold quite well?
-
Compute the pressure in bar of hydrogen gas produced at 304 K in a container of volume 5.64 L that results when 2.53 g of aluminum react with 31.9 mL of a 0.396 mol L-1 sulfuric acid solution. You...
-
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...
-
When the primary direct crank of a reciprocating engine is positioned at \(30^{\circ}\) clockwise, the secondary reverse crank for balancing will be at (a) \(30^{\circ}\) anti-clockwise (b)...
-
Two heavy rotating masses are connected by shafts of length \(l_{1}, l_{2}\), and \(l_{3}\) and the corresponding diameters and \(d_{1}, d_{2}\), and \(d_{3}\). This system is reduced to a...
-
The given Fig. 32 depicts a vector diagram of forces and displacements in the case of Forced Damped Vibration. If vector \(A\) represents the forcing function \(P=P_{o} \sin \omega t\), vector \(B\)...
Study smarter with the SolutionInn App