The answers are shown below:
Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 6 | |
Net sales | 12.0 | 80.7 | 155.0 | 1,438.8 | 131.6 | 4,056.7 |
Cost of goods sold | 6.1 | 42.6 | 59.2 | 951.2 | 90.0 | 1,669.5 |
Gross margin - dollars | 5.9 | 38.1 | 95.8 | 487.6 | 41.6 | 2,387.2 |
Gross margin - % | 49.2% | 47.2% | 61.8% | 33.9% | 31.6% | 58.8% |
Expenses - dollars | 4.2 | 31.9 | 88.2 | 464.9 | 41.1 | 2,258.7 |
Expenses - % | 35.0% | 39.5% | 56.9% | 32.3% | 31.2% | 55.7% |
Net income - dollars | 1.7 | 6.2 | 7.6 | 22.7 | 0.5 | 128.5 |
Net income - % | 14.2% | 7.7% | 4.9% | 1.6% | 0.4% | 3.2% |
Formulas used can be seen in the attached image below:
CUI 2. Complete the following grid: Store 1 Store 2 Store 4 Store 3 $155.0 Store...
2. Complete the following grid: Store 3 Ner Sales Cast of goods sold Gros margin-dollars Groos margin-percent Expenses---dollars Expenses-percent Net income-dollars Net income-percent Dollars expressed in millions Store 1 Store 2 Store 4 Store 5 Store 6 $12.0 80.7 $155.0 1,438.8.131.6 $4,056.7 6.1 $42. 6 5 9.2 $951.2 $90.0 1,619.5 $5.9 $38.1 65.8 $487.6 41.6 $2,387.2 49.2% 47.2% 61.8% 33.9731.6% 58.8% $4.2 31.9 $88.2 464.9 $41.1 2,259.7 35.0% 39.5% 56.9% 32.3% 31.2% 55.71 1.7 $6.2 $7.6 $22.7 $0.5 $128.5 114.2%...
perfo Solving Problems 1. A retailers current assets are $7.4 million Presently, his current ratio is .5.) The retailer wants to borrow money to fund an expansion; however, a lender tells him that, to borrow money, the retailer must bring his current ratio up to 2.0. What are the retailer's current liabilities? By how much must he reduce his current liabilities to obtain a loan, assuming that current assets remain constant? 2 Complete the following grid: Store 1 Store 2...
3. Complete the following grid: Department Department D B $78.0 $32.5 $1.5 Sales $45.2 12.0 3.5 4.5 Turnover $.4 $15.0 $4.5 $7.1 Average Inventory COGS $.6 $52.3 $41.3 $.7 $12.9 $15.8 Gross Margin- percent GMROI Solving Problems 1. A retailer's current assets are $7 The retailer wants to borro tells him that, to be 10 2.0. What are there his current liabilities to constant? ent assets are $7.4 million. Presently, his current ratio is 1.5. vants to borrow money to...
solving Problems A retailer's current assets are $7.4 milli The retailer wants to be rells him that, to borrow m ets are $7.4 million. Presently, his current ratio is 1.5. ants to borrow money to fund an expansion: however, a lender horrow money, the retailer must bring his current ratio up t's current liabilities? By how much must he reduce ilities to obtain a loan, assuming that current assets remain What are the retailer's current liabilities? By h to 2.0....
! Required information The Foundational 15 (Algo) (LO5-1, LO5-3, LO5-4, LO5-5, LO5-6, LO5-7, LO5-8] [The following information applies to the questions displayed below.) Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 50,000 27,500 22,500 14,850 $ 7,650 11. What is the margin of safety in dollars? What is the...
! Required information The Foundational 15 (LO6-1, LO6-3, L06-4, LO6-5, L06-6, LO6-7, LO6-8) (The following information applies to the questions displayed below.) Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 25,000 17,500 7,500 4,200 $ 3,300 Foundational 6-8 8. What is the break-even point in unit sales? Break-even point...
The Foundational 15 (LO6-1, LO6-3, L06-4, LO6-5, LO6-6, LO 6-7, L06-8] [The following information applies to the questions displayed below.) Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): 5 Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 15,000 9,000 6,000 3,120 $ 2,880 Foundational 6-6 6. If the selling price increases by $2 per unit and the...
Required information The Foundational 15 (LO6-1, LO6-3, L06-4, L06-5, L06-6, LO6-7, LO6-8] [The following information applies to the questions displayed below.] Oslo Company prepared the following contribution format income statement based on a sales volume of 1.000 units (the relevant range of production is 500 units to 1,500 units): sales Variable expenses Contribution margin Fixed expenses. Tiet operating income $ 90,000 49,500 40.500 33.210 $ 7,200 Foundational 6-2 2. What is the contribution margin ratio? Contribution marginatio Required information The...
CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...