Question

CUI 2. Complete the following grid: Store 1 Store 2 Store 4 Store 3 $155.0 Store 5 $12.0 Store 6 $4,056.7 $42.6 $90.0 $5.9 $3
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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:

M o P Q Store 2 =M4+M5 42.6 1 2 Store 1 3 Net sales 12 Cost of goods sold -L3-L5 5 Gross margin-dollars 5.9 Gross margin - %

Add a comment
Know the answer?
Add Answer to:
CUI 2. Complete the following grid: Store 1 Store 2 Store 4 Store 3 $155.0 Store...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 2. Complete the following grid: Store 3 Ner Sales Cast of goods sold Gros margin-dollars Groos...

    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...

    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...

    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...

    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...

    ! 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...

    ! 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 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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT