DOWNLOAD A COPY of this spreadsheet to your computer by clicking on the word "File" in top left corner of this screen.

Then click "Download as

Cincinnati Seasonings with Five Stores - Monthly Profit & Loss Report plus KPIs

SALES REVENUE Total Company Seasonings Factory Seasonings DC Louisville Store Indianapolis Store
Products Sold (Demand at Stores 9,920 3,100 2,170
** Retail Markup % (enter manually) 30.00 30.00
Retail Sales Price 1,300 1,300
Total Income 12,896,000 $4,030,000 $2,821,000

OPERATING EXPENSE
Cost of Products Sold 9,920,000 3,100,000 2,170,000
Facility Storage & Operating Cost 3,258,000 1,320,000 1,200,000 225,000 165,000
Transportation Cost 62,325 10,962 51,363
Total Expenses 13,240,325 1,330,962 1,251,363 3,325,000 2,335,000

MONTHLY PROFIT OR LOSS

Gross Profit before Admin & Tax -$344,325 $705,000 $486,000
Gross Profit % -2.67% 17.49% 17.23%

SUPPLY CHAIN PERFORMANCE Total Company Seasonings Factory Seasonings DC Louisville Store Indianapolis Store
** Spicy Cube: Product Cost $1,000
Beginning Inventory On-Hand 6,240 940 3660 400 230
Ending Inventory On-Hand 7,250 2860 2730 500 300
Percent Change 16.19% 204.26% -25.41% 25.00% 30.43%
Avg On-Hand Inventory Amount 6,787 1,888 3,195 457 270
Avg On-Hand Inventory Value $6,787,000 $1,888,000 $3,195,000 $456,667 $269,667
Product Daily Demand 320 100 70
Inventory Days of Supply 21.21 4.57 3.85
Vehicle Carbon Footprint (kg) 88,956
NOTES:
** Accept default numbers for Product Markup and Product Price, or enter other numbers manually in cells outlined in orange.

-- What is the Gross Profit before Admin & Tax? Is it positive or negative? Look under the main heading MONTHLY PROFIT OR LOSS. Did you make m
What can you do to increase the Gross Profit? Look for ways to cut Transportation Cost, and Faciity Storage & Operating Cost

-- Default rent costs at facilities are set higher than market rates. If you wish to use market rates, find them at a commercial real estate website such as

-- Expand this template to accomodate new products, facilities, and vehicles as you add them to your supply chain. See how cells in this reporting tab
* Add new columns to read and display data for new facilities - repeat column G for each new store
* Add new rows to read and display data for new products - repeat rows 24 - 31 for each new product
* See "Modify P&L Reporting Template for New Facilities – A Short Tutorial" at botton of Analyzing Simulation Data section in Onlne Guide
en click "Download as" in the submenu and select download format

Ft Wayne Store Chicago Store Columbus Store

620 3,100 930
30.00 30.00 30.00
1,300 1,300 1,300
$806,000 $4,030,000 $1,209,000

620,000 3,100,000 930,000

216,000 81,000 51,000

836,000 3,181,000 981,000

-$30,000 $849,000 $228,000

-3.72% 21.07% 18.86%

Ft Wayne Store Chicago Store Columbus Store

780 200 30
640 170 50
-17.95% -15.00% 66.67%
712 219 46
$712,000 $219,333 $46,333
20 100 30
35.60 2.19 1.54
 in orange.

LOSS. Did you make money or lose money?

estate website such as www.cityfeet.com

lls in this reporting tab read data in the simulation data tab:

ion in Onlne Guide

On-hand report
Facility Seasonings Factory - Spicy Cube Seasonings DC - Spicy Cube Louisville Store - Spicy Cube
Day 0 940 3660 400
Day 1 960 3650 400
Day 2 980 3640 400
Day 3 1110 3580 400
Day 4 1130 3570 400
Day 5 1260 3450 400
Day 6 1280 3550 400
Day 7 1300 3540 400
Day 8 1430 3480 400
Day 9 1450 3470 400
Day 10 1580 3350 400
Day 11 1600 3340 400
Day 12 1620 3390 400
Day 13 1750 3270 400
Day 14 1770 3260 500
Day 15 1900 3140 500
Day 16 1920 3190 500
Day 17 1940 3290 500
Day 18 2070 3170 500
Day 19 2090 3160 500
Day 20 2220 3100 500
Day 21 2240 3090 500
Day 22 2260 3080 500
Day 23 2390 2790 500
Day 24 2410 2840 500
Day 25 2540 2720 500
Day 26 2560 2710 500
Day 27 2580 2810 500
Day 28 2710 2750 500
Day 29 2730 2740 500
Day 30 2860 2730 500

Demand report
 Facility Seasonings Factory - Spicy Cube Seasonings DC - Spicy Cube Louisville Store - Spicy Cube
Day 0 0 0 100
Day 1 0 0 100
Day 2 0 0 100
Day 3 0 0 100
Day 4 0 0 100
Day 5 0 0 100
Day 6 0 0 100
Day 7 0 0 100
Day 8 0 0 100
Day 9 0 0 100
Day 10 0 0 100
Day 11 0 0 100
Day 12 0 0 100
Day 13 0 0 100
Day 14 0 0 100
Day 15 0 0 100
Day 16 0 0 100
Day 17 0 0 100
Day 18 0 0 100
Day 19 0 0 100
Day 20 0 0 100
Day 21 0 0 100
Day 22 0 0 100
Day 23 0 0 100
Day 24 0 0 100
Day 25 0 0 100
Day 26 0 0 100
Day 27 0 0 100
Day 28 0 0 100
Day 29 0 0 100
Day 30 0 0 100

Production report
Facility Seasonings Factory - Spicy Cube Seasonings DC - Spicy Cube Louisville Store - Spicy Cube
Day 0 350 0 0
Day 1 350 0 0
Day 2 350 0 0
Day 3 350 0 0
Day 4 350 0 0
Day 5 350 0 0
Day 6 350 0 0
Day 7 350 0 0
Day 8 350 0 0
Day 9 350 0 0
Day 10 350 0 0
Day 11 350 0 0
Day 12 350 0 0
Day 13 350 0 0
Day 14 350 0 0
Day 15 350 0 0
Day 16 350 0 0
Day 17 350 0 0
Day 18 350 0 0
Day 19 350 0 0
Day 20 350 0 0
Day 21 350 0 0
Day 22 350 0 0
Day 23 350 0 0
Day 24 350 0 0
Day 25 350 0 0
Day 26 350 0 0
Day 27 350 0 0
Day 28 350 0 0
Day 29 350 0 0
Day 30 350 0 0

In report
Facility Seasonings Factory - Spicy Cube Seasonings DC - Spicy Cube Louisville Store - Spicy Cube
Day 0 0 0 0
Day 1 0 330 100
Day 2 0 660 200
Day 3 0 880 300
Day 4 0 1210 400
Day 5 0 1430 500
Day 6 0 1760 600
Day 7 0 2090 700
Day 8 0 2310 800
Day 9 0 2640 900
Day 10 0 2860 1000
Day 11 0 3190 1100
Day 12 0 3520 1200
Day 13 0 3740 1300
Day 14 0 4070 1500
Day 15 0 4290 1600
Day 16 0 4620 1700
Day 17 0 4950 1800
Day 18 0 5170 1900
Day 19 0 5500 2000
Day 20 0 5720 2100
Day 21 0 6050 2200
Day 22 0 6380 2300
Day 23 0 6600 2400
Day 24 0 6930 2500
Day 25 0 7150 2600
Day 26 0 7480 2700
Day 27 0 7810 2800
Day 28 0 8030 2900
Day 29 0 8360 3000
Day 30 0 8690 3100

Out report
Facility Seasonings Factory - Spicy Cube Seasonings DC - Spicy Cube Louisville Store - Spicy Cube
Day 0 110 340 100
Day 1 440 680 200
Day 2 770 1020 300
Day 3 990 1300 400
Day 4 1320 1640 500
Day 5 1540 1980 600
Day 6 1870 2210 700
Day 7 2200 2550 800
Day 8 2420 2830 900
Day 9 2750 3170 1000
Day 10 2970 3510 1100
Day 11 3300 3850 1200
Day 12 3630 4130 1300
Day 13 3850 4470 1400
Day 14 4180 4810 1500
Day 15 4400 5150 1600
Day 16 4730 5430 1700
Day 17 5060 5660 1800
Day 18 5280 6000 1900
Day 19 5610 6340 2000
Day 20 5830 6620 2100
Day 21 6160 6960 2200
Day 22 6490 7300 2300
Day 23 6710 7810 2400
Day 24 7040 8090 2500
Day 25 7260 8430 2600
Day 26 7590 8770 2700
Day 27 7920 9000 2800
Day 28 8140 9280 2900
Day 29 8470 9620 3000
Day 30 8690 9960 3100

Facilities Cost report

Facility Seasonings Factory Seasonings DC Louisville Store
Day 0 44000 40000 7500
Day 1 44000 40000 7500
Day 2 88000 80000 15000
Day 3 132000 120000 22500
Day 4 176000 160000 30000
Day 5 220000 200000 37500
Day 6 264000 240000 45000
Day 7 308000 280000 52500
Day 8 352000 320000 60000
Day 9 396000 360000 67500
Day 10 440000 400000 75000
Day 11 484000 440000 82500
Day 12 528000 480000 90000
Day 13 572000 520000 97500
Day 14 616000 560000 105000
Day 15 660000 600000 112500
Day 16 704000 640000 120000
Day 17 748000 680000 127500
Day 18 792000 720000 135000
Day 19 836000 760000 142500
Day 20 880000 800000 150000
Day 21 924000 840000 157500
Day 22 968000 880000 165000
Day 23 1012000 920000 172500
Day 24 1056000 960000 180000
Day 25 1100000 1000000 187500
Day 26 1144000 1040000 195000
Day 27 1188000 1080000 202500
Day 28 1232000 1120000 210000
Day 29 1276000 1160000 217500
Day 30 1320000 1200000 225000

Vehicles Cost report

Vehicle DC Truck2 DC Truck3 DC Truck4
Running Cost 9288 11610 10485
Total Carbon (kg) 13932 13932 14679
Facility Seasonings Factory Seasonings DC Seasonings DC
Indianapolis Store - Spicy Cube Ft Wayne Store - Spicy Cube Chicago Store - Spicy Cube Columbus Store - Spicy Cube
230 780 200 30
230 780 210 40
230 780 220 50
230 780 230 60
230 760 240 30
230 760 250 40
230 760 260 50
230 760 270 60
230 740 170 30
230 740 180 40
230 740 190 50
230 740 200 60
230 720 210 30
230 720 220 40
300 720 230 50
300 720 240 60
300 700 250 30
300 700 260 40
300 700 270 50
300 700 170 60
300 700 180 30
300 680 190 40
300 680 200 50
300 680 210 60
300 680 220 30
300 660 230 40
300 660 240 50
300 660 250 60
300 660 260 70
300 640 160 40
300 640 170 50
Indianapolis Store - Spicy Cube Ft Wayne Store - Spicy Cube Chicago Store - Spicy Cube Columbus Store - Spicy Cube
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30
70 20 100 30

Indianapolis Store - Spicy Cube Ft Wayne Store - Spicy Cube Chicago Store - Spicy Cube Columbus Store - Spicy Cube
 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

Indianapolis Store - Spicy Cube Ft Wayne Store - Spicy Cube Chicago Store - Spicy Cube Columbus Store - Spicy Cube
0 0 0 0
 70 20 110 40
140 40 220 80
210 60 330 120
280 60 440 120
350 80 550 160
420 100 660 200
490 120 770 240
560 120 770 240
630 140 880 280
700 160 990 320
770 180 1100 360
840 180 1210 360
910 200 1320 400
1050 220 1430 440
1120 240 1540 480
1190 240 1650 480
1260 260 1760 520
1330 280 1870 560
1400 300 1870 600
1470 320 1980 600
1540 320 2090 640
1610 340 2200 680
1680 360 2310 720
1750 380 2420 720
1820 380 2530 760
1890 400 2640 800
1960 420 2750 840
2030 440 2860 880
2100 440 2860 880
2170 460 2970 920

Indianapolis Store - Spicy Cube Ft Wayne Store - Spicy Cube Chicago Store - Spicy Cube Columbus Store - Spicy Cube
70 20 100 30
140 40 200 60
 210 60 300 90
280 80 400 120
350 100 500 150
420 120 600 180
490 140 700 210
560 160 800 240
630 180 900 270
700 200 1000 300
770 220 1100 330
840 240 1200 360
910 260 1300 390
980 280 1400 420
1050 300 1500 450
1120 320 1600 480
1190 340 1700 510
1260 360 1800 540
1330 380 1900 570
1400 400 2000 600
1470 420 2100 630
1540 440 2200 660
1610 460 2300 690
1680 480 2400 720
1750 500 2500 750
1820 520 2600 780
1890 540 2700 810
1960 560 2800 840
2030 580 2900 870
2100 600 3000 900
2170 620 3100 930

Indianapolis Store Ft Wayne Store Chicago Store Columbus Store

5500 7200 2700 1700
5500 7200 2700 1700
11000 14400 5400 3400
 16500 21600 8100 5100
22000 28800 10800 6800
27500 36000 13500 8500
33000 43200 16200 10200
38500 50400 18900 11900
44000 57600 21600 13600
49500 64800 24300 15300
55000 72000 27000 17000
60500 79200 29700 18700
66000 86400 32400 20400
71500 93600 35100 22100
77000 100800 37800 23800
82500 108000 40500 25500
88000 115200 43200 27200
93500 122400 45900 28900
99000 129600 48600 30600
104500 136800 51300 32300
110000 144000 54000 34000
115500 151200 56700 35700
121000 158400 59400 37400
126500 165600 62100 39100
132000 172800 64800 40800
137500 180000 67500 42500
143000 187200 70200 44200
148500 194400 72900 45900
154000 201600 75600 47600
159500 208800 78300 49300
165000 216000 81000 51000

DC Truck5 Factory Truck 1

19980 10962
29970 16443
Seasonings DC