Master Budget Project

Group $87$C

Vaughan Company makes AMAZING SUPER DUPER Widgets. Management

is now preparing detailed budgets for the third quarter, July through September, and

has assembled the following information to assist in budget preparation:

Sales Budget

The marketing department has estimated sales as follows for the remainder of

the year: $($Actual sales in June were $5,000$ units$)$

July $4,000$ October $5,000$

August $18,000$ November $6,000$

September $15,000$ December $8,000$

The selling price of a SUPER DUPER widget is $$56$ and all sales are on account.

Based on past experience, sales are collected in the following pattern:

$60\%$ in the month of sale

$35\%$ in month following the sale

$5\%$ are never collected $($uncollectible$)$

Vaughan Company

Sales Budget Total

$3$rd Quarter July August September $3$rd Quarter

Sales in Units $4,00018,00015,00037,000$

Selling Price per Unit $*$$$56*$$$56*$$$56*$$$56$

Total Sales in $ $4000*$$$56=22400018000*$ $$56=100800015000*$ $$56=84000037000*$ $$56=2072000$

$4$

Cash Collections $224000*60\%=1344001008000*60\%=604800840000*60\%=504000$

June's Cash Collections $5000*$$$56=280000*35\%=9800098,000$

July's Cash Collections $224000*60\%=134400224000*35\%=78400134400+78400=212800$

August's Cash Collections $1008000*60\%=6048001008000*35\%=352800604800+352800=957600$

September's Cash Collections $840000*60\%=504000504,000$

Total Cash Collections $98000+134400=$$$23240078400+604800=$$$683200352800+504000=$$$856800232400+683200+856800=$$$1772400$

Production Budget

The company maintains a finished goods inventory equal to $25\%$ of the following

month's sales. The inventory of finished goods on July $1$ is as it should be$.$

Vaughan Company

Production Budget Total

$3$rd Quarter July August September $3$rd Quarter

Budgeted Sales in Units $4,00018,00015,00037,000$

Add: Desired Ending Inventory $18000*25\%=450015000*25\%=37505000*25\%=12501,250$

Total Needs $4000+4500=850018000+3750=2175015000+1250=1625037000+1250=38250$

Less: Beginning Inventory $4000*25\%=(1000)(4,500)(3,750)(1,000)$

Required Production $8500-1000=750021750-4500=1725016250-3750=1250038250-1000=37250$

Raw Materials Purchasing Budget

Each unit of SUPER DUPER widget requires $3$ pounds of WHAM compound. To

prevent shortages, the company would like the inventory of WHAM compound on hand

at the end of each month to equal $10\%$ of the following month's production needs.

The inventory on July $1$ is $2,250$ pounds.

WHAM compound costs $$1\mathrm{.}80$ per pound and Vaughan pays for $60\%$ of its purchases

in the month of purchase; the remainder is paid in the following month. $$29,565$

of WHAM compound was purchased in June and $60\%$ was paid for in June.

Vaughan Company

RM Purchasing Budget Total

$3$rd Quarter July August September $3$rd Quarter

Required Production $7,50017,25012,50037,250$

RM per Unit $*3$# $*3$# $*3$# $*3$#

Production Needs $7500*3$#$=22500$# $17250*3$#$=51750$# $12500*3$#$=37500$# $37250*3$#$=111750$#

Add: Desired Ending Inventory $51750*10\%=5175$# $37500*10\%=3750$# $5250*3$#$=15750*10\%=15751575$#

Total Needs $22500+5175=27675$# $51750+3750=55500$# $37500+1575=39075$# $111750+1575=113325$

Less: Beginning Inventory $(2250$#$)(5175$#$)(3750$#$)(2250$#$)$

RM to be Purchased $27675-2250=25425$# $55500-5175=5032539075-3750=35325113325-2250=111075$

Cost of RM per pound $25425*1\mathrm{.}80=4576550325*1\mathrm{.}80=9058535325*1\mathrm{.}80=63585111075*1\mathrm{.}80=199935$

Cost of RM to be Purchased $ $45,765$ $ $90,585$ $ $63,585$ $ $199,935$

$4$

Cash Disbursements for RM $45765*60\%90585*60\%63585*60\%$

June's RM Purchases $29565*40\%=1182611,826$

July's RM Purchases $45765*60\%=2745945765*40\%=1830627459+18306=45765$

August's RM Purchases $90585*60\%=5435190585*40\%=3623454$