Documents

22 pages
5 views

38. Retail Sales PL Template Proofread (1)

of 22
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
Sales
Transcript
  PROFIT AND LOSS INSTRUCTIONS AssumptonsReailers 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. SummaryLine IemsDisribuor's Epenses b. Personnel !penses Input the costs associated with ales $ana%er and other personnel &not salespeople'c. (ompany Administra)on Input the amount spent on rent, supplies, etc. *his Pro+t  -oss tatement &P-' is for two products manufactured by the same company in a retail sales model. *he product ows throu%h the supply chain as follows $anufacturer //0 istributor //0 Retailer//0 (ustomer. Instruc)ons on how to +ll out the P- statement are bro2en down by the tabs below.Input data only in cells with blue characters. 3ill in the data as accurately as possible, as this informa)on is used in the Retailers and ummary tabs. 1. Input data only in cells with blue characters. All areas in blac2 will calculate automa)cally. 4ot all blue cells re5uire inputs. If this is the case, simply enter nothin% in the cell &but do not delete the line, as it will a6ect the formulas'.7. *he Retailers tab pushes data to the ummary tab. *he spreadsheet has been set up to an)cipate 8 retailers. In order to add more retailers, simply scroll down to the last remainin% retailer &#8', copy the bo! above it and insert below, i.e., Retailer #8 %ets copied and inserted to ma2e Retailer #9. *hen lin2 the relevant cells into the :roup on the correspondin% ummary tab in order to accurately roll up the total.4o inputs are necessary on this tab, as the data inpu;ed in Assump)ons, Retailers, and -ine Items tabs are pushed into this tab. 1. Input data only in cells with blue characters. All areas in blac2 will calculate automa)cally. *his tab pushes data to the ummary tab under istributor<s Administra)ve !penses. 4ot all blue cells re5uire inputs. If this is the case, simply enter nothin% in the cell &but do not delete the line, as it will a6ect the formulas'. nter as a ne%a)ve number. a. istribu)on !penses Input the costs associated with transpor)n% inventory from the manufacturer to the retailers and any business/related travel for personnel.  !anu a#urer's Epenses c. Personnel !penses Input the costs associated with ales $ana%er and other personnel &not salespeople'd. (ompany Administra)on Input the amount spent on rent, supplies, etc. 7=17 1. Input data only in cells with blue characters. All areas in blac2 will calculate automa)cally. *his tab pushes data to the ummary tab under $anufacturer<s $ar2e)n% and Administra)ve !penses. 4ot all blue cells re5uire inputs. If this is the case, simply enter nothin% in the cell &but do not delete the line, as it will a6ect the formulas'. nter as a ne%a)ve number. a. $ar2e)n% !penses Input the above the line and below the line mar2e)n% ac)vity names and their associated costs. Abo$e%&e%line maretn( ac)vi)es are broadcasts to mass audiences such as throu%h *>, radio, and newspapers and can reach a lar%er audience 5uic2ly. It is harder to tailor the messa%es or measure the return on investment &how e6ec)ve are these ac)vi)es at reachin% your tar%eted audience?' compared with below/the/line mar2e)n%. )elo*%&e%line maretn( can be tailored to a speci+c %roup and includes items such as leaets, coupons, %i@s with purchase, and point/of/sale displays. It is much easier to measure the return on investment of these ac)vi)es. 3or e!ample, if you o6er coupons to customers, it is easy to count how many coupons were redeemed per store. ou can measure the chan%e in sales durin% the months you o6er the coupon compared with the months that you did not o6er that promo)on to see if the increase in revenues is worth the cost. b. istribu)on !penses Input any costs associated with transpor)n% the inventory and any business/related travel for personnel.  P+L ASSU!PTIONS ASSU!PTIONS (urrencyC Riel*he currency of the country where you are conduc)n% business.!chan%e RateD,7== Product A Retail PriceEFnit17=,=== *he price that the manufacturer su%%ests the retailer should char%e the customer for Product A.Product A istributor PriceEFnit1==,=== *he price that the distributor char%es the retailer for Product A.Product A $anufacturer PriceEFnitG=,=== *he price that the manufacturer char%es the distributor for Product A.Product A $anufacturer (ostEFnit9=,=== *he cost for the manufacturer to produce Product A.Product B Retail PriceEFnit18=,=== *he price that the manufacturer su%%ests the retailer should char%e the customer for Product B.Product B istributor PriceEFnit1H=,=== *he price that the distributor char%es the retailer for Product B.Product B $anufacturer PriceEFnit118,=== *he price that the manufacturer char%es the distributor for Product B. Product B $anufacturer (ostEFnit=,=== *he cost for the manufacturer to produce Product B.>alue Added *a! &Retailer'1=.=J>A* is the ta! on the purchase price for customers. *he rate varies from country to country. >alue Added *a! &$anufacturer'1=.=JIf you need to report to sta2eholders in di6erent countries, repor)n% amounts in their currency will help them understand the pro+tability of your business be;er. 3or e!ample, if your business is based in (ambodia but you are receivin% fundin% from a donor in the Fnited tates, you should report amounts converted from (ambodian Riel to F ollars. >A* is applied once value has been added to the product at the produc)on sta%e, which is when all the supplies are assembled to create the +nal product. *he rate varies from country to country.  RETAILERS P+L Reailer ,- Kanuary3ebruary$archApril$ayKuneKulyAu%usteptemberPRLF(* A unit sales17= PRLF(* B unit sales1M8 Pro.u# A Re$enue-/0/110111 1 1 1 1 1 1 1 1 -ess Product (ost&17,===,==='= = = = = = = = :ross Pro+t7,D==,=== = = = = = = = = Gross Margin %17% PriceEFnit17=,=== Pro+tEFnit7=,=== Pro.u# ) Re$enue2302410111 1 1 1 1 1 1 1 1 -ess Product (ost&77,M8=,==='= = = = = = = = :ross Pro+tH,8==,=== = = = = = = = = Gross Margin %13% PriceEFnit18=,=== Pro+tEFnit7=,=== -ess >alue Added *a!&D,=98,==='= = = = = = = = Toal 5ross Pro6-07840111 1 1 1 1 1 1 1 1 Gross Margin %5% Reailer ,2 Kanuary3ebruary$archApril$ayKuneKulyAu%usteptemberPRLF(* A unit sales8= PRLF(* B unit salesG8 Pro.u# A Re$enue301110111 1 1 1 1 1 1 1 1 Input the number of units sold of each product for each retailer and the individual mar%ins and pro+ts will be automa)cally calculated based on the summariNed in the :roup at the bo;om. oin% this monthly allows you to see the retailersO performance over )me to be;er understand their individ and worst performin% retailers are and allows you to follow up with them to be;er understand why and improve performance across all retail outlets
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks