Interest payment 1 pm 80 ending cash balance 20010

Info icon This preview shows pages 3–8. Sign up to view the full content.

Interest Payment 1% PM $ -80 Ending Cash Balance $ 20,010 $ 44,080 Requirement H Cost of Goods Sold Budget Per Unit Manufacturing Cost: Input Unit Rate Total Cost per unit Direct Material 2.5 $ 4.00 $ 10.00 Direct Labor 0.3 $ 20.00 $ 6.00 Overhead 0.3 $ 50.00 $ 15.00 Total Cost $ 31.00 Cost fo Goods manufactured and sold Beginning Raw Material Inventory $ 3,000 Purchases $ 56,200 Raw maaterial Available $ 59,200 Ending Raw Material Inventory (750*$ 4) $ -3,000 Raw Material used $ 56,200 Labor $ 33,720
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Overhead $ 84,300 Total Manufacturing Cost $ 174,220 Beginning work in process inventory $ - Total Work in process inventory $ 174,220 Ending work in process inventory $ - Cost of Goods manufactured $ 174,220 Beginning Finished goods $ 10,800 Goods Available $ 185,020 Ending Finished Goods (720*31) $ -22,320 Cost of Goods Sold $ 162,700 Requirement 2 Income Statement Sales Revenue $ 364,000 Less: Cost of Goods Sold $ 162,700 Gross Margin $ 201,300 Selling and Administrative Expenses $ 74,280 Operating Income $ 127,020 Interest Expense $ 160 Income before tax $ 126,860 Less Income Tax $ 14,000 Net Income $ 112,860 Requirement I Balance Sheet Assets: Cash $ 118,640 Accounts Receivable $ 30,240 Raw Material Inventory $ 3,000 Finished Goods Inventory $ 22,320 Total Current Assets $ 174,200 Equipment (168000+25000) $ 193,000 Less: Accumulated Dep (39000+24000+8000) $ -71,000 $ 122,000 Total Assets $ 296,200 Liabilities: Accounts Payable $ 6,540 Equity: Common Stock $ 130,000 Retained Earning (46800+Net Income) $ 159,660 $ 289,660 Total Liabilities and Equity $ 289,660 $ 296,200
Image of page 4
ment, will get back to you. Gavin Gavin Comprehensive Budget Full Budget Q3 Q4 Full Year 1,400 1,600 5,200 $ 70 $ 70 $ 70 $ 98,000 $ 112,000 $ 364,000 $ 9,800 $ 11,200 $ 36,400 $ 88,200 $ 100,800 $ 327,600 Q3 Q4 Full Year Receivables $ 30,000 $ 9,800 $ 11,200 $ 36,400 $ 63,000 $ 22,680 $ 75,600 $ 61,740 $ 26,460 $ 88,200 $ 70,560 $ 70,560 $ 30,240 $ 94,220 $ 108,220 $ 363,760 $ 30,240 Q3 Q4 Full Year Q1 2020 1,400 1,600 5,200 $ 1,800 640 720 720 2,040 2,320 5,920 -560 -640 -300 1,480 1,680 5,620 Q3 Q4 Full Year 1,480 1,680 5,620 2.50 ### 2.50 3,700 4,200 14,050 1,680 750 750 5,380 4,950 14,800 -1,480 -1,680 -750 3,900 3,270 14,050 $ 4 $ 4 $ 4 $ 15,600 $ 13,080 $ 56,200
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Q3 Q4 Full Year Payable $ 16,000 $ 13,920 $ 6,800 $ 13,600 $ 7,800 $ 7,800 $ 15,600 $ 6,540 $ 6,540 $ 6,540 $ 14,600 $ 14,340 $ 65,660 $ 6,540 Q3 Q4 Full Year 1,480 1,680 5,620 0.30 0.30 0.30 444 504 1,686 $ 20 $ 20 $ 20 $ 8,880 $ 10,080 $ 33,720 Q3 Q4 Full Year $ 4,440 $ 5,040 $ 16,860 $ 6,000 ### $ 24,000 $ 10,860 ### $ 43,440 $ 21,300 $ 21,900 $ 84,300 $ 6,000 $ 6,000 $ 24,000 $ 15,300 $ 15,900 $ 60,300 1,686 $ 50.00 Q3 Q4 Full Year $ 1,960 $ 2,240 $ 7,280 $ 8,000 ### $ 32,000 $ 4,800 ### $ 19,200 $ 1,950 ### $ 7,800 $ 2,000 ### $ 8,000 $ 18,710 $ 18,990 $ 74,280
Image of page 6
$ 2,000 $ 2,000 $ 8,000 $ 16,710 $ 16,990 $ 66,280 Q3 Q4 Full Year $ 44,080 $ 71,230 $ 20,000 $ 94,220 $ 108,220 $ 363,760 $ 138,300 $ 179,450 $ 383,760 $ 14,600 $ 14,340 $ 65,660 $ 8,880 $ 10,080 $ 33,720 $ 15,300 $ 15,900 $ 60,300 $ 16,710 $ 16,990 $ 66,280 $ 25,000 $ 3,500 ### $ 14,000 $ 58,990 $ 60,810 $ 264,960 $ 79,310 $ 118,640 $ 118,800 $ 8,000 $ -8,000 $ -8,000 $ -80 $ -160 $ 71,230 $ 118,640 $ 118,640
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '18
  • Soni
  • Balance Sheet, raw material, Total Budgeted Sale

{[ snackBarMessage ]}

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