Need help filling out excel sheet (last page)

Chapter 5 Operating Activities CASE 5-1 that secures shelf space in independent boolstores for small puitlshing compnies As a member of the company's esecutive tem, you are pecaring the epertig dt the fourth qarter of 2017 Your ntent is to e the budget for team membens and provide them with detailed schedules thot support yoar overview ens general leder provides you with curren accnt data on September 3 3 Accounts (accoent amounts in thoands of dollars) Debit Cred Accounts secelvable (the end of the third quarter) of operations 8 8000 20000 Accounts payable 21.70 Retained eming 538400 lack Clor Vice President of Sales, etimated that sales should incre from their fourth quarter lewels of the peevious year Per your requst be oranded hib mosthly Sourth quaeter sales estimates to you, alotnug with the curent modh's ac sales and his forecast Soe Jaaary 3018 Month Sales 72.000 Bvaary SoLS ou next met with Mary Balnce, Zen's Controle M Balance indomed y thut the eanguay prices ks products inceder to ensure a 26%-peo sueon sls Zn has met that margin theoughout the fiest three quartees of 2017, and se was eeet that the fin would meet this target mangin in the sear temm Mary aso toild yo tha disoount on the ce price mr r"nainngt40% of the cuiners poy on armurta.di' salstrmnsr. .coM This mrms credit cutmers must 0y the full invoice price by the end of lhe math olowing the month in wich they purchased menchandi Maryeed Ou customers are peetty soplisticated, and they constaety manae theie cash as we do. Ceseqent, if we make a credit sale in October,tey wal pey us by the ended November. Finally, Mary sald, "We screen our eusomers very careully before estending them credit Our customers pay what they owe us. We don't have any bad debesandwe dont expect any in the future and Finance Mary also provided you with third quarter monthly espense data to asist conetnacting your bodget. The nest table presents that information Monthly Expense Item General She concluded that, "As you know, we pay our operating expenses in the month we accnae the Procurement officer Jim Washburn managed invenbory so that its ending balance