I’ve done 1-7 but just need the last 3 questions from 8-10 done. I’m very confus

Question

I’ve done 1-7 but just need the last 3 questions from 8-10 done. I’m very confused on how to do these last 3! Please help outtttt! Thank you!! Following is the work I’ve done so far!
Our controller, Veronica Verrengia, is negotiating with our bamboo suppliers in China. We need the Softball Bat Division's Master Budget for 2018 for our corporate strategic planning process, and we cannot wait for Veronica's return from China. We would like you to prepare the Softball Bat Division's Master Budget for 2018 The deliverables are as follows

Explanation / Answer

Payment for purchases Qtr.1 2 3 4 Direct material purchases 3239100 2934000 2782800 2916000 11871900 Payment schedule 30% payments 925000 971730 880200 834840 3611770 70% payments 2267370 2053800 1947960 2041200 8310330 Total cash payments for d/m 3192370 3025530 2828160 2876040 11922100 Cash Budget Quarter 1 Qtr.2 Qtr.3 Qtr. 4 Total Opening Balance 220000 205930 206300 202240 220000 Add: Sales Collections 5184300 6514900 6461600 6445200 24606000 Total cash available 5404300 6720830 6667900 6647440 24826000 Less: Disbursements: Total cash payments for d/m 3192370 3025530 2828160 2876040 11922100 Direct labor 1251200 1115200 1047200 1088000 4501600 Mfg. OH 1274800 1155800 1096300 1132000 4658900 Selling & admn. OH 800000 904000 840000 872000 3416000 Equipment 350000 350000 Dividends 40000 40000 40000 40000 160000 Total disbursements 6558370 6240530 5851660 6358040 25008600 Surplus(Deficit) -1154070 480300 816240 289400 -182600 Add : Borrowings 1360000 1360000 Less: (Repayments) -240000 -600000 -80000 -920000 Less: (Interest) -34000 -14000 -6500 -54500 Ending cash balance 205930 206300 202240 202900 202900 1360000*1.25%*2= 34000 (1360000-240000)=1120000*1.25%=14000 (1360000-240000-600000)=520000*1.25%=6500 COGM & COGS Schedule Op. Raw material inventory 368100 Add:Purchase of raw materials 11871900 Less: ending raw materials 324000 Raw materials consumed 11916000 Direct labor 4501600 Mfg.OH 281350 D/l hrs. 6098900 Cost of goods mfd. 22516500 Less: Cost of Ending inventory Raw materials 20000*40*0.9= 720000 Labor 20000*0.85*16= 272000 Mfg.Oh 20000*0.85*6098900/281350 368514 1360514 So, Cost of Goods sold 21155986 Alternatively, COGS Raw materials =311000*40*0.9 11196000 Labor=311000*0.85*16 4229600 Mfg. OH =311000*0.85*6098900/281350 5730386 Total   21155986 Bugdeted Income statement Sales revenue 311000*82 25502000 Less: COGS(As per COGM& COGS Sch.) 21155986 Gross profit 4346014 Less: Sell.& admn. OH 3608000 Net Operating Income 738014 Less: Interest expense 54500 Net income to Retained Earnings 683514 Balance Sheet Assets Cash 202900 Accounts Receivables(6560000*35%) 2296000 Raw materials inventory(360000 oz.*0.90/oz.) 324000 Finished goods inventory (as per COGS Sch.) 1360514 Plant & Equipment(1700000+1400000) 3100000 Less: Depreciation(1440000+192000) -1632000 Total Assets 5651414 Liabilities & Equity Accounts Payable(2916000*30%) 874800 Bank loan(1360000-920000) 440000 Notes payable(1400000*75%) 1050000 Capital stock 2000000 Retained Earnings(763100+683514-160000) 1286614 Total Liabilities & Equity 5651414

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.