Course Hero Logo
Question
Answered step-by-step

Q. 1 York Industries has planned for the following purchases in the...

Q. 1

York Industries has planned for the following purchases in the next five months.

Month Budgeted Purchases

June $42,500

July $38,500

August $39,600

September $52,800

October $66,700

This is the established pattern for payment purchases: 15% in the month of purchase, 65% in the following month, and 20% two months after purchase.

York Industries also has the following planned sales over the next five months:

Month Budgeted Sales

June $88,500

July $98,500

August $99,300

September $82,800

October $1,06,800

20% of sales are cash and 80% of sales are credit. Cash sales are collected in the same month as sales and credit sales are collected with the following pattern; 35% in the month of sale, 50% in the month after the sale, and 15% two months after the sale. Operating expenses for each month are $13,000. Assume these expenses are paid for in cash at the end of each month. Required: What is the net cash flow for August and September?

Answer this show all work using EXCEL FORMULAS

Answer & Explanation
Verified Solved by verified expert
Rated Helpful

usce dui lectus,

gue

itur laoreeac, dictum vitae odi

sum dolor sit aac, dictum vitae odio

s ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscin

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
Step-by-step explanation

s a molestie consequat, u

su, dictum via molestie coacinia pulvinariccextl
icec facaciniaec facng elcingm risususu
lec faclestieec facsung elat, ulsum dosu
xec aat, ulec facsusutriaciniaec fac
suentesqametec facsususususacinia
ec facconsectsum doaciniasusususuat, ul
or nec facilisis. Pellentesque dapisususung elfficec facgue vec fac

gue

gue

ng elit. Nam lacinia pulvina

sue vel laoreet aiccextl
icaciniaceaciniaonecsusu
lec facsuorceametsu
xec facsusulleninia pec a
sutrisususuec aur la
ec facec facsusususuacinia
entesque dapibus efficitur laoreet.sucecingfficsu

acinia

f

gue

ur laoreet. Nam risus ante

gue

ac, dictum vitae odio. Done

gue

trices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vi

facilisis. Pellentesque dapibus efficit

dictum vitae odio. Donec aliquet. Lorem ipsicitur l

a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, d

gue

gue

gue

et, consectetur adipiscing eli

gue

ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dict

itur laoreet. Nam risus ante, dapibus a

dictum vitae odio. Donec aliquet. Lorem ipsicitur l

ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing

gue

gue

gue

Student review
100% (1 rating)
Easy to follow