Kellogg's

Sales Budget (Schedule 1)

For the Year Ended December 31, 2022
2022 2023 2024
Expected Sales 10,247,058.82 9,529,764.71 8,862,681.18
Unit Sales Price $2.15 $2.25 $2.32
Total Sales Revenue $22,013,879.00 $21,476,079.94 $20,571,936.97

Schedule of Expected Cash Collections

2022 2023 2024
Accounts receivable $3,126,150.00 $3,049,778.16 $2,921,382.50
Total Cash Collections $3,126,150.00 $3,049,778.16 $2,921,382.50
percentage of sales rev 14% 14% 14%

Kellogg's
Production Budget (Schedule 2)
For the Year Ended December 31, 2022
2022 2023 2024
8% 10% 10% assume the desired ending inv is
Planned Sales 10,247,059 9,529,765 8,862,681
Desired ending inventory* 826,568 952,976.47 886,268.12
Total needs 11,073,627 10,482,741 9,748,949
Less: Beginning inventory 917,388 826,568 952,976.47
Units to be produced 10,156,238 9,656,173 8,795,973

Kellogg's
Direct Materials Budget (Schedule 3)
For the Year Ended December 31, 20B
2022 2023 2024
Units to be produced (Schedule
2) 10,156,238 9,656,173 8,795,973
Material needs per unit (kg)* 0.66 0.66 0.66
Production needs (usage) 6,677,532 6,348,748.23 5,783,183.01
Desired ending inventory of
materials 513,320.29
488,045.81 444,569.25 percentage method
Total Needs 7,190,852 6,836,794 6,227,752
Less: Beginning inventory 587,088 513,320 488,045.81
Materials to be purchased 6,603,764 6,323,474 5,739,706
Unit price* (given data) $0.65 $0.63 $0.61 % method
Purchase cost $4,292,446.67 $4,009,844.33 $3,486,435.61

Schedule of Expected Cash Payments

2022 2023 2024
$3,385,687.00
Accounts payable, 12/31/20A $3,302,974.67 $3,163,919.43
Total Cash Disbursements $3,385,687.00 $3,302,974.67 $3,163,919.43
% of sales rev 15% 15% 15%

Kellogg's
Direct Labor Budget (Schedule 4)
For the Year Ended December 31, 20B
2022 2023 2024
Units to be produced (Schedule
2) 10,156,238 9,656,173 8,795,973
Direct labor hours per unit* X 0.2 X 0.2 X 0.2
Total Hours 1,613,702 1,931,235 1,759,195
Direct labor cost per hour* X $2.66 X $2.66 X $2.66
Total direct labor cost $4,292,446.67 $5,137,084.14 $4,679,457.54

Kellogg's
Factory Overhead Budget (Schedule 5)
For the Year Ended December 31, 20B
2022 2023 2024
Budgeted Direct Labor (Total 1,613,702 1,931,235 1,759,195
Hours - Schedule 4)
Variable Overhead rate X $2.66 2.66 2.66
Variable Overhead budgeted $4,292,446.67 $ 5,137,084.14 $ 4,679,457.54
Fixed overhead budgeted $0.00 $0.00 $0.00
Total budgeted Overhead $4,292,446.67 $ 5,137,084.14 $ 4,679,457.54
Less: Depreciation* $447,934.00 $436,990.97 $418,593.65 % method
Cash disbursements for $3,844,512.67 $ 4,700,093.17 $ 4,260,863.89
Factory overhead

Kellogg's
Ending Inventory Budget (Schedule 6)
2022
Ending Inventory
Units Unit Product Cost
Units (Schedule 2) 826,567.97 $1.25

Unit Cost Units

Direct Materials $0.65 0.28
Direct Labor $2.66 0.2
Factory Overhead $2.66 0.2
Unit Product Cost

Kellogg's
Selling and Administrative Expense Budget (Schedule 7)
For the Year Ended December 31, 20B
2022 2023 2024
Expected sales in units 10,247,059 9,529,765 8,862,681
Variable selling and
administrative expense X $0.59 $0.59 $0.59
per unit*
Budgeted variable expense $6,011,956.00 $5,591,119.08 $5,199,740.74
Fixed selling and
administrative expense**:
Advertising
Insurance
Office salaries
Other Taxes/Fines
Total budgeted selling and $6,011,956.00 $5,865,083.91 $5,618,163.88 apply % method
administrative expenses***

Kellogg's
Cash Budget (Schedule 8)

From Schedule 2022 2023 2024

Beginning Cash Balance 5,808,952 $5,395,954.00 5264130.84378
(+) Add receipts:
Collections from customers 1 $22,013,879.00 $21,476,079.94 $20,571,936.97
Total cash available (a) $27,822,831.00 $26,872,033.94 $25,836,067.81
(-) Less:
Disbursements:
Direct materials 3 $4,292,446.67 $4,009,844.33 $3,486,435.61
Direct Labor 4 $4,292,446.67 $5,137,084.14 $4,679,457.54
Factory Overhead 5 $3,844,512.67 $4,700,093.17 $4,260,863.89
Selling and Admin 7 $6,011,956.00 $5,865,083.91 $5,618,163.88
Income Tax 10 $593,944.00 $579,433.95 $555,039.78
Total disbursements (b) $19,035,306.00 $20,291,539.51 $18,599,960.70
Minimum Cash Balance ASSUMPTIONS
Total Cash needed (c ) $19,035,306.00 $20,291,539.51 $18,599,960.70
Cash Surplus/Deficit (a)-(c) $8,787,525.00 $6,580,494.42 $7,236,107.11
Finance:
Borrowing
Repayment
Interest
Total effect of financing (d) n/a
Cash Balance, ending (a)- $5,395,954.00 $5,264,130.84 $5,042,510.94
(b) + (d)

