B2B Marketing IWC RONA Assignment

profilegladiator999
rona.xlsx

RONA

Sales Revenue
$400 Gross Margin
- $150
Cost of Goods Sold
$250 Profit
- $20 Net Profit Margin
÷ 5.00%
Sales Revenue (Net Profit ÷ Net Sales)
Total Op. Expenses $400
$130 Return on Assets
x 8.00%
Asset Turnover
÷ 1.60
Other current assets
$20
+
Accounts Receivable Current Assets
$75 $195 Total Assets
+ + $250
Inventory Fixed Assets
$100 $55

3% Increase

Sales Revenue
$412 Gross Margin
- 154.50
Cost of Goods Sold
257.50 Profit
- $25 Net Profit Margin
÷ 6.13%
Sales Revenue (Net Profit ÷ Net Sales)
Total Op. Expenses $400
$130 Return on Assets
x 9.80%
Asset Turnover
÷ 1.60
Other current assets
$20
+
Accounts Receivable Current Assets
$75 $195 Total Assets
+ + $250
Inventory Fixed Assets
$100 $55

3% Decrease

Sales Revenue
$412 Gross Margin
- 162.00
Cost of Goods Sold
250.00 Profit
- $32 Net Profit Margin
÷ 8.00%
Sales Revenue (Net Profit ÷ Net Sales)
Total Op. Expenses $400
$130 Return on Assets
x 12.80%
Asset Turnover
÷ 1.60
Other current assets
$20
+
Accounts Receivable Current Assets
$75 $195 Total Assets
+ + $250
Inventory Fixed Assets
$100 $55

10% Reduced Inv.

Sales Revenue
$412 Gross Margin
- 162.23
Cost of Goods Sold
249.77 Profit
- $32 Net Profit Margin
÷ 8.06%
Sales Revenue (Net Profit ÷ Net Sales)
Total Op. Expenses $400
$130 Return on Assets
x 13.43%
Asset Turnover
÷ 1.67
Other current assets
$20
+
Accounts Receivable Current Assets
$75 $185 Total Assets
+ + $240
Inventory Fixed Assets
$90 $55

RONA #6

Sales Revenue
$400 Gross Margin
- $150
Cost of Goods Sold
$250 Profit
- $20 Net Profit Margin
÷ 5.00%
Sales Revenue (Net Profit ÷ Net Sales)
Total Op. Expenses $400
$130 Return on Assets
x 8.00%
Asset Turnover
÷ 1.60
Other current assets
$20
+
Accounts Receivable Current Assets
$75 $195 Total Assets
+ + $250
Inventory Fixed Assets
$100 $55