Cincinnati Seasonings Monthly Earnings and KPIs
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
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" in the submenu and select download format
2
When you download this template to your own computer you can make any changes you wish to your own copy. Please also see notes at bottom of this spreadsheet.
3
4
Cincinnati Seasonings - Monthly Profit & Loss Report plus KPIs
5
6
INCOMETotal Company
Seasonings Factory
Seasonings DCLouisville StoreIndianapolis StoreFt Wayne Store
7
Products Sold (Demand at Stores)
5,8903,1002,170620
8
Retail Markup %30.0030.0030.00
9
Product Sales Price1,3001,3001,300
10
Total Income$7,657,000$4,030,000$2,821,000$806,000
11
12
EXPENSE
13
Cost of Products Sold5,890,0003,100,0002,170,000620,000
14
Facility Storage & Operating Cost
3,276,0001,320,0001,350,000225,000165,000216,000
15
Vehicle Operating Cost43,6469,66633,980
16
Total Expenses 9,209,6461,329,6661,383,9803,325,0002,335,000836,000
17
18
MONTHLY PROFIT OR LOSS
19
Gross Profit -$1,552,646$705,000$486,000-$30,000
20
Gross Profit %-20.28%17.49%17.23%-3.72%
21
22
23
SUPPLY CHAIN PERFORMANCE
Total Company
Seasonings Factory
Seasonings DCLouisville StoreIndianapolis StoreFt Wayne Store
24
**Spicy Cube: Product Price$1,000
25
Beginning Inventory On-Hand6,6509404300400230780
26
Ending Inventory On-Hand11,500286064802005201440
27
Percent Change72.93%204.26%50.70%-50.00%126.09%84.62%
28
Avg On-Hand Inventory Amount
9,1621,8885,4443303831,117
29
Avg On-Hand Inventory Value$9,161,667$1,888,000$5,443,667$330,000$383,000$1,117,000
30
Product Daily Demand1901007020
31
Inventory Days of Supply 48.223.305.4755.85
32
33
34
NOTES:
35
-- There is only so much cost cutting that can be done at Cincinnati Seasonings. Expenses can definitely be reduced, but the company cannot use cost cutting alone to become profitable.
36
The company also needs to increase revenue by opening new stores. It has the infrastructure in place to support a much larger business. See what happens as you add new stores
37
in Chicago, Columbus and elsewhere. First see how much you can reduce expenses in the existing 3-store supply chain. Then add more stores to your supply chain and to this
38
reporting template. How many new stores and how much revenue increase do you need to become profitable? What happens if facility rent costs are reduced by 50% or 75%?
39
40
-- 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 www.cityfeet.com
41
42
-- Expand this spreadsheet template to accomodate new facilities as you add them to your supply chain. See how the cells in this reporting tab read the data in the simulation data tab.
43
Add new columns to this report to read and display the data for new facilities. Add new rows for new products - repeat rows 24 - 31 for each new product. Also add new rows
44
under the Income and Expense sections for data about each new product added.
45
46
-- BUG: Sometimes all the vehicle cost data does not download when you export simulation results to a spreadsheet. At the bottom of the exported simulation data you will see a header
47
titled "Vehicles Cost Report" and below that you see the names of the vehicles used in your simulation. If you do not see all the vehicles listed it means all the vehicle data did not
48
export correctly. You can find this same data displayed on your Simulate screen when you click on the "Vehicles" tab on the right side of the screen. See Bug Report in FAQs for
49
more information on how to fix this problem - http://blog.scmglobe.com/?page_id=274 ).
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
P&L Report and KPIs
Simulation Data
 
 
Main menu