Problem $18\mathrm{.}51($Algo$)$ Contrlbutlon Income Statement; Spreadsheet Applleation $[$LO $18-3]$

Fashionisto Incorporated is an upscale clothing store in New York City and London. Each store hos two main departments, Men's Apporel and Women's Apparel. Marie Phelps, Foshionisto's CFO, wants to use strategic performance messurement to better understand the company's financisl results. She has decided to use the profit center method to messure performance and has gathered the following information sbout the two stores and the two departments of the New York City store:

$\backslash$table$[[$Total net sales,$$4,180,$ ebe$],[$Fixed costs$],[$Partly traceable and controllable,$280,080],[$Partly traceable but noncontrollable,$250,080],[$Nontraceable costs,$100,\backslash$theta $8$e$],[$Total net sales $($percent$)],[$London store,$],[$New York store,$60],[$Ncw York$-$Men's Apparel,$40],[$Ncw York$-$Wonen's Apparel,$60],[$Cost of goods sold$-$variable $($percent of sales$)],[$Lendon store,$528],[$Ncw York$-$Men's Apparel,$45],[$Ncw York$-$Wonen's Apparel,$60],[$Variable operating costs $($percent of sales$)],[$Landon store,$36\%],[$Ncw York$-$Men's Apparel,$22],[$Ncw York$-$Wonen's Apparel,$32],[$Fixed controllable costs$-$partly traceable $($percent of total$)],[$Landon store,$48$ex$],[$Ncw York tatal,$40],[$Men$\text{'}$s Apparel,$45],[$Women$\text{'}$s Apparel,$40],[$Could not be traced to Men's or Wemen's Apparel,$15],[$Could not be traced to London or New York,$20],[$Fixed noncontrollable costs$-$partly traceable $($percent of total$)],[$Landon store,$58$x$],[$Ncw York tatal,$40],[$Men$\text{'}$s Apparel,$35],[$Wements Apparel,$15],[$Could not be traced to Men's or Women's Apparel,$50],[$Could not be traced to London or New York,$10]]$

Required:

Using this information, prepare a contribution income statement for Fashionisto.

$\backslash$table$[[,\backslash$table$[[$Combined$],[$Company$]],$Not Allocated,London store,$\backslash$table$[[$New York$],[$store$]],$Not allocated,Men's wear,Women's wear$],[$COGS$],[$Variable cost$],[,,,,,,,1],[,,,,,,,],[$Tatal variable cost,$0,,0,0,,0,$c$],[,,,,,,$T$],[,,,,,,],[0,,0,0,,0,$a$],[,,,$a$,,,],[0,0,0,0,0,$s$,$s$],[,,,,,,],[0,,,,,,]]$