Question

Morganton Company makes one product and it provided the following information to help prepare the master budget:

Answer 1

Answer:

Budgeted sales for July = $60*29000=$1740000

Expected Cash Collection :30%*1740000=$522000

Explanation:

Budgeted Cash sales for July =$6*29000=$1740000

Expected cash collection for July =70%(60*9800)+30%(1740000)

411,600+522,000=933,600

Account receivable at the end of July =70%*1740000 = $1,218,000.

Units produced in July = 80% * 29000+20%*31000 =29400

5) (10% * 124800 )+90%(4*29400)=12480+105840=118,320

6) 118320*2.5=$295,800

7)(70%*152,160)+(30%*295,800)=106512+88740=$192,252

8) 70%*29580$207,060

9)10%*124800=12,480

10)29400*2*15=$882,000

11)(29400*2*7)+882000=1,293,600/29400=$43.98

12)(20%*31000*2*15)+ (20%*31000*7)= 186000+43,400=229,400

13)Cost of goods sold = 1,293,600

Gross Margin =1,740,000-1,293,000=$447,000

14)68000+(1.8*29000)=$120,200

15) (29000*60)-(1,293,600) - (1.8*29000)-68,000=$326,800