Copy of Cincinnati Seasonings Earnings and KPIs - Month 1
 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 "File" in top left corner of this screen. Then click "Download as" in the submenu and select download format
2
3
Cincinnati Seasonings - Business and Supply Chain Performance - Month 1
4
5
INCOMETotal Company
Seasonings Factory
Seasonings DCLouisville StoreIndianapolis StoreFt Wayne Store
6
Products Sold (Demand at Stores)
5,8903,1002,170620
7
Retail Markup %30.0030.0030.00
8
Product Sales Price1,3001,3001,300
9
Total Income$7,657,000$4,030,000$2,821,000$806,000
10
11
EXPENSE
12
Product Price (Cost)1,0001,0001,0001,0001,0001,000
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
Beginning Inventory On-Hand6,6509404300400230780
25
Ending Inventory On-Hand11,500286064802005201440
26
Percent Change72.93%204.26%50.70%-50.00%126.09%84.62%
27
Avg On-Hand Inventory Amount9,1621,8885,4443303831,117
28
Avg On-Hand Inventory Value$9,161,667$1,888,000$5,443,667$330,000$383,000$1,117,000
29
Product Daily Demand1901007020
30
Inventory Days of Supply 48.223.305.4755.85
31
32
33
NOTES:
34
-- This template can be expanded as needed to add new facilities and products so it will work with any other case study or supply chain model.
35
Look at the spreadsheet report template and see how the reporting tab reads the data in the simulation data tab. Expand this reporting logic as needed to cover additional
36
facilities and products you may add to your supply chain model. See documentation for the spreadsheet you are using if you need additional information on how to
37
add new columns and expand the reporting logic in your spreadsheet template.
38
39
-- Sometimes all the vehicle cost data does not download when you export your simulation results to a spreadsheet. At the bottom of the exported simulation data you will see a header titled
40
"Vehicles Cost Report" and below that you see the names of the vehicles used in your simulation. If you do not see all of the vehicles listed it means all the vehicle data did not
41
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. Copy that data and type it into the
42
spreadsheet in the columns where that data should be if all the data had exported correctly.
43
44
45
46
47
48
49
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