Retail Inventory Template1 - Free Download
4.9, 3705 votes
Please vote for this template if it helps you.
Retail Inventory Template1
Retail Inventory Template1
!"#$%&'()*'+#,,'%),&"-.&%#),
This%Profit%&%Loss%Statement%(P&L)%is%for%two%products%manufactured%by%the%same%company%in%a%retail%sales%model.%The
product%flows%through%the%supply%chain%as%follows:%Manufacturer%-->%Distributor%-->%Retailer-->%Customer.%Instructions%on
how%to%fill%out%the%P&L%statement%are%broken%down%by%the%tabs%below.
(//0123456/
Input%data%only%in%cells%with%blue%characters.%Fill%in%the%data%as%accurately%as%possible,%as%this%information%is%used%in%the
Retailers%and%Summary%tabs.
"738497:/
1.%Input%data%only%in%cells%with%blue%characters.%All%areas%in%black%will%calculate%automatically.%Not%all%blue%cells%require
inputs.%If%this%is%the%case,%simply%enter%nothing%in%the%cell%(but%do%not%delete%the%line,%as%it%will%affect%the%formulas).
a.%Input%name%of%retailer%#1%where%it%says%"Retailer%#1"%and%repeat%for%every%retailer.
b.%Input%the%number%of%units%sold%for%Product%A%and%Product%B,%per%retailer.
2.%The%Retailers%tab%pushes%data%to%the%Summary%tab.%The%spreadsheet%has%been%set%up%to%anticipate%5%retailers.%In%order
to%add%more%retailers,%simply%scroll%down%to%the%last%remaining%retailer%(#5),%copy%the%box%above%it%and%insert%below,%i.e.,
Retailer%#5%gets%copied%and%inserted%to%make%Retailer%#6.%Then%link%the%relevant%cells%into%the%"Group"%on%the
corresponding%Summary%tab%in%order%to%accurately%roll%up%the%total.
,0118:;
No%inputs%are%necessary%on%this%tab,%as%the%data%inputted%in%Assumptions,%Retailers,%and%Line%Items%tabs%are%pushed%into
this%tab.
+467'%371/
*4/3:4<035:=/'>276/7/
1.%Input%data%only%in%cells%with%blue%characters.%All%areas%in%black%will%calculate%automatically.%This%tab%pushes%data%to%the
Summary%tab%under%Distributor's%Administrative%Expenses.%Not%all%blue%cells%require%inputs.%If%this%is%the%case,%simply%enter
nothing%in%the%cell%(but%do%not%delete%the%line,%as%it%will%affect%the%formulas).%Enter%as%a%negative%number.
a.%Distribution%Expenses:%Input%the%costs%associated%with%transporting%inventory%from%the%manufacturer%to%the%retailers
and%any%business-related%travel%for%personnel.
b.%Personnel%Expenses:%Input%the%costs%associated%with%Sales%Manager%and%other%personnel%(not%salespeople)
c.%Company%Administration:%Input%the%amount%spent%on%rent,%supplies,%etc.%
Retail Inventory Template1 Previous Page Retail Inventory Template1 Next Page
Retail Inventory Template1
Previous

1/20

Next