Kellogg's
Budgeted Income Statement (Schedule 9)
For the Year Ended December 31, 20B
2022 2023 2024
Sales FROM SCHEDULE $22,013,879.00 $21,476,079.94 $20,571,936.97
(-) COGS
 Beginning finished goods
inventory 10 $1,029,903.69 $ 1,183,171.50 $ 1,093,724.63
(+) COGS Manufactured (6100
units x $82) 6 $12,877,340.00 $12,562,746.58 $12,033,854.95
Cost of goods available for sale $13,907,243.69 $13,745,918.08 $13,127,579.58
(-) Ending finished goods
inventory 6 $1,029,903.69 $1,183,171.50 $1,093,724.63
TOTAL COGS $12,877,340.00 $12,562,746.58 $12,033,854.95
Gross margin $9,136,539.00 $8,913,333.35 $8,538,082.02
(-) Selling and administrative
expense 7 $6,011,956.00 $5,865,083.91 $5,618,163.88
Operating income $3,124,583.00 $3,048,249.44 $2,919,918.14
(-) Interest expense 8 -$1,068,819.00 -$1,042,707.75 -$998,809.76
Net income before taxes $2,055,764.00 $2,005,541.69 $1,921,108.38
(-) Income taxes $593,944.00 $579,433.95 $555,039.78
Net income after taxes $1,461,820.00 $1,426,107.74 $1,366,068.60

Kellogg's
Balance Sheet (Schedule 11)
2022
ASSETS
SCHEDULE
Cash $5,395,954.00
Acc Receivable 1 $3,126,150.00
Material Inventory 3 $333,658.19
Finished Goods Inventory 6 $1,029,903.69
TOTAL CURRENT ASSETS $9,885,665.88
Plant & Equipment:
Land 10 $3,748,007.00
Buildings and Equipment 8 &10 $3,748,007.00
Accumulated Depreciation 5 &10 $447,934.00
Plant and equipment, net $7,943,948.00
TOTAL ASSETS $17,829,613.88
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,385,687.00
Income tax payable 9 $593,944.00
TOTAL CURRENT LIABILITIES $3,979,631.00
Stockholders’ equity:
Common stock, no par 10 $3,960,000.00
Retained earnings 8, 9 &10 $10,595,594.00
TOTAL STOCKHOLDER'S EQUITY $14,555,594.00
Total liabilities and
$18,535,225.00
stockholders’ equity
 Breakfast cereal prices have witnessed a significant rise in 2023, the re
materials. Many prominent cereal brands, including Chocapic, Froot Lo
susceptible to global price fluctuations.
+ costs (IVA)

increase based on Euromonitor forecast Price go up then UP

#VALUE! 4.9% increase form 2022 - 2023 according to world cereal price index, t
Sales go down then down
Price rises lead consumers to reach for more affordable options

assume percentage method

25%

$0.27
$0.34
e the desired ending inv is 10% $0.07

kellogg's 26.8% m 13,000 tons of products sold by a

grams 3,484,000,000 3484

340
10,247,058.82 units sold

how many grains of rice

381,607 587,087.69
not possibel to do with data avia
ntage method 7.69%
workaorund to assume the cost w

0.000002953% https://markets.businessinsider.com/commodities/wheat-price

0.4178 USD/kg
https://ycharts.com/indicators/world_sugar_price

assume percentage method

 * Given data cogs -12877340
raw materials (4,292,446.67)
direct labor (4,292,446.67)
overhead
(4,292,446.67)

(workaround done)

hard to estimate

2.03%

2023
Ending Inventory
Total Units Unit Product Cost
$1,029,903.69 Units (Schedule 2) 952,976.47 $1.24

Total Unit Cost

$0.18 Direct Materials $0.63
$0.53 Direct Labor $2.66
$0.53 Factory Overhead $2.66
$1.25 Unit Product Cost
 27%

% method 2.70%

%method
24.51%
 % method
58%

% method -5%

% method 2.70%

Kellogg's
Balance Sheet (Schedule 11)
2023
ASSETS
SCHEDULE
Cash $5,264,130.84
Acc Receivable 1 $3,049,778.16
Material Inventory 3 $309,479.85
Finished Goods Inventory 6 $1,183,171.50
TOTAL CURRENT ASSETS $9,806,560.35
Plant & Equipment:
Land 10 $3,656,443.19 % method 17%
Buildings and Equipment 8 &10 $3,656,443.19
Accumulated Depreciation 5 &10 $436,990.97
Plant and equipment, net $7,749,877.35
TOTAL ASSETS $17,556,437.70
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,302,974.67
Income tax payable 9 $579,433.95
TOTAL CURRENT LIABILITIES $3,882,408.61
Stockholders’ equity:
Common stock, no par 10 $3,863,257.20 % method 17.99%
Retained earnings 8, 9 &10 $10,336,743.64 % method 48%
TOTAL STOCKHOLDER'S EQUITY $14,200,000.84
Total liabilities and
$18,082,409.45
stockholders’ equity
gnificant rise in 2023, the result of the ongoing inflations and the rising costs of raw
ncluding Chocapic, Froot Loops, Trix, and Zucaritas, are imported, rendering them

to world cereal price index, then iva increase happened (3% increase)

re affordable options

3.7500%

3%

00 tons of products sold by all companiyes

tonns sold by kellogs

grams avg cereal box siz4e

ossibel to do with data avialabe

aorund to assume the cost will be 4 million

dities/wheat-price

dicators/world_sugar_price
 3 2024
ventory Ending Inventory
Unit Product Cost Total Units Unit Product Cost
$1.24 $1,183,171.50 Units (Schedule 2) 886,268.12 $1.23

Units Total
0.28 $0.18 Direct Materials
0.2 $0.53 Direct Labor
0.2 $0.53 Factory Overhead
$1.24 Unit Product Cost
 really close to the emis financial statement

