{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Help","Sales Report"],"not_rendered":{"charts":2,"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[4,6,4,8],[5,6,5,8]]}
["Sales Revenue Template"]
["https://excelgraduate.com/calculate-total-revenue-in-excel/"]
["About This Template"]
[null,"This spreadsheet lets you calculate total revenue and net income from your sales data. You can set up quantity, unit price, markup, & shipping cost to analyze your monthly sales. It also generates some charts and graphs to help you understand how your sales performs over the month."]
[]
[null,"Note: This spreadsheet is not financial advice. The results may not be accurate or relevant to your specific situation. Please seek professional advice from a qualified financial advisor or accountant before making any significant financial decisions.",{"$nulls":4},"\nExcelgraduate\n© 2023 by Excelgraduate | All Rights Reserved."]
[]
["Terminology"]
[null,"Product List: A comprehensive list of products or items available for sale, usually accompanied by their respective product codes or names."]
[null,"Ordered Quantity: The number of units of a product that a customer has ordered or requested."]
[null,"Unit Price: The price of a single unit of a product, often referred to as the \"base price.\""]
[null,"Markup: The percentage added to the unit price to determine the selling price, which represents the desired profit margin."]
[null,"Total Revenue: The total amount of money generated from the sale of a product, calculated as the product of the ordered quantity, the unit price, and the markup."]
[null,"Charged Shipping Cost: The amount charged to the customer to cover the cost of shipping and handling the ordered products."]
[null,"Actual Shipping Cost: The amount that the seller incurs to ship the products, including packaging, postage, and other expenses."]
[null,"Profit Per Unit: The amount of profit generated by selling one unit of a product."]
[null,"Returned Quantity: The number of units of a product that have been returned by customers due to defects or other reasons."]
[null,"Net Profit: The total profit generated from the sale of a product."]
[]
["Formulas"]
[null,"Total Revenue = Ordered Quantity*Unit Price*(1 + Markup)"]
[null,"Profit Per Unit = Unit Price*Markup + (Charged Shipping Cost - Actual Shipping Cost)"]
[null,"Net Profit = (Ordered Quantity - Returned Quantity)*Profit Per Unit + Returned Quantity*(Charged Shipping Cost - Actual Shipping Cost)"]

