• Author / Uploaded
• jtang512

Citation preview

PLAY TIME COMPANY

SCHEDULE OF INVENTORY 1991 (A) Month January February March April May June July August September October November December

+

(B)

‐

(C)

=

(D)

Beginning Balance

Cost of Finished Goods Completed (a)

Cost of Goods sold (b)

Ending Balance

$530                 948              1,355              1,749              2,157              2,564              2,971              3,365              2,904              2,314              1,549                 697

$489                       489                       489                       489                       489                       489                       489                       489                       489                       489                       489                       489 $5,865

$70                      82                      94                      81                      81                      81                      94                    950                1,079                1,254                1,340                    656 $5,865

$948           1,355           1,749           2,157           2,564           2,971           3,365           2,904           2,314           1,549               697               530

Notes:     (a)  Total Cost of Good Sold under level production divided into 12 months.     (b)  Monthly COGS at 65.1667% of sales, reflecting the $435,000 labor savings

~ ~

~ e:

o

~'"

tt

~

Cl

:e

~

.. ¡:

"l ~i: (I

~. 0

a o ... ~

So ;i

~ r

Cl r¡

i: ...

~ g

a a J=h ~.

i: Q.

l: i:

~ a

~. (' 'i~

o ~

o I: "l-

(' Cl

(I Q.

go §

~ i: "". _. '" ~i: (I .. Q.

~ l: ..§ ¡: ~

¡:š 0

~. ~ 5i ;' ~~ .. '"

r¡ 0

r¡ ..

... (I

~ i:

CD Q.

~ (I ~ O"

-

gr¡

~ ~

~ b o iit: S' o ~ ~

§

b" 'k a-

Q.

i:

l:

S. ~

~ ~ii(I r¡ Cl (t en r¡

l:

"l

a

-o ~

i:

Q.

Cl

.:

o

i: ..

(I

g å i: 0 g; ~ '! ~

: ~ a 0

o o

9o .. t:

"" 0

o I:

o a

CD .:

;ì ~

Cl

.. ~o ~"l ~. ti ;; i:r¡ ~ 0.. (t .. ~i: l:I:.. a;; "l Cl :æ. i:

.: Cl ci 0"

g. IQ. i:

r¡

~ (I l:

.. r¡

i i:' ... ei

:: "l

r¡ l:

e: s:

E- ~

Cl Q. ..~ ~ (I b~

~ i ~ = i: S" g;

~ 0

s' a

g. go

tt i:

Cl CD

g; S"

~ o Cl .. Q.

(I

ii S' ~ .. r¡ ~ r¡ g, ..i: ä ~ ~

al:

CD

t5

(I

'i

l: r¡ l:

i:

¡D a.

à g

t: !a ëó pe CD CD r¡ .. ..

Cl

Q. I: l:ti S' ~ 8. ~ g i: 0...- c:~~ 0Q... Q. ~ti ..~ ~ i: .. ti .,. ii I= i:~ .. ~ s. o ... CD s- g; o

O" ~ i- ~~ i:.~ ~ g; ~i: Cl "l ~ ~ Ì= 'i Q. ~ a (I "l Cl (I (I

~ ~ s....

c: '- '-n

¡J

..~ (I

i+

I'

oi:

o m

oI'

..

i+

o~

$.

I'

oI;

i: o

o~

o I;

o~

o '-o

I'

o..

'-

o,-Io '-I; ,oI' oH:

'-~

o,-I"

'-m

o,-~

'-~

~~

'-

o,-Io~

:: ~ ,'-i:

o

l"

"C

CD

~

2:

~

l. ~ c:

H:

c:

..~

I-

~ l.

I-

l. ~

1=

oH:

I-

'-~

c:

"'

'-¡;

,c:

'-¡;

,i;

'-~

"'c:

'-~

,-H:

i; '-I-

"'

'-¡;

,i:

~

~

CD

S

o

~ ~ ('

l"

CD

p,

CD

.... ~

~ o

I-

l. m

01

..m

i+

..ao

ei

..

I; o

'-~

c:

,I" 01 '-.. ,I'

'-~

Oi

"'I-

i: '-i+

"'I-

'-

H: Oi

,-Ii: '-o ,I'

'-

i: H:

"'I-

~ CD r;

CD

Oi m I; i:

~ 1-

l. I;

I- c: ~ ~ o 0

I' .. ~ I- I'..

I- m ~ c: .. I"

~ ~ ao m

o 0 I' ao

~ 01

~ 01 o I; I-

S H:

Nl ~

~

I" ~ ~ ~

~ ~

I- ~

I' i: ~ m I-

~ H: $.

I" H:

~ ao

I- ei

~

(I

CD

IJ

i:

CD

"0

t: ~ ~

~ 0

~ l" ..

CD

0-

~ (I l: IJ 0: ::

o ~

"t 0

i: ~

I;

I=

Fd

o

~ ~

m

o ~ I-

~ o a.

i: 0

~

r

CD

1.

2: ~

:t

o('

¡+

I'

CD

CI

~ ~

~

CD

§

E

~:s

01 * ~ òo m 0b

m

i: mb 0

~o~ c: b.. * m I"

I' *Nl

~c: ~ ~ i+ 01

I' ~ .. ~ i: i: I' I'* b ~

00

o 01

* ~ I01 ~

$. i+ 01

* ~ I-

i:

o 00 I' I' Nl

c:

I' Nl

00 o I'

Oi

o 00 I' ~I'

i:

$. i+

~

I'

* 00 INl Nl

~

i:

o 0 00

.. 1=

e

o

00

i: ,-

i: IJ

o o

C' ~

~ æ.

~ 00

IJ ..

ö Z I; CD

): ..

oC cn -I o Z

'" JJ

r'

m -= m

r' -(

JJ Z

C '1 m ):

OZ 0 O.. .. o c ('0 -(J zs:

': m ..

~ m :s .. š: m

.. .. ::

en i .. ):

m '1

s:

o

zn

):

s:

o ." o::

::

'i

PLAY TIME TOY COMPANY

CASH BUDGET UNDER LEVEL PRODUCTION 1991 ($ OOOs)

Jan.

Feb.

Mar.

Apr.

May

June

July

Aug.

Sept.

$1,778

$850

$108

$126

$145

$125

$125

$125

$145

255

225 0

225 80

225

225

225

225

225

0

0

0

225 32

225

31

225 31

0

0

225 32

0

0 197

0 199

25

0

20Jl

0 198

25 190

264

264

264

264

0 195 264

0 191

264

203 264

0 201

264

264

Oct.

Nov.

Dec.

Cash Inflows:

ColIection of AI

$1,458 $1,655 $1,925

Cash Outflows:

Payment of Al Tax Payments

0

Repayment of

Operating Expenses

0 192

Wages

264

194 264

0 196 264

Total

$711

$683

$764

$717

$688

$746

$691

$689

$719

$683

$680

$736

Net Inflow (Outflow)

1,067 175

167 562

(656) 730

(591) 175

(543) 175

(621) 175

(566) 175

(564) 175

(574) 175

775 175

975 175

1,189 175

1,242

730

73

(416)

(368)

(446)

(391)

(389)

(399)

950

1,150

1,364

175

175

175

175

175

175

175

175

175

175

175

175

-680 0 $562

0 0 $730

102 102

591 693 $175

543 1,236 $175

621 1,856 $175

566 2,423 $175

564 2,987 $175

574 3,561 $175

(775) 2,786 $175

(975) 1,811

(1,189) 622 $175

Long-term debt

Beginning Cash Ending Cash before any Loan Incr. Deer.

Desired Cash Balance Loan (Repayment)

Increase End-of-month Loan

End-of-month Cash

$175

$175

_W__N ..NQv~90 Dec~90 Jåi~9fNteb~9rMar~91A.2ra91Maya9I;.~~:~~~iil~9i Au.ga~ÜSepa91 Octa91 Nova91 Dec-91

MQllthly

Sales $1.,778 $850 $108 $126 $145 $125 $125 $125 $145 $1,458 $1,655 $1,925 $2,057 $1,006

AI Ending Balance (a)

$2,628 $958 $234 $271 $270 $250 $250 $270 $1,603 $3,113 $3,580 $3,982 $3,063

Cash

Infows

$1,778 $850 $108 $126 $145 $125 $125 $125 $145 $1,458 $1,655 $1,925

Notes:

(a) Assumed a 60aday collection period.

PLAY TIME TOY COMPANY

CASH BUDGET UNDER LEVEL PRODUCTION 1991 ($ OOOs)

June

July

Jan.

Feb.

Mar.

($102)

($99)

($96)

(Inc.) Deer. AI

1,670

724

(37)

1

20

0

(20)

(Ine.)Deer. Inventory

(418)

(407)

(394)

(407)

(407)

(407)

(394)

461

Inc. (Deer.) NP

(30)

0

0

0

0

0

0

Inc. (Deer.) Accr. Tax

(53)

(51)

(129)

(83)

(53)

(84)

Inc. (Deer.) L-T Debt

0

0

0

0

0

(25)

Net

Income

Net Inc. (Deer) in Cash $1,067 $167

Apr.

May

Aug.

Sept.

Oct.

Nov.

Dec.

$203

$250

$314

$347

$106

(467)

(402)

919

590

766

852

167

0

0

0

0

0

(52)

104

97

162

179

22

0

0

0

0

0

(25)

($564)

($574)

$775

$975

$1,189

175

175

175

175

175

($399)

$950

175 574 3,561 $175

175 (775) 2,786

($102) ($103) ($104) ($100)

($656) ($591) ($543) ($621) ($566)

(1,333) (1,510)

175 562 Beginning Cash Ending Cash before any Loan Inc. or Rep. $1,242 $730

730 $73

($416) ($368) ($446) ($391) ($389)

Desired Cash Balance

175 0 0

175 102 102

$730

$175

175 591 693 $175

175

Loan (Repayment) Inc. (680) 0 End of Month Loan Month Cash . $562

End of

175

175

175 543 1,236 $175

175

175

175 621 1,856

175 566 2,423

$175

$175

175 564 2,987 $175

$175

$1,150 $1,364

175 (975) 1,811 $175

175 (1,189) 622 $175

PLAY TIME TOY COMPANY

PRO FORMA BALANCE SHEET UNDER LEVEL PRODUCTION 1991 ($ OOOs)

Actual Assets Cash Accounts Receivable (a

Inventory (b) Current Assets

Net Plant & Equip.

Total Assets

Dec-9O

Jan.

Feb.

Mar.

Apr.

May

June

July

Aug.

Sept.

Oct.

Nov.

Dec.

$175 530

$562 958 948

$730 234 1,355

$175 271 1,749

$175 270 2,157

$175 250 2,564

$175 250 2,971

$175 270 3,365

$175 1,603 2,904

$Ì75 3,113 2,314

$175 3,580 1,549

$175 3,982 697

$175 3,063 530

3,333 1,070

2,469 1,070

2,319 1,070

2,195 1,070

2,602 1,070

2,989 1,070

3,396 1,070

3,810 1,070

4,682 1,070

5,602 1,070

5,304 1,070

4,854 1,070

3,768 1,070

2,628

$4,403 $3,539 $3,389 $3,265 $3,672 $4,059 $4,466 $4,880

$5,752 $6,672 $6,374 $5,924 $4,838

Liabilities & Net Worth Accounts Payable (c) Notes Payable (d) Accrued Taxes (e)

(24)

225 102 (153)

225 693 (236)

225 1,236 (289)

225 1,856 (374)

225 2,423 (425)

225 2,987 (321)

225 3,561 (224)

225 2,786 (62)

225 1,811 116

225 622 139

50 302

50 251

50 224

50 732

50 1,222

50 1,758

.50 2,272

50 2,941

50 3,612

50 2,999

50 2,202

50 1,036

400 2,836

400 2,737

400 2,641

400 2,540

400 2,437

375 2,333

375 2,233

375 2,436

375 2,686

375 3,000

375 3,346

350 3,452

255 680 80

225

225

0

0

27

50 1,065

Long-term debt Current Portion (0

Current Liabilities

400 Long-term Debt Shareholders'Equity (h 2,938

Total Liabilities &

Equity

$4,403 $3,539 $3,389 $3,265 $3,672 ,$41959 $4,466 $4,880

$5,752 $6,672 $6,374 $5,924 $4,838

o rn

:: .

P'

::

CD

("

rn

0.

1'

1- -

g: 0.

CD

&. s

&. ~rn P' ~

CD C" (" ~o rn

CD ~ 0. rn' 1--

p- Cl ::

C" :- P'

:: '"

~ P' 0 ~. C" ::

~ u: 0:

I- c: ~ o CD ("

0. ::. 0. ~

P' ~~C§ :: i: 0 (c

~ rn i- 1--

01 CD ~ p-

~ i-CD 0

0- g. i- g

CD C"1'~

P' ~o.0 OOCDCDO

:: S ~ * ~ CD P' 1' ~ :: ~ 0

1- . :: CD CD

~ ~ ~ ~ 0. CD 0 ~ C"o.op' o 1-. i- aq

~ -i I- ~

~ ~. *~. rn :: Ci,~

CD 1-. ~ rn

P' rn 1' :: 1' p- P' CJ

CD 0 rn 1' ~rnrn~o . &r £ CD ~.

-i (" CD i: 1'

CD P' CD p- ~

("aq~~oc: CD (" ;S. 0

rn S- P' P' P' i: 1' C" rn ::

~ OO~Otd

("

rn

CD

C"

,, '- "-"-z ee 0

'0 '~ 0i-

~ 00

'z

I

00

i-

z~

~--

~

~ ¡. ~ i~ 0 ii+ 0 i+ 0

~ ~ ~ ~ 00 -'-~

C

00 '-

. ~

a: :~~~

~ '~

;~

~~

i-

¡~ 1'G

~ .~

~ i-

~ ~ ~ Z~z zs:

i+ ~ 0'

'0

~ Z ~ 00

'G

~

0

'0 ~ ~ ~ 0' 0

~ Z ~ 00

00

.~ 'G

Ig) i

5 ~

, ,~

i- ~

~ ~ C ~

~ t: p. p. ~

¡~ '~

o

l: rK

tD

ie. t. e. ~ 1-. i0

~:t

i~

i- i-

l t z z t: t:

Q

Ql

Q

~ Ql

~ ff ff

Q Q

I-

ff ff

Q

~ Q Q

~ Ql Q

~ Q Q

~

Ql

-( -i

,i1i~

~

eJ

~

z

~

o~

~

I'

~I it i

§ t

~ ~ "i "i ~ ~

"' "'

JJ

oC C o :: oz

"U -(

~ Z

"U

ooš:

o-(

oim en -i

Q

~I

gJ

š:

g

I-.

¡ ~I

i:

c.

~

a:

?,

~

a:

?-

~

~

Cl

c. Q

~ Ql

~

~

~

t:

:.

zo

!"

o ('

!"

"C

m

00

~ ~

!'

Ql

I:

e

e = ~

~ =

"""

Q1

Q1

.. g

00 8 -- --

~~

~t

g

t. =

g

t. Q1 ~ = ~

g

~ Q1

g

..=

~LAY TIME TOY COM~ANY PRODUCTION 4000

1\

~'

3000

I \ I \ I\

3500

~.

~

i 2500

2000

\

\

\

\ \.

1500

1000

\

II ;: i I i ~ J.. ~

.~

I ,. I ! I ""

I ff dI !?),: I ii ? I?o

\

\

\I \I ~

.,

500

~Inventory (L)

..NIP(L)

¡¡

Ii

i :: Mar. Apr. May June .J1llY A1,g. Sept. Oct. Nov. Dec. MONTH

I

I

1800T.................................................................................................................................................................................................................................................................................

1600

I 1400l

-.... ..

\ \

I

\

I 1200

I

\

I

I

1000

I

\ \.II

I

800 l

\

I I

600 ""

L

400

200

-

., Inventory (8) II NIP (8)

~ Feb.

-

~yi

Mar.

Apr.

I

"".........

June July MONTH

I

I

I

ow

)

Aug.

Sept.

Oct.

Nov.

Dec.

4000 *., ~

3500

ß. ::;

x?

:;:

/ \ / (' Jq

/ \ il / \ "~ "x x

3000

I

1:/

2500

/f / ~

2000

ri !!j

1500

1000

ri

i /

500

/ /

I

I

/.. *

\

\

\ \.

\

11

\

NIP(L) (L)I I· ~IIAI

\

\: \!

,,: I ISept.I ?Aqgo Mar. Apr. May June Jqiy Oct.

"'..

MONTH

I

I i

Nov. Deco

"

'l..

.. ..

g

0~

~

t:

~

z

!'

o ()

~ ~

.. .

g

'"

Q1

I

, I .~

" " "

00 ..

"

g0

00 '00 '-

~ ~

H

0~ g 8

~

Q1

0~ g ~ ~

g 8

ij 0

4000

3500

~t / ¡¡ ,

.

..

.,

iø

.

,.

. ,.

..

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

3000

2500

2000

//

1500

1000 .

/

)I

/ /

11

/

iI //'" I /

,

,

,

,

.

,

, , , .

,

,

.

500

.

.

.

,

.

.

.

.

.

,

,

.

,

,

, ,

,

-:: -.- _.AI (L) II Inventory (L)

"'NfP (L)

,

.

,

,

.

.

o

Jan.

, , ,

.

Feb.

Mar.

Apr.

May

June July MONTH

Aug.

Sept.

Oct.

Nov,

Dec,

~

t:

~

z

l"

o

o

l"

~

00

~ ~

i

"

-1--- --- --

;1 .

\~-~l

+

I

I

I

,

I

I

I

i

.

: ,i

l

\i

r"t

,,~"

""

ø.. 8

~ õ..

00 = 00

'" iÐ '"

~~~

Hi

~

..

ø~ g

-- -- --

z'" Ï!

-- ..-

.. Q1 g

- -- --

g

~

Q1

ø

,--

g

c:

"

", ", ",

\fl

", ",

""

"" ", ",

""

g

Q1

c:

""

ø g

,¡