Kellogg's
Balance Sheet (Schedule 11)
2024
ASSETS
SCHEDULE
Cash $5,042,510.94
Acc Receivable 1 $2,921,382.50
Material Inventory 3 $270,042.04
Finished Goods Inventory 6 $1,093,724.63
TOTAL CURRENT ASSETS $9,327,660.11
Plant & Equipment:
Land 10 $3,502,506.93
Buildings and Equipment 8 &10 $3,502,506.93
Accumulated Depreciation 5 &10 $418,593.65
Plant and equipment, net $7,423,607.51
TOTAL ASSETS $16,751,267.62
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,163,919.43
Income tax payable 9 $555,039.78
TOTAL CURRENT LIABILITIES $3,718,959.21
Stockholders’ equity:
Common stock, no par 10 $3,700,614.07
Retained earnings 8, 9 &10 $9,901,566.73
TOTAL STOCKHOLDER'S EQUITY $13,602,180.80
Total liabilities and
$17,321,140.02
stockholders’ equity
 2024
ding Inventory
Unit Product Cost Total
$1.23 $1,093,724.63

Unit Cost Units Total

$0.61 0.28 $0.17
$2.66 0.2 $0.53
$2.66 0.2 $0.53
Product Cost $1.23
 Kellogg's
Sales Budget (Schedule 1)
For the Year Ended December 31, 2022
2022 2023 2024
Expected Sales 10,247,058.82 10,759,411.76 11,297,382.35
Unit Sales Price $2.15 $2.15 $2.15
Total Sales Revenue $22,013,879.00 $23,114,572.95 $24,270,301.60

Schedule of Expected Cash Collections

2022 2023 2024
Accounts receivable $3,126,150.00 $3,282,457.50 $3,446,580.38
Total Cash Collections $3,126,150.00 $3,282,457.50 $3,446,580.38
percentage of sales rev 14%

Kellogg's
Production Budget (Schedule 2)
For the Year Ended December 31, 2022
2022 2023 2024
8% 10% 10% assume the desired ending inv is
Planned Sales 10,247,059 10,759,412 11,297,382
Desired ending inventory* 826,568 1,075,941.18 1,129,738.24
Total needs 11,073,627 11,835,353 12,427,121
Less: Beginning inventory 917,388 826,568 1,075,941.18
Units to be produced 10,156,238 11,008,785 11,351,179

Kellogg's
Direct Materials Budget (Schedule 3)
For the Year Ended December 31, 20B
2022 2023 2024
Units to be produced (Schedule
2) 10,156,238 11,008,785 11,351,179
Material needs per unit (lbs)* X0.65 X 0.65 X0.65
Production needs (usage) 6,645,943 7,203,823.84 7,427,876.65
Desired ending inventory of
materials 544,909
590,650.62 609,021.00 percentage method
Total Needs 7,190,852 7,794,474 8,036,898
Less: Beginning inventory 587,088 544,909 590,650.62
Materials to be purchased 6,603,764 7,249,565 7,446,247
Unit price* (given data) $0.65 $0.65 $0.65
Purchase cost $4,292,446.67 $4,712,217.40 $4,840,060.57

Schedule of Expected Cash Payments

2022 2023 2024
$3,385,687.00
Accounts payable, 12/31/20A $3,554,971.35 $3,732,719.92
Total Cash Disbursements $3,385,687.00 $3,554,971.35 $3,732,719.92
% of sales rev 15%

Kellogg's
Direct Labor Budget (Schedule 4)
For the Year Ended December 31, 20B
2022 2023 2024
Units to be produced (Schedule
2) 10,156,238 11,008,785 11,351,179
Direct labor hours per unit* X 0.2 X 0.2 X 0.2
Total Hours 1,613,702 2,201,757 2,270,236
Direct labor cost per hour* X $2.66 X $2.66 X $2.66
Total direct labor cost $4,292,446.67 $5,856,673.60 $6,038,827.45

Kellogg's
Factory Overhead Budget (Schedule 5)
For the Year Ended December 31, 20B
2022 2023 2024
Budgeted Direct Labor (Total 1,613,702 2,201,757 2,270,236
Hours - Schedule 4)
Variable Overhead rate X $2.66 2.66 2.66
Variable Overhead budgeted $4,292,446.67 $ 5,856,673.60 $ 6,038,827.45
Fixed overhead budgeted $0.00 $0.00 $0.00
Total budgeted Overhead $4,292,446.67 $ 5,856,673.60 $ 6,038,827.45
Less: Depreciation* $447,934.00 $470,330.70 $493,847.24 % method
Cash disbursements for $3,844,512.67 $ 5,386,342.90 $ 5,544,980.21
Factory overhead

Kellogg's
Ending Inventory Budget (Schedule 6)
2022
Ending Inventory
Units Unit Product Cost
Units (Schedule 2) 826,567.97 $1.25

Unit Cost Units

Direct Materials $0.65 0.28
Direct Labor $2.66 0.2
Factory Overhead $2.66 0.2
Unit Product Cost

Kellogg's
Selling and Administrative Expense Budget (Schedule 7)
For the Year Ended December 31, 20B
2022 2023 2024
Expected sales in units 10,247,059 10,759,412 11,297,382
Variable selling and
administrative expense X $0.59 $0.59 $0.59
per unit*
Budgeted variable expense $6,011,956.00 $6,312,553.80 $6,628,181.49
Fixed selling and
administrative expense**:
Advertising
Insurance
Office salaries
Other Taxes/Fines
Total budgeted selling and $6,011,956.00 $6,312,553.80 $6,628,181.49 apply % method
administrative expenses***

Kellogg's
Cash Budget (Schedule 8)

From Schedule 2022 2023 2024

