May June Total 365000 Period January COGS 120000 Add Ending Inventory Required

May june total 365000 period january cogs 120000 add

This preview shows page 13 - 20 out of 24 pages.

May June Total $ 365,000 Period January COGS $ 120,000 Add: Ending Inventory - Required $ 88,200 Total Inventory Needed $ 208,200 Less: Inventory - Beginning $ 105,000 Inventory Purchase - Required $ 103,200
Image of page 13
Period January Account Payable - Beginning $ 65,000 January $ 61,920 February March April May June Total $ 126,920 Period January Cash Balance - Beginning $ 40,000 Collection From Sales $ 365,000 Total Cash Available $ 405,000 Disbursments Inventory - Account payable $ 126,920 Sales & Admisnistration Expense $ 90,000 Operating expenses $ 105,000 Rent $ 5,000 Repair - Building Total Disbursment $ 326,920 Excess (Deficiancy) of Cash $ 78,080 Financing Borrowing (At Beginning) $ 1,930 Repayment (At End) $ - Interest $ 10 Total Financing $ 1,920 Cash Balance - Ending $ 80,000 Account Receivable Account Payable
Image of page 14
Inventory
Image of page 15
Sales Budget - 2020 February March April May June $ 315,000 $ 330,750 $ 347,288 $ 364,652 $ 382,884 $ 126,000 $ 132,300 $ 138,915 $ 145,861 $ 153,154 $ 189,000 $ 198,450 $ 208,373 $ 218,791 $ 229,731 Cash Collection Budget - 2020 February March April May June $ 157,500 $ 165,375 $ 173,644 $ 182,326 $ 191,442 $ 60,000 $ 15,000 $ 78,750 $ 63,000 $ 15,750 $ 82,688 $ 66,150 $ 16,538 $ 86,822 $ 69,458 $ 17,364 $ 91,163 $ 72,930 $ 95,721 $ 296,250 $ 326,063 $ 342,366 $ 359,484 $ 377,458 Inventory Budget - 2020 February March April May June $ 126,000 $ 132,300 $ 138,915 $ 145,861 $ 153,154 $ 92,610 $ 97,241 $ 102,103 $ 107,208 $ 112,568 $ 218,610 $ 229,541 $ 241,018 $ 253,068 $ 265,722 $ 88,200 $ 92,610 $ 97,241 $ 102,103 $ 107,208 $ 130,410 $ 136,931 $ 143,777 $ 150,966 $ 158,514
Image of page 16
Account Payable Budget - 2020 February March April May June $ 41,280 $ 78,246 $ 52,164 $ 82,158 $ 54,772 $ 86,266 $ 57,511 $ 90,580 $ 60,386 $ 95,109 $ 119,526 $ 134,322 $ 141,038 $ 148,090 $ 155,495 Cash Budget - 2020 February March April May June $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 296,250 $ 326,063 $ 342,366 $ 359,484 $ 377,458 $ 376,250 $ 406,063 $ 422,366 $ 439,484 $ 457,458 $ 119,526 $ 134,322 $ 141,038 $ 148,090 $ 155,495 $ 94,500 $ 99,225 $ 104,186 $ 109,396 $ 114,865 $ 110,250 $ 115,763 $ 121,551 $ 127,628 $ 134,010 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 10,000 $ 339,276 $ 354,310 $ 371,775 $ 390,114 $ 409,370 $ 36,974 $ 51,753 $ 50,590 $ 49,370 $ 48,088 $ 43,252 $ 28,616 $ 29,928 $ 31,305 $ 32,751 $ - $ - $ - $ - $ - $ 226 $ 369 $ 519 $ 675 $ 839 $ 43,026 $ 28,247 $ 29,410 $ 30,630 $ 31,912 $ 80,000 $ 80,000 $ 80,000 $ 80,000 $ 80,000 Balances End of June 30, 2020 $ 113,954 $ 63,406
Image of page 17
$ 112,568
Image of page 18
Requireme Sales Increase in sales (per moth) Cost of Good Sold Cash Sales Receive in Same Month Receive in Next Month Receive in 2nd next month July Total - 6 Months $ 402,029 $ 2,040,574 Inventory $ 160,811 $ 816,230 Ending Inventory Requirement $ 241,217 $ 1,224,344 Beginning Inventory Account Payable Payable Same Month July Total - 6 Months $ 140,000 Payable Next Month $ 201,014 $ 1,020,287 $ 150,000 Cash Budget $ 157,500 Cash Beginning Balance $ 165,375 Commission on Sales $ 173,644 Rent $ 18,233 $ 164,093 Operating Expense on sales $ 76,577 $ 95,721 Interest per month $ 295,824 $ 2,066,620
Image of page 19
Image of page 20

You've reached the end of your free preview.

Want to read all 24 pages?

  • Winter '17
  • Revenue, Expense, Generally Accepted Accounting Principles, Goods Sold

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors