(Solved): MKTG 4600 Assignment 2 Financials : Score for this quiz: 100 out of 100 Due Dec 21 at 11:59pm...
MKTG 4600 Assignment 2 Financials
Score for this quiz: 100 out of 100
Submitted Dec 20 at 11:15 am
This attempt took 29 minutes.
Retailer Z Physical Stores Income Statement ( In Millions) |
Retailer Z Income statement in Millions (Online store) |
||||||
Net sales |
765,329 |
279,346 |
|||||
Less Cost of Goods Sold (COGS) |
_______ |
_______ |
|||||
Gross margin |
327,477 |
113,974 |
|||||
Less operating expenses (SG&A) |
269,316 |
98,724 |
|||||
Operating profit margin |
_______ |
_______ |
|||||
Less other income (expense), interest, taxes |
12,398 |
3,984 |
|||||
Net profit margin |
______ |
______ |
|||||
|
|
||||||
Gross margin as % of sales |
_________ |
______________ |
|||||
Operating expenses as % of sales |
_________ |
_____________ |
|||||
Operating profit margin as a % of sales |
_________ |
_____________ |
|||||
Net profit margin as a % of sales |
_________ |
_____________ |
|||||
|
|
|
|||||
Balance Sheet in Millions |
Retailer Z Stores |
Retailer Z online |
|||||
Cash |
175,877 |
58,971 |
|||||
Merchandise Inventory (monthly average) |
_______ |
________ |
|||||
Total Current Assets |
348,263 |
118,350 |
|||||
Fixed Assets |
_______ |
_______ |
|||||
Total Assets |
388,720 |
155,799 |
|||||
RATIOS |
|||||||
Inventory turnover |
________ |
_______ |
|||||
Asset turnover |
________ |
_______ |
|||||
ROA |
________ |
_______ |
|||||
Calculate GMROI for both divisions of Retailer Z |
|
|
|||||
GMROI |
_________ |
_________ |
|
|
|||
|
|
|
|||||
4.439624 |
A men’s clothing retailer has discovered the following variables can be used to predict, with suitable accuracy, the sales potential for proposed
store locations.
- Percentage of households in trade area with children ages 15-18 x (1,500,000)
- Percentage of PRIZM households in trade area described as Middleburg Managers X (900,000)
- Number of households in trade area within a 20-minute drive X 225
- Square feet in shopping center X 9.5
- Visibility from street + 200,000
- Presence of Dillard’s in shopping center + 250,000
There are three locations being considered, with the corresponding values for each shown in the table below:
Variable |
Location “A” |
Location “B” |
Location “C” |
A |
.25 |
.3 |
.35 |
B |
.4 |
.25 |
.20 |
C |
10,000 |
9,500 |
11,000 |
D |
240,000 |
270,000 |
190,000 |
E |
No |
Yes |
Yes |
F |
Yes |
No |
Yes |
|
|
|
|
Projected Sales |
____________ |
_____________ |
_____________ |
Given the results of your calculations, the retailer should pick Location _____ for the new store.
Type out the formula you used to calculate the answer for each empty cell.
Do not type out six zeros for any answer. Full dollar numbers are in Millions.
Ratios should be calculated to two (2) decimal places and reported as such.
This is an individual assignment. You should not work with anyone else on this assignment.
Expert Answer
[ The solution contains filled values of the highlighted parts and SCREENSHOTS of the Quiz ]
Buy This Answer $15
-- OR --
Subscribe $20 / Month