Beginning Cash Balance 5,808,952 $5,395,954.00 5665751.7
(+) Add receipts:
Collections from customers 1 $22,013,879.00 $23,114,572.95 $24,270,301.60
Total cash available (a) $27,822,831.00 $28,510,526.95 $29,936,053.30
(-) Less:
Disbursements:
Direct materials 3 $4,292,446.67 $4,712,217.40 $4,840,060.57
Direct Labor 4 $4,292,446.67 $5,856,673.60 $6,038,827.45
Factory Overhead 5 $3,844,512.67 $5,386,342.90 $5,544,980.21
Selling and Admin 7 $6,011,956.00 $6,312,553.80 $6,628,181.49
Income Tax 10 $593,944.00 $623,641.20 $654,823.26
Total disbursements (b) $19,035,306.00 $22,891,428.91 $23,706,872.98
Minimum Cash Balance ASSUMPTIONS
Total Cash needed (c ) $19,035,306.00 $22,891,428.91 $23,706,872.98
Cash Surplus/Deficit (a)-(c) $8,787,525.00 $5,619,098.04 $6,229,180.32
Finance:
Borrowing
Repayment
Interest
Total effect of financing (d) n/a
Cash Balance, ending (a)- $5,395,954.00 $5,665,751.70 $5,949,039.29
(b) + (d)

Kellogg's
Budgeted Income Statement (Schedule 9)
For the Year Ended December 31, 20B
2022 2023 2024
Sales FROM SCHEDULE $22,013,879.00 $23,114,572.95 $24,270,301.60
(-) COGS
 Beginning finished goods
inventory 10 $1,029,903.69 $ 1,340,622.71 $ 1,407,653.84
(+) COGS Manufactured (6100
units x $82) 6 $12,877,340.00 $13,521,207.00 $14,197,267.35
Cost of goods available for sale $13,907,243.69 $14,861,829.71 $15,604,921.19
(-) Ending finished goods
inventory 6 $1,029,903.69 $1,340,622.71 $1,407,653.84
TOTAL COGS $12,877,340.00 $13,521,207.00 $14,197,267.35
Gross margin $9,136,539.00 $9,593,365.95 $10,073,034.25
(-) Selling and administrative
expense 7 $6,011,956.00 $6,312,553.80 $6,628,181.49
Operating income $3,124,583.00 $3,280,812.15 $3,444,852.76
(-) Interest expense 8 -$1,068,819.00 -$1,122,259.95 -$1,178,372.95
Net income before taxes $2,055,764.00 $2,158,552.20 $2,266,479.81
(-) Income taxes $593,944.00 $623,641.20 $654,823.26
Net income after taxes $1,461,820.00 $1,534,911.00 $1,611,656.55

Kellogg's
Balance Sheet (Schedule 11)
2022
ASSETS
SCHEDULE
Cash $5,395,954.00
Acc Receivable 1 $3,126,150.00
Material Inventory 3 $354,191.00
Finished Goods Inventory 6 $1,029,903.69
TOTAL CURRENT ASSETS $9,906,198.69
Plant & Equipment:
Land 10 $3,748,007.00
Buildings and Equipment 8 &10 $3,748,007.00
Accumulated Depreciation 5 &10 $447,934.00
Plant and equipment, net $7,943,948.00
TOTAL ASSETS $17,850,146.69
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,385,687.00
Income tax payable 9 $593,944.00
TOTAL CURRENT LIABILITIES $3,979,631.00
Stockholders’ equity:
Common stock, no par 10 $3,960,000.00
Retained earnings 8, 9 &10 $10,595,594.00
TOTAL STOCKHOLDER'S EQUITY $14,555,594.00
Total liabilities and
$18,535,225.00
stockholders’ equity
 Kellog's action toward the community can provide a good reputation to
https://www.forbes.com.ec/advertorial/kellogg-une-iniciativa-vacunac

Also kellogs has a name change, which might attract the attention of ne
https://www.portafolio.co/negocios/empresas/kellogg-s-cambia-de-no

increase based on Euromonitor forecast Good pr = more people wanting to support Kellog's so they can keep
#VALUE!
EXPECTED SALES GO UP
in 2020 their growth increase dby 5% so lets assume thats possibility n

assume percentage method

e the desired ending inv is 10%

kellogs 26.8% mar13,000 tons of products sold by a

grams 3,484,000,000 3484

340
10,247,058.82 units sold

how many grains of rice

381,607 587,087.69
not possibel to do with data avia
ntage method 8.20%
workaorund to assume the cost w

assume percentage method

* Given data cogs -12877340
raw materials (4,292,446.67)
direct labor (4,292,446.67)
overhead
(4,292,446.67)
not possible
workaround done

hard to estimate

2.03%

2023
Ending Inventory
Total Units Unit Product Cost
$1,029,903.69 Units (Schedule 2) 1,075,941.18 $1.25

Total Unit Cost

$0.18 Direct Materials $0.65
$0.53 Direct Labor $2.66
$0.53 Factory Overhead $2.66
$1.25 Unit Product Cost
 27%

% method 2.70%

not enough data (nboit enough costs accounted for) in order to properly

%method
24.51%
 % method
58%

% method -5%

% method 2.70%

Kellogg's
Balance Sheet (Schedule 11)
2023
ASSETS
SCHEDULE
Cash $5,665,751.70
Acc Receivable 1 $3,282,457.50
Material Inventory 3 $383,922.90
Finished Goods Inventory 6 $1,340,622.71
TOTAL CURRENT ASSETS $10,672,754.81
Plant & Equipment:
Land 10 $3,935,407.35 % method 17%
Buildings and Equipment 8 &10 $3,935,407.35
Accumulated Depreciation 5 &10 $470,330.70
Plant and equipment, net $8,341,145.40
TOTAL ASSETS $19,013,900.21
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,554,971.35
Income tax payable 9 $623,641.20
TOTAL CURRENT LIABILITIES $4,178,612.55
Stockholders’ equity:
Common stock, no par 10 $4,158,000.00 % method 17.99%
Retained earnings 8, 9 &10 $11,125,373.70 % method 48%
TOTAL STOCKHOLDER'S EQUITY $15,283,373.70
Total liabilities and
$19,461,986.25
stockholders’ equity
provide a good reputation to the company and thus its productss.
llogg-une-iniciativa-vacunacion-ninos-guayaquil-n12668

