Reference · Passion Bakery
Passion Bakery's codes
Passion Bakery Ltd, Plot 27, Namanve Industrial Park, Mukono, Uganda. Local currency UGX; VAT 18%, eggs and milk exempt. Your training company has all of this, and three months of business up to the day it was made.
Ingredients and packaging
All are kept at BAKERY, in the general product posting group INGREDIENT. Cost is about what a base unit costs, without VAT.
| No. | Description | Base unit | Bought in | Cost | VAT | Inventory group | Vendor |
|---|---|---|---|---|---|---|---|
| RM000001 | Wheat Flour | KG | BAG of 50 | 3,600 | STANDARD | RAW | V000001 |
| RM000002 | Whole Wheat Flour | KG | BAG of 50 | 4,200 | STANDARD | RAW | V000001 |
| RM000003 | Sugar | KG | BAG of 50 | 4,600 | STANDARD | RAW | V000002 |
| RM000004 | Icing Sugar | KG | KG | 7,000 | STANDARD | RAW | V000002 |
| RM000005 | Baking Margarine | KG | CARTON of 10 | 9,500 | STANDARD | RAW | V000005 |
| RM000006 | Eggs | PCS | TRAY of 30 | 450 | EXEMPT | RAW | V000003 |
| RM000007 | Fresh Milk | L | L | 2,000 | EXEMPT | RAW | V000004 |
| RM000008 | Dry Yeast | KG | KG | 18,000 | STANDARD | RAW | V000005 |
| RM000009 | Salt | KG | KG | 1,500 | STANDARD | RAW | V000005 |
| RM000010 | Vegetable Oil | L | JERRYCAN of 20 | 7,500 | STANDARD | RAW | V000005 |
| RM000011 | Cocoa Powder | KG | KG | 32,000 | STANDARD | RAW | V000005 |
| RM000012 | Vanilla Essence | L | L | 45,000 | STANDARD | RAW | V000005 |
| RM000013 | Baking Powder | KG | KG | 14,000 | STANDARD | RAW | V000005 |
| PK000001 | Bread Bag | PCS | PACK of 500 | 60 | STANDARD | PACKAGING | V000006 |
| PK000002 | Donut Box | PCS | PACK of 100 | 700 | STANDARD | PACKAGING | V000006 |
| PK000003 | Cookie Bag | PCS | PACK of 500 | 120 | STANDARD | PACKAGING | V000006 |
| PK000004 | Cake Box | PCS | PACK of 50 | 1,800 | STANDARD | PACKAGING | V000006 |
Products and their recipes
All in PCS, inventory posting group FINISHED, VAT STANDARD. Each has an assembly BOM for one unit; prices include VAT.
| No. | Description | Price | Gen. Prod. group | Recipe for one |
|---|---|---|---|---|
| FG000001 | White Bread, 800 g | 5,000 | BREAD | Wheat flour 0.5 KG, sugar 0.03 KG, yeast 0.008 KG, salt 0.008 KG, oil 0.02 L, 1 bread bag |
| FG000002 | Brown Bread, 800 g | 5,500 | BREAD | Whole wheat flour 0.35 KG, wheat flour 0.15 KG, sugar 0.04 KG, yeast 0.008 KG, salt 0.008 KG, oil 0.02 L, 1 bread bag |
| FG000003 | Milk Buns, pack of 6 | 4,500 | BREAD | Wheat flour 0.36 KG, sugar 0.05 KG, milk 0.12 L, margarine 0.03 KG, yeast 0.006 KG, 1 egg, 1 bread bag |
| FG000004 | Sugar Donuts, box of 6 | 7,000 | PASTRY | Wheat flour 0.3 KG, sugar 0.08 KG, 2 eggs, milk 0.1 L, yeast 0.005 KG, oil 0.15 L, 1 donut box |
| FG000005 | Chocolate Cookies, 250 g | 7,000 | PASTRY | Wheat flour 0.12 KG, sugar 0.06 KG, margarine 0.06 KG, cocoa 0.02 KG, 1 egg, baking powder 0.002 KG, 1 cookie bag |
| FG000006 | Butter Cookies, 250 g | 6,500 | PASTRY | Wheat flour 0.13 KG, sugar 0.06 KG, margarine 0.07 KG, 1 egg, vanilla 0.002 L, 1 cookie bag |
| FG000007 | Vanilla Cake, 1 kg | 35,000 | CAKE | Wheat flour 0.3 KG, sugar 0.25 KG, margarine 0.2 KG, 5 eggs, milk 0.1 L, baking powder 0.01 KG, vanilla 0.005 L, 1 cake box |
| FG000008 | Chocolate Cake, 1 kg | 40,000 | CAKE | Wheat flour 0.3 KG, sugar 0.25 KG, margarine 0.2 KG, 5 eggs, milk 0.1 L, cocoa 0.06 KG, baking powder 0.01 KG, 1 cake box |
| FG000009 | Birthday Cake, 2 kg | 120,000 | CAKE | Wheat flour 0.6 KG, sugar 0.5 KG, margarine 0.4 KG, 10 eggs, milk 0.2 L, baking powder 0.02 KG, vanilla 0.01 L, icing sugar 0.5 KG, 1 cake box |
New items are numbered from FG000010.
Customers
All in the posting groups DOMESTIC, department SALES.
| No. | Name | Address | Payment terms | Channel | Agreed prices |
|---|---|---|---|---|---|
| C000001 | Kisementi Fresh Market | Kisementi, Kampala | 30 DAYS | WHOLESALE | White bread 4,600, brown bread 5,100 |
| C000002 | Nakawa Family Supermarket | Nakawa, Kampala | 30 DAYS | WHOLESALE | White bread 4,700, milk buns 4,200 |
| C000003 | Ntinda Corner Shop | Ntinda, Kampala | 14 DAYS | WHOLESALE | |
| C000004 | St. Kizito Boarding School | Kisubi, Wakiso | 30 DAYS | WHOLESALE | White bread 4,500 |
| C000005 | Kigo Lakeview Hotel | Kigo, Wakiso | 30 DAYS | WHOLESALE | Deliveries charged 25,000 on 210400 |
| C000006 | Bwaise Mini Mart | Bwaise, Kampala | 14 DAYS | WHOLESALE | |
| C000007 | Makerere Campus Cafe | Makerere, Kampala | 14 DAYS | WHOLESALE | |
| C000008 | Joy Events and Catering | Kansanga, Kampala | 14 DAYS | EVENTS | |
| C000009 | Walk-in Customers | Ntinda shop | CASH | RETAIL |
Credit customers have Credit Type Credit and a limit of 30,000,000; Walk-in Customers has none. New customers are numbered from C000010.
Vendors
All in the posting groups DOMESTIC.
| No. | Name | Supplies | Payment terms | Department |
|---|---|---|---|---|
| V000001 | Nile Flour Millers | Flours | 30 DAYS | PRODUCTION |
| V000002 | Busoga Sugar Distributors | Sugar, icing sugar | 30 DAYS | PRODUCTION |
| V000003 | Mukono Poultry Farm | Eggs | 14 DAYS | PRODUCTION |
| V000004 | Gayaza Dairy Co-operative | Milk | 14 DAYS | PRODUCTION |
| V000005 | Kampala Bakers’ Supplies | Yeast, salt, margarine, oil, cocoa, vanilla, baking powder | 30 DAYS | PRODUCTION |
| V000006 | Kampala Packaging Ltd | Bags and boxes | 30 DAYS | PRODUCTION |
| V000007 | City Power Distribution | Electricity and water | 14 DAYS | ADMIN |
| V000008 | Namanve Properties Ltd | Rent | CASH | ADMIN |
| V000009 | Kampala Gas Supplies | Oven gas | 14 DAYS | PRODUCTION |
| V000010 | Lakeside Telecom | Internet and telephone | 14 DAYS | ADMIN |
New vendors are numbered from V000011.
Locations
| Code | Description | In-transit |
|---|---|---|
| BAKERY | Bakery and store, Namanve (the default location) | No |
| SHOP | Passion Bakery shop, Ntinda | No |
| VAN | Delivery van | Yes |
Dimensions
| Dimension | Name | Values |
|---|---|---|
| DEPARTMENT (Dimension 1) | Department | PRODUCTION (Production), SALES (Sales), ADMIN (Administration), DELIVERY (Delivery) |
| CHANNEL (Dimension 2) | Sales Channel | WHOLESALE (Wholesale), RETAIL (Retail shop), EVENTS (Events and orders) |
Bank accounts
| No. | Name | Posting group | G/L account |
|---|---|---|---|
| STANBIC | Stanbic Bank, current account (no. 9030001234567) | BANK | 110200 Stanbic Bank |
| SHOP-TILL | Shop till, Ntinda | CASH | 110100 Cash on Hand, Shop Till |
Chart of accounts
| No. | Name | Type |
|---|---|---|
| 100000 | BALANCE SHEET | Heading |
| 110000 | ASSETS | Begin Total |
| 110100 | Cash on Hand, Shop Till | |
| 110200 | Stanbic Bank | |
| 110400 | Trade Debtors | |
| 110500 | Raw Materials Inventory | |
| 110510 | Packaging Inventory | |
| 110520 | Finished Goods Inventory | |
| 110600 | Bakery Equipment | |
| 110610 | Delivery Van | |
| 110700 | Accumulated Depreciation | |
| 119999 | Total Assets | End Total |
| 120000 | LIABILITIES | Begin Total |
| 120100 | Trade Creditors | |
| 120200 | Goods Received Not Invoiced | |
| 120300 | VAT Payable/Receivable | |
| 120400 | PAYE Payable | |
| 120500 | NSSF Payable | |
| 129999 | Total Liabilities | End Total |
| 130000 | EQUITY | Begin Total |
| 130100 | Share Capital | |
| 130200 | Retained Earnings | |
| 139999 | Total Equity | End Total |
| 200000 | INCOME STATEMENT | Heading |
| 210000 | INCOME | Begin Total |
| 210100 | Sales of Bread and Buns | |
| 210200 | Sales of Donuts and Cookies | |
| 210300 | Sales of Cakes | |
| 210400 | Delivery Charges | |
| 219999 | Total Income | End Total |
| 220000 | COST OF SALES | Begin Total |
| 220100 | Cost of Bread and Buns Sold | |
| 220110 | Cost of Donuts and Cookies Sold | |
| 220120 | Cost of Cakes Sold | |
| 220200 | Ingredients Purchased | |
| 220300 | Inventory Adjustments | |
| 229999 | Total Cost of Sales | End Total |
| 230000 | EXPENSES | Begin Total |
| 230100 | Production Wages | |
| 230110 | Sales and Administration Salaries | |
| 230200 | Rent | |
| 230300 | Electricity and Water | |
| 230310 | Oven Gas | |
| 230400 | Delivery Fuel | |
| 230500 | Telephone and Internet | |
| 230600 | Repairs and Maintenance | |
| 230700 | Depreciation | |
| 230800 | Bank Charges | |
| 239999 | Total Expenses | End Total |
| 299999 | NET PROFIT | End Total, from 200000 |
Blank types are posting accounts. Posting groups and setups are in Posting groups.
Number series
| Series | Numbers | Used for |
|---|---|---|
| CUST | C000010… | Customers |
| VEND | V000011… | Vendors |
| ITEM | FG000010… | Items |
| S-QUO, S-ORD, S-INV, S-CR | SQ…, SO…, SI…, SC… | Sales quotes, orders, invoices, credit memos |
| S-SHPT, S-PINV, S-PCR | SS…, PSI…, PSC… | Posted sales shipments, invoices, credit memos |
| S-RCPT, S-RFND, S-RDOC | RCT…, RFD…, RD… | Cash receipts, cash refunds, receipt documents |
| P-QUO, P-ORD, P-INV, P-CR | PQ…, PO…, PI…, PC… | Purchase quotes, orders, invoices, credit memos |
| P-RCPT, P-PINV, P-PCR | PR…, PPI…, PPC… | Posted purchase receipts, invoices, credit memos |
| P-PMT | PMT… | Vendor payments |
| T-ORD, T-SHPT, T-RCPT | TO…, TS…, TR… | Transfer orders, posted transfer shipments and receipts |
| A-ORD, A-PORD | AO…, PAO… | Assembly orders, posted assembly orders |
Each starts at 000001 but the first three. Return orders have no series.
Other setup
| Setup | Codes |
|---|---|
| Payment terms | CASH (0D), 14 DAYS (14D), 30 DAYS (30D) |
| Units of measure | PCS, KG, L, BAG, TRAY, CARTON, JERRYCAN, PACK |
| General journal templates | GENERAL (batches DEFAULT, MONTHLY), SALES, PURCHASES, CASHRECEIPT, PAYMENT, ITEM (batch DEFAULT each) |
| Item journal templates | ITEM and PHYS. INVENTORY, each with batch DEFAULT |
Left open for exercises
- Two purchase orders not yet received: wheat flour from Nile Flour Millers, sugar from Busoga Sugar Distributors.
- A sales order from Joy Events and Catering for a wedding: 4 birthday cakes and 3 chocolate cakes.
- An assembly order for 250 white loaves at BAKERY, dated the day after the bakery’s last day.
- Customer invoices not yet paid, and vendor invoices not yet paid.