{"sheet":"Sales Report","index":1,"n_rows":24,"n_cols":14,"rows_kept":24,"merged":[[0,0,0,3],[2,0,2,1],[2,2,2,3],[3,0,3,1],[3,2,3,3],[5,13,5,15],[6,13,6,15],[15,0,15,9],[20,0,20,9]]}
["Sales Revenue Template"]
[{"$nulls":5},"Help: ","https://excelgraduate.com/calculate-total-revenue-in-excel/"]
["Date:",null,"January 2023"]
["Company Name:",null,"Zenith Corporation"]
[]
["Product List","Ordered Quantity","Unit Price","Markup","Total Revenue","Charged Shipping Cost","Actual Shipping Cost","Profit Per Unit","Returned Quantity","Net Profit",{"$nulls":3},"Excelgraduate"]
["A",110,{"v":210,"d":"$210.00"},{"v":0.11,"d":"11%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":25641.000000000004,"d":"$25,641.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":33.1,"d":"$33.10"}},2,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":3594.8,"d":"$3,594.80"}},{"$nulls":3},"© 2023 by Excelgraduate | All Rights Reserved."]
["B",120,{"v":370,"d":"$370.00"},{"v":0.11,"d":"11%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":49284.00000000001,"d":"$49,284.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":50.7,"d":"$50.70"}},2,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":6002.6,"d":"$6,002.60"}}]
["C",140,{"v":210,"d":"$210.00"},{"v":0.2,"d":"20%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":35280,"d":"$35,280.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":52,"d":"$52.00"}},9,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":6902,"d":"$6,902.00"}}]
["D",180,{"v":400,"d":"$400.00"},{"v":0.07,"d":"7%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":77040,"d":"$77,040.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":38,"d":"$38.00"}},8,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":6616,"d":"$6,616.00"}}]
["E",60,{"v":240,"d":"$240.00"},{"v":0.17,"d":"17%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":16848,"d":"$16,848.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":50.80000000000001,"d":"$50.80"}},4,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":2884.8000000000006,"d":"$2,884.80"}}]
["F",120,{"v":400,"d":"$400.00"},{"v":0.09,"d":"9%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":52320.00000000001,"d":"$52,320.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":46,"d":"$46.00"}},6,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":5304,"d":"$5,304.00"}}]
["G",170,{"v":210,"d":"$210.00"},{"v":0.19,"d":"19%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":42483,"d":"$42,483.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":49.900000000000006,"d":"$49.90"}},7,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":8203.7,"d":"$8,203.70"}}]
["H",180,{"v":300,"d":"$300.00"},{"v":0.12,"d":"12%"},{"$f":"IFERROR(Table1[[#This Row],[Ordered Quantity]]*Table1[[#This Row],[Unit Price]]*(1+Table1[[#This Row],[Markup]]),0)","v":{"v":60480.00000000001,"d":"$60,480.00"}},{"v":25,"d":"$25.00"},{"v":15,"d":"$15.00"},{"$f":"IFERROR(Table1[[#This Row],[Unit Price]]*Table1[[#This Row],[Markup]]+Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]],0)","v":{"v":46,"d":"$46.00"}},5,{"$f":"IFERROR(((Table1[[#This Row],[Ordered Quantity]]-Table1[[#This Row],[Returned Quantity]])*Table1[[#This Row],[Profit Per Unit]])+(Table1[[#This Row],[Returned Quantity]]*(Table1[[#This Row],[Charged Shipping Cost]]-Table1[[#This Row],[Actual Shipping Cost]])),0)","v":{"v":8100,"d":"$8,100.00"}}]
[]
["Total Revenue by Product"]
["Product List","A","B","C","D","E","F","G","H","All"]
["Total Revenue",{"$f":"E7","v":{"v":25641.000000000004,"d":"$25,641.00"}},{"$f":"E8","v":{"v":49284.00000000001,"d":"$49,284.00"}},{"$f":"E9","v":{"v":35280,"d":"$35,280.00"}},{"$f":"E10","v":{"v":77040,"d":"$77,040.00"}},{"$f":"E11","v":{"v":16848,"d":"$16,848.00"}},{"$f":"E12","v":{"v":52320.00000000001,"d":"$52,320.00"}},{"$f":"E13","v":{"v":42483,"d":"$42,483.00"}},{"$f":"E14","v":{"v":60480.00000000001,"d":"$60,480.00"}},{"$f":"SUM(B18:I18)","v":{"v":359376,"d":"$359,376.00"}}]
["% of Total Revenue",{"$f":"B18/J18","v":{"v":0.07134867102978497,"d":"7%"}},{"$f":"C18/J18","v":{"v":0.13713770535595032,"d":"14%"}},{"$f":"D18/J18","v":{"v":0.09817016161346334,"d":"10%"}},{"$f":"E18/J18","v":{"v":0.2143715774008281,"d":"21%"}},{"$f":"F18/J18","v":{"v":0.04688126085214372,"d":"5%"}},{"$f":"G18/J18","v":{"v":0.14558568184853748,"d":"15%"}},{"$f":"H18/J18","v":{"v":0.1182132362762121,"d":"12%"}},{"$f":"I18/J18","v":{"v":0.16829170562308002,"d":"17%"}},{"$f":"SUM(B19:I19)","v":{"v":1,"d":"100%"}}]
[]
["Net Profit by Product"]
["Product List","A","B","C","D","E","F","G","H","All"]
["Net Profit",{"$f":"J7","v":{"v":3594.8,"d":"$3,594.80"}},{"$f":"J8","v":{"v":6002.6,"d":"$6,002.60"}},{"$f":"J9","v":{"v":6902,"d":"$6,902.00"}},{"$f":"J10","v":{"v":6616,"d":"$6,616.00"}},{"$f":"J11","v":{"v":2884.8000000000006,"d":"$2,884.80"}},{"$f":"J12","v":{"v":5304,"d":"$5,304.00"}},{"$f":"J13","v":{"v":8203.7,"d":"$8,203.70"}},{"$f":"J14","v":{"v":8100,"d":"$8,100.00"}},{"$f":"SUM(B23:I23)","v":{"v":47607.9,"d":"$47,607.90"}}]
["% of Net Profit",{"$f":"B23/J23","v":{"v":0.07550847653435669,"d":"8%"}},{"$f":"C23/J23","v":{"v":0.12608411629162386,"d":"13%"}},{"$f":"D23/J23","v":{"v":0.14497593886728882,"d":"14%"}},{"$f":"E23/J23","v":{"v":0.13896853253346608,"d":"14%"}},{"$f":"F23/J23","v":{"v":0.060594985286055475,"d":"6%"}},{"$f":"G23/J23","v":{"v":0.1114100810999855,"d":"11%"}},{"$f":"H23/J23","v":{"v":0.1723180396530828,"d":"17%"}},{"$f":"I23/J23","v":{"v":0.17013982973414077,"d":"17%"}},{"$f":"SUM(B24:I24)","v":{"v":1,"d":"100%"}}]