ht attract the attention of new coustomers :

esas/kellogg-s-cambia-de-nombre-es-ahora-kellanova-600221

t Kellog's so they can keep doing such good actions

ts assume thats possibility now

00 tons of products sold by all companiyes

tonns sold by kellogs

grams avg cereal box siz4e

ossibel to do with data avialabe

aorund to assume the cost will be 4 million
 3 2024
ventory Ending Inventory
Unit Product Cost Total Units Unit Product Cost
$1.25 $1,340,622.71 Units (Schedule 2) 1,129,738.24 $1.25

Units Total
0.28 $0.18 Direct Materials
0.2 $0.53 Direct Labor
0.2 $0.53 Factory Overhead
$1.25 Unit Product Cost
ted for) in order to properly predict the forecast here
 really close to the emis financial statement

Kellogg's
Balance Sheet (Schedule 11)
2024
ASSETS
SCHEDULE
Cash $5,949,039.29
Acc Receivable 1 $3,446,580.38
Material Inventory 3 $395,863.65
Finished Goods Inventory 6 $1,407,653.84
TOTAL CURRENT ASSETS $11,199,137.15
Plant & Equipment:
Land 10 $4,132,177.72
Buildings and Equipment 8 &10 $4,132,177.72
Accumulated Depreciation 5 &10 $493,847.24
Plant and equipment, net $8,758,202.67
TOTAL ASSETS $19,957,339.82
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,732,719.92
Income tax payable 9 $654,823.26
TOTAL CURRENT LIABILITIES $4,387,543.18
Stockholders’ equity:
Common stock, no par 10 $4,365,900.00
Retained earnings 8, 9 &10 $11,681,642.39
TOTAL STOCKHOLDER'S EQUITY $16,047,542.39
Total liabilities and
$20,435,085.56
stockholders’ equity
 2024
ding Inventory
Unit Product Cost Total
$1.25 $1,407,653.84

Unit Cost Units Total

$0.65 0.28 $0.18
$2.66 0.2 $0.53
$2.66 0.2 $0.53
Product Cost $1.25
 Kellogg's
Sales Budget (Schedule 1)
For the Year Ended December 31, 2022
2022 2023 2024
Expected Sales 10,247,058.82 8,812,470.59 7,578,724.71
Unit Sales Price $2.15 $2.30 $2.46
Total Sales Revenue $22,013,879.00 $20,257,171.46 $18,640,649.17

Schedule of Expected Cash Collections

2022 2023 2024
Accounts receivable $3,126,150.00 $2,876,683.23 $2,647,123.91
Total Cash Collections $3,126,150.00 $2,876,683.23 $2,647,123.91
percentage of sales rev 14%

Kellogg's
Production Budget (Schedule 2)
For the Year Ended December 31, 2022
2022 2023 2024
8% 10% 10% assume the desired ending inv is
Planned Sales 10,247,059 8,812,471 7,578,725
Desired ending inventory* 826,568 881,247.06 757,872.47
Total needs 11,073,627 9,693,718 8,336,597
Less: Beginning inventory 917,388 826,568 881,247.06
Units to be produced 10,156,238 8,867,150 7,455,350

Kellogg's
Direct Materials Budget (Schedule 3)
For the Year Ended December 31, 20B
2022 2023 2024
Units to be produced (Schedule
2) 10,156,238 8,867,150 7,455,350
Material needs per unit (lbs)* X0.65 X 0.65 X0.65
Production needs (usage) 6,645,943 5,802,400.94 4,878,560.99
Desired ending inventory of
materials 544,909
475,746.19 399,999.38 percentage method
Total Needs 7,190,852 6,278,147 5,278,560
Less: Beginning inventory 587,088 544,909 475,746.19
Materials to be purchased 6,603,764 5,733,238 4,802,814
Unit price* (given data) $0.65 $0.65 $0.65
Purchase cost $4,292,446.67 $3,726,604.63 $3,121,829.22

Schedule of Expected Cash Payments

2022 2023 2024
$3,385,687.00
Accounts payable, 12/31/20A $3,115,509.18 $2,866,891.55
Total Cash Disbursements $3,385,687.00 $3,115,509.18 $2,866,891.55
% of sales rev 15%

Kellogg's
Direct Labor Budget (Schedule 4)
For the Year Ended December 31, 20B
2022 2023 2024
Units to be produced (Schedule
2) 10,156,238 8,867,150 7,455,350
Direct labor hours per unit* X 0.2 X 0.2 X 0.2
Total Hours 1,613,702 1,773,430 1,491,070
Direct labor cost per hour* X $2.66 X $2.66 X $2.66
Total direct labor cost $4,292,446.67 $4,717,323.63 $3,966,246.26

Kellogg's
Factory Overhead Budget (Schedule 5)
For the Year Ended December 31, 20B
2022 2023 2024
Budgeted Direct Labor (Total 1,613,702 1,773,430 1,491,070
Hours - Schedule 4)
Variable Overhead rate X $2.66 2.66 2.66
Variable Overhead budgeted $4,292,446.67 $ 4,717,323.63 $ 3,966,246.26
Fixed overhead budgeted $0.00 $0.00 $0.00
Total budgeted Overhead $4,292,446.67 $ 4,717,323.63 $ 3,966,246.26
Less: Depreciation* $447,934.00 $412,188.87 $379,296.20 % method
Cash disbursements for $3,844,512.67 $ 4,305,134.76 $ 3,586,950.07
Factory overhead

