Have a Question ?

Home / Answered Questions / MKTG 4600 / mktg-4600-assignment-2-financials-score-for-this-quiz-100-out-of-100-due-dec-21-at-11-59pm-q-275

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

 

  1. Percentage of households in trade area with children ages 15-18   x  (1,500,000)
  2. Percentage of PRIZM households in trade area described as Middleburg Managers  X   (900,000)
  3. Number of households in trade area within a 20-minute drive   X   225
  4. Square feet in shopping center    X    9.5
  5. Visibility from street   +  200,000
  6. 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.

 

 



We have an Answer from Expert View Expert Answer

Expert Answer


      [ The solution contains filled values of the highlighted parts  and SCREENSHOTS of the Quiz ]

 

 

 

We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month