Joyden's Csrryout Stores has elght locetiona. The firm wishes to expond by two more stores snd needs s bonk losn to do this. Mra.

Wison, the bsrker, wil finsnce construction if the firm can present an scceptable three$-$month finsonciol plsn for Jsnusry through

Morch. The following ore sctusi snd forecsst ssies figures:

Of the firm's sales, $60$ percent are for cesh snd the remsining $40$ percent sre on credit. Of credit ssles, $20$ percent are pold in the

month sfer ssle snd $90$ percent are poid in the second month ofter the ssie. Moterisla cost $20$ percent of sales snd sie purchssed and

recelved each month in sn omount sufficient to cover the following manth's expected soies. Msteris s are pe'd for in the manth after

they sre recehed. Lsbor expense is $50$ percent of sales snd lis poid for lin the month of soles. Selling snd sdminlstratve expense is $15$

percent of ssies and is psid in the month of sales. Overhesd expense is $$31,000$ in cesh per month.

Deprecistion expense is $$10,600$ per month. Texes of $$8,600$ wil be psid in Janusry, snd dividends of $$5,000wll$ be psid in Merch.

Cosh ot the beginning of Jenuery is $$92,000,$ snd the minimum desired cas bolance is $$87,000.$

a$.$ Prepse a schedule of monthly cash rece pts for Jenuery, Februsry, and March.

b$.$ Prepsre a schedule af monthly cash poyments for Janusy, Februsry, and Morch.

Note: Input all omounts ss positive. Leave no cells blank be certain to enter $0$ wherever required.

C$.$ Prepse o monthly csah budget with borrowings snd repoyments for Jonusry, Februsry, snd Msrch$.$

Note: Negatlve smounts should be Indicated by o minus slgn$.$ Assume the Janusry beginning loan belance is $$0.$ Leave no cells

blenk be certain to enter $0$ wherever required.