Kellogg's
Ending Inventory Budget (Schedule 6)
2022
Ending Inventory
Units Unit Product Cost
Units (Schedule 2) 826,567.97 $1.25

Unit Cost Units

Direct Materials $0.65 0.28
Direct Labor $2.66 0.2
Factory Overhead $2.66 0.2
Unit Product Cost

Kellogg's
Selling and Administrative Expense Budget (Schedule 7)
For the Year Ended December 31, 20B
2022 2023 2024
Expected sales in units 10,247,059 8,812,471 7,578,725
Variable selling and
administrative expense X $0.59 $0.59 $0.59
per unit*
Budgeted variable expense $6,011,956.00 $5,170,282.16 $4,446,442.66
Fixed selling and
administrative expense**:
Advertising
Insurance
Office salaries
Other Taxes/Fines
Total budgeted selling and $6,011,956.00 $5,532,201.91 $5,090,732.20 apply % method
administrative expenses***

Kellogg's
Cash Budget (Schedule 8)

From Schedule 2022 2023 2024

Beginning Cash Balance 5,808,952 $5,395,954.00 4965356.8708
(+) Add receipts:
Collections from customers 1 $22,013,879.00 $20,257,171.46 $18,640,649.17
Total cash available (a) $27,822,831.00 $25,653,125.46 $23,606,006.04
(-) Less:
Disbursements:
Direct materials 3 $4,292,446.67 $3,726,604.63 $3,121,829.22
Direct Labor 4 $4,292,446.67 $4,717,323.63 $3,966,246.26
Factory Overhead 5 $3,844,512.67 $4,305,134.76 $3,586,950.07
Selling and Admin 7 $6,011,956.00 $5,532,201.91 $5,090,732.20
Income Tax 10 $593,944.00 $546,547.27 $502,932.80
Total disbursements (b) $19,035,306.00 $18,827,812.20 $16,268,690.55
Minimum Cash Balance ASSUMPTIONS
Total Cash needed (c ) $19,035,306.00 $18,827,812.20 $16,268,690.55
Cash Surplus/Deficit (a)-(c) $8,787,525.00 $6,825,313.26 $7,337,315.50
Finance:
Borrowing
Repayment
Interest
Total effect of financing (d) n/a
Cash Balance, ending (a)- $5,395,954.00 $4,965,356.87 $4,569,121.39
(b) + (d)

Kellogg's
Budgeted Income Statement (Schedule 9)
For the Year Ended December 31, 20B
2022 2023 2024
Sales FROM SCHEDULE $22,013,879.00 $20,257,171.46 $18,640,649.17
(-) COGS
 Beginning finished goods
inventory 10 $1,029,903.69 $ 1,098,033.84 $ 944,309.10
(+) COGS Manufactured (6100
units x $82) 6 $12,877,340.00 $11,849,728.27 $10,904,119.95
Cost of goods available for sale $13,907,243.69 $12,947,762.10 $11,848,429.05
(-) Ending finished goods
inventory 6 $1,029,903.69 $1,098,033.84 $944,309.10
TOTAL COGS $12,877,340.00 $11,849,728.27 $10,904,119.95
Gross margin $9,136,539.00 $8,407,443.19 $7,736,529.22
(-) Selling and administrative
expense 7 $6,011,956.00 $5,532,201.91 $5,090,732.20
Operating income $3,124,583.00 $2,875,241.28 $2,645,797.02
(-) Interest expense 8 -$1,068,819.00 -$983,527.24 -$905,041.77
Net income before taxes $2,055,764.00 $1,891,714.03 $1,740,755.25
(-) Income taxes $593,944.00 $546,547.27 $502,932.80
Net income after taxes $1,461,820.00 $1,345,166.76 $1,237,822.46

Kellogg's
Balance Sheet (Schedule 11)
2022
ASSETS
SCHEDULE
Cash $5,395,954.00
Acc Receivable 1 $3,126,150.00
Material Inventory 3 $354,191.00
Finished Goods Inventory 6 $1,029,903.69
TOTAL CURRENT ASSETS $9,906,198.69
Plant & Equipment:
Land 10 $3,748,007.00
Buildings and Equipment 8 &10 $3,748,007.00
Accumulated Depreciation 5 &10 $447,934.00
Plant and equipment, net $7,943,948.00
TOTAL ASSETS $17,850,146.69
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,385,687.00
Income tax payable 9 $593,944.00
TOTAL CURRENT LIABILITIES $3,979,631.00
Stockholders’ equity:
Common stock, no par 10 $3,960,000.00
Retained earnings 8, 9 &10 $10,595,594.00
TOTAL STOCKHOLDER'S EQUITY $14,555,594.00
Total liabilities and
$18,535,225.00
stockholders’ equity
 Breakfast cereal prices have witnessed a significant rise in 2023, https:/
internacionales-cereales-suben-tensiones-geopoliticas-197743.html
now it could be worse so lets assume the worst

Price go up then up
7% price growth
Sales go down then worse

lose clients by 14%

assume percentage method

e the desired ending inv is 10%

kellogs 26.8% mar13,000 tons of products sold by a

grams 3,484,000,000 3484

340
10,247,058.82 units sold

how many grains of rice

381,607 587,087.69

ntage method 8.20%

assume percentage method

 workaorund to assume the cost w

* Given data cogs -12877340

raw materials (4,292,446.67)
direct labor (4,292,446.67)
overhead
(4,292,446.67)
not possible
workaround done

hard to estimate

2.03%

2023
Ending Inventory
Total Units Unit Product Cost
$1,029,903.69 Units (Schedule 2) 881,247.06 $1.25

Total Unit Cost

