flexiBake Tutorial 4

Administrator

Description

flexiBake Tutorial 4Tutorial 4: What If? Cost Analysis.IntroductionUse this function to determine what effect a change in the cost of ingredients, or a change in labourcosts, or a change in the cost of packaging has on your recipe’s net profits.You can choose to display only those recipes thatare no longer making their specified profitmargins. When you have hundreds of recipes in yourdatabase, this is a handy feature.(See Tutorial 3 for details on setting a recipe’s targetretail and wholesale net profit)NavigationClick on the What If icon on the Toolbar or alternatively click on the Activities menu and select theWhat If Cost Analysis from the dropdown menu.ToolbarActivities Menu1 2003 Afcom. All Rights ReservedflexiBake Tutorial 4OverviewThe What If Cost Analysis function is easily used as shown in the steps below.Step 6Click to makethese costchangespermanent bysaving to thedatabase.Step 1Enter the ingredientand/or labour and/orpackaging costs changesStep 4Click the AnalysebuttonStep 2Choose to analyseeither retail orStep 5 wholesale pricingView the list of recipesaffected by these costchanges.Step 3Check to view all recipes affected by these cost changes. Leaveunchecked to view only those recipes affected which are nolonger making their specified profit margins.2 2003 Afcom. All Rights ReservedflexiBake Tutorial 4Ingredient CostsBegin typing in the name of the ingredient and flexiBake will attempt to “autofill” the ...

Informations

• Publié par: Choon
• Nombre de lectures: 28
• Langue: English

Extrait

flexiBake Tutorial 4

1



2003 Afcom. All Rights Reserved

Tutorial 4: What If? Cost Analysis.

Introduction

Use this function to determine what effect a change in the cost of ingredients, or a change in labour

costs, or a change in the cost of packaging has on your recipe’s net profits.

You can choose to display

only those recipes that

are no longer making their specified profit

margins

. When you have hundreds of recipes in your

database, this is a handy feature.

(See Tutorial 3 for details on setting a recipe’s target

retail and wholesale net profit)

Navigation

Click on the What If icon on the Toolbar or alternatively click on the Activities menu and select the

What If Cost Analysis from the dropdown menu.

Toolbar

Activities Menu

flexiBake Tutorial 4

2



2003 Afcom. All Rights Reserved

Overview

The What If Cost Analysis function is easily used as shown in the steps below.

Step 1

Enter the ingredient

and/or labour and/or

packaging costs changes

Step 2

Choose to analyse

either retail or

wholesale pricing

Step 3

Check to view all recipes affected by these cost changes. Leave

unchecked to view only those recipes affected which are no

longer making their specified profit margins.

Step 4

Click the Analyse

button

Step 5

View the list of recipes

affected by these cost

changes.

Step 6

Click to make

these cost

changes

permanent by

saving to the

database.

flexiBake Tutorial 4

3



2003 Afcom. All Rights Reserved

Ingredient Costs

Begin typing in the name of the ingredient and flexiBake will attempt to “autofill” the remaining letters

as you are typing the name (alternatively press F2 and select from the ingredient list displayed). Once

the name of the ingredient appears in the text box, click on the Now (cost price) box and enter the

new ingredient cost.

Click on the Add button to add this ingredient to the What If Cost query. Add any other ingredient cost

changes.

Enter the new cost

of the ingredient.

Current cost of ingredient will be

automatically displayed once

you enter the new cost.

flexiBake Tutorial 4

4



2003 Afcom. All Rights Reserved

If you enter an incorrect value, select the record, enter the correct cost in the Now box and then click

the Update button.

When you have entered all your ingredient cost changes, click the Analyse button

and flexiBake will do a complete cost analysis on every recipe in the database which

uses any of these ingredients. The recipes will appear in the grid in the lower half of

the window.

flexiBake Tutorial 4

5



2003 Afcom. All Rights Reserved

In the example below the analysis has run and no recipes have been found to have slipped below

their target profit margins as a result of the increased cost of these two ingredients.

In the example below the same ingredient cost increases are entered, wholesale pricing is selected

but the

View All

check box has been checked. The analysis function will now list all recipes affected

(not just those recipes which are no longer making their target net profits).

These ingredient

cost increases

have not caused

any recipes to slip

below their target

wholesale net

profits

Wholesale pricing

selected for analysis

View All recipes

checked

The analysis module displays a comparison of current vs new pricing due to the increased costs.

This recipe is still

making its target

wholesale net profit of

20% (This is why it was

not displayed in the

example above).

The recipes net profit

has however dropped

from 25% to 21.2%

flexiBake Tutorial 4

6



2003 Afcom. All Rights Reserved

Labour Costs

Click on the Labour Costs tab to adjust your labour costs. You can either choose to change all labour

rates by the same percentage or else you can adjust individually. In the example below all labour

rates have been increased by 10%.

Packaging

Click on the Packaging Costs tab to adjust your packaging costs.

flexiBake Tutorial 4

7



2003 Afcom. All Rights Reserved

Summary

Once you have entered your cost changes (i.e. ingredient, labour, packaging) and clicked on the

Analyse button the following options are available.

End.

Click on column

headings to sort in

either ascending or

descending order

Click on the Save Cost Changes

button to save these cost changes to

the database. If you do not want to

save these changes, simply click the

Close button to exit.

To view a recipe’s details, highlight

the recipe from the list and click on

the View/Edit Recipe button (or

simply doubly click on the record)

Print Analysis will give you a printout

of the entire analysis screen.