Sales Vs. Wages - Revision history

Cienna: Blanked the page

2024-12-02T02:27:01Z

Blanked the page

← Older revision		Revision as of 02:27, 2 December 2024
Line 1:		Line 1:
	Logging your incoming sales or gross profit (GP) and comparing it to your outgoing wages can be a fantastic way to achieve a properly forecasted roster, actively track sales for reports, and find discrepancies between your projections and what actually happened that week/fortnight.
	~~<br>~~
	~~To aid in ensuring full visibility of your data, you can also highlight when a wage percentage exceeds a certain amount, and even the option to track per department.~~
	~~<br><br>~~
	~~This information is different to Budgets but equally as beneficial, and will be coming soon in a future article.<br>~~
	~~You can also grab the Sales vs. Wages data from [[Reports#Sales.2FWages\|Reports]] for previous roster/pay periods, which can be exported into Excel.~~
	~~<br><Br>~~
	~~To get the best out of the Sales vs. Wages report, Projected Sales/GP data must be entered; this can be completed as you're creating the roster, or can be backdated.<br>~~
	Actual Sales/GP data is manually entered either in the timesheet or backdated in the roster for the same period. If you're lucky enough and use one of the [[Point of Sale]] systems that we integrate with, we may be able to pull your data automatically.
	~~<br><br>~~
	~~Before we get to the fancy stuff, let's enable the tool and have a look at the difference between Sales and Gross Profit, and how Sales vs. Wages works.<br><br>~~

	~~==Difference between Sales and Gross Profit==~~
	~~Sales is incoming revenue stream into the business, based off selling your goods and services.<br>~~
	~~Gross profit is the incoming revenue stream minus production/manufacturing costs and any overheads.<br>~~
	~~Depending on which you would prefer tracking, it can change the wage percentage and calculations for this tool and report.~~
	~~<br><br>~~

	~~==Enabling Sales/GP Tracking==~~
	* Open up Wageloch and sign in.
	* Click on the Settings cog in the top right and select General.
	~~<Br>[[File:2.0 Settings and General.png\|300px]]~~

	* Tick the box for Track wage percentages
	** Choose to track by Sales or Gross Profit.
	** Opt for highlighting % or if you'd like to track per department.
	* Click Done to save.

	~~<br>[[File:2.0 Track Wage Percentages.png\|300px]]<br>~~

	~~==How does it work?==~~
	~~When creating your roster and inputting data in the Sales area, the only two fields you can enter values into are the Projected Sales/GP and the Actual Sales/GP.~~
	~~Ideally when in the setup stages, only input the Projected Sales/GP values; if you're backdating data, you can input the Actual Sales/GP values.<br>~~

	~~To generate the wage percentage and reports correctly, the calculations work off '''four (4)''' fields:~~
	* Projected Sales or Gross Profit
	* Actual Sales or Gross Profit
	* Projected Wages (based off the rostered hours)
	* Actual Wages (based off the timesheet)
	~~<br>~~
	~~When viewing your Wage Percentage, for most industries anything sitting around '''20% - 25%''' is average and ideal; the lower the better.~~
	~~If you're finding your wage percentage is creeping up and over 30%, you may need to review your revenue or your rosters to be more cost effective.<br>~~

	~~{\| class="wikitable"~~
	~~! style="color:black; background-color:#e49cc5" \| '''Figures to include for accurate data:'''~~
	\|-
	\|
	*Projected Sales or Gross Profit
	*Actual Sales or Gross Profit
	*Projected Wages (based off the rostered hours)
	*Actual Wages (based off the timesheet)
	~~\|}<br>~~

	~~{\|class="wikitable" style="text-align:center;"~~
	~~! style="color:black; background-color:#e49cc5" \| '''Value 1'''~~
	~~! style="color:black; background-color:#e49cc5" \| '''Value 2'''~~
	~~! style="color:black; background-color:#e49cc5" \| '''Result'''~~
	~~! style="color:black; background-color:#e49cc5" \| '''Notes'''~~
	\|-
	~~\| Projected Sales/GP \|\| Actual Sales/GP \|\| Sales/GP Variance \|\| Are you up, down or break even?~~
	\|-
	~~\| Projected Wages \|\| Actual Wages \|\| Wages Variance \|\| Did you spend more/less on wages than you earned?~~
	\|-
	~~\| Projected Wage % \|\| Actual Wage % \|\| Wage Percentage Variance \|\| What is the variance between the % of money you spent on wages?~~
	\|-
	~~\| Roster Hours \|\| Actual Paid Hours \|\| Hours Variance \|\| Was there a difference between your roster and timesheet hours?~~
	\|-
	~~\| Projected Sales/GP \|\| Projected Wages \|\| Projected Wage % \|\| How much of your Sales/GP will you anticipate spending on wages?~~
	\|-
	~~\| Actual Sales/GP \|\| Actual Wages \|\| Actual Wage % \|\| How much of your Sales /GP have you spent on Wages?~~
	\|}
	~~<br>~~
	~~</center>~~

	~~==Format: Roster vs Report ==~~

	When looking at the difference between the two report formats, one key difference is that when running the Sales vs Wages report from the [[Reports]] menu, this is able to be exported as a .csv or .xlsx spreadsheet format to work with in programs such as Microsoft Excel or even Google Sheets.

	~~Click on the thumbnails to open a larger view of the images.~~
	~~<center>~~
	~~[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]~~
	~~</center>~~
	~~<br>~~
	~~<br>~~
	~~<br>~~
	~~[[File:Back-button-new.png\|link=Budgeting]] [[File:Home-button-new.png\|link=Main Page]] [[File:Next-button-new.png\|link=Grid View]]~~

Cienna at 05:14, 15 September 2023

2023-09-15T05:14:11Z

← Older revision		Revision as of 05:14, 15 September 2023
Line 84:		Line 84:
	<br>		<br>
	<br>		<br>
	~~<b>~~[[Main Page \| ~~< Back~~]]~~</b>~~		[[File:Back-button-new.png\|link=Budgeting]] [[File:Home-button-new.png\|link=Main Page]] [[File:Next-button-new.png\|link=Grid View]]

Cienna: /* Format: Roster vs Report */

2023-02-17T02:36:43Z

Format: Roster vs Report

← Older revision		Revision as of 02:36, 17 February 2023
Line 80:		Line 80:
	<center>		<center>
	[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]		[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]
			</center>
	<br>		<br>
	<br>		<br>
	<br>		<br>
	<b>[[Main Page \| < Back]]</b>		<b>[[Main Page \| < Back]]</b>

Cienna at 02:36, 17 February 2023

2023-02-17T02:36:22Z

← Older revision		Revision as of 02:36, 17 February 2023
Line 3:		Line 3:
	To aid in ensuring full visibility of your data, you can also highlight when a wage percentage exceeds a certain amount, and even the option to track per department.		To aid in ensuring full visibility of your data, you can also highlight when a wage percentage exceeds a certain amount, and even the option to track per department.
	<br><br>		<br><br>
	This information is different to [[Budgets]] but ~~is part of the [[Advanced_Roster_Functions]] section~~, ~~which is available~~ in ~~each individual roster~~.		This information is different to Budgets but equally as beneficial, and will be coming soon in a future article.<br>
	You can also grab the Sales vs. Wages data from [[Reports#Sales.2FWages\|Reports]] for previous roster/pay periods, which can be exported into Excel.		You can also grab the Sales vs. Wages data from [[Reports#Sales.2FWages\|Reports]] for previous roster/pay periods, which can be exported into Excel.
	<br><Br>		<br><Br>

Cienna at 02:35, 17 February 2023

2023-02-17T02:35:22Z

← Older revision		Revision as of 02:35, 17 February 2023
Line 80:		Line 80:
	<center>		<center>
	[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]		[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]

			<br>
			<br>
			<br>
			<b>[[Main Page \| < Back]]</b>

Cienna: /* How does it work? */

2023-02-07T05:30:36Z

How does it work?

← Older revision		Revision as of 05:30, 7 February 2023
Line 31:		Line 31:
	==How does it work?==		==How does it work?==
	When creating your roster and inputting data in the Sales area, the only two fields you can enter values into are the Projected Sales/GP and the Actual Sales/GP.		When creating your roster and inputting data in the Sales area, the only two fields you can enter values into are the Projected Sales/GP and the Actual Sales/GP.
	Ideally when in the setup stages, only input the Projected Sales/GP values; if you're backdating data, you can input the Actual Sales/GP values.~~<br>~~<br>		Ideally when in the setup stages, only input the Projected Sales/GP values; if you're backdating data, you can input the Actual Sales/GP values.<br>

	To generate the wage percentage and reports correctly, the calculations work off '''four (4)''' fields:		To generate the wage percentage and reports correctly, the calculations work off '''four (4)''' fields:
Line 38:		Line 38:
	* Projected Wages (based off the rostered hours)		* Projected Wages (based off the rostered hours)
	* Actual Wages (based off the timesheet)		* Actual Wages (based off the timesheet)
	~~<br>~~<br>		<br>
	When viewing your Wage Percentage, for most industries anything sitting around '''20% - 25%''' is average and ideal; the lower the better.		When viewing your Wage Percentage, for most industries anything sitting around '''20% - 25%''' is average and ideal; the lower the better.
	If you're finding your wage percentage is creeping up and over 30%, you may need to review your revenue or your rosters to be more cost effective.~~<br>~~<br>		If you're finding your wage percentage is creeping up and over 30%, you may need to review your revenue or your rosters to be more cost effective.<br>

	~~<center>~~		{\| class="wikitable"
	{\| class="wikitable" style="~~margin~~-~~center;~~"		! style="color:black; background-color:#e49cc5" \| '''Figures to include for accurate data:'''
	~~!Provided the fields in the report contain figures, the remainder of the report will generate accordingly~~
	\|-		\|-
	\|		\|
Line 51:		Line 50:
	*Projected Wages (based off the rostered hours)		*Projected Wages (based off the rostered hours)
	*Actual Wages (based off the timesheet)		*Actual Wages (based off the timesheet)
	\|}		\|}<br>
	~~</center>~~<br>

	~~<center>~~		{\|class="wikitable" style="text-align:center;"
	{\|class="wikitable" style="~~margin~~:center;" style="~~text~~-~~align~~:~~center;~~"		! style="color:black; background-color:#e49cc5" \| '''Value 1'''
	! Value 1 !! Value 2 !! Result !! Notes		! style="color:black; background-color:#e49cc5" \| '''Value 2'''
			! style="color:black; background-color:#e49cc5" \| '''Result'''
			! style="color:black; background-color:#e49cc5" \| '''Notes'''
	\|-		\|-
	\| Projected Sales/GP \|\| Actual Sales/GP \|\| Sales/GP Variance \|\| Are you up, down or break even?		\| Projected Sales/GP \|\| Actual Sales/GP \|\| Sales/GP Variance \|\| Are you up, down or break even?

Cienna: /* Format: Roster vs Report */

2023-02-07T05:22:13Z

Format: Roster vs Report

← Older revision		Revision as of 05:22, 7 February 2023
Line 76:		Line 76:

	When looking at the difference between the two report formats, one key difference is that when running the Sales vs Wages report from the [[Reports]] menu, this is able to be exported as a .csv or .xlsx spreadsheet format to work with in programs such as Microsoft Excel or even Google Sheets.		When looking at the difference between the two report formats, one key difference is that when running the Sales vs Wages report from the [[Reports]] menu, this is able to be exported as a .csv or .xlsx spreadsheet format to work with in programs such as Microsoft Excel or even Google Sheets.

			Click on the thumbnails to open a larger view of the images.
	<center>		<center>
	~~{\|class="wikitable"~~		[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]
	![[File:Salesvwages.PNG]] !! [[File:Sales report r002.PNG]]
	\|}

Cienna: /* Format: Roster vs Report */

2023-02-07T05:19:30Z

Format: Roster vs Report

← Older revision		Revision as of 05:19, 7 February 2023
Line 74:		Line 74:

	==Format: Roster vs Report ==		==Format: Roster vs Report ==

			When looking at the difference between the two report formats, one key difference is that when running the Sales vs Wages report from the [[Reports]] menu, this is able to be exported as a .csv or .xlsx spreadsheet format to work with in programs such as Microsoft Excel or even Google Sheets.
	<center>		<center>
	{\|class="wikitable"		{\|class="wikitable"
	![[File:Salesvwages.PNG]] !! [[File:Sales report r002.PNG]]		![[File:Salesvwages.PNG]] !! [[File:Sales report r002.PNG]]
	\|}		\|}

Cienna: /* Enabling Sales/GP Tracking */

2023-02-07T05:17:14Z

Enabling Sales/GP Tracking

← Older revision		Revision as of 05:17, 7 February 2023
Line 20:		Line 20:
	* Open up Wageloch and sign in.		* Open up Wageloch and sign in.
	* Click on the Settings cog in the top right and select General.		* Click on the Settings cog in the top right and select General.
			<Br>[[File:2.0 Settings and General.png\|300px]]

	* Tick the box for Track wage percentages		* Tick the box for Track wage percentages
	** Choose to track by Sales or Gross Profit.		** Choose to track by Sales or Gross Profit.
	** Opt for highlighting % or if you'd like to track per department.		** Opt for highlighting % or if you'd like to track per department.
	* Click Done to save.		* Click Done to save.

			<br>[[File:2.0 Track Wage Percentages.png\|300px]]<br>

	==How does it work?==		==How does it work?==

Cienna: /* The Report */

2022-08-11T05:50:50Z

The Report

← Older revision		Revision as of 05:50, 11 August 2022
Line 69:		Line 69:
	</center>		</center>

	==~~The~~ Report==		==Format: Roster vs Report ==
	<center>		<center>
	[[File:Salesvwages.PNG]]		{\|class="wikitable"
			![[File:Salesvwages.PNG]] !! [[File:Sales report r002.PNG]]
			\|}