$0.18 Direct Materials $0.65
$0.53 Direct Labor $2.66
$0.53 Factory Overhead $2.66
$1.25 Unit Product Cost
 27%

% method 2.70%

%method
24.51%
 % method
58%

% method -5%

% method 2.70%

Kellogg's
Balance Sheet (Schedule 11)
2023
ASSETS
SCHEDULE
Cash $4,965,356.87
Acc Receivable 1 $2,876,683.23
Material Inventory 3 $309,235.02
Finished Goods Inventory 6 $1,098,033.84
TOTAL CURRENT ASSETS $9,249,308.96
Plant & Equipment:
Land 10 $3,448,916.04 % method 17%
Buildings and Equipment 8 &10 $3,448,916.04
Accumulated Depreciation 5 &10 $412,188.87
Plant and equipment, net $7,310,020.95
TOTAL ASSETS $16,559,329.91
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $3,115,509.18
Income tax payable 9 $546,547.27
TOTAL CURRENT LIABILITIES $3,662,056.45
Stockholders’ equity:
Common stock, no par 10 $3,643,992.00 % method 17.99%
Retained earnings 8, 9 &10 $9,750,065.60 % method 48%
TOTAL STOCKHOLDER'S EQUITY $13,394,057.60
Total liabilities and
$17,056,114.05
stockholders’ equity
gnificant rise in 2023, https://www.expreso.ec/actualidad/economia/precios-
geopoliticas-197743.html
worst

00 tons of products sold by all companiyes

tonns sold by kellogs

grams avg cereal box siz4e
aorund to assume the cost will be 4 million

3 2024
ventory Ending Inventory
Unit Product Cost Total Units Unit Product Cost
$1.25 $1,098,033.84 Units (Schedule 2) 757,872.47 $1.25

Units Total
0.28 $0.18 Direct Materials
0.2 $0.53 Direct Labor
0.2 $0.53 Factory Overhead
$1.25 Unit Product Cost
 really close to the emis financial statement

Kellogg's
Balance Sheet (Schedule 11)
2024
ASSETS
SCHEDULE
Cash $4,569,121.39
Acc Receivable 1 $2,647,123.91
Material Inventory 3 $259,999.60
Finished Goods Inventory 6 $944,309.10
TOTAL CURRENT ASSETS $8,420,554.00
Plant & Equipment:
Land 10 $3,173,692.54
Buildings and Equipment 8 &10 $3,173,692.54
Accumulated Depreciation 5 &10 $379,296.20
Plant and equipment, net $6,726,681.28
TOTAL ASSETS $15,147,235.28
LIABILITIES and Stockholders’ Equity
Current liabilities
Accounts payable (raw
materials) 3 &10 $2,866,891.55
Income tax payable 9 $502,932.80
TOTAL CURRENT LIABILITIES $3,369,824.34
Stockholders’ equity:
Common stock, no par 10 $3,353,201.44
Retained earnings 8, 9 &10 $8,972,010.36
TOTAL STOCKHOLDER'S EQUITY $12,325,211.80
Total liabilities and
$15,695,036.14
stockholders’ equity
 2024
ding Inventory
Unit Product Cost Total
$1.25 $944,309.10

Unit Cost Units Total

$0.65 0.28 $0.18
$2.66 0.2 $0.53
$2.66 0.2 $0.53
Product Cost $1.25
Kellogg Ecuador C. Ltda Ecuakellogg (Ecuador)
Source:

Statement type Annual, Individual Annual, Individual

Period end date 2022-12-31 2021-12-31
Units -7% -2%
8,805,551.60 9,508,627.20
2.5 2.5
Income Statement 2022 2021
Total operating revenue 22,013,879 23,771,568
Net sales revenue 22,013,879 23,771,369
Export sales revenue 0.00
Domestic sales revenue 23,771,369
Cost of goods sold -12,877,340 -11,100,520
Gross profit 9,136,539 12,670,849
Selling and distribution expenses -3,364,904 0.00
Administrative expenses -2,647,052 -5,126,508
Depreciation, amortization and impairment charges -447,934
Net other operating result 0.00 -3,458,698
Other operating income 0.00 199.60
Other operating expenses -3,458,898
Operating profit (EBIT) 3,124,583 3,637,708
EBITDA 3,833,229 4,085,643
Financial result 0.00 25,795
Finance income 43,596
Interest income 0.00 43,596
Finance Expenses 0.00 -17,801
Other financial expenses 0.00 -17,801
Net - other non-operating result -706,037 0.00
Extraordinary Non-operating items -362,782 0.00
Profit before income tax 2,055,764 3,663,503
Income tax -593,944 -918,132
Profit after income tax 0.00 2,745,372
Other Extraordinary Items 0.00 -549,525
Net Profit (Loss) for the Period 1,461,820 2,212,737
Other comprehensive result for the period, net of tax 23,733
Comprehensive income 1,485,553

Balance Sheet 2022 2021

Total assets 20,818,953 19,430,939
 Non-current assets 7,499,312 7,963,029
Property, plant and equipment 7,496,014 7,507,681
Land and buildings 2,785,885
Vehicles and machinery 7,219,856
Fixtures and fittings 1,637,567
Other property, plant and equipment -4,135,627
Construction in progress 326,005
Trademarks and licenses 0.00
Other intangible assets 0.00
Deferred assets 0.00 126,045
Non-current deferred tax assets 0.00 126,045
Other non-current assets 3,298 3,298
Current assets 13,319,641 11,467,910
Inventories 2,284,297
Raw materials 381,607
Work in progress 4,806
Finished goods 1,515,692
Other inventories 382,192
Trade and other receivables 260,946 3,126,150
Current trade receivables 0.00 2,813,971
Other current receivables 0.00 35,295
Tax receivables 260,946 276,885
Prepayments, accrued income and other deferred current assets 318,963 248,510
Cash and Cash Equivalents 5,395,954 5,808,952
Total equity and liabilities 20,818,953 19,430,939
Total equity 14,642,573 13,157,019
Equity attributable to owners of the parent 14,642,573 13,157,019
Issued capital 3,300,000 3,300,000
Other reserves 660,000 1,779,780
Retained earnings 9,133,774 2,484,801
Profit or loss for the period 1,461,820 2,212,737
Other components of equity 86,979 332,067
Total liabilities 6,176,380 6,273,920
Non-current liabilities 290,259 562,828
Deferred revenue, accrued expenses and other deferred non-current liabilities36,848 336,085
Provisions for other liabilities and charges 253,411 226,743
Current liabilities 5,886,121 5,711,091
Trade and other payables 3,861,602 3,385,687
Current trade payables 2,558,324 2,948,836
Other current payables 1,303,278 436,851
Provisions for other liabilities and charges 1,414,927 1,844,181
Other current liabilities 287,227 0.00
Current income tax liabilities 322,365 481,223

Cash Flow Statement 2022 2021

Net cash flow from (used in) operating activities -17,735 3,510,780
Cash generated from operations -17,735
 Adjustments for: Depreciation and impairment of property, plant and equipment708,646
Changes in: Other changes -726,381
Net cash flow from (used in) investing activities -395,263 -587,397
Net cash flow from (used in) financing activities 0.00 0.00
Net increase (decrease) in cash and cash equivalents -412,998 2,923,384
Cash at the beginning of the period 5,808,952 2,885,568
Cash at the end of the period 5,395,954 5,808,952

Statement type Annual, Individual Annual, Individual

Begin date of reporting period 2022-01-01 2021-01-01
Period end date 2022-12-31 2021-12-31
Original Units as Reported 1 USD 1 USD
Audited Audited Audited
Source Supercias - FS Supercias - FS

Any redistribution of this information is strictly prohibited.

Copyright © 2024 EMIS, all rights reserved.
 EMIS
12TH FLOOR 30 CROWN PLACE
London, EC2A 4EB, United Kingdom
www.emis.com

Annual, Individual Annual, Individual Annual, Individual

2020-12-31 2019-12-31 2018-12-31
5% 1% #DIV/0! -9%
9,701,448.80 9,210,326.80 9,110,620.80
2.5 2.5 2.5
2020 2019 2018
24,253,622 23,025,817 22,776,552
24,251,657 23,015,360 22,770,274
0.00 39,320 117,961
24,251,657 22,976,040 22,652,312
-11,245,207 -11,551,414 -11,359,027
13,006,450 11,463,946 11,411,246
0.00 0.00 0.00
-4,697,743 -4,500,366 -4,324,576
-587,199 -634,658 -668,893
-3,736,565 -3,266,975 -3,381,223
1,965 10,457 6,278
-3,738,531 -3,277,432 -3,387,501
3,984,943 3,061,948 3,036,554
4,572,142 3,696,605 3,705,447
65,552 11,790 -11,988
80,640 28,198 6,165
80,640 28,198 6,165
-15,088 -16,409 -18,153
-15,088 -16,409 -18,153
0.00 0.00 0.00
0.00 0.00 0.00
4,050,495 3,073,738 3,024,566
-1,017,835 -750,108 0.00
3,032,660 2,323,630 3,024,566
-607,574 -461,061 0.00
2,484,800 1,888,990 1,701,299

2020 2019 2018

16,884,147 17,907,824 16,201,760
 7,880,411 8,228,791 8,407,509
7,358,537 7,890,884 7,826,242
2,646,442 2,646,442 2,592,083
6,873,569 7,145,007 6,515,820
1,610,827 1,614,147 1,679,431
-3,772,302 -3,514,712 -2,961,093
392,156 210,230 461,164
0.00 11,833 11,833
0.00 -11,833 -11,833
126,420 124,379 116,805
126,420 124,379 116,805
3,298 3,298 3,298
9,003,736 9,679,033 7,794,251 avg
2,211,226 1,845,962 1,891,132 2,058,154
317,177 426,520 291,460 354,191
212.97 789.56 10,441 4,062
1,386,380 1,097,156 1,170,086 1,292,329
507,456 321,496 419,145 407,572
3,704,493 3,646,931 3,724,316
3,501,945 3,424,001 3,523,901
19,164 13,627 15,879
183,384 209,302 184,536
202,449 151,137 293,643
2,885,568 4,035,004 1,885,159
16,884,147 17,907,824 16,201,760
10,913,380 11,827,764 9,907,227
10,913,380 11,827,764 9,907,227
3,300,000 3,300,000 3,300,000
1,779,780 1,743,879 1,658,814
3,047,636 4,663,871 3,047,637
2,484,800 1,888,990 1,701,299
301,165 231,023 199,477
5,970,767 6,080,061 6,294,532
568,426 634,450 637,020
353,351 411,025 429,872
215,075 223,425 207,148
5,402,341 5,445,610 5,657,513
3,433,523 3,549,867 3,561,433
3,033,081 3,130,579 3,206,023
400,442 419,288 355,410
1,732,085 1,397,559 1,497,375
0.00 0.00 0.00
236,733 498,184 598,705

2020 2019 2018

2,960,297 2,629,095 2,911,887
 -640,408 -479,251 -493,626
-3,469,325 0.00 -2,422,937
-1,149,436 2,149,844 -4,676
0.00 1,885,160 0.00
-1,149,436 4,035,004 -4,676

Annual, Individual Annual, Individual Annual, Individual

2020-01-01 2019-01-01 2018-01-01
2020-12-31 2019-12-31 2018-12-31
1 USD 1 USD 1 USD
Audited Audited Audited
Supercias - FS Supercias - FS Supercias